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

Line 57: csp_inv_loc_assignments cila,

53: IS
54: SELECT cila_acc.user_id, mis.inventory_item_id, mis.organization_id, mis.secondary_inventory
55: FROM csm_mtl_system_items_acc msi_acc,
56: csm_inv_loc_ass_acc cila_acc,
57: csp_inv_loc_assignments cila,
58: mtl_item_sub_inventories mis
59: WHERE msi_acc.inventory_item_id = mis.inventory_item_id
60: AND msi_acc.organization_id = mis.organization_id
61: AND cila.csp_inv_loc_assignment_id = cila_acc.csp_inv_loc_assignment_id

Line 311: csp_inv_loc_assignments cila,

307: IS
308: SELECT cila_acc.user_id, mis.inventory_item_id, mis.organization_id, mis.secondary_inventory
309: FROM csm_mtl_system_items_acc msi_acc,
310: csm_inv_loc_ass_acc cila_acc,
311: csp_inv_loc_assignments cila,
312: mtl_item_sub_inventories mis
313: WHERE msi_acc.inventory_item_id = mis.inventory_item_id
314: AND msi_acc.organization_id = mis.organization_id
315: AND cila.csp_inv_loc_assignment_id = cila_acc.csp_inv_loc_assignment_id

Line 330: csp_inv_loc_assignments cila,

326: UNION ALL
327: SELECT cila_acc.user_id, mis.inventory_item_id, mis.organization_id, mis.secondary_inventory
328: FROM csm_mtl_system_items_acc msi_acc,
329: csm_inv_loc_ass_acc cila_acc,
330: csp_inv_loc_assignments cila,
331: mtl_item_sub_inventories mis,
332: csm_user_inventory_org uorg
333: WHERE msi_acc.inventory_item_id = mis.inventory_item_id
334: AND msi_acc.organization_id = mis.organization_id

Line 371: csp_inv_loc_assignments cila,

367: WHERE NOT EXISTS
368: (SELECT 1
369: FROM csm_mtl_system_items_acc msi_acc,
370: csm_inv_loc_ass_acc cila_acc,
371: csp_inv_loc_assignments cila,
372: mtl_item_sub_inventories mis
373: WHERE msi_acc.inventory_item_id = mis.inventory_item_id
374: AND msi_acc.organization_id = mis.organization_id
375: AND cila.csp_inv_loc_assignment_id = cila_acc.csp_inv_loc_assignment_id

Line 386: csp_inv_loc_assignments cila,

382: UNION ALL
383: SELECT 1
384: FROM csm_mtl_system_items_acc msi_acc,
385: csm_inv_loc_ass_acc cila_acc,
386: csp_inv_loc_assignments cila,
387: mtl_item_sub_inventories mis,
388: csm_user_inventory_org uorg
389: WHERE msi_acc.inventory_item_id = mis.inventory_item_id
390: AND msi_acc.organization_id = mis.organization_id