DBA Data[Home] [Help]

APPS.ENG_CHANGE_IMPORT_UTIL dependencies on EGO_MFG_PART_NUM_CHGS

Line 2406: FROM EGO_MFG_PART_NUM_CHGS pending_change2

2402: SET intf.process_flag = G_CM_DATA_POPULATION
2403: WHERE intf.data_set_id = p_batch_id
2404: AND intf.process_flag = G_CM_TO_BE_PROCESSED
2405: AND EXISTS ( SELECT 'x'
2406: FROM EGO_MFG_PART_NUM_CHGS pending_change2
2407: WHERE intf.inventory_item_id = pending_change2.inventory_item_id
2408: AND intf.organization_id = pending_change2.organization_id
2409: AND intf.manufacturer_id = pending_change2.manufacturer_id
2410: AND intf.mfg_part_num = pending_change2.mfg_part_num

Line 2548: FROM EGO_MFG_PART_NUM_CHGS pending_change

2544: -- intf.attribute14),
2545: -- DECODE(intf.attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
2546: -- NULL,pending_change.attribute15,
2547: -- intf.attribute15)
2548: FROM EGO_MFG_PART_NUM_CHGS pending_change
2549: WHERE intf.inventory_item_id = pending_change.inventory_item_id
2550: AND intf.organization_id = pending_change.organization_id
2551: AND intf.manufacturer_id = pending_change.manufacturer_id
2552: AND intf.mfg_part_num = pending_change.mfg_part_num

Line 2629: -- FROM EGO_MFG_PART_NUM_CHGS pending_change2

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