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

30: PROCEDURE INSERT_MTL_ITEM_SUBINV( p_organization_id IN number
31: , p_user_id IN number
32: , p_last_run_date IN date)
33: IS
34: TYPE inventory_item_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
35: TYPE organization_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE
36: INDEX BY BINARY_INTEGER;
37: TYPE secondary_inventory_typ IS TABLE OF mtl_item_sub_inventories.secondary_inventory%TYPE INDEX BY BINARY_INTEGER;
38: TYPE access_id_tbl_typ IS TABLE OF number INDEX BY binary_integer;

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

31: , p_user_id IN number
32: , p_last_run_date IN date)
33: IS
34: TYPE inventory_item_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
35: TYPE organization_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE
36: INDEX BY BINARY_INTEGER;
37: TYPE secondary_inventory_typ IS TABLE OF mtl_item_sub_inventories.secondary_inventory%TYPE INDEX BY BINARY_INTEGER;
38: TYPE access_id_tbl_typ IS TABLE OF number INDEX BY binary_integer;
39: TYPE user_id_tbl_typ IS TABLE OF number INDEX BY binary_integer;

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

202: PROCEDURE DELETE_MTL_ITEM_SUBINV( p_organization_id IN number
203: , p_user_id IN number
204: , p_last_run_date IN date)
205: IS
206: TYPE inventory_item_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
207: TYPE organization_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;
208: TYPE secondary_inventory_typ IS TABLE OF mtl_item_sub_inventories.secondary_inventory%TYPE INDEX BY BINARY_INTEGER;
209: l_inventory_items_tbl inventory_item_tbl_typ;
210: l_organizations_tbl organization_tbl_typ;

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

203: , p_user_id IN number
204: , p_last_run_date IN date)
205: IS
206: TYPE inventory_item_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
207: TYPE organization_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;
208: TYPE secondary_inventory_typ IS TABLE OF mtl_item_sub_inventories.secondary_inventory%TYPE INDEX BY BINARY_INTEGER;
209: l_inventory_items_tbl inventory_item_tbl_typ;
210: l_organizations_tbl organization_tbl_typ;
211: l_sec_inventory_tbl secondary_inventory_typ;

Line 292: l_user_palm_organization_id mtl_system_items.organization_id%TYPE;

288: l_all_omfs_palm_resource_list asg_download.user_list;
289: l_valid_omfs_resource_list asg_download.user_list;
290: l_null_palm_omfs_resource_list asg_download.user_list;
291: l_user_id fnd_user.user_id%TYPE;
292: l_user_palm_organization_id mtl_system_items.organization_id%TYPE;
293: l_user_language mtl_system_items_tl.language%TYPE;
294: l_run_date date;
295: l_sqlerrno varchar2(20);
296: l_sqlerrmsg varchar2(2000);

Line 293: l_user_language mtl_system_items_tl.language%TYPE;

289: l_valid_omfs_resource_list asg_download.user_list;
290: l_null_palm_omfs_resource_list asg_download.user_list;
291: l_user_id fnd_user.user_id%TYPE;
292: l_user_palm_organization_id mtl_system_items.organization_id%TYPE;
293: l_user_language mtl_system_items_tl.language%TYPE;
294: l_run_date date;
295: l_sqlerrno varchar2(20);
296: l_sqlerrmsg varchar2(2000);
297:

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