DBA Data[Home] [Help]

APPS.CSM_MTL_ITEM_LOC_EVENT_PKG dependencies on CSP_INV_LOC_ASSIGNMENTS

Line 57: csp_inv_loc_assignments cila,

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
61: AND mil.organization_id = cila.organization_id

Line 92: csp_inv_loc_assignments cila,

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
96: AND mil.inventory_location_id = acc.inventory_location_id