DBA Data[Home] [Help]

APPS.BOM_VALIDATE_RTG_HEADER dependencies on BOM_COMPONENT_OPERATIONS

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)