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 2876: FROM MSC_APPS_INSTANCES

2872: v_current_date,
2873: v_current_user,
2874: v_instance_code,
2875: v_instance_type -- OPM
2876: FROM MSC_APPS_INSTANCES
2877: WHERE INSTANCE_ID= p_instance_id;
2878:
2879:
2880: -- check whether SCE is installed

Line 2980: UPDATE MSC_APPS_INSTANCES mai

2976: IS
2977: lv_param_rec_count PLS_INTEGER; -- for L flow
2978: BEGIN
2979:
2980: UPDATE MSC_APPS_INSTANCES mai
2981: SET LAST_UPDATE_DATE = v_current_date,
2982: LAST_UPDATED_BY = v_current_user,
2983: LRID= v_refresh_id,
2984: LRTYPE= 'L',

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

4178: BEGIN
4179: v_sql_stmt := 4; /*Bug 2172537*/
4180: lv_sql_stmt :=
4181: 'SELECT 1'
4182: ||' FROM msc_calendar_shifts mcs, msc_apps_instances mai '
4183: ||' WHERE NOT EXISTS(SELECT 1 '
4184: ||' FROM msc_st_workday_patterns mwp '
4185: ||' WHERE mwp.shift_name = mcs.shift_name'
4186: ||' AND mcs.calendar_code = mwp.calendar_code'

Line 7617: ||' update msc_apps_instances'

7613: ||' RETCODE => retcode,'
7614: ||' p_instance_id => :v_instance_id,'
7615: ||' p_batch_id => :lv_batch_id);'
7616: ||' IF ( retcode = '||G_WARNING||') THEN '
7617: ||' update msc_apps_instances'
7618: ||' set dbs_ver = '||SYS_YES
7619: ||' where instance_id='||v_instance_id||';'
7620: ||' END IF;'
7621: ||' END ;';

Line 8530: ||' update msc_apps_instances'

8526: ||' RETCODE => retcode ,'
8527: ||' p_instance_id => :v_instance_id,'
8528: ||' p_batch_id => :lv_batch_id);'
8529: ||' IF ( retcode = '||G_WARNING||') THEN '
8530: ||' update msc_apps_instances'
8531: ||' set dbs_ver = '||SYS_YES
8532: ||' where instance_id='||v_instance_id||';'
8533: ||' END IF;'
8534: ||' END ;';

Line 24116: msc_apps_instances mai

24112: ||' WHERE nvl(serial_number_control_code,2) = 2 '
24113: ||' AND EXISTS (SELECT serial_number_control_code
24114: FROM msc_system_items msi,
24115: msc_item_id_lid miil,
24116: msc_apps_instances mai
24117: WHERE msi.plan_id = -1
24118: AND msi.organization_id = mssi.organization_id
24119: AND msi.sr_instance_id = mai.instance_id
24120: AND msi.inventory_item_id = miil.inventory_item_id

Line 24132: msc_apps_instances mai

24128: msc_sup_dem_entries msde,
24129: msc_trading_partner_maps mtpm,
24130: msc_trading_partners mtp,
24131: msc_item_id_lid miil,
24132: msc_apps_instances mai
24133: WHERE msde.inventory_item_id = miil.inventory_item_id
24134: AND miil.sr_inventory_item_id = mssi.sr_inventory_item_id
24135: AND miil.sr_instance_id = mai.instance_id
24136: AND mai.instance_code = mssi.sr_instance_code

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

28228: v_sql_stmt := 09;
28229:
28230: lv_sql_stmt:=
28231: 'UPDATE msc_st_item_sourcing msis'
28232: ||' SET receipt_org_instance_id = ( SELECT instance_id FROM msc_apps_instances mai'
28233: ||' WHERE mai.instance_code = msis.sr_instance_code)'
28234: ||' WHERE sr_instance_code = :v_instance_code'
28235: ||' AND batch_id = :lv_batch_id'
28236: ||' AND process_flag ='||G_IN_PROCESS

Line 35111: ||' FROM msc_apps_instances mai'

35107: lv_sql_stmt :=
35108: 'UPDATE msc_st_supplies mss'
35109: ||' SET source_organization_id = from_organization_id,'
35110: ||' source_sr_instance_id = (select instance_id'
35111: ||' FROM msc_apps_instances mai'
35112: ||' WHERE mai.instance_code = mss.source_sr_instance_code)'
35113: ||' WHERE deleted_flag ='|| SYS_NO
35114: ||' AND process_flag ='|| G_IN_PROCESS
35115: ||' AND NVL(batch_id,'||NULL_VALUE||')= :p_batch_id'

Line 35883: FROM msc_apps_instances

35879: , apps_ver
35880: INTO
35881: lv_allow_atp_flag
35882: , lv_apps_ver
35883: FROM msc_apps_instances
35884: WHERE
35885: instance_id = v_instance_id;
35886:
35887: IF (lv_allow_atp_flag = 1) AND (lv_apps_ver = -1) THEN

Line 57389: ||' update msc_apps_instances'

57385: ||' RETCODE => retcode ,'
57386: ||' p_calendar_code => :v_calendar_code,'
57387: ||' p_instance_id => :v_instance_id );'
57388: ||' IF ( retcode = '||G_WARNING||') THEN '
57389: ||' update msc_apps_instances'
57390: ||' set dbs_ver = '||SYS_YES
57391: ||' where instance_id='||v_instance_id||';'
57392: ||' END IF;'
57393: ||' END ;';

Line 57593: 'UPDATE msc_apps_instances mai'

57589: END IF;
57590:
57591:
57592: lv_sql_stmt :=
57593: 'UPDATE msc_apps_instances mai'
57594: ||' SET (validation_org_id, lbj_details) = (SELECT validation_org_id, wsm_create_lbj_copy_routing'
57595: ||' FROM msc_st_apps_instances msai'
57596: ||' WHERE msai.sr_instance_code = mai.instance_code'
57597: ||' AND msai.sr_instance_id = mai.instance_id'

Line 57639: FROM MSC_APPS_INSTANCES mai

57635: IF p_st_status= G_ST_PRE_PROCESSING THEN
57636:
57637: SELECT mai.ST_STATUS
57638: INTO lv_staging_table_status
57639: FROM MSC_APPS_INSTANCES mai
57640: WHERE mai.INSTANCE_ID= p_instance_id
57641: FOR UPDATE;
57642:
57643: IF lv_staging_table_status= G_ST_PULLING THEN

Line 57676: UPDATE MSC_APPS_INSTANCES

57672:
57673: ELSE
57674: RETCODE := G_SUCCESS;
57675:
57676: UPDATE MSC_APPS_INSTANCES
57677: SET ST_STATUS= G_ST_PRE_PROCESSING,
57678: LCID= MSC_COLLECTION_S.NEXTVAL,
57679: LAST_UPDATE_DATE= v_current_date,
57680: LAST_UPDATED_BY= v_current_user,

Line 57695: UPDATE MSC_APPS_INSTANCES

57691:
57692: ---===================== READY ====================
57693: ELSIF p_st_status= G_ST_READY THEN
57694:
57695: UPDATE MSC_APPS_INSTANCES
57696: SET ST_STATUS= G_ST_READY,
57697: LAST_UPDATE_DATE= v_current_date,
57698: LAST_UPDATED_BY= v_current_user,
57699: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

Line 58150: FROM MSC_APPS_INSTANCES

58146:
58147:
58148: CURSOR Warn_Flag IS
58149: SELECT dbs_ver
58150: FROM MSC_APPS_INSTANCES
58151: WHERE instance_id = p_instance_id;
58152:
58153:
58154: BEGIN

Line 58301: UPDATE MSC_APPS_INSTANCES mai

58297:
58298:
58299: ---========Get the new refresh ID =================
58300: IF v_req_data = G_NEW_REQUEST THEN
58301: UPDATE MSC_APPS_INSTANCES mai
58302: SET LRID= msc_cl_refresh_s.nextval, mai.DBS_VER= SYS_NO
58303: WHERE mai.INSTANCE_ID = p_instance_id;
58304: commit;
58305: END IF;

Line 59533: UPDATE MSC_APPS_INSTANCES mai

59529: ELSE
59530:
59531: lv_task_number:= TASK_ALL_COMPLETED;
59532:
59533: UPDATE MSC_APPS_INSTANCES mai
59534: SET LAST_UPDATE_DATE= v_current_date,
59535: LAST_UPDATED_BY= v_current_user,
59536: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
59537: WHERE mai.INSTANCE_ID= v_instance_id;