APPS.CSM_MTL_ITEM_SUBINV_EVENT_PKG dependencies on CSM_MTL_SYSTEM_ITEMS_ACC

Line 55: FROM csm_mtl_system_items_acc msi_acc,

51: p_userid IN number,
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

Line 141: TYPE access_id_tbl_typ IS TABLE OF csm_mtl_system_items_acc.access_id%TYPE INDEX BY BINARY_INTEGER;

137: PROCEDURE UPDATE_MTL_ITEM_SUBINV( p_organization_id IN number
138: , p_user_id IN number
139: , p_last_run_date IN date)
140: IS
141: TYPE access_id_tbl_typ IS TABLE OF csm_mtl_system_items_acc.access_id%TYPE INDEX BY BINARY_INTEGER;
142: l_access_id_tbl access_id_tbl_typ;
143: l_mark_dirty boolean;
144: l_run_date date;
145: l_sqlerrno varchar2(20);

Line 309: FROM csm_mtl_system_items_acc msi_acc,

305: --process inserts
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

Line 328: FROM csm_mtl_system_items_acc msi_acc,

324: AND acc.secondary_inventory = mis.secondary_inventory
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

Line 369: FROM csm_mtl_system_items_acc msi_acc,

365: acc.inventory_item_id, acc.user_id
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

Line 384: FROM csm_mtl_system_items_acc msi_acc,

380: AND msi_acc.organization_id = acc.organization_id
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