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_SYSTEM_ITEM_EVENT_PKG dependencies on MTL_SYSTEM_ITEMS

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

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

Line 31: -- below procedure is called from csm_mtl_system_items where there is an org change

27: CSM_ACC_PKG.t_publication_item_list('CSF_M_ITEM_INSTANCES');
28: g_pk1_name2 CONSTANT VARCHAR2(30) := 'INSTANCE_ID';
29: g_pub_item2 CONSTANT VARCHAR2(30) := 'CSF_M_ITEM_INSTANCES';
30:
31: -- below procedure is called from csm_mtl_system_items where there is an org change
32: PROCEDURE delete_system_items(p_user_id IN NUMBER,
33: p_organization_id IN NUMBER)
34: IS
35: l_sqlerrno VARCHAR2(20);

Line 119: l_old_organization_id mtl_system_items.organization_id%TYPE;

115:
116: l_dummy BOOLEAN;
117: l_user_id_lst asg_download.user_list;
118: l_acc_id_lst asg_download.access_list;
119: l_old_organization_id mtl_system_items.organization_id%TYPE;
120: l_organization_id mtl_system_items.organization_id%TYPE;
121: l_userid NUMBER;
122:
123: BEGIN

Line 120: l_organization_id mtl_system_items.organization_id%TYPE;

116: l_dummy BOOLEAN;
117: l_user_id_lst asg_download.user_list;
118: l_acc_id_lst asg_download.access_list;
119: l_old_organization_id mtl_system_items.organization_id%TYPE;
120: l_organization_id mtl_system_items.organization_id%TYPE;
121: l_userid NUMBER;
122:
123: BEGIN
124: CSM_UTIL_PKG.LOG('Entering CSM_SYSTEM_ITEM_EVENT_PKG.PURGE_SYSTEM_ITEMS ',

Line 203: --SELECT /*+ INDEX (msi MTL_SYSTEM_ITEMS_B_U1) CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL,

199: l_sqlerrmsg varchar2(2000);
200:
201: CURSOR l_systemitems_ins_csr(p_new_organization_id IN number, p_user_id IN number)
202: IS
203: --SELECT /*+ INDEX (msi MTL_SYSTEM_ITEMS_B_U1) CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL,
204: au.user_id,
205: msi.inventory_item_id,
206: msi.organization_id
207: FROM asg_user au,

Line 209: mtl_system_items_b msi,

205: msi.inventory_item_id,
206: msi.organization_id
207: FROM asg_user au,
208: asg_user_pub_resps aupr,
209: mtl_system_items_b msi,
210: CS_BILLING_TYPE_CATEGORIES cbtc
211: WHERE au.user_id = p_user_id
212: AND au.user_name = aupr.user_name
213: AND aupr.pub_name = 'SERVICEP'

Line 237: l_old_organization_id mtl_system_items.organization_id%TYPE;

233: l_user_id_lst asg_download.user_list;
234: l_acc_id_lst asg_download.access_list;
235:
236: l_dummy BOOLEAN;
237: l_old_organization_id mtl_system_items.organization_id%TYPE;
238: l_organization_id mtl_system_items.organization_id%TYPE;
239: l_user_id NUMBER;
240:
241: BEGIN

Line 238: l_organization_id mtl_system_items.organization_id%TYPE;

234: l_acc_id_lst asg_download.access_list;
235:
236: l_dummy BOOLEAN;
237: l_old_organization_id mtl_system_items.organization_id%TYPE;
238: l_organization_id mtl_system_items.organization_id%TYPE;
239: l_user_id NUMBER;
240:
241: BEGIN
242: CSM_UTIL_PKG.LOG('Entering CSM_SYSTEM_ITEM_EVENT_PKG.GET_NEW_SYSTEM_ITEMS ',

Line 350: SELECT MAX(last_update_date) FROM mtl_system_items_b;

346: AND procedure_name = 'REFRESH_ACC';
347:
348: CURSOR c_max_last_upd_date_b
349: IS
350: SELECT MAX(last_update_date) FROM mtl_system_items_b;
351:
352: CURSOR c_max_last_upd_date_tl
353: IS
354: SELECT MAX(last_update_date) FROM mtl_system_items_tl;

Line 354: SELECT MAX(last_update_date) FROM mtl_system_items_tl;

350: SELECT MAX(last_update_date) FROM mtl_system_items_b;
351:
352: CURSOR c_max_last_upd_date_tl
353: IS
354: SELECT MAX(last_update_date) FROM mtl_system_items_tl;
355:
356: -- insert
357: CURSOR l_systemitems_ins_csr
358: IS

Line 359: SELECT /+ INDEX (msi MTL_SYSTEM_ITEMS_B_U1) / CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL,

355:
356: -- insert
357: CURSOR l_systemitems_ins_csr
358: IS
359: SELECT /*+ INDEX (msi MTL_SYSTEM_ITEMS_B_U1) */ CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL,
360: au.user_id,
361: msi.inventory_item_id,
362: msi.organization_id
363: FROM asg_user au,

Line 366: mtl_system_items_b msi,

362: msi.organization_id
363: FROM asg_user au,
364: asg_user_pub_resps aupr,
365: csm_user_inventory_org user_org,
366: mtl_system_items_b msi,
367: CS_BILLING_TYPE_CATEGORIES cbtc
368: WHERE au.user_name = aupr.user_name
369: AND aupr.pub_name = 'SERVICEP'
370: AND user_org.user_id = au.user_id

Line 389: SELECT /+ INDEX (acc CSM_SYSTEM_ITEMS_ACC_U1) (msi MTL_SYSTEM_ITEMS_B_U1) / acc.access_id,

385:
386: -- update
387: CURSOR l_systemitems_upd_b_csr(p_last_run_date DATE)
388: IS
389: SELECT /*+ INDEX (acc CSM_SYSTEM_ITEMS_ACC_U1) (msi MTL_SYSTEM_ITEMS_B_U1) */ acc.access_id,
390: acc.user_id,
391: msi.inventory_item_id,
392: msi.organization_id
393: FROM csm_system_items_acc acc,

Line 394: mtl_system_items_b msi

390: acc.user_id,
391: msi.inventory_item_id,
392: msi.organization_id
393: FROM csm_system_items_acc acc,
394: mtl_system_items_b msi
395: WHERE acc.inventory_item_id = msi.inventory_item_id
396: AND acc.organization_id = msi.organization_id
397: AND msi.last_update_date >= p_last_run_date
398: ;

Line 402: SELECT /+ INDEX (acc CSM_SYSTEM_ITEMS_ACC_U1) (msi_tl MTL_SYSTEM_ITEMS_TL_U1) / acc.access_id,

398: ;
399:
400: CURSOR l_systemitems_upd_tl_csr(p_last_run_date DATE)
401: IS
402: SELECT /*+ INDEX (acc CSM_SYSTEM_ITEMS_ACC_U1) (msi_tl MTL_SYSTEM_ITEMS_TL_U1) */ acc.access_id,
403: acc.user_id,
404: msi_tl.inventory_item_id,
405: msi_tl.organization_id
406: FROM csm_system_items_acc acc,

Line 408: mtl_system_items_tl msi_tl

404: msi_tl.inventory_item_id,
405: msi_tl.organization_id
406: FROM csm_system_items_acc acc,
407: asg_user au,
408: mtl_system_items_tl msi_tl
409: WHERE acc.user_id = au.user_id
410: AND acc.inventory_item_id = msi_tl.inventory_item_id
411: AND acc.organization_id = msi_tl.organization_id
412: AND au.LANGUAGE = msi_tl.LANGUAGE

Line 425: FROM mtl_system_items_b msi,

421: acc.organization_id
422: FROM csm_system_items_acc acc
423: WHERE NOT EXISTS
424: (SELECT 1
425: FROM mtl_system_items_b msi,
426: CS_BILLING_TYPE_CATEGORIES cbtc
427: WHERE msi.inventory_item_id = acc.inventory_item_id
428: AND msi.organization_id = acc.organization_id
429: AND msi.material_billable_flag = cbtc.billing_type

Line 499: /* This portion of code assumes indexes on last_update_date on MTL_SYSTEM_ITEMS_B */

495: IF l_org_id.COUNT > 0 THEN
496: l_org_id.DELETE;
497: END IF;
498:
499: /* This portion of code assumes indexes on last_update_date on MTL_SYSTEM_ITEMS_B */
500: /* , MTL_SYSTEM_ITEMS_TL which were custom created */
501:
502: -- get max last_upd_date from msi
503: OPEN c_max_last_upd_date_b;

Line 500: /* , MTL_SYSTEM_ITEMS_TL which were custom created */

496: l_org_id.DELETE;
497: END IF;
498:
499: /* This portion of code assumes indexes on last_update_date on MTL_SYSTEM_ITEMS_B */
500: /* , MTL_SYSTEM_ITEMS_TL which were custom created */
501:
502: -- get max last_upd_date from msi
503: OPEN c_max_last_upd_date_b;
504: FETCH c_max_last_upd_date_b INTO l_max_last_update_date_b;

Line 685: SELECT distinct /+ index (msi MTL_SYSTEM_ITEMS_B_U1) index (ohqmv MTL_ONHAND_QUANTITIES_N5) / au.user_id

681:
682: -- get the onhand details for mobile subinventories that are not present
683: -- for some or all the mobile users
684: CURSOR l_onhand_insert_csr IS
685: SELECT distinct /*+ index (msi MTL_SYSTEM_ITEMS_B_U1) index (ohqmv MTL_ONHAND_QUANTITIES_N5) */ au.user_id
686: , ohqmv.INVENTORY_ITEM_ID
687: , ohqmv.ORGANIZATION_ID
688: , ohqmv.SUBINVENTORY_CODE
689: , ohqmv.LOCATOR_ID

Line 703: mtl_system_items_b msi,

699: nvl(ohqmv.LOT_NUMBER,-9999)=nvl(ohqmv2.LOT_NUMBER,-9999))
700: FROM asg_user au,
701: asg_user_pub_resps aupr,
702: mtl_onhand_quantities_detail ohqmv,
703: mtl_system_items_b msi,
704: CS_BILLING_TYPE_CATEGORIES cbtc
705: WHERE au.user_name = aupr.user_name
706: AND aupr.pub_name = 'SERVICEP'
707: AND au.user_id = au.owner_id

Line 1007: SELECT /+ INDEX (msi MTL_SYSTEM_ITEMS_B_U1) / CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL,

1003: l_sqlerrmsg varchar2(2000);
1004:
1005: CURSOR l_systemitems_ins_csr(p_organization_id IN NUMBER, p_user_id IN NUMBER)
1006: IS
1007: SELECT /*+ INDEX (msi MTL_SYSTEM_ITEMS_B_U1) */ CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL,
1008: au.user_id,
1009: msi.inventory_item_id,
1010: msi.organization_id
1011: FROM asg_user au,

Line 1013: mtl_system_items_b msi,

1009: msi.inventory_item_id,
1010: msi.organization_id
1011: FROM asg_user au,
1012: asg_user_pub_resps aupr,
1013: mtl_system_items_b msi,
1014: CS_BILLING_TYPE_CATEGORIES cbtc
1015: WHERE au.user_id = p_user_id
1016: AND au.user_name = aupr.user_name
1017: AND aupr.pub_name = 'SERVICEP'

Line 1041: l_organization_id mtl_system_items.organization_id%TYPE;

1037: l_user_id_lst asg_download.user_list;
1038: l_acc_id_lst asg_download.access_list;
1039:
1040: l_dummy BOOLEAN;
1041: l_organization_id mtl_system_items.organization_id%TYPE;
1042:
1043: BEGIN
1044: CSM_UTIL_PKG.LOG('Entering CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items ',
1045: 'CSM_SYSTEM_ITEM_EVENT_PKG.get_new_user_system_items',FND_LOG.LEVEL_PROCEDURE);