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 CSM_INV_LOC_ASS_ACC

Line 739: FROM csm_inv_loc_ass_acc acc,

735: )
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

Line 805: FROM csm_inv_loc_ass_acc ilaacc1,

801: AND cbtc.billing_category = 'M'
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