APPS.CSM_MTL_MATERIAL_TXN_ACC_PKG dependencies on CSM_INV_LOC_ASS_ACC

Line 200: FROM csm_inv_loc_ass_acc cilaa,

196: MTL_MATERIAL_TRANSACTIONS B
197: WHERE B.TRANSACTION_ID = ACC.TRANSACTION_ID
198: AND B.TRANSACTION_ACTION_ID = 2 --Subinventory transfer
199: AND (NOT EXISTS (SELECT 1
200: FROM csm_inv_loc_ass_acc cilaa,
201: csp_inv_loc_assignments cila
202: WHERE cilaa.csp_inv_loc_assignment_id = cila.csp_inv_loc_assignment_id
203: AND cilaa.user_id = ACC.user_id
204: AND cila.subinventory_code = B.subinventory_code

Line 208: FROM csm_inv_loc_ass_acc cilaa,

204: AND cila.subinventory_code = B.subinventory_code
205: AND cila.organization_id = B.organization_id)
206: OR
207: NOT EXISTS (SELECT 1
208: FROM csm_inv_loc_ass_acc cilaa,
209: csp_inv_loc_assignments cila
210: WHERE cilaa.csp_inv_loc_assignment_id = cila.csp_inv_loc_assignment_id
211: AND cilaa.user_id = ACC.user_id
212: AND cila.subinventory_code = B.transfer_subinventory

Line 233: csm_inv_loc_ass_acc cilaa,

229: IS
230: SELECT cilaa.user_id
231: , B.TRANSACTION_ID
232: FROM MTL_MATERIAL_TRANSACTIONS B,
233: csm_inv_loc_ass_acc cilaa,
234: csp_inv_loc_assignments cila_from
235: WHERE cilaa.csp_inv_loc_assignment_id = cila_from.csp_inv_loc_assignment_id
236: AND TRANSACTION_ACTION_ID = 2 --Subinventory transfer
237: AND cila_from.subinventory_code = B.subinventory_code

Line 248: csm_inv_loc_ass_acc cilaa,

244: UNION ALL
245: SELECT cilaa.user_id
246: , B.TRANSACTION_ID
247: FROM MTL_MATERIAL_TRANSACTIONS B,
248: csm_inv_loc_ass_acc cilaa,
249: csp_inv_loc_assignments cila_to
250: WHERE cilaa.csp_inv_loc_assignment_id = cila_to.csp_inv_loc_assignment_id
251: AND TRANSACTION_ACTION_ID = 2 --Subinventory transfer
252: AND cila_to.subinventory_code = B.transfer_subinventory

Line 406: csm_inv_loc_ass_acc cilaa,

402: --Insert if either from OR to subinv are assigned to the mobile user
403: CURSOR l_mat_insert_csr (b_user_id IN NUMBER) IS
404: SELECT B.TRANSACTION_ID
405: FROM MTL_MATERIAL_TRANSACTIONS B,
406: csm_inv_loc_ass_acc cilaa,
407: csp_inv_loc_assignments cila_from
408: WHERE cilaa.csp_inv_loc_assignment_id = cila_from.csp_inv_loc_assignment_id
409: AND TRANSACTION_ACTION_ID = 2 --Subinventory transfer
410: AND cila_from.subinventory_code = B.subinventory_code

Line 420: csm_inv_loc_ass_acc cilaa,

416: AND B.transaction_date > (sysdate -CSM_PROFILE_PKG.get_task_history_days(cilaa.user_id))
417: UNION ALL
418: SELECT B.TRANSACTION_ID
419: FROM MTL_MATERIAL_TRANSACTIONS B,
420: csm_inv_loc_ass_acc cilaa,
421: csp_inv_loc_assignments cila_to
422: WHERE cilaa.csp_inv_loc_assignment_id = cila_to.csp_inv_loc_assignment_id
423: AND TRANSACTION_ACTION_ID = 2 --Subinventory transfer
424: AND cila_to.subinventory_code = B.transfer_subinventory