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.CSM_EMAIL_QUERY_PKG dependencies on CSP_INV_LOC_ASSIGNMENTS

Line 2673: FROM CSP_INV_LOC_ASSIGNMENTS ila,

2669:
2670: CURSOR c_get_sub_inv(p_resource_id NUMBER, p_org_id NUMBER)
2671: IS
2672: SELECT ila.SUBINVENTORY_CODE , csi.condition_type
2673: FROM CSP_INV_LOC_ASSIGNMENTS ila,
2674: csp_sec_inventories csi
2675: WHERE ila.RESOURCE_ID = p_resource_id
2676: AND ila.RESOURCE_TYPE = 'RS_EMPLOYEE'
2677: AND ila.ORGANIZATION_ID = p_org_id