APPS.CSM_SYSTEM_ITEM_EVENT_PKG dependencies on CSM_INV_LOC_ASS_ACC

Line 650: FROM csm_inv_loc_ass_acc acc,

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

Line 716: FROM csm_inv_loc_ass_acc ilaacc1,

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