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 CSM_MTL_ITEM_SUBINV_ACC

Line 15: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_SUBINV_ACC';

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');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INVENTORY_ITEM_ID';

Line 16: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_MTL_ITEM_SUBINV_ACC_S';

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');
19: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INVENTORY_ITEM_ID';
20: g_pk2_name1 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';

Line 60: FROM csm_mtl_item_subinv_acc acc

56: AND cila.subinventory_code = mis.secondary_inventory
57: AND cila_acc.user_id = msi_acc.user_id
58: AND NOT EXISTS
59: (SELECT 1
60: FROM csm_mtl_item_subinv_acc acc
61: WHERE acc.user_id = msi_acc.user_id
62: AND acc.inventory_item_id = mis.inventory_item_id
63: AND acc.organization_id = mis.organization_id
64: AND acc.secondary_inventory = mis.secondary_inventory

Line 80: INSERT INTO csm_mtl_item_subinv_acc(access_id, user_id, inventory_item_id, organization_id, secondary_inventory, counter,

76: CLOSE l_ins_mtl_item_subinv_csr;
77:
78: IF l_access_id_tbl.count > 0 THEN
79: FORALL i IN 1..l_access_id_tbl.count
80: INSERT INTO csm_mtl_item_subinv_acc(access_id, user_id, inventory_item_id, organization_id, secondary_inventory, counter,
81: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
82: VALUES (l_access_id_tbl(i), p_user_id, l_inventory_items_tbl(i), l_organizations_tbl(i),l_sec_inventory_tbl(i), 1,
83: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
84:

Line 85: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_access_id_tbl.count || ' records into csm_mtl_item_subinv_acc for user ' || p_user_id ,

81: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
82: VALUES (l_access_id_tbl(i), p_user_id, l_inventory_items_tbl(i), l_organizations_tbl(i),l_sec_inventory_tbl(i), 1,
83: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
84:
85: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_access_id_tbl.count || ' records into csm_mtl_item_subinv_acc for user ' || p_user_id ,
86: 'CSM_MTL_ITEM_SUBINV_EVENT_PKG.INSERT_MTL_ITEM_SUBINV',FND_LOG.LEVEL_STATEMENT);
87:
88: -- make dirty calls
89: FOR i IN 1..l_access_id_tbl.count LOOP

Line 146: FROM csm_mtl_item_subinv_acc acc

142: CURSOR l_upd_mtl_item_subinv_csr( p_organizationid IN number
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

Line 213: FROM csm_mtl_item_subinv_acc acc

209: CURSOR l_del_mtl_item_subinv_csr( p_organizationid IN number
210: , p_userid IN NUMBER)
211: IS
212: SELECT acc.inventory_item_id, acc.organization_id, acc.secondary_inventory
213: FROM csm_mtl_item_subinv_acc acc
214: WHERE acc.user_id = p_userid
215: AND acc.organization_id = p_organizationid
216: AND NOT EXISTS
217: (SELECT 1

Line 314: FROM csm_mtl_item_subinv_acc acc

310: AND cila.subinventory_code = mis.secondary_inventory
311: AND cila_acc.user_id = msi_acc.user_id
312: AND NOT EXISTS
313: (SELECT 1
314: FROM csm_mtl_item_subinv_acc acc
315: WHERE acc.user_id = msi_acc.user_id
316: AND acc.inventory_item_id = mis.inventory_item_id
317: AND acc.organization_id = mis.organization_id
318: AND acc.secondary_inventory = mis.secondary_inventory

Line 326: FROM csm_mtl_item_subinv_acc acc,

322: CURSOR l_upd_mtl_item_subinv_csr(p_last_upd_date DATE)
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

Line 338: FROM csm_mtl_item_subinv_acc acc

334: CURSOR l_del_mtl_item_subinv_csr
335: IS
336: SELECT acc.access_id, acc.secondary_inventory, acc.organization_id,
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,