eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_POST_PROCESS_MESSAGE_PVT dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 690: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,

686: CURSOR get_sucessful_bundles_top_item ( c_batch_id NUMBER
687: , c_request_id NUMBER )
688: IS
689: SELECT msii.BUNDLE_ID, msii.SOURCE_SYSTEM_ID, msii.SOURCE_SYSTEM_REFERENCE
690: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
691: ( SELECT DISTINCT msii_inner1.BUNDLE_ID BUNDLE_ID
692: FROM MTL_SYSTEM_ITEMS_INTERFACE msii_inner1
693: WHERE msii_inner1.REQUEST_ID = c_request_id
694: AND msii_inner1.SET_PROCESS_ID = c_batch_id

Line 692: FROM MTL_SYSTEM_ITEMS_INTERFACE msii_inner1

688: IS
689: SELECT msii.BUNDLE_ID, msii.SOURCE_SYSTEM_ID, msii.SOURCE_SYSTEM_REFERENCE
690: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
691: ( SELECT DISTINCT msii_inner1.BUNDLE_ID BUNDLE_ID
692: FROM MTL_SYSTEM_ITEMS_INTERFACE msii_inner1
693: WHERE msii_inner1.REQUEST_ID = c_request_id
694: AND msii_inner1.SET_PROCESS_ID = c_batch_id
695: ) selected_bundles
696: WHERE

Line 699: FROM MTL_SYSTEM_ITEMS_INTERFACE msii_inner2

695: ) selected_bundles
696: WHERE
697: 'S' = COALESCE (
698: ( SELECT 'F'
699: FROM MTL_SYSTEM_ITEMS_INTERFACE msii_inner2
700: WHERE
701: msii_inner2.PROCESS_FLAG <> 7
702: AND msii_inner2.BUNDLE_ID = selected_bundles.BUNDLE_ID
703: AND msii_inner2.SET_PROCESS_ID = c_batch_id