DBA Data[Home] [Help]

APPS.ENG_ITEM_PKG dependencies on BOM_OPERATIONAL_ROUTINGS

Line 860: FROM BOM_OPERATIONAL_ROUTINGS BOR

856: BEGIN
857: X_stmt_num := 301;
858: SELECT BOR.COMMON_ROUTING_SEQUENCE_ID, BOR.ROUTING_TYPE
859: INTO l_routing_sequence_id, l_routing_type
860: FROM BOM_OPERATIONAL_ROUTINGS BOR
861: WHERE BOR.ASSEMBLY_ITEM_ID = ctb.ASSEMBLY_ITEM_ID
862: AND BOR.ORGANIZATION_ID = ctb.ORGANIZATION_ID
863: AND BOR.ALTERNATE_ROUTING_DESIGNATOR = ctb.ALTERNATE_BOM_DESIGNATOR;
864: EXCEPTION

Line 877: FROM BOM_OPERATIONAL_ROUTINGS BOR

873: BEGIN
874: X_stmt_num := 302;
875: SELECT BOR.COMMON_ROUTING_SEQUENCE_ID, BOR.ROUTING_TYPE
876: INTO l_routing_sequence_id, l_routing_type
877: FROM BOM_OPERATIONAL_ROUTINGS BOR
878: WHERE BOR.ASSEMBLY_ITEM_ID = ctb.ASSEMBLY_ITEM_ID
879: AND BOR.ORGANIZATION_ID = ctb.ORGANIZATION_ID
880: AND BOR.ALTERNATE_ROUTING_DESIGNATOR IS NULL;
881:

Line 994: FROM BOM_OPERATIONAL_ROUTINGS BOR,

990: UPDATE BOM_INVENTORY_COMPONENTS BIC
991: SET OPERATION_SEQ_NUM = 1
992: WHERE NOT EXISTS
993: (SELECT 'X'
994: FROM BOM_OPERATIONAL_ROUTINGS BOR,
995: BOM_BILL_OF_MATERIALS BOM,
996: BOM_OPERATION_SEQUENCES BOS
997: WHERE BIC.BILL_SEQUENCE_ID = BOM.BILL_SEQUENCE_ID
998: AND BOR.ROUTING_TYPE = 1