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.MSC_CL_PRE_PROCESS dependencies on MSC_APPS_INSTANCES

Line 2868: FROM MSC_APPS_INSTANCES

2864: v_current_date,
2865: v_current_user,
2866: v_instance_code,
2867: v_instance_type -- OPM
2868: FROM MSC_APPS_INSTANCES
2869: WHERE INSTANCE_ID= p_instance_id;
2870:
2871:
2872: -- check whether SCE is installed

Line 2972: UPDATE MSC_APPS_INSTANCES mai

2968: IS
2969: lv_param_rec_count PLS_INTEGER; -- for L flow
2970: BEGIN
2971:
2972: UPDATE MSC_APPS_INSTANCES mai
2973: SET LAST_UPDATE_DATE = v_current_date,
2974: LAST_UPDATED_BY = v_current_user,
2975: LRID= v_refresh_id,
2976: LRTYPE= 'L',

Line 4175: ||' FROM msc_calendar_shifts mcs, msc_apps_instances mai '

4171: BEGIN
4172: v_sql_stmt := 4; /*Bug 2172537*/
4173: lv_sql_stmt :=
4174: 'SELECT 1'
4175: ||' FROM msc_calendar_shifts mcs, msc_apps_instances mai '
4176: ||' WHERE NOT EXISTS(SELECT 1 '
4177: ||' FROM msc_st_workday_patterns mwp '
4178: ||' WHERE mwp.shift_name = mcs.shift_name'
4179: ||' AND mcs.calendar_code = mwp.calendar_code'

Line 7594: ||' update msc_apps_instances'

7590: ||' RETCODE => retcode,'
7591: ||' p_instance_id => :v_instance_id,'
7592: ||' p_batch_id => :lv_batch_id);'
7593: ||' IF ( retcode = '||G_WARNING||') THEN '
7594: ||' update msc_apps_instances'
7595: ||' set dbs_ver = '||SYS_YES
7596: ||' where instance_id='||v_instance_id||';'
7597: ||' END IF;'
7598: ||' END ;';

Line 8404: ||' update msc_apps_instances'

8400: ||' RETCODE => retcode ,'
8401: ||' p_instance_id => :v_instance_id,'
8402: ||' p_batch_id => :lv_batch_id);'
8403: ||' IF ( retcode = '||G_WARNING||') THEN '
8404: ||' update msc_apps_instances'
8405: ||' set dbs_ver = '||SYS_YES
8406: ||' where instance_id='||v_instance_id||';'
8407: ||' END IF;'
8408: ||' END ;';

Line 20627: msc_apps_instances mai

20623: ||' WHERE nvl(serial_number_control_code,2) = 2 '
20624: ||' AND EXISTS (SELECT serial_number_control_code
20625: FROM msc_system_items msi,
20626: msc_item_id_lid miil,
20627: msc_apps_instances mai
20628: WHERE msi.plan_id = -1
20629: AND msi.organization_id = mssi.organization_id
20630: AND msi.sr_instance_id = mai.instance_id
20631: AND msi.inventory_item_id = miil.inventory_item_id

Line 20643: msc_apps_instances mai

20639: msc_sup_dem_entries msde,
20640: msc_trading_partner_maps mtpm,
20641: msc_trading_partners mtp,
20642: msc_item_id_lid miil,
20643: msc_apps_instances mai
20644: WHERE msde.inventory_item_id = miil.inventory_item_id
20645: AND miil.sr_inventory_item_id = mssi.sr_inventory_item_id
20646: AND miil.sr_instance_id = mai.instance_id
20647: AND mai.instance_code = mssi.sr_instance_code

Line 24743: ||' SET receipt_org_instance_id = ( SELECT instance_id FROM msc_apps_instances mai'

24739: v_sql_stmt := 09;
24740:
24741: lv_sql_stmt:=
24742: 'UPDATE msc_st_item_sourcing msis'
24743: ||' SET receipt_org_instance_id = ( SELECT instance_id FROM msc_apps_instances mai'
24744: ||' WHERE mai.instance_code = msis.sr_instance_code)'
24745: ||' WHERE sr_instance_code = :v_instance_code'
24746: ||' AND batch_id = :lv_batch_id'
24747: ||' AND process_flag ='||G_IN_PROCESS

Line 30631: ||' FROM msc_apps_instances mai'

30627: lv_sql_stmt :=
30628: 'UPDATE msc_st_supplies mss'
30629: ||' SET source_organization_id = from_organization_id,'
30630: ||' source_sr_instance_id = (select instance_id'
30631: ||' FROM msc_apps_instances mai'
30632: ||' WHERE mai.instance_code = mss.source_sr_instance_code)'
30633: ||' WHERE deleted_flag ='|| SYS_NO
30634: ||' AND process_flag ='|| G_IN_PROCESS
30635: ||' AND NVL(batch_id,'||NULL_VALUE||')= :p_batch_id'

Line 52358: ||' update msc_apps_instances'

52354: ||' RETCODE => retcode ,'
52355: ||' p_calendar_code => :v_calendar_code,'
52356: ||' p_instance_id => :v_instance_id );'
52357: ||' IF ( retcode = '||G_WARNING||') THEN '
52358: ||' update msc_apps_instances'
52359: ||' set dbs_ver = '||SYS_YES
52360: ||' where instance_id='||v_instance_id||';'
52361: ||' END IF;'
52362: ||' END ;';

Line 52562: 'UPDATE msc_apps_instances mai'

52558: END IF;
52559:
52560:
52561: lv_sql_stmt :=
52562: 'UPDATE msc_apps_instances mai'
52563: ||' SET (validation_org_id, lbj_details) = (SELECT validation_org_id, wsm_create_lbj_copy_routing'
52564: ||' FROM msc_st_apps_instances msai'
52565: ||' WHERE msai.sr_instance_code = mai.instance_code'
52566: ||' AND msai.sr_instance_id = mai.instance_id'

Line 52608: FROM MSC_APPS_INSTANCES mai

52604: IF p_st_status= G_ST_PRE_PROCESSING THEN
52605:
52606: SELECT mai.ST_STATUS
52607: INTO lv_staging_table_status
52608: FROM MSC_APPS_INSTANCES mai
52609: WHERE mai.INSTANCE_ID= p_instance_id
52610: FOR UPDATE;
52611:
52612: IF lv_staging_table_status= G_ST_PULLING THEN

Line 52645: UPDATE MSC_APPS_INSTANCES

52641:
52642: ELSE
52643: RETCODE := G_SUCCESS;
52644:
52645: UPDATE MSC_APPS_INSTANCES
52646: SET ST_STATUS= G_ST_PRE_PROCESSING,
52647: LCID= MSC_COLLECTION_S.NEXTVAL,
52648: LAST_UPDATE_DATE= v_current_date,
52649: LAST_UPDATED_BY= v_current_user,

Line 52664: UPDATE MSC_APPS_INSTANCES

52660:
52661: ---===================== READY ====================
52662: ELSIF p_st_status= G_ST_READY THEN
52663:
52664: UPDATE MSC_APPS_INSTANCES
52665: SET ST_STATUS= G_ST_READY,
52666: LAST_UPDATE_DATE= v_current_date,
52667: LAST_UPDATED_BY= v_current_user,
52668: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

Line 53110: FROM MSC_APPS_INSTANCES

53106:
53107:
53108: CURSOR Warn_Flag IS
53109: SELECT dbs_ver
53110: FROM MSC_APPS_INSTANCES
53111: WHERE instance_id = p_instance_id;
53112:
53113:
53114: BEGIN

Line 53257: UPDATE MSC_APPS_INSTANCES mai

53253:
53254:
53255: ---========Get the new refresh ID =================
53256: IF v_req_data = G_NEW_REQUEST THEN
53257: UPDATE MSC_APPS_INSTANCES mai
53258: SET LRID= msc_cl_refresh_s.nextval, mai.DBS_VER= SYS_NO
53259: WHERE mai.INSTANCE_ID = p_instance_id;
53260: commit;
53261: END IF;

Line 54440: UPDATE MSC_APPS_INSTANCES mai

54436: ELSE
54437:
54438: lv_task_number:= TASK_ALL_COMPLETED;
54439:
54440: UPDATE MSC_APPS_INSTANCES mai
54441: SET LAST_UPDATE_DATE= v_current_date,
54442: LAST_UPDATED_BY= v_current_user,
54443: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
54444: WHERE mai.INSTANCE_ID= v_instance_id;