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_CHANGE_PEOPLE_IMPORT_PKG dependencies on MTL_PARAMETERS

Line 1783: FROM mtl_parameters mp

1779: --Update the organization id column
1780: UPDATE eng_change_people_intf ecpi
1781: SET ecpi.organization_id =
1782: ( SELECT mp.organization_id
1783: FROM mtl_parameters mp
1784: WHERE mp.organization_code = ecpi.organization_code
1785: )
1786: WHERE ecpi.data_set_id = G_DATA_SET_ID
1787: AND ecpi.transaction_id BETWEEN G_FROM_LINE_NUMBER AND G_TO_LINE_NUMBER

Line 1792: FROM mtl_parameters mp2

1788: AND ecpi.process_status = G_PS_IN_PROCESS
1789: AND ecpi.organization_id IS NULL
1790: AND ecpi.organization_code IS NOT NULL
1791: AND EXISTS ( SELECT mp2.organization_id
1792: FROM mtl_parameters mp2
1793: WHERE mp2.organization_code = ecpi.organization_code
1794: );
1795:
1796: -- For missing organization_id, update process_status and log an error.