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 CSM_INV_LOC_ASS_ACC

Line 56: csm_inv_loc_ass_acc cila_acc,

52: p_lastrundate IN date)
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

Line 310: csm_inv_loc_ass_acc cila_acc,

306: CURSOR l_ins_mtl_item_subinv_csr
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

Line 329: csm_inv_loc_ass_acc cila_acc,

325: )
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

Line 370: csm_inv_loc_ass_acc cila_acc,

366: FROM csm_mtl_item_subinv_acc acc
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

Line 385: csm_inv_loc_ass_acc cila_acc,

381: AND acc.secondary_inventory = cila.subinventory_code
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