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 66: FROM csm_mtl_item_subinv_acc acc

62: AND cila.subinventory_code = mis.secondary_inventory
63: AND cila_acc.user_id = msi_acc.user_id
64: AND NOT EXISTS
65: (SELECT 1
66: FROM csm_mtl_item_subinv_acc acc
67: WHERE acc.user_id = msi_acc.user_id
68: AND acc.inventory_item_id = mis.inventory_item_id
69: AND acc.organization_id = mis.organization_id
70: AND acc.secondary_inventory = mis.secondary_inventory

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

82: CLOSE l_ins_mtl_item_subinv_csr;
83:
84: IF l_access_id_tbl.count > 0 THEN
85: FORALL i IN 1..l_access_id_tbl.count
86: INSERT INTO csm_mtl_item_subinv_acc(access_id, user_id, inventory_item_id, organization_id, secondary_inventory, counter,
87: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
88: VALUES (l_access_id_tbl(i), p_user_id, l_inventory_items_tbl(i), l_organizations_tbl(i),l_sec_inventory_tbl(i), 1,
89: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
90:

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

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

Line 152: FROM csm_mtl_item_subinv_acc acc

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

Line 219: FROM csm_mtl_item_subinv_acc acc

215: CURSOR l_del_mtl_item_subinv_csr( p_organizationid IN number
216: , p_userid IN NUMBER)
217: IS
218: SELECT acc.inventory_item_id, acc.organization_id, acc.secondary_inventory
219: FROM csm_mtl_item_subinv_acc acc
220: WHERE acc.user_id = p_userid
221: AND acc.organization_id = p_organizationid
222: AND NOT EXISTS
223: (SELECT 1

Line 320: FROM csm_mtl_item_subinv_acc acc

316: AND cila.subinventory_code = mis.secondary_inventory
317: AND cila_acc.user_id = msi_acc.user_id
318: AND NOT EXISTS
319: (SELECT 1
320: FROM csm_mtl_item_subinv_acc acc
321: WHERE acc.user_id = msi_acc.user_id
322: AND acc.inventory_item_id = mis.inventory_item_id
323: AND acc.organization_id = mis.organization_id
324: AND acc.secondary_inventory = mis.secondary_inventory

Line 342: FROM csm_mtl_item_subinv_acc acc

338: AND msi_acc.user_id = -1
339: AND uorg.organization_id = msi_acc.organization_id
340: AND NOT EXISTS
341: (SELECT 1
342: FROM csm_mtl_item_subinv_acc acc
343: WHERE acc.user_id = cila_acc.user_id
344: AND acc.inventory_item_id = mis.inventory_item_id
345: AND acc.organization_id = mis.organization_id
346: AND acc.secondary_inventory = mis.secondary_inventory

Line 354: FROM csm_mtl_item_subinv_acc acc,

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

Line 366: FROM csm_mtl_item_subinv_acc acc

362: CURSOR l_del_mtl_item_subinv_csr
363: IS
364: SELECT acc.access_id, acc.secondary_inventory, acc.organization_id,
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,