DBA Data[Home] [Help]

APPS.ENG_ITEM_PKG dependencies on BOM_OPERATIONAL_ROUTINGS

Line 759: FROM BOM_OPERATIONAL_ROUTINGS BOR

755: BEGIN
756: X_stmt_num := 301;
757: SELECT BOR.COMMON_ROUTING_SEQUENCE_ID, BOR.ROUTING_TYPE
758: INTO l_routing_sequence_id, l_routing_type
759: FROM BOM_OPERATIONAL_ROUTINGS BOR
760: WHERE BOR.ASSEMBLY_ITEM_ID = ctb.ASSEMBLY_ITEM_ID
761: AND BOR.ORGANIZATION_ID = ctb.ORGANIZATION_ID
762: AND BOR.ALTERNATE_ROUTING_DESIGNATOR = ctb.ALTERNATE_BOM_DESIGNATOR;
763: EXCEPTION

Line 776: FROM BOM_OPERATIONAL_ROUTINGS BOR

772: BEGIN
773: X_stmt_num := 302;
774: SELECT BOR.COMMON_ROUTING_SEQUENCE_ID, BOR.ROUTING_TYPE
775: INTO l_routing_sequence_id, l_routing_type
776: FROM BOM_OPERATIONAL_ROUTINGS BOR
777: WHERE BOR.ASSEMBLY_ITEM_ID = ctb.ASSEMBLY_ITEM_ID
778: AND BOR.ORGANIZATION_ID = ctb.ORGANIZATION_ID
779: AND BOR.ALTERNATE_ROUTING_DESIGNATOR IS NULL;
780:

Line 893: FROM BOM_OPERATIONAL_ROUTINGS BOR,

889: UPDATE BOM_INVENTORY_COMPONENTS BIC
890: SET OPERATION_SEQ_NUM = 1
891: WHERE NOT EXISTS
892: (SELECT 'X'
893: FROM BOM_OPERATIONAL_ROUTINGS BOR,
894: BOM_BILL_OF_MATERIALS BOM,
895: BOM_OPERATION_SEQUENCES BOS
896: WHERE BIC.BILL_SEQUENCE_ID = BOM.BILL_SEQUENCE_ID
897: AND BOR.ROUTING_TYPE = 1