APPS.CSM_MTL_ITEM_LOC_EVENT_PKG dependencies on CSM_INV_LOC_ASS_ACC

Line 56: FROM csm_inv_loc_ass_acc acc,

52: IS
53: SELECT acc.user_id,
54: mil.inventory_location_id,
55: mil.organization_id
56: FROM csm_inv_loc_ass_acc acc,
57: csp_inv_loc_assignments cila,
58: mtl_item_locations mil
59: WHERE cila.csp_inv_loc_assignment_id = acc.csp_inv_loc_assignment_id
60: AND mil.subinventory_code = cila.subinventory_code

Line 91: FROM csm_inv_loc_ass_acc cila_acc,

87: acc.user_id
88: FROM csm_mtl_item_locations_acc acc
89: WHERE NOT EXISTS
90: (SELECT 1
91: FROM csm_inv_loc_ass_acc cila_acc,
92: csp_inv_loc_assignments cila,
93: mtl_item_locations mil
94: WHERE cila_acc.user_id = acc.user_id
95: AND cila_acc.csp_inv_loc_assignment_id = cila.csp_inv_loc_assignment_id