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.

[Home] [Help]

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 6573: DELETE MSC_ATP_SUMMARY_SD where plan_id = p_plan_id;

6569:
6570: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'Inside shared part_partition');
6571: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'before deleteing data from the table');
6572:
6573: DELETE MSC_ATP_SUMMARY_SD where plan_id = p_plan_id;
6574: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'After deleting data from the table');
6575:
6576: END IF; --- IF share_partition = 'Y'
6577:

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

6581: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'Insert data into sd table');
6582:
6583: load_sd_full_alloc(p_plan_id, p_sys_date);
6584:
6585: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'After inserting into MSC_ATP_SUMMARY_SD');
6586: ELSE -- IF G_ALLOC_ATP = 'Y' AND G_CLASS_HRCHY = 1 AND G_ALLOC_METHOD = 1 THEN
6587: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'Unallocated ATP');
6588: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'Insert data into sd table');
6589:

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

6614: -- End ATP4drp
6615: END IF;
6616: END IF;
6617:
6618: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'After inserting into MSC_ATP_SUMMARY_SD');
6619: END IF; -- IF G_ALLOC_ATP = 'Y' AND G_CLASS_HRCHY = 1 AND G_ALLOC_METHOD = 1 THEN
6620:
6621: ELSE --- IF p_full_refresh = 1 THEN
6622: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'Inside incremental summation');

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

6626: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'Insert data into sd table');
6627:
6628: load_sd_net_alloc(p_plan_id, p_last_refresh_number, p_new_refresh_number, p_sys_date);
6629:
6630: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'After inserting into MSC_ATP_SUMMARY_SD');
6631: ELSE -- IF G_ALLOC_ATP = 'Y' AND G_CLASS_HRCHY = 1 AND G_ALLOC_METHOD = 1 THEN
6632: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'Inside unallocated ATP');
6633: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'Insert data into sd table');
6634:

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

6640: load_sd_net_unalloc(p_plan_id, p_last_refresh_number, p_new_refresh_number, p_time_phased_pf, p_sys_date);
6641: END IF;
6642: -- ATP4drp
6643:
6644: msc_util.msc_log('LOAD_PLAN_SUMMARY_SD: ' || 'After inserting into MSC_ATP_SUMMARY_SD');
6645: END IF; -- IF G_ALLOC_ATP = 'Y' AND G_CLASS_HRCHY = 1 AND G_ALLOC_METHOD = 1 THEN
6646:
6647: END IF; --- IF p_full_refresh = 1 THEN
6648:

Line 6664: INSERT INTO MSC_ATP_SUMMARY_SD (

6660: msc_util.msc_log('******** LOAD_SD_FULL_UNALLOC_UNOPT Begin ********');
6661:
6662: l_user_id := FND_GLOBAL.USER_ID;
6663:
6664: INSERT INTO MSC_ATP_SUMMARY_SD (
6665: plan_id,
6666: sr_instance_id,
6667: organization_id,
6668: inventory_item_id,

Line 6804: INSERT INTO MSC_ATP_SUMMARY_SD (

6800: msc_util.msc_log('******** LOAD_SD_FULL_UNALLOC_UNOPT_PF Begin ********');
6801:
6802: l_user_id := FND_GLOBAL.USER_ID;
6803:
6804: INSERT INTO MSC_ATP_SUMMARY_SD (
6805: plan_id,
6806: sr_instance_id,
6807: organization_id,
6808: inventory_item_id,

Line 6980: INSERT INTO MSC_ATP_SUMMARY_SD (

6976: msc_util.msc_log('******** LOAD_SD_FULL_UNALLOC_OPT Begin ********');
6977:
6978: l_user_id := FND_GLOBAL.USER_ID;
6979:
6980: INSERT INTO MSC_ATP_SUMMARY_SD (
6981: plan_id,
6982: sr_instance_id,
6983: organization_id,
6984: inventory_item_id,

Line 7088: INSERT INTO MSC_ATP_SUMMARY_SD (

7084: msc_util.msc_log('******** LOAD_SD_FULL_UNALLOC_OPT_PF Begin ********');
7085:
7086: l_user_id := FND_GLOBAL.USER_ID;
7087:
7088: INSERT INTO MSC_ATP_SUMMARY_SD (
7089: plan_id,
7090: sr_instance_id,
7091: organization_id,
7092: inventory_item_id,

Line 7240: INSERT INTO MSC_ATP_SUMMARY_SD (

7236: msc_util.msc_log('******** LOAD_SD_FULL_ALLOC Begin ********');
7237:
7238: l_user_id := FND_GLOBAL.USER_ID;
7239:
7240: INSERT INTO MSC_ATP_SUMMARY_SD (
7241: plan_id,
7242: sr_instance_id,
7243: organization_id,
7244: inventory_item_id,

Line 7501: UPDATE MSC_ATP_SUMMARY_SD

7497:
7498: msc_util.msc_log('LOAD_SD_NET_UNALLOC: ' || 'l_inventory_item_id_tab.COUNT := ' || l_inventory_item_id_tab.COUNT);
7499:
7500: forall j IN l_inventory_item_id_tab.first.. l_inventory_item_id_tab.last
7501: UPDATE MSC_ATP_SUMMARY_SD
7502: SET sd_qty = sd_qty + l_sd_quantity_tab(j),
7503: last_update_date = p_sys_date,
7504: last_updated_by = l_user_id
7505: WHERE plan_id = p_plan_id

Line 7534: INSERT INTO MSC_ATP_SUMMARY_SD (

7530:
7531: msc_util.msc_log('LOAD_SD_NET_UNALLOC: ' || 'l_ins_inventory_item_id_tab.COUNT := ' || l_ins_inventory_item_id_tab.COUNT);
7532:
7533: forall j IN l_ins_inventory_item_id_tab.first.. l_ins_inventory_item_id_tab.last
7534: INSERT INTO MSC_ATP_SUMMARY_SD (
7535: plan_id,
7536: sr_instance_id,
7537: organization_id,
7538: inventory_item_id,

Line 7653: UPDATE MSC_ATP_SUMMARY_SD

7649:
7650: msc_util.msc_log('LOAD_SD_NET_ALLOC: ' || 'l_inventory_item_id_tab.COUNT := ' || l_inventory_item_id_tab.COUNT);
7651:
7652: forall j IN l_inventory_item_id_tab.first.. l_inventory_item_id_tab.last
7653: UPDATE MSC_ATP_SUMMARY_SD
7654: SET sd_qty = sd_qty + l_sd_quantity_tab(j),
7655: last_update_date = p_sys_date,
7656: last_updated_by = l_user_id
7657: WHERE plan_id = p_plan_id

Line 7689: INSERT INTO MSC_ATP_SUMMARY_SD (

7685:
7686: msc_util.msc_log('LOAD_SD_NET_ALLOC: ' || 'l_ins_inventory_item_id_tab.COUNT := ' || l_ins_inventory_item_id_tab.COUNT);
7687:
7688: forall j IN l_ins_inventory_item_id_tab.first.. l_ins_inventory_item_id_tab.last
7689: INSERT INTO MSC_ATP_SUMMARY_SD (
7690: plan_id,
7691: sr_instance_id,
7692: organization_id,
7693: inventory_item_id,

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

8774:
8775: msc_util.msc_log('Truncate_Summ_Plan_Partition: ' || 'truncate partition for sd');
8776: l_partition_name := 'ATP_SUMMARY_SD_' || to_char(p_plan_id);
8777: msc_util.msc_log('Truncate_Summ_Plan_Partition: ' || 'Partition name : ' || l_partition_name);
8778: l_sql_stmt := 'ALTER TABLE MSC_ATP_SUMMARY_SD TRUNCATE PARTITION ' ||
8779: l_partition_name || ' DROP STORAGE';
8780:
8781: BEGIN
8782: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_SD');

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

8778: l_sql_stmt := 'ALTER TABLE MSC_ATP_SUMMARY_SD TRUNCATE PARTITION ' ||
8779: l_partition_name || ' DROP STORAGE';
8780:
8781: BEGIN
8782: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_SD');
8783: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
8784: APPLICATION_SHORT_NAME => 'MSC',
8785: STATEMENT_TYPE => ad_ddl.alter_table,
8786: STATEMENT => l_sql_stmt,

Line 8787: OBJECT_NAME => 'MSC_ATP_SUMMARY_SD');

8783: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
8784: APPLICATION_SHORT_NAME => 'MSC',
8785: STATEMENT_TYPE => ad_ddl.alter_table,
8786: STATEMENT => l_sql_stmt,
8787: OBJECT_NAME => 'MSC_ATP_SUMMARY_SD');
8788: END;
8789: msc_util.msc_log('Truncate_Summ_Plan_Partition: ' || 'After truncating SD partition');
8790:
8791: ------------------------------------------------

Line 8847: tabname=>'MSC_ATP_SUMMARY_SD',

8843: l_partition_name := 'ATP_SUMMARY_SD_' || to_char(p_plan_id);
8844: END IF;
8845:
8846: fnd_stats.gather_table_stats(ownname=>'MSC',
8847: tabname=>'MSC_ATP_SUMMARY_SD',
8848: partname=>l_partition_name,
8849: granularity=>'PARTITION',
8850: percent =>10);
8851: msc_util.msc_log('Gather_Summ_Plan_Stats: ' || 'After gathering stats for S/D tables');