DBA Data[Home] [Help]

APPS.ENG_CHANGE_IMPORT_UTIL dependencies on EGO_MFG_PART_NUM_CHGS

Line 2410: FROM EGO_MFG_PART_NUM_CHGS pending_change2

2406: SET intf.process_flag = G_CM_DATA_POPULATION
2407: WHERE intf.data_set_id = p_batch_id
2408: AND intf.process_flag = G_CM_TO_BE_PROCESSED
2409: AND EXISTS ( SELECT 'x'
2410: FROM EGO_MFG_PART_NUM_CHGS pending_change2
2411: WHERE intf.inventory_item_id = pending_change2.inventory_item_id
2412: AND intf.organization_id = pending_change2.organization_id
2413: AND intf.manufacturer_id = pending_change2.manufacturer_id
2414: AND intf.mfg_part_num = pending_change2.mfg_part_num

Line 2552: FROM EGO_MFG_PART_NUM_CHGS pending_change

2548: -- intf.attribute14),
2549: -- DECODE(intf.attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2550: -- NULL,pending_change.attribute15,
2551: -- intf.attribute15)
2552: FROM EGO_MFG_PART_NUM_CHGS pending_change
2553: WHERE intf.inventory_item_id = pending_change.inventory_item_id
2554: AND intf.organization_id = pending_change.organization_id
2555: AND intf.manufacturer_id = pending_change.manufacturer_id
2556: AND intf.mfg_part_num = pending_change.mfg_part_num

Line 2633: -- FROM EGO_MFG_PART_NUM_CHGS pending_change2

2629: -- <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
2630: ) ;
2631: -- I don't think we need this
2632: -- AND EXISTS WHEN ( SELECT 'x'
2633: -- FROM EGO_MFG_PART_NUM_CHGS pending_change2
2634: -- WHERE intf.inventory_item_id = pending_change2.inventory_item_id
2635: -- AND intf.organization_id = pending_change2.organization_id
2636: -- AND intf.manufacturer_id = pending_change2.manufacturer_id
2637: -- AND intf.mfg_part_num = pending_change2.mfg_part_num