3

Bill Of Material - Routing query in oracle -R12

posted on , by Unknown

Bill Of Material - Routing query in oracle -R12 A routing defines the step-by-step operations you perform to manufacture a product. Each routing can have any number of operations. For each operation you specify a department that determines the resources you may use for that operation. Here sharing query to get routing,item and its uom(unit of measure) information : SELECT distinct bor.line_code,                 mtlp.organization_code,       ...

1

List of tables in oracle Apps R-12

posted on , by Unknown

List of tables based on module and schema in oracle Apps R-12 Tables related to order management module 1.Blanket tables BLANKET ONT.OE_BLANKET_HEADERS_ALL BLANKET ONT.OE_BLANKET_HEADERS_EXT BLANKET ONT.OE_BLANKET_LINES_ALL BLANKET ONT.OE_BLANKET_LINES_ALL BLANKET ONT.OE_BLANKET_LINES_EXT 2.BOM(Bill of Materials) tables BOM BOM.BOM_COMPONENTS_B ...