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 740: csp_inv_loc_assignments cila

736: OR NOT EXISTS
737: (
738: SELECT 1
739: FROM csm_inv_loc_ass_acc acc,
740: csp_inv_loc_assignments cila
741: WHERE acc.user_id = ohqacc.user_id
742: AND acc.csp_inv_loc_assignment_id = cila.csp_inv_loc_assignment_id
743: AND cila.organization_id = ohqacc.organization_id
744: AND cila.subinventory_code = ohqacc.subinventory_code

Line 806: csp_inv_loc_assignments ila1

802: AND SYSDATE BETWEEN nvl(cbtc.start_date_active, SYSDATE) AND nvl(cbtc.end_date_active, SYSDATE)
803: AND EXISTS
804: ( SELECT 1
805: FROM csm_inv_loc_ass_acc ilaacc1,
806: csp_inv_loc_assignments ila1
807: -- csp_sec_inventories csi --R12Not requirec as we are now downloading both the items in good and bad subinv
808: WHERE ilaacc1.user_id = au.user_id
809: AND ilaacc1.csp_inv_loc_assignment_id = ila1.csp_inv_loc_assignment_id
810: AND ila1.subinventory_code = ohqmv.subinventory_code

Line 1431: AND EXISTS ( SELECT 1 FROM csp_inv_loc_assignments ila

1427: AND ohqmv.organization_id=p_org_id
1428: AND nvl(ohqmv.subinventory_code,'-999') = nvl(p_subinv_code,'-999')
1429: AND au.user_id = au.owner_id
1430: AND au.user_id=p_user_id
1431: AND EXISTS ( SELECT 1 FROM csp_inv_loc_assignments ila
1432: WHERE ila.resource_id = au.resource_id
1433: AND ila.resource_type='RS_EMPLOYEE'
1434: AND ila.subinventory_code = ohqmv.subinventory_code
1435: AND ila.organization_id = ohqmv.organization_id