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_SD

Line 335: msc_util.msc_log('Load SD details in msc_atp_summary_sd table');

331: GROUP BY so.inventory_item_id, so.organization_id, so.demand_class,
332: so.sd_date, -1, p_instance_id, l_sys_date, l_user_id);
333:
334: END IF;
335: msc_util.msc_log('Load SD details in msc_atp_summary_sd table');
336:
337: IF (P_COLLECT_TYPE= 2 ) OR (P_COLLECT_TYPE= 3 ) THEN
338: msc_util.msc_log('Load SD Details, ODS Case');
339:

Line 566: msc_util.msc_log('Before create index on MSC_atp_summary_sd: ');

562: '
563: -- NOLOGGING
564: (plan_id, sr_instance_id, organization_id,inventory_item_id,sd_date, demand_class)
565: storage(INITIAL 40K NEXT 2M PCTINCREASE 0)'; --tablespace ' || l_tbspace(i);
566: msc_util.msc_log('Before create index on MSC_atp_summary_sd: ');
567: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
568: APPLICATION_SHORT_NAME => 'MSC',
569: STATEMENT_TYPE => ad_ddl.create_index,
570: STATEMENT => l_sql_stmt_1,

Line 580: l_sql_stmt := 'ALTER TABLE MSC_ATP_SUMMARY_SD exchange partition ' || l_partition_name ||

576: l_partition_name := 'ATP_SUMMARY_SD__' || to_char(p_instance_id) ;
577:
578: msc_util.msc_log('Partition name for msc_atp_summary table sd part := ' || l_partition_name);
579:
580: l_sql_stmt := 'ALTER TABLE MSC_ATP_SUMMARY_SD exchange partition ' || l_partition_name ||
581: ' with table MSC_TEMP_SUMM_SD'||
582: ' including indexes without validation';
583:
584: BEGIN

Line 585: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_sd: ');

581: ' with table MSC_TEMP_SUMM_SD'||
582: ' including indexes without validation';
583:
584: BEGIN
585: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_sd: ');
586: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
587: APPLICATION_SHORT_NAME => 'MSC',
588: STATEMENT_TYPE => ad_ddl.alter_table,
589: STATEMENT => l_sql_stmt,

Line 590: OBJECT_NAME => 'MSC_ATP_SUMMARY_SD');

586: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
587: APPLICATION_SHORT_NAME => 'MSC',
588: STATEMENT_TYPE => ad_ddl.alter_table,
589: STATEMENT => l_sql_stmt,
590: OBJECT_NAME => 'MSC_ATP_SUMMARY_SD');
591: END;
592: END IF;
593:
594: ---- clean tables

Line 3330: UPDATE MSC_ATP_SUMMARY_SD

3326: msc_util.msc_log('l_inventory_item_id := ' || l_inventory_item_id);
3327:
3328: --- With 9i the entire set can be accomplished in one MERGE statement.
3329: --- Try to update record first and then
3330: UPDATE MSC_ATP_SUMMARY_SD
3331: SET sd_qty = sd_qty + l_sd_qty, -- APPLY THE DELTA
3332: last_update_date = l_sysdate,
3333: last_updated_by = l_user_id
3334: WHERE plan_id = -1

Line 3346: INSERT INTO MSC_ATP_SUMMARY_SD

3342: --- if not found insert it.
3343: IF (SQL%NOTFOUND) THEN
3344: --- Insert the new record
3345: BEGIN
3346: INSERT INTO MSC_ATP_SUMMARY_SD
3347: (plan_id,
3348: sr_instance_id,
3349: organization_id,
3350: inventory_item_id,

Line 3369: UPDATE MSC_ATP_SUMMARY_SD

3365: -- If a record has already been inserted by another process
3366: -- If insert fails then update.
3367: WHEN DUP_VAL_ON_INDEX THEN
3368: -- Update the record.
3369: UPDATE MSC_ATP_SUMMARY_SD
3370: SET sd_qty = sd_qty + l_sd_qty, -- The value is a DELTA
3371: last_update_date = l_sysdate,
3372: last_updated_by = l_user_id
3373: WHERE plan_id = -1

Line 3619: ELSIF l_table_name = 'MSC_ATP_SUMMARY_SD' THEN

3615: || l_split_partition || ' AT ( '
3616: || to_char(p_instance_id +1) || ')'
3617: || ' INTO ( PARTITION ' || l_partition_name || ','
3618: || ' PARTITION ' || l_split_partition || ')';
3619: ELSIF l_table_name = 'MSC_ATP_SUMMARY_SD' THEN
3620: l_sql_stmt := 'alter table ' || l_table_name || ' split partition '
3621: || l_split_partition || ' AT ( -1, '
3622: || to_char(p_instance_id +1) || ')'
3623: || ' INTO ( PARTITION ' || l_partition_name || ','

Line 3752: ELSIF l_table_name = 'MSC_ATP_SUMMARY_SD' THEN

3748: || l_split_partition || ' AT ( '
3749: || to_char(instance_ids(j) +1) || ')'
3750: || ' INTO ( PARTITION ' || l_partition_name || ','
3751: || ' PARTITION ' || l_split_partition || ')';
3752: ELSIF l_table_name = 'MSC_ATP_SUMMARY_SD' THEN
3753: l_sql_stmt := 'alter table ' || l_table_name || ' split partition '
3754: || l_split_partition || ' AT ( -1, '
3755: || to_char(instance_ids(j) +1) || ')'
3756: || ' INTO ( PARTITION ' || l_partition_name || ','

Line 6602: DELETE MSC_ATP_SUMMARY_SD where plan_id = p_plan_id;

6598:
6599: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'Inside shared part_partition');
6600: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'before deleteing data from the table');
6601:
6602: DELETE MSC_ATP_SUMMARY_SD where plan_id = p_plan_id;
6603: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'After deleting data from the table');
6604:
6605: END IF; --- IF share_partition = 'Y'
6606:

Line 6614: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'After inserting into MSC_ATP_SUMMARY_SD');

6610: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'Insert data into sd table');
6611:
6612: load_sd_full_alloc(p_plan_id, p_sys_date);
6613:
6614: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'After inserting into MSC_ATP_SUMMARY_SD');
6615: ELSE -- IF G_ALLOC_ATP = 'Y' AND G_CLASS_HRCHY = 1 AND G_ALLOC_METHOD = 1 THEN
6616: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'Unallocated ATP');
6617: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'Insert data into sd table');
6618:

Line 6647: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'After inserting into MSC_ATP_SUMMARY_SD');

6643: -- End ATP4drp
6644: END IF;
6645: END IF;
6646:
6647: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'After inserting into MSC_ATP_SUMMARY_SD');
6648: END IF; -- IF G_ALLOC_ATP = 'Y' AND G_CLASS_HRCHY = 1 AND G_ALLOC_METHOD = 1 THEN
6649:
6650: ELSE --- IF p_full_refresh = 1 THEN
6651: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'Inside incremental summation');

Line 6659: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'After inserting into MSC_ATP_SUMMARY_SD');

6655: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'Insert data into sd table');
6656:
6657: load_sd_net_alloc(p_plan_id, p_last_refresh_number, p_new_refresh_number, p_sys_date);
6658:
6659: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'After inserting into MSC_ATP_SUMMARY_SD');
6660: ELSE -- IF G_ALLOC_ATP = 'Y' AND G_CLASS_HRCHY = 1 AND G_ALLOC_METHOD = 1 THEN
6661: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'Inside unallocated ATP');
6662: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'Insert data into sd table');
6663:

Line 6673: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'After inserting into MSC_ATP_SUMMARY_SD');

6669: load_sd_net_unalloc(p_plan_id, p_last_refresh_number, p_new_refresh_number, p_time_phased_pf, p_sys_date);
6670: END IF;
6671: -- ATP4drp
6672:
6673: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'After inserting into MSC_ATP_SUMMARY_SD');
6674: END IF; -- IF G_ALLOC_ATP = 'Y' AND G_CLASS_HRCHY = 1 AND G_ALLOC_METHOD = 1 THEN
6675:
6676: END IF; --- IF p_full_refresh = 1 THEN
6677:

Line 6693: INSERT INTO MSC_ATP_SUMMARY_SD (

6689: msc_util.msc_log('******** LOAD_SD_FULL_UNALLOC_UNOPT Begin ********');
6690:
6691: l_user_id := FND_GLOBAL.USER_ID;
6692:
6693: INSERT INTO MSC_ATP_SUMMARY_SD (
6694: plan_id,
6695: sr_instance_id,
6696: organization_id,
6697: inventory_item_id,

Line 6833: INSERT INTO MSC_ATP_SUMMARY_SD (

6829: msc_util.msc_log('******** LOAD_SD_FULL_UNALLOC_UNOPT_PF Begin ********');
6830:
6831: l_user_id := FND_GLOBAL.USER_ID;
6832:
6833: INSERT INTO MSC_ATP_SUMMARY_SD (
6834: plan_id,
6835: sr_instance_id,
6836: organization_id,
6837: inventory_item_id,

Line 7009: INSERT INTO MSC_ATP_SUMMARY_SD (

7005: msc_util.msc_log('******** LOAD_SD_FULL_UNALLOC_OPT Begin ********');
7006:
7007: l_user_id := FND_GLOBAL.USER_ID;
7008:
7009: INSERT INTO MSC_ATP_SUMMARY_SD (
7010: plan_id,
7011: sr_instance_id,
7012: organization_id,
7013: inventory_item_id,

Line 7117: INSERT INTO MSC_ATP_SUMMARY_SD (

7113: msc_util.msc_log('******** LOAD_SD_FULL_UNALLOC_OPT_PF Begin ********');
7114:
7115: l_user_id := FND_GLOBAL.USER_ID;
7116:
7117: INSERT INTO MSC_ATP_SUMMARY_SD (
7118: plan_id,
7119: sr_instance_id,
7120: organization_id,
7121: inventory_item_id,

Line 7269: INSERT INTO MSC_ATP_SUMMARY_SD (

7265: msc_util.msc_log('******** LOAD_SD_FULL_ALLOC Begin ********');
7266:
7267: l_user_id := FND_GLOBAL.USER_ID;
7268:
7269: INSERT INTO MSC_ATP_SUMMARY_SD (
7270: plan_id,
7271: sr_instance_id,
7272: organization_id,
7273: inventory_item_id,

Line 7530: UPDATE MSC_ATP_SUMMARY_SD

7526:
7527: msc_util.msc_log('LOAD_SD_NET_UNALLOC: ' || 'l_inventory_item_id_tab.COUNT := ' || l_inventory_item_id_tab.COUNT);
7528:
7529: forall j IN l_inventory_item_id_tab.first.. l_inventory_item_id_tab.last
7530: UPDATE MSC_ATP_SUMMARY_SD
7531: SET sd_qty = sd_qty + l_sd_quantity_tab(j),
7532: last_update_date = p_sys_date,
7533: last_updated_by = l_user_id
7534: WHERE plan_id = p_plan_id

Line 7563: INSERT INTO MSC_ATP_SUMMARY_SD (

7559:
7560: msc_util.msc_log('LOAD_SD_NET_UNALLOC: ' || 'l_ins_inventory_item_id_tab.COUNT := ' || l_ins_inventory_item_id_tab.COUNT);
7561:
7562: forall j IN l_ins_inventory_item_id_tab.first.. l_ins_inventory_item_id_tab.last
7563: INSERT INTO MSC_ATP_SUMMARY_SD (
7564: plan_id,
7565: sr_instance_id,
7566: organization_id,
7567: inventory_item_id,

Line 7682: UPDATE MSC_ATP_SUMMARY_SD

7678:
7679: msc_util.msc_log('LOAD_SD_NET_ALLOC: ' || 'l_inventory_item_id_tab.COUNT := ' || l_inventory_item_id_tab.COUNT);
7680:
7681: forall j IN l_inventory_item_id_tab.first.. l_inventory_item_id_tab.last
7682: UPDATE MSC_ATP_SUMMARY_SD
7683: SET sd_qty = sd_qty + l_sd_quantity_tab(j),
7684: last_update_date = p_sys_date,
7685: last_updated_by = l_user_id
7686: WHERE plan_id = p_plan_id

Line 7718: INSERT INTO MSC_ATP_SUMMARY_SD (

7714:
7715: msc_util.msc_log('LOAD_SD_NET_ALLOC: ' || 'l_ins_inventory_item_id_tab.COUNT := ' || l_ins_inventory_item_id_tab.COUNT);
7716:
7717: forall j IN l_ins_inventory_item_id_tab.first.. l_ins_inventory_item_id_tab.last
7718: INSERT INTO MSC_ATP_SUMMARY_SD (
7719: plan_id,
7720: sr_instance_id,
7721: organization_id,
7722: inventory_item_id,

Line 8807: l_sql_stmt := 'ALTER TABLE MSC_ATP_SUMMARY_SD TRUNCATE PARTITION ' ||

8803:
8804: msc_util.msc_log('Truncate_Summ_Plan_Partition: ' || 'truncate partition for sd');
8805: l_partition_name := 'ATP_SUMMARY_SD_' || to_char(p_plan_id);
8806: msc_util.msc_log('Truncate_Summ_Plan_Partition: ' || 'Partition name : ' || l_partition_name);
8807: l_sql_stmt := 'ALTER TABLE MSC_ATP_SUMMARY_SD TRUNCATE PARTITION ' ||
8808: l_partition_name || ' DROP STORAGE';
8809:
8810: BEGIN
8811: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_SD');

Line 8811: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_SD');

8807: l_sql_stmt := 'ALTER TABLE MSC_ATP_SUMMARY_SD TRUNCATE PARTITION ' ||
8808: l_partition_name || ' DROP STORAGE';
8809:
8810: BEGIN
8811: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_SD');
8812: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
8813: APPLICATION_SHORT_NAME => 'MSC',
8814: STATEMENT_TYPE => ad_ddl.alter_table,
8815: STATEMENT => l_sql_stmt,

Line 8816: OBJECT_NAME => 'MSC_ATP_SUMMARY_SD');

8812: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
8813: APPLICATION_SHORT_NAME => 'MSC',
8814: STATEMENT_TYPE => ad_ddl.alter_table,
8815: STATEMENT => l_sql_stmt,
8816: OBJECT_NAME => 'MSC_ATP_SUMMARY_SD');
8817: END;
8818: msc_util.msc_log('Truncate_Summ_Plan_Partition: ' || 'After truncating SD partition');
8819:
8820: ------------------------------------------------

Line 8885: tabname=>'MSC_ATP_SUMMARY_SD',

8881: l_partition_name := 'ATP_SUMMARY_SD_' || to_char(p_plan_id);
8882: END IF;
8883:
8884: fnd_stats.gather_table_stats(ownname=>l_msc_schema,
8885: tabname=>'MSC_ATP_SUMMARY_SD',
8886: partname=>l_partition_name,
8887: granularity=>'PARTITION',
8888: percent =>10);
8889: msc_util.msc_log('Gather_Summ_Plan_Stats: ' || 'After gathering stats for S/D tables');