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 31: TYPE secondary_inventory_typ IS TABLE OF mtl_item_sub_inventories.secondary_inventory%TYPE INDEX BY BINARY_INTEGER;

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;
34:
35: l_inventory_items_tbl inventory_item_tbl_typ;

Line 52: mtl_item_sub_inventories mis

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
54: AND msi_acc.organization_id = mis.organization_id
55: AND cila.csp_inv_loc_assignment_id = cila_acc.csp_inv_loc_assignment_id
56: AND cila.subinventory_code = mis.secondary_inventory

Line 147: , mtl_item_sub_inventories mis

143: , p_lastrundate IN DATE
144: , p_userid IN NUMBER) IS
145: SELECT access_id
146: FROM csm_mtl_item_subinv_acc acc
147: , mtl_item_sub_inventories mis
148: WHERE mis.inventory_item_id = acc.inventory_item_id
149: AND mis.organization_id = acc.organization_id
150: AND mis.secondary_inventory = acc.secondary_inventory
151: AND mis.last_update_date >= p_last_run_date

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

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

Line 218: FROM mtl_item_sub_inventories mis

214: WHERE acc.user_id = p_userid
215: AND acc.organization_id = p_organizationid
216: AND NOT EXISTS
217: (SELECT 1
218: FROM mtl_item_sub_inventories mis
219: WHERE mis.inventory_item_id = acc.inventory_item_id
220: AND mis.organization_id = acc.organization_id
221: AND mis.secondary_inventory = acc.secondary_inventory
222: );

Line 306: mtl_item_sub_inventories mis

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
308: AND msi_acc.organization_id = mis.organization_id
309: AND cila.csp_inv_loc_assignment_id = cila_acc.csp_inv_loc_assignment_id
310: AND cila.subinventory_code = mis.secondary_inventory

Line 327: mtl_item_sub_inventories mis

323: IS
324: SELECT acc.access_id, acc.secondary_inventory, acc.organization_id,
325: acc.inventory_item_id, acc.user_id
326: FROM csm_mtl_item_subinv_acc acc,
327: mtl_item_sub_inventories mis
328: WHERE mis.inventory_item_id = acc.inventory_item_id
329: AND mis.secondary_inventory = acc.secondary_inventory
330: AND mis.organization_id = acc.organization_id
331: AND mis.last_update_date >= p_last_upd_date;

Line 344: mtl_item_sub_inventories mis

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
346: AND msi_acc.organization_id = mis.organization_id
347: AND cila.csp_inv_loc_assignment_id = cila_acc.csp_inv_loc_assignment_id
348: AND cila.subinventory_code = mis.secondary_inventory