APPS.CSM_MTL_ITEM_SUBINV_EVENT_PKG dependencies on CSM_MTL_SYSTEM_ITEMS_ACC

Line 49: FROM csm_mtl_system_items_acc msi_acc,

45: p_userid IN number,
46: p_lastrundate IN date)
47: IS
48: SELECT cila_acc.user_id, mis.inventory_item_id, mis.organization_id, mis.secondary_inventory
49: FROM csm_mtl_system_items_acc msi_acc,
50: csm_inv_loc_ass_acc cila_acc,
51: csp_inv_loc_assignments cila,
52: mtl_item_sub_inventories mis
53: WHERE msi_acc.inventory_item_id = mis.inventory_item_id

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

131: PROCEDURE UPDATE_MTL_ITEM_SUBINV( p_organization_id IN number
132: , p_user_id IN number
133: , p_last_run_date IN date)
134: IS
135: TYPE access_id_tbl_typ IS TABLE OF csm_mtl_system_items_acc.access_id%TYPE INDEX BY BINARY_INTEGER;
136: l_access_id_tbl access_id_tbl_typ;
137: l_mark_dirty boolean;
138: l_run_date date;
139: l_sqlerrno varchar2(20);

Line 303: FROM csm_mtl_system_items_acc msi_acc,

299: --process inserts
300: CURSOR l_ins_mtl_item_subinv_csr
301: IS
302: SELECT cila_acc.user_id, mis.inventory_item_id, mis.organization_id, mis.secondary_inventory
303: FROM csm_mtl_system_items_acc msi_acc,
304: csm_inv_loc_ass_acc cila_acc,
305: csp_inv_loc_assignments cila,
306: mtl_item_sub_inventories mis
307: WHERE msi_acc.inventory_item_id = mis.inventory_item_id

Line 341: FROM csm_mtl_system_items_acc msi_acc,

337: acc.inventory_item_id, acc.user_id
338: FROM csm_mtl_item_subinv_acc acc
339: WHERE NOT EXISTS
340: (SELECT 1
341: FROM csm_mtl_system_items_acc msi_acc,
342: csm_inv_loc_ass_acc cila_acc,
343: csp_inv_loc_assignments cila,
344: mtl_item_sub_inventories mis
345: WHERE msi_acc.inventory_item_id = mis.inventory_item_id