APPS.EGO_IMPORT_UTIL_PVT dependencies on EGO_INBOUND_MSG_EXT

Line 3757: FROM EGO_INBOUND_MSG_EXT

3753: IF p_item_detail_tbl(i).PROCESS_FLAG = 6 THEN
3754: IF p_show_prod_timestemp THEN
3755: BEGIN
3756: SELECT TO_CHAR(LAST_MESSAGE_TIMESTAMP, G_NLS_DATE_FORMAT) INTO l_prod_timestamp
3757: FROM EGO_INBOUND_MSG_EXT
3758: WHERE SOURCE_SYSTEM_ID = p_item_detail_tbl(i).SOURCE_SYSTEM_ID
3759: AND INVENTORY_ITEM_ID = p_item_detail_tbl(i).INVENTORY_ITEM_ID
3760: AND ORGANIZATION_ID = p_item_detail_tbl(i).ORGANIZATION_ID
3761: AND DATA_LEVEL_ID = p_item_detail_tbl(i).DATA_LEVEL_ID

Line 3891: FROM EGO_INBOUND_MSG_EXT eime

3887: LAST_UPDATED_BY = l_user_id
3888: WHERE SET_PROCESS_ID = p_batch_id
3889: AND PROCESS_FLAG = 1
3890: AND EXISTS (SELECT NULL
3891: FROM EGO_INBOUND_MSG_EXT eime
3892: WHERE eime.SOURCE_SYSTEM_ID = msii.SOURCE_SYSTEM_ID
3893: AND eime.DATA_LEVEL_ID = l_item_master_dl_id
3894: AND eime.INVENTORY_ITEM_ID = msii.INVENTORY_ITEM_ID
3895: AND eime.ORGANIZATION_ID = msii.ORGANIZATION_ID

Line 3940: FROM EGO_INBOUND_MSG_EXT eime, EGO_ITM_USR_ATTR_INTRFC eiuai2, MTL_SYSTEM_ITEMS_INTERFACE msii

3936: LAST_UPDATED_BY = l_user_id
3937: WHERE DATA_SET_ID = p_batch_id
3938: AND PROCESS_STATUS = 1
3939: AND ROW_IDENTIFIER IN (SELECT eiuai2.ROW_IDENTIFIER
3940: FROM EGO_INBOUND_MSG_EXT eime, EGO_ITM_USR_ATTR_INTRFC eiuai2, MTL_SYSTEM_ITEMS_INTERFACE msii
3941: WHERE eiuai2.DATA_SET_ID = eiuai.DATA_SET_ID
3942: AND eiuai2.PROCESS_STATUS = 1
3943: AND eime.SOURCE_SYSTEM_ID = eiuai2.SOURCE_SYSTEM_ID
3944: AND eime.DATA_LEVEL_ID = eiuai2.DATA_LEVEL_ID

Line 4047: FROM EGO_INBOUND_MSG_EXT eime, MTL_SYSTEM_ITEMS_INTERFACE msii

4043: LAST_UPDATED_BY = l_user_id
4044: WHERE SET_PROCESS_ID = p_batch_id
4045: AND PROCESS_FLAG = 1
4046: AND EXISTS (SELECT NULL
4047: FROM EGO_INBOUND_MSG_EXT eime, MTL_SYSTEM_ITEMS_INTERFACE msii
4048: WHERE mici.SET_PROCESS_ID = msii.SET_PROCESS_ID
4049: AND msii.PROCESS_FLAG = 6
4050: AND mici.INVENTORY_ITEM_ID = msii.INVENTORY_ITEM_ID
4051: AND mici.ORGANIZATION_ID = msii.ORGANIZATION_ID

Line 4071: FROM EGO_INBOUND_MSG_EXT eime, MTL_SYSTEM_ITEMS_INTERFACE msii

4067: LAST_UPDATED_BY = l_user_id
4068: WHERE BATCH_ID = p_batch_id
4069: AND PROCESS_FLAG = 1
4070: AND EXISTS (SELECT NULL
4071: FROM EGO_INBOUND_MSG_EXT eime, MTL_SYSTEM_ITEMS_INTERFACE msii
4072: WHERE bbmi.BATCH_ID = msii.SET_PROCESS_ID
4073: AND msii.PROCESS_FLAG = 6
4074: AND bbmi.ASSEMBLY_ITEM_ID = msii.INVENTORY_ITEM_ID
4075: AND bbmi.ORGANIZATION_ID = msii.ORGANIZATION_ID

Line 4094: FROM EGO_INBOUND_MSG_EXT eime, MTL_SYSTEM_ITEMS_INTERFACE msii

4090: LAST_UPDATED_BY = l_user_id
4091: WHERE BATCH_ID = p_batch_id
4092: AND PROCESS_FLAG = 1
4093: AND EXISTS (SELECT NULL
4094: FROM EGO_INBOUND_MSG_EXT eime, MTL_SYSTEM_ITEMS_INTERFACE msii
4095: WHERE bici.BATCH_ID = msii.SET_PROCESS_ID
4096: AND msii.PROCESS_FLAG = 6
4097: AND bici.COMPONENT_ITEM_ID = msii.INVENTORY_ITEM_ID
4098: AND bici.ORGANIZATION_ID = msii.ORGANIZATION_ID

Line 6788: MERGE INTO EGO_INBOUND_MSG_EXT eime

6784: RETURN;
6785: END;
6786:
6787: Debug_Conc_Log('Update_Timestamp_In_Prod: l_item_master_dl_id='||l_item_master_dl_id);
6788: MERGE INTO EGO_INBOUND_MSG_EXT eime
6789: USING ( SELECT
6790: SOURCE_SYSTEM_ID,
6791: l_item_master_dl_id AS DATA_LEVEL_ID,
6792: INVENTORY_ITEM_ID,