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, ...
APARBOMcustomerdeliveryinventoryList of tablesMTLWIP
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 ...