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_POST_PRO dependencies on MSC_APPS_INSTANCES

Line 151: FROM msc_apps_instances

147: -- SELECT NVL(summary_flag, 1)
148: -- into l_summary_flag
149: SELECT NVL(summary_flag, 1), instance_code
150: into l_summary_flag, l_instance_code
151: FROM msc_apps_instances
152: where instance_id = p_instance_id;
153:
154: msc_util.msc_log('l_summary_flag := ' || l_summary_flag);
155: -- 2301524: Summary is not supported for sites using backlog workbench

Line 226: UPDATE msc_apps_instances

222:
223: --- update the tbl_status so that user can't do ATP in full refresh mode
224: IF (P_COLLECT_TYPE = 1) OR (P_COLLECT_TYPE = 3) THEN
225: BEGIN
226: UPDATE msc_apps_instances
227: set so_tbl_status = 2,
228: summary_flag = 2
229: where instance_id = p_instance_id;
230:

Line 599: UPDATE msc_apps_instances

595: MSC_POST_PRO.CLEAN_TABLES(l_applsys_schema);
596:
597: --update the so_tbl_status to 1 so that user can do ATP
598: BEGIN
599: UPDATE msc_apps_instances
600: set so_tbl_status = 1,
601: summary_flag = 3
602: where instance_id = p_instance_id;
603: --- commit the change

Line 621: UPDATE msc_apps_instances

617: --- clean tables
618: MSC_POST_PRO.CLEAN_TABLES(l_applsys_schema);
619: ----update so_tbl_status
620: BEGIN
621: UPDATE msc_apps_instances
622: set so_tbl_status = 1,
623: summary_flag = 1
624: where instance_id = p_instance_id;
625: END;

Line 1129: from msc_apps_instances

1125: -- for summary enhancement - backlog workbench will be supported with summary
1126: /*
1127: SELECT NVL(SUMMARY_FLAG,1)
1128: into l_summary_flag
1129: from msc_apps_instances
1130: where rownum = 1;
1131:
1132: IF NVL(l_summary_flag,1) = 200 THEN
1133: msc_util.msc_log('Summary Approach is not supported for sites using backlog workbench');

Line 2362: from msc_apps_instances

2358: END IF;
2359:
2360: SELECT NVL(summary_flag, 1), NVL(summary_refresh_number,0),apps_lrn ---LCID
2361: INTO l_summary_flag,l_refresh_number,l_apps_lrn ---bug3049003
2362: from msc_apps_instances
2363: where instance_id = p_instance_id;
2364:
2365: IF NVL(l_summary_flag, 1) = 2 THEN
2366: msc_util.msc_log('Another session is running Complete summary for this instance');

Line 2823: --- update summary flag in msc_apps_instances so that summary not available to use

2819: END IF;
2820: IF (NET_CHANGE_SO_NEW%ISOPEN) THEN
2821: CLOSE NET_CHANGE_SO_NEW;
2822: END IF;
2823: --- update summary flag in msc_apps_instances so that summary not available to use
2824: update msc_apps_instances
2825: set summary_flag = 1
2826: where instance_id = p_instance_id;
2827: msc_util.msc_log('An error occured while running net change on Sales Orders');

Line 2824: update msc_apps_instances

2820: IF (NET_CHANGE_SO_NEW%ISOPEN) THEN
2821: CLOSE NET_CHANGE_SO_NEW;
2822: END IF;
2823: --- update summary flag in msc_apps_instances so that summary not available to use
2824: update msc_apps_instances
2825: set summary_flag = 1
2826: where instance_id = p_instance_id;
2827: msc_util.msc_log('An error occured while running net change on Sales Orders');
2828: msc_util.msc_log('Complete refresh would need to be run to activate Summary ATP');

Line 3237: from msc_apps_instances

3233: END IF;
3234:
3235: /* SELECT NVL(summary_flag, 1), NVL(summary_refresh_number,0) ---LCID
3236: INTO l_summary_flag, l_refresh_number
3237: from msc_apps_instances
3238: where instance_id = p_instance_id;*/
3239:
3240: SELECT NVL(summary_flag, 1), NVL(summary_refresh_number,0),apps_lrn ---LCID
3241: INTO l_summary_flag,l_refresh_number,l_apps_lrn ---bug3049003

Line 3242: from msc_apps_instances

3238: where instance_id = p_instance_id;*/
3239:
3240: SELECT NVL(summary_flag, 1), NVL(summary_refresh_number,0),apps_lrn ---LCID
3241: INTO l_summary_flag,l_refresh_number,l_apps_lrn ---bug3049003
3242: from msc_apps_instances
3243: where instance_id = p_instance_id;
3244:
3245: msc_util.msc_log('l_refresh_number := ' || l_refresh_number);
3246:

Line 3401: --- update summary flag in msc_apps_instances so that summary not available to use

3397:
3398: IF (C_NET_SUPPLY_DEMAND%ISOPEN) THEN
3399: CLOSE C_NET_SUPPLY_DEMAND;
3400: END IF;
3401: --- update summary flag in msc_apps_instances so that summary not available to use
3402: update msc_apps_instances
3403: set summary_flag = 1
3404: where instance_id = p_instance_id;
3405: msc_util.msc_log('An error occured while running net change on Sales Orders');

Line 3402: update msc_apps_instances

3398: IF (C_NET_SUPPLY_DEMAND%ISOPEN) THEN
3399: CLOSE C_NET_SUPPLY_DEMAND;
3400: END IF;
3401: --- update summary flag in msc_apps_instances so that summary not available to use
3402: update msc_apps_instances
3403: set summary_flag = 1
3404: where instance_id = p_instance_id;
3405: msc_util.msc_log('An error occured while running net change on Sales Orders');
3406: msc_util.msc_log('Complete refresh would need to be run to activate Summary ATP');

Line 3566: FROM msc_apps_instances

3562: l_table_name varchar2(30);
3563:
3564: CURSOR C_INST IS
3565: SELECT instance_id
3566: FROM msc_apps_instances
3567: WHERE instance_id > p_instance_id
3568: AND NVL(summary_flag, 0) <> 0
3569: ORDER BY instance_id;
3570:

Line 3589: FROM msc_apps_instances

3585: msc_util.msc_log('partition_name : '|| l_partition_name);
3586: BEGIN
3587: SELECT NVL(summary_flag, 0)
3588: INTO l_summary_flag
3589: FROM msc_apps_instances
3590: WHERE instance_id = p_instance_id;
3591:
3592: msc_util.msc_log('summary_flag for instance : '|| p_instance_id || ' : '|| l_summary_flag);
3593:

Line 3708: -- msc_apps_instances to look for existing instance partitions

3704: BEGIN
3705: SELECT INSTANCE_ID
3706: BULK COLLECT INTO INSTANCE_IDS
3707: ---bug 2389523: use msc_ins_partitions instead of
3708: -- msc_apps_instances to look for existing instance partitions
3709: --FROM MSC_APPS_INSTANCES
3710: FROM MSC_INST_PARTITIONS
3711: ORDER BY INSTANCE_ID;
3712: END;

Line 3709: --FROM MSC_APPS_INSTANCES

3705: SELECT INSTANCE_ID
3706: BULK COLLECT INTO INSTANCE_IDS
3707: ---bug 2389523: use msc_ins_partitions instead of
3708: -- msc_apps_instances to look for existing instance partitions
3709: --FROM MSC_APPS_INSTANCES
3710: FROM MSC_INST_PARTITIONS
3711: ORDER BY INSTANCE_ID;
3712: END;
3713:

Line 3984: UPDATE msc_apps_instances

3980: --- Net Chnage/Targeted refresh is done only for those
3981: --- Sales orders or supply/demands where refresh number is greater than summary refresh number
3982: --- This is done this way to avoid summarizing in partial refresh if it is run erroneously after
3983: --- full refresh by user.
3984: UPDATE msc_apps_instances
3985: SET summary_refresh_number = LCID
3986: WHERE instance_id = p_instance_id;
3987:
3988: commit; --bug3049003