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_SYSTEM_ITEM_EVENT_PKG dependencies on CSP_INV_LOC_ASSIGNMENTS

Line 651: csp_inv_loc_assignments cila

647: OR NOT EXISTS
648: (
649: SELECT 1
650: FROM csm_inv_loc_ass_acc acc,
651: csp_inv_loc_assignments cila
652: WHERE acc.user_id = ohqacc.user_id
653: AND acc.csp_inv_loc_assignment_id = cila.csp_inv_loc_assignment_id
654: AND cila.organization_id = ohqacc.organization_id
655: AND cila.subinventory_code = ohqacc.subinventory_code

Line 717: csp_inv_loc_assignments ila1

713: AND SYSDATE BETWEEN nvl(cbtc.start_date_active, SYSDATE) AND nvl(cbtc.end_date_active, SYSDATE)
714: AND EXISTS
715: ( SELECT 1
716: FROM csm_inv_loc_ass_acc ilaacc1,
717: csp_inv_loc_assignments ila1
718: -- csp_sec_inventories csi --R12Not requirec as we are now downloading both the items in good and bad subinv
719: WHERE ilaacc1.user_id = au.user_id
720: AND ilaacc1.csp_inv_loc_assignment_id = ila1.csp_inv_loc_assignment_id
721: AND ila1.subinventory_code = ohqmv.subinventory_code