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_ITEM_SUB_INVENTORIES

Line 14: g_table_name1 CONSTANT VARCHAR2(30) := 'MTL_ITEM_SUB_INVENTORIES';

10: -- Person Date Comments
11: -- --------- ------ ------------------------------------------
12: -- Enter procedure, function bodies as shown below
13:
14: g_table_name1 CONSTANT VARCHAR2(30) := 'MTL_ITEM_SUB_INVENTORIES';
15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_SUBINV_ACC';
16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_SUBINV_ACC_S';
17: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
18: CSM_ACC_PKG.t_publication_item_list('CSM_MTL_ITEM_SUBINV');

Line 37: TYPE secondary_inventory_typ IS TABLE OF mtl_item_sub_inventories.secondary_inventory%TYPE INDEX BY BINARY_INTEGER;

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;
40:
41: l_inventory_items_tbl inventory_item_tbl_typ;

Line 58: mtl_item_sub_inventories mis

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
61: AND cila.csp_inv_loc_assignment_id = cila_acc.csp_inv_loc_assignment_id
62: AND cila.subinventory_code = mis.secondary_inventory

Line 153: , mtl_item_sub_inventories mis

149: , p_lastrundate IN DATE
150: , p_userid IN NUMBER) IS
151: SELECT access_id
152: FROM csm_mtl_item_subinv_acc acc
153: , mtl_item_sub_inventories mis
154: WHERE mis.inventory_item_id = acc.inventory_item_id
155: AND mis.organization_id = acc.organization_id
156: AND mis.secondary_inventory = acc.secondary_inventory
157: AND mis.last_update_date >= p_last_run_date

Line 208: TYPE secondary_inventory_typ IS TABLE OF mtl_item_sub_inventories.secondary_inventory%TYPE INDEX BY BINARY_INTEGER;

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;
212: l_sqlerrno varchar2(20);

Line 224: FROM mtl_item_sub_inventories mis

220: WHERE acc.user_id = p_userid
221: AND acc.organization_id = p_organizationid
222: AND NOT EXISTS
223: (SELECT 1
224: FROM mtl_item_sub_inventories mis
225: WHERE mis.inventory_item_id = acc.inventory_item_id
226: AND mis.organization_id = acc.organization_id
227: AND mis.secondary_inventory = acc.secondary_inventory
228: );

Line 312: mtl_item_sub_inventories mis

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
315: AND cila.csp_inv_loc_assignment_id = cila_acc.csp_inv_loc_assignment_id
316: AND cila.subinventory_code = mis.secondary_inventory

Line 331: mtl_item_sub_inventories mis,

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
334: AND msi_acc.organization_id = mis.organization_id
335: AND cila.csp_inv_loc_assignment_id = cila_acc.csp_inv_loc_assignment_id

Line 355: mtl_item_sub_inventories mis

351: IS
352: SELECT acc.access_id, acc.secondary_inventory, acc.organization_id,
353: acc.inventory_item_id, acc.user_id
354: FROM csm_mtl_item_subinv_acc acc,
355: mtl_item_sub_inventories mis
356: WHERE mis.inventory_item_id = acc.inventory_item_id
357: AND mis.secondary_inventory = acc.secondary_inventory
358: AND mis.organization_id = acc.organization_id
359: AND mis.last_update_date >= p_last_upd_date;

Line 372: mtl_item_sub_inventories mis

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
375: AND cila.csp_inv_loc_assignment_id = cila_acc.csp_inv_loc_assignment_id
376: AND cila.subinventory_code = mis.secondary_inventory

Line 387: mtl_item_sub_inventories mis,

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
390: AND msi_acc.organization_id = mis.organization_id
391: AND cila.csp_inv_loc_assignment_id = cila_acc.csp_inv_loc_assignment_id