APPS.EGO_IMPORT_UTIL_PVT dependencies on EGO_INBOUND_MSG_EXT

Line 3554: FROM EGO_INBOUND_MSG_EXT

3550: IF p_item_detail_tbl(i).PROCESS_FLAG = 6 THEN
3551: IF p_show_prod_timestemp THEN
3552: BEGIN
3553: SELECT TO_CHAR(LAST_MESSAGE_TIMESTAMP, G_NLS_DATE_FORMAT) INTO l_prod_timestamp
3554: FROM EGO_INBOUND_MSG_EXT
3555: WHERE SOURCE_SYSTEM_ID = p_item_detail_tbl(i).SOURCE_SYSTEM_ID
3556: AND INVENTORY_ITEM_ID = p_item_detail_tbl(i).INVENTORY_ITEM_ID
3557: AND ORGANIZATION_ID = p_item_detail_tbl(i).ORGANIZATION_ID
3558: AND DATA_LEVEL_ID = p_item_detail_tbl(i).DATA_LEVEL_ID

Line 3688: FROM EGO_INBOUND_MSG_EXT eime

3684: LAST_UPDATED_BY = l_user_id
3685: WHERE SET_PROCESS_ID = p_batch_id
3686: AND PROCESS_FLAG = 1
3687: AND EXISTS (SELECT NULL
3688: FROM EGO_INBOUND_MSG_EXT eime
3689: WHERE eime.SOURCE_SYSTEM_ID = msii.SOURCE_SYSTEM_ID
3690: AND eime.DATA_LEVEL_ID = l_item_master_dl_id
3691: AND eime.INVENTORY_ITEM_ID = msii.INVENTORY_ITEM_ID
3692: AND eime.ORGANIZATION_ID = msii.ORGANIZATION_ID

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

3733: LAST_UPDATED_BY = l_user_id
3734: WHERE DATA_SET_ID = p_batch_id
3735: AND PROCESS_STATUS = 1
3736: AND ROW_IDENTIFIER IN (SELECT eiuai2.ROW_IDENTIFIER
3737: FROM EGO_INBOUND_MSG_EXT eime, EGO_ITM_USR_ATTR_INTRFC eiuai2, MTL_SYSTEM_ITEMS_INTERFACE msii
3738: WHERE eiuai2.DATA_SET_ID = eiuai.DATA_SET_ID
3739: AND eiuai2.PROCESS_STATUS = 1
3740: AND eime.SOURCE_SYSTEM_ID = eiuai2.SOURCE_SYSTEM_ID
3741: AND eime.DATA_LEVEL_ID = eiuai2.DATA_LEVEL_ID

Line 3844: FROM EGO_INBOUND_MSG_EXT eime, MTL_SYSTEM_ITEMS_INTERFACE msii

3840: LAST_UPDATED_BY = l_user_id
3841: WHERE SET_PROCESS_ID = p_batch_id
3842: AND PROCESS_FLAG = 1
3843: AND EXISTS (SELECT NULL
3844: FROM EGO_INBOUND_MSG_EXT eime, MTL_SYSTEM_ITEMS_INTERFACE msii
3845: WHERE mici.SET_PROCESS_ID = msii.SET_PROCESS_ID
3846: AND msii.PROCESS_FLAG = 6
3847: AND mici.INVENTORY_ITEM_ID = msii.INVENTORY_ITEM_ID
3848: AND mici.ORGANIZATION_ID = msii.ORGANIZATION_ID

Line 3868: FROM EGO_INBOUND_MSG_EXT eime, MTL_SYSTEM_ITEMS_INTERFACE msii

3864: LAST_UPDATED_BY = l_user_id
3865: WHERE BATCH_ID = p_batch_id
3866: AND PROCESS_FLAG = 1
3867: AND EXISTS (SELECT NULL
3868: FROM EGO_INBOUND_MSG_EXT eime, MTL_SYSTEM_ITEMS_INTERFACE msii
3869: WHERE bbmi.BATCH_ID = msii.SET_PROCESS_ID
3870: AND msii.PROCESS_FLAG = 6
3871: AND bbmi.ASSEMBLY_ITEM_ID = msii.INVENTORY_ITEM_ID
3872: AND bbmi.ORGANIZATION_ID = msii.ORGANIZATION_ID

Line 3891: FROM EGO_INBOUND_MSG_EXT eime, MTL_SYSTEM_ITEMS_INTERFACE msii

3887: LAST_UPDATED_BY = l_user_id
3888: WHERE BATCH_ID = p_batch_id
3889: AND PROCESS_FLAG = 1
3890: AND EXISTS (SELECT NULL
3891: FROM EGO_INBOUND_MSG_EXT eime, MTL_SYSTEM_ITEMS_INTERFACE msii
3892: WHERE bici.BATCH_ID = msii.SET_PROCESS_ID
3893: AND msii.PROCESS_FLAG = 6
3894: AND bici.COMPONENT_ITEM_ID = msii.INVENTORY_ITEM_ID
3895: AND bici.ORGANIZATION_ID = msii.ORGANIZATION_ID

Line 6004: MERGE INTO EGO_INBOUND_MSG_EXT eime

6000: RETURN;
6001: END;
6002:
6003: Debug_Conc_Log('Update_Timestamp_In_Prod: l_item_master_dl_id='||l_item_master_dl_id);
6004: MERGE INTO EGO_INBOUND_MSG_EXT eime
6005: USING ( SELECT
6006: SOURCE_SYSTEM_ID,
6007: l_item_master_dl_id AS DATA_LEVEL_ID,
6008: INVENTORY_ITEM_ID,