DBA Data[Home] [Help]

APPS.BOM_VALIDATE_RTG_HEADER dependencies on BOM_BILL_OF_MATERIALS

Line 1427: FROM BOM_BILL_OF_MATERIALS BOM, BOM_COMPONENT_OPERATIONS BCO

1423: CURSOR c_Check_BOM IS
1424: SELECT NULL from dual
1425: WHERE exists
1426: (SELECT 1 /* Checking for the BOM components operation seq. num. for alternate */
1427: FROM BOM_BILL_OF_MATERIALS BOM, BOM_COMPONENT_OPERATIONS BCO
1428: WHERE BOM.ORGANIZATION_ID = p_rtg_header_unexp_rec.organization_id
1429: AND BOM.ASSEMBLY_ITEM_ID = p_rtg_header_unexp_rec.assembly_item_id
1430: AND BOM.ALTERNATE_BOM_DESIGNATOR = p_rtg_header_rec.alternate_routing_code
1431: AND BOM.BILL_SEQUENCE_ID = BCO.BILL_SEQUENCE_ID)

Line 1434: FROM BOM_BILL_OF_MATERIALS BOM, BOM_INVENTORY_COMPONENTS BIC

1430: AND BOM.ALTERNATE_BOM_DESIGNATOR = p_rtg_header_rec.alternate_routing_code
1431: AND BOM.BILL_SEQUENCE_ID = BCO.BILL_SEQUENCE_ID)
1432: OR exists
1433: (SELECT 1 /* Checking for the BOM components operation seq. num. for alternate */
1434: FROM BOM_BILL_OF_MATERIALS BOM, BOM_INVENTORY_COMPONENTS BIC
1435: WHERE BOM.ORGANIZATION_ID = p_rtg_header_unexp_rec.organization_id
1436: AND BOM.ASSEMBLY_ITEM_ID = p_rtg_header_unexp_rec.assembly_item_id
1437: AND BOM.ALTERNATE_BOM_DESIGNATOR = p_rtg_header_rec.alternate_routing_code
1438: AND BOM.BILL_SEQUENCE_ID = BIC.BILL_SEQUENCE_ID