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_MTL_MATERIAL_TXN_ACC_PKG dependencies on CSP_INV_LOC_ASSIGNMENTS

Line 201: csp_inv_loc_assignments cila

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
205: AND cila.organization_id = B.organization_id)

Line 209: csp_inv_loc_assignments cila

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
213: AND cila.organization_id = B.transfer_organization_id)

Line 234: csp_inv_loc_assignments cila_from

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
238: AND cila_from.organization_id = B.organization_id

Line 249: csp_inv_loc_assignments cila_to

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
253: AND cila_to.organization_id = B.transfer_organization_id

Line 407: csp_inv_loc_assignments cila_from

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
411: AND cila_from.organization_id = B.organization_id

Line 421: csp_inv_loc_assignments cila_to

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
425: AND cila_to.organization_id = B.transfer_organization_id