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 205: csp_inv_loc_assignments cila

201: OR
202: NOT EXISTS
203: (SELECT 1
204: FROM csm_inv_loc_ass_acc cilaa,
205: csp_inv_loc_assignments cila
206: WHERE cilaa.csp_inv_loc_assignment_id = cila.csp_inv_loc_assignment_id
207: AND cilaa.user_id = ACC.user_id
208: AND cila.subinventory_code = B.subinventory_code
209: AND cila.organization_id = B.organization_id

Line 213: csp_inv_loc_assignments cila

209: AND cila.organization_id = B.organization_id
210: UNION ALL
211: SELECT 1
212: FROM csm_inv_loc_ass_acc cilaa,
213: csp_inv_loc_assignments cila
214: WHERE cilaa.csp_inv_loc_assignment_id = cila.csp_inv_loc_assignment_id
215: AND cilaa.user_id = ACC.user_id
216: AND cila.subinventory_code = B.transfer_subinventory
217: AND cila.organization_id = B.transfer_organization_id)

Line 236: csp_inv_loc_assignments cila_from

232: SELECT cilaa.user_id
233: , B.TRANSACTION_ID
234: FROM MTL_MATERIAL_TRANSACTIONS B,
235: csm_inv_loc_ass_acc cilaa,
236: csp_inv_loc_assignments cila_from
237: WHERE cilaa.csp_inv_loc_assignment_id = cila_from.csp_inv_loc_assignment_id
238: AND TRANSACTION_ACTION_ID = 2 --Subinventory transfer
239: AND cila_from.subinventory_code = B.subinventory_code
240: AND cila_from.organization_id = B.organization_id

Line 251: csp_inv_loc_assignments cila_to

247: SELECT cilaa.user_id
248: , B.TRANSACTION_ID
249: FROM MTL_MATERIAL_TRANSACTIONS B,
250: csm_inv_loc_ass_acc cilaa,
251: csp_inv_loc_assignments cila_to
252: WHERE cilaa.csp_inv_loc_assignment_id = cila_to.csp_inv_loc_assignment_id
253: AND TRANSACTION_ACTION_ID = 2 --Subinventory transfer
254: AND cila_to.subinventory_code = B.transfer_subinventory
255: AND cila_to.organization_id = B.transfer_organization_id

Line 414: csp_inv_loc_assignments cila_from

410: WHERE B.transaction_date > (sysdate - b_profile_value)
411: AND B.TRANSACTION_ACTION_ID = 2 --Subinventory transfer
412: AND EXISTS( SELECT 1
413: FROM csm_inv_loc_ass_acc cilaa1,
414: csp_inv_loc_assignments cila_from
415: WHERE cilaa1.csp_inv_loc_assignment_id = cila_from.csp_inv_loc_assignment_id
416: AND cila_from.subinventory_code = B.subinventory_code
417: AND cila_from.organization_id = B.organization_id
418: AND NVL(cila_from.locator_id,0) = NVL(B.locator_id,0)

Line 430: csp_inv_loc_assignments cila_to

426: WHERE B.transaction_date > (sysdate - b_profile_value)
427: AND B.TRANSACTION_ACTION_ID = 2 --Subinventory transfer
428: AND EXISTS (SELECT 1
429: FROM csm_inv_loc_ass_acc cilaa2,
430: csp_inv_loc_assignments cila_to
431: WHERE cilaa2.csp_inv_loc_assignment_id = cila_to.csp_inv_loc_assignment_id
432: AND cila_to.subinventory_code = B.transfer_subinventory
433: AND cila_to.organization_id = B.transfer_organization_id
434: AND NVL(cila_to.locator_id,0) = NVL(B.transfer_locator_id,0)