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_ATP_SUMMARY_SUP

Line 1681: msc_util.msc_log('INSERT_SUPPLIER_DATA: ' || 'Delete Data from msc_atp_summary_sup');

1677: -- Data for share_partition='N' has already been deleted
1678: IF p_share_partition = 'Y' THEN
1679: msc_util.msc_log('INSERT_SUPPLIER_DATA: ' || 'Share partition ');
1680: --- first delete data from the table
1681: msc_util.msc_log('INSERT_SUPPLIER_DATA: ' || 'Delete Data from msc_atp_summary_sup');
1682: delete MSC_ATP_SUMMARY_SUP where plan_id = p_plan_id;
1683: END IF;
1684:
1685: msc_util.msc_log('INSERT_SUPPLIER_DATA: ' || 'Loading complete summary in MSC_ATP_SUMMARY_SUP');

Line 1682: delete MSC_ATP_SUMMARY_SUP where plan_id = p_plan_id;

1678: IF p_share_partition = 'Y' THEN
1679: msc_util.msc_log('INSERT_SUPPLIER_DATA: ' || 'Share partition ');
1680: --- first delete data from the table
1681: msc_util.msc_log('INSERT_SUPPLIER_DATA: ' || 'Delete Data from msc_atp_summary_sup');
1682: delete MSC_ATP_SUMMARY_SUP where plan_id = p_plan_id;
1683: END IF;
1684:
1685: msc_util.msc_log('INSERT_SUPPLIER_DATA: ' || 'Loading complete summary in MSC_ATP_SUMMARY_SUP');
1686: -- The actual SQL is moved to new procedure for summary enhancement

Line 1685: msc_util.msc_log('INSERT_SUPPLIER_DATA: ' || 'Loading complete summary in MSC_ATP_SUMMARY_SUP');

1681: msc_util.msc_log('INSERT_SUPPLIER_DATA: ' || 'Delete Data from msc_atp_summary_sup');
1682: delete MSC_ATP_SUMMARY_SUP where plan_id = p_plan_id;
1683: END IF;
1684:
1685: msc_util.msc_log('INSERT_SUPPLIER_DATA: ' || 'Loading complete summary in MSC_ATP_SUMMARY_SUP');
1686: -- The actual SQL is moved to new procedure for summary enhancement
1687: LOAD_SUP_DATA_FULL(p_plan_id, p_sys_date);
1688: msc_util.msc_log('INSERT_SUPPLIER_DATA: ' || 'After loading complete summary in MSC_ATP_SUMMARY_SUP');
1689:

Line 1688: msc_util.msc_log('INSERT_SUPPLIER_DATA: ' || 'After loading complete summary in MSC_ATP_SUMMARY_SUP');

1684:
1685: msc_util.msc_log('INSERT_SUPPLIER_DATA: ' || 'Loading complete summary in MSC_ATP_SUMMARY_SUP');
1686: -- The actual SQL is moved to new procedure for summary enhancement
1687: LOAD_SUP_DATA_FULL(p_plan_id, p_sys_date);
1688: msc_util.msc_log('INSERT_SUPPLIER_DATA: ' || 'After loading complete summary in MSC_ATP_SUMMARY_SUP');
1689:
1690: -- Code to gather stats was here. Removed for summary enhancement as stats are gathered right in the end.
1691:
1692: ELSE

Line 1694: msc_util.msc_log('INSERT_SUPPLIER_DATA: ' || 'Loading net summary in MSC_ATP_SUMMARY_SUP');

1690: -- Code to gather stats was here. Removed for summary enhancement as stats are gathered right in the end.
1691:
1692: ELSE
1693:
1694: msc_util.msc_log('INSERT_SUPPLIER_DATA: ' || 'Loading net summary in MSC_ATP_SUMMARY_SUP');
1695: LOAD_SUP_DATA_NET(p_plan_id, p_last_refresh_number, p_new_refresh_number, p_sys_date);
1696: msc_util.msc_log('INSERT_SUPPLIER_DATA: ' || 'After loading net summary in MSC_ATP_SUMMARY_SUP');
1697:
1698:

Line 1696: msc_util.msc_log('INSERT_SUPPLIER_DATA: ' || 'After loading net summary in MSC_ATP_SUMMARY_SUP');

1692: ELSE
1693:
1694: msc_util.msc_log('INSERT_SUPPLIER_DATA: ' || 'Loading net summary in MSC_ATP_SUMMARY_SUP');
1695: LOAD_SUP_DATA_NET(p_plan_id, p_last_refresh_number, p_new_refresh_number, p_sys_date);
1696: msc_util.msc_log('INSERT_SUPPLIER_DATA: ' || 'After loading net summary in MSC_ATP_SUMMARY_SUP');
1697:
1698:
1699: END IF;
1700:

Line 7797: INSERT INTO MSC_ATP_SUMMARY_SUP(

7793: msc_util.msc_log('LOAD_SUP_DATA_FULL: ' || 'l_calendar_code = ' || l_calendar_code);
7794:
7795: l_user_id := FND_GLOBAL.USER_ID;
7796:
7797: INSERT INTO MSC_ATP_SUMMARY_SUP(
7798: plan_id,
7799: sr_instance_id,
7800: inventory_item_id,
7801: supplier_id,

Line 8059: UPDATE MSC_ATP_SUMMARY_SUP

8055:
8056: msc_util.msc_log('LOAD_SUP_DATA_NET: ' || 'l_inventory_item_id_tab.COUNT := ' || l_inventory_item_id_tab.COUNT);
8057:
8058: forall j IN l_inventory_item_id_tab.first.. l_inventory_item_id_tab.last
8059: UPDATE MSC_ATP_SUMMARY_SUP
8060: SET sd_qty = sd_qty + l_sd_quantity_tab(j),
8061: last_update_date = p_sys_date,
8062: last_updated_by = l_user_id
8063: WHERE plan_id = p_plan_id

Line 8095: INSERT INTO MSC_ATP_SUMMARY_SUP (

8091:
8092: msc_util.msc_log('LOAD_SUP_DATA_NET: ' || 'l_ins_inventory_item_id_tab.COUNT := ' || l_ins_inventory_item_id_tab.COUNT);
8093:
8094: forall j IN l_ins_inventory_item_id_tab.first.. l_ins_inventory_item_id_tab.last
8095: INSERT INTO MSC_ATP_SUMMARY_SUP (
8096: plan_id,
8097: sr_instance_id,
8098: inventory_item_id,
8099: supplier_id,

Line 8825: l_sql_stmt := 'ALTER TABLE MSC_ATP_SUMMARY_SUP TRUNCATE PARTITION ' ||

8821:
8822: msc_util.msc_log('Truncate_Summ_Plan_Partition: ' || 'truncate partition for sup');
8823: l_partition_name := 'ATP_SUMMARY_SUP_' || to_char(p_plan_id);
8824: msc_util.msc_log('Truncate_Summ_Plan_Partition: ' || 'Partition name : ' || l_partition_name);
8825: l_sql_stmt := 'ALTER TABLE MSC_ATP_SUMMARY_SUP TRUNCATE PARTITION ' ||
8826: l_partition_name || ' DROP STORAGE';
8827:
8828: BEGIN
8829: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_SUP');

Line 8829: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_SUP');

8825: l_sql_stmt := 'ALTER TABLE MSC_ATP_SUMMARY_SUP TRUNCATE PARTITION ' ||
8826: l_partition_name || ' DROP STORAGE';
8827:
8828: BEGIN
8829: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_SUP');
8830: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
8831: APPLICATION_SHORT_NAME => 'MSC',
8832: STATEMENT_TYPE => ad_ddl.alter_table,
8833: STATEMENT => l_sql_stmt,

Line 8834: OBJECT_NAME => 'MSC_ATP_SUMMARY_SUP');

8830: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
8831: APPLICATION_SHORT_NAME => 'MSC',
8832: STATEMENT_TYPE => ad_ddl.alter_table,
8833: STATEMENT => l_sql_stmt,
8834: OBJECT_NAME => 'MSC_ATP_SUMMARY_SUP');
8835: END;
8836: msc_util.msc_log('Truncate_Summ_Plan_Partition: ' || 'After truncating sup partition');
8837:
8838: ------------------------------------------------

Line 8899: tabname=>'MSC_ATP_SUMMARY_SUP',

8895: l_partition_name := 'ATP_SUMMARY_SUP_' || to_char(p_plan_id);
8896: END IF;
8897:
8898: fnd_stats.gather_table_stats(ownname=>l_msc_schema,
8899: tabname=>'MSC_ATP_SUMMARY_SUP',
8900: partname=>l_partition_name,
8901: granularity=>'PARTITION',
8902: percent =>10);
8903: msc_util.msc_log('Gather_Summ_Plan_Stats: ' || 'After gathering stats for Sup tables');