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 MTL_SYSTEM_ITEMS

Line 28: TYPE inventory_item_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

24: PROCEDURE INSERT_MTL_ITEM_SUBINV( p_organization_id IN number
25: , p_user_id IN number
26: , p_last_run_date IN date)
27: IS
28: TYPE inventory_item_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
29: TYPE organization_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE
30: INDEX BY BINARY_INTEGER;
31: TYPE secondary_inventory_typ IS TABLE OF mtl_item_sub_inventories.secondary_inventory%TYPE INDEX BY BINARY_INTEGER;
32: TYPE access_id_tbl_typ IS TABLE OF number INDEX BY binary_integer;

Line 29: TYPE organization_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE

25: , p_user_id IN number
26: , p_last_run_date IN date)
27: IS
28: TYPE inventory_item_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
29: TYPE organization_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE
30: INDEX BY BINARY_INTEGER;
31: TYPE secondary_inventory_typ IS TABLE OF mtl_item_sub_inventories.secondary_inventory%TYPE INDEX BY BINARY_INTEGER;
32: TYPE access_id_tbl_typ IS TABLE OF number INDEX BY binary_integer;
33: TYPE user_id_tbl_typ IS TABLE OF number INDEX BY binary_integer;

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 200: TYPE inventory_item_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;

196: PROCEDURE DELETE_MTL_ITEM_SUBINV( p_organization_id IN number
197: , p_user_id IN number
198: , p_last_run_date IN date)
199: IS
200: TYPE inventory_item_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
201: TYPE organization_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;
202: TYPE secondary_inventory_typ IS TABLE OF mtl_item_sub_inventories.secondary_inventory%TYPE INDEX BY BINARY_INTEGER;
203: l_inventory_items_tbl inventory_item_tbl_typ;
204: l_organizations_tbl organization_tbl_typ;

Line 201: TYPE organization_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;

197: , p_user_id IN number
198: , p_last_run_date IN date)
199: IS
200: TYPE inventory_item_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
201: TYPE organization_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;
202: TYPE secondary_inventory_typ IS TABLE OF mtl_item_sub_inventories.secondary_inventory%TYPE INDEX BY BINARY_INTEGER;
203: l_inventory_items_tbl inventory_item_tbl_typ;
204: l_organizations_tbl organization_tbl_typ;
205: l_sec_inventory_tbl secondary_inventory_typ;

Line 286: l_user_palm_organization_id mtl_system_items.organization_id%TYPE;

282: l_all_omfs_palm_resource_list asg_download.user_list;
283: l_valid_omfs_resource_list asg_download.user_list;
284: l_null_palm_omfs_resource_list asg_download.user_list;
285: l_user_id fnd_user.user_id%TYPE;
286: l_user_palm_organization_id mtl_system_items.organization_id%TYPE;
287: l_user_language mtl_system_items_tl.language%TYPE;
288: l_run_date date;
289: l_sqlerrno varchar2(20);
290: l_sqlerrmsg varchar2(2000);

Line 287: l_user_language mtl_system_items_tl.language%TYPE;

283: l_valid_omfs_resource_list asg_download.user_list;
284: l_null_palm_omfs_resource_list asg_download.user_list;
285: l_user_id fnd_user.user_id%TYPE;
286: l_user_palm_organization_id mtl_system_items.organization_id%TYPE;
287: l_user_language mtl_system_items_tl.language%TYPE;
288: l_run_date date;
289: l_sqlerrno varchar2(20);
290: l_sqlerrmsg varchar2(2000);
291:

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