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_B

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 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 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 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 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 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'