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_SO

Line 523: ---- Create index on MSC_ATP_SUMMARY_SO

519:
520: ---exchange partition
521: IF (P_COLLECT_TYPE = 1) OR (P_COLLECT_TYPE = 3) THEN
522: msc_util.msc_log('Swap partition for Slaes Orders. Only for full collection');
523: ---- Create index on MSC_ATP_SUMMARY_SO
524: BEGIN
525: msc_util.msc_log('Create index on MSC_TEMP_SUMM_SO');
526: l_sql_stmt_1 := 'create UNIQUE index MSC_TEMP_SUMM_SO_N1 on MSC_TEMP_SUMM_SO ' ||
527: '

Line 531: msc_util.msc_log('Before create index on MSC_atp_summary_so: ');

527: '
528: -- NOLOGGING
529: (sr_instance_id, organization_id, inventory_item_id, sd_date, demand_class)
530: storage(INITIAL 40K NEXT 2M PCTINCREASE 0)'; --tablespace ' || l_tbspace(i);
531: msc_util.msc_log('Before create index on MSC_atp_summary_so: ');
532: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
533: APPLICATION_SHORT_NAME => 'MSC',
534: STATEMENT_TYPE => ad_ddl.create_index,
535: STATEMENT => l_sql_stmt_1,

Line 543: l_sql_stmt := 'ALTER TABLE MSC_ATP_SUMMARY_SO exchange partition ' || l_partition_name ||

539: fnd_stats.gather_table_stats(l_msc_schema, 'MSC_TEMP_SUMM_SO', granularity => 'ALL');
540:
541: l_partition_name := 'ATP_SUMMARY_SO__' || to_char(p_instance_id);
542: msc_util.msc_log('Sales order partition name := ' || l_partition_name);
543: l_sql_stmt := 'ALTER TABLE MSC_ATP_SUMMARY_SO exchange partition ' || l_partition_name ||
544: ' with table MSC_TEMP_SUMM_SO'||
545: ' including indexes without validation';
546:
547: BEGIN

Line 548: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_SO: ');

544: ' with table MSC_TEMP_SUMM_SO'||
545: ' including indexes without validation';
546:
547: BEGIN
548: msc_util.msc_log('Before alter table MSC_ATP_SUMMARY_SO: ');
549: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
550: APPLICATION_SHORT_NAME => 'MSC',
551: STATEMENT_TYPE => ad_ddl.alter_table,
552: STATEMENT => l_sql_stmt,

Line 553: OBJECT_NAME => 'MSC_ATP_SUMMARY_SO');

549: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
550: APPLICATION_SHORT_NAME => 'MSC',
551: STATEMENT_TYPE => ad_ddl.alter_table,
552: STATEMENT => l_sql_stmt,
553: OBJECT_NAME => 'MSC_ATP_SUMMARY_SO');
554: END;
555: END IF;
556:
557: IF (P_COLLECT_TYPE = 2) OR (P_COLLECT_TYPE = 3) THEN

Line 2449: INSERT INTO MSC_ATP_SUMMARY_SO

2445:
2446: --- With 9i the entire set can be accomplished in one MERGE statement.
2447: --- Insert the new record
2448: BEGIN
2449: INSERT INTO MSC_ATP_SUMMARY_SO
2450: (plan_id,
2451: sr_instance_id,
2452: organization_id,
2453: inventory_item_id,

Line 2471: UPDATE MSC_ATP_SUMMARY_SO

2467: EXCEPTION
2468: -- If a record has already been inserted by another process
2469: WHEN DUP_VAL_ON_INDEX THEN
2470: -- Update the record.
2471: UPDATE MSC_ATP_SUMMARY_SO
2472: SET sd_qty = sd_qty + l_sd_qty, -- The value is now a DELTA
2473: last_update_date = l_sysdate,
2474: last_updated_by = l_user_id
2475: WHERE plan_id = -1

Line 2518: UPDATE MSC_ATP_SUMMARY_SO

2514: msc_util.msc_log('l_sd_date := ' || l_sd_date);
2515: msc_util.msc_log('l_sd_qty := ' || l_sd_qty);
2516: msc_util.msc_log('l_inventory_item_id := ' || l_inventory_item_id);
2517:
2518: UPDATE MSC_ATP_SUMMARY_SO
2519: SET sd_qty = sd_qty + l_sd_qty, -- APPLY THE DELTA
2520: last_update_date = l_sysdate,
2521: last_updated_by = l_user_id
2522: WHERE plan_id = -1

Line 2530: INSERT INTO MSC_ATP_SUMMARY_SO

2526: AND demand_class = l_demand_class
2527: AND trunc(sd_date) = trunc(l_sd_date);
2528: IF (SQL%NOTFOUND) THEN
2529: BEGIN
2530: INSERT INTO MSC_ATP_SUMMARY_SO
2531: (plan_id,
2532: sr_instance_id,
2533: organization_id,
2534: inventory_item_id,

Line 2560: update /+ INDEX(msc_atp_summary_so MSC_ATP_SUMMARY_SO_U1) / msc_atp_summary_so

2556: -- If a record has already been inserted by another process
2557: -- If insert fails then update.
2558: WHEN DUP_VAL_ON_INDEX THEN
2559: -- Update the record.
2560: update /*+ INDEX(msc_atp_summary_so MSC_ATP_SUMMARY_SO_U1) */ msc_atp_summary_so
2561: set sd_qty = (sd_qty + l_sd_qty),
2562: last_update_date = l_sysdate,
2563: last_updated_by = l_user_id
2564: where inventory_item_id = l_inventory_item_id

Line 2573: UPDATE MSC_ATP_SUMMARY_SO

2569:
2570: END;
2571: END IF;
2572:
2573: UPDATE MSC_ATP_SUMMARY_SO
2574: SET sd_qty = sd_qty - l_sd_qty, -- APPLY THE DELTA
2575: last_update_date = l_sysdate,
2576: last_updated_by = l_user_id
2577: WHERE plan_id = -1

Line 2585: INSERT INTO MSC_ATP_SUMMARY_SO

2581: AND demand_class = l_demand_class
2582: AND trunc(sd_date) = trunc(l_sys_next_date);
2583: IF (SQL%NOTFOUND) THEN
2584: BEGIN
2585: INSERT INTO MSC_ATP_SUMMARY_SO
2586: (plan_id,
2587: sr_instance_id,
2588: organization_id,
2589: inventory_item_id,

Line 2615: update /+ INDEX(msc_atp_summary_so MSC_ATP_SUMMARY_SO_U1) / msc_atp_summary_so

2611: -- If a record has already been inserted by another process
2612: -- If insert fails then update.
2613: WHEN DUP_VAL_ON_INDEX THEN
2614: -- Update the record.
2615: update /*+ INDEX(msc_atp_summary_so MSC_ATP_SUMMARY_SO_U1) */ msc_atp_summary_so
2616: set sd_qty = (sd_qty - l_sd_qty),
2617: last_update_date = l_sysdate,
2618: last_updated_by = l_user_id
2619: where inventory_item_id = l_inventory_item_id

Line 2659: UPDATE MSC_ATP_SUMMARY_SO

2655: msc_util.msc_log('l_sd_date := ' || l_sd_date);
2656: msc_util.msc_log('l_sd_qty := ' || l_sd_qty);
2657: msc_util.msc_log('l_inventory_item_id := ' || l_inventory_item_id);
2658:
2659: UPDATE MSC_ATP_SUMMARY_SO
2660: SET sd_qty = sd_qty + l_sd_qty, -- APPLY THE DELTA
2661: last_update_date = l_sysdate,
2662: last_updated_by = l_user_id
2663: WHERE plan_id = -1

Line 2671: INSERT INTO MSC_ATP_SUMMARY_SO

2667: AND demand_class = l_demand_class
2668: AND trunc(sd_date) = trunc(l_sd_date);
2669: IF (SQL%NOTFOUND) THEN
2670: BEGIN
2671: INSERT INTO MSC_ATP_SUMMARY_SO
2672: (plan_id,
2673: sr_instance_id,
2674: organization_id,
2675: inventory_item_id,

Line 2701: update /+ INDEX(msc_atp_summary_so MSC_ATP_SUMMARY_SO_U1) / msc_atp_summary_so

2697: -- If a record has already been inserted by another process
2698: -- If insert fails then update.
2699: WHEN DUP_VAL_ON_INDEX THEN
2700: -- Update the record.
2701: update /*+ INDEX(msc_atp_summary_so MSC_ATP_SUMMARY_SO_U1) */ msc_atp_summary_so
2702: set sd_qty = (sd_qty + l_sd_qty),
2703: last_update_date = l_sysdate,
2704: last_updated_by = l_user_id
2705: where inventory_item_id = l_inventory_item_id

Line 2749: UPDATE MSC_ATP_SUMMARY_SO

2745:
2746: --- With 9i the entire set can be accomplished in one MERGE statement.
2747: --- Try to update it first and then
2748:
2749: UPDATE MSC_ATP_SUMMARY_SO
2750: SET sd_qty = sd_qty + l_sd_qty, -- APPLY THE DELTA
2751: last_update_date = l_sysdate,
2752: last_updated_by = l_user_id
2753: WHERE plan_id = -1

Line 2766: INSERT INTO MSC_ATP_SUMMARY_SO

2762: --- if not found insert it.
2763: IF (SQL%NOTFOUND) THEN
2764: --- Insert the new record
2765: BEGIN
2766: INSERT INTO MSC_ATP_SUMMARY_SO
2767: (plan_id,
2768: sr_instance_id,
2769: organization_id,
2770: inventory_item_id,

Line 2789: UPDATE MSC_ATP_SUMMARY_SO

2785: -- If a record has already been inserted by another process
2786: -- If insert fails then update.
2787: WHEN DUP_VAL_ON_INDEX THEN
2788: -- Update the record.
2789: UPDATE MSC_ATP_SUMMARY_SO
2790: SET sd_qty = sd_qty + l_sd_qty, -- The value is a DELTA
2791: last_update_date = l_sysdate,
2792: last_updated_by = l_user_id
2793: WHERE plan_id = -1

Line 3613: IF l_table_name = 'MSC_ATP_SUMMARY_SO' THEN

3609: END IF; -- C_INST%NOTFOUND THEN
3610:
3611: CLOSE C_INST;
3612:
3613: IF l_table_name = 'MSC_ATP_SUMMARY_SO' THEN
3614: l_sql_stmt := 'alter table ' || l_table_name || ' split partition '
3615: || l_split_partition || ' AT ( '
3616: || to_char(p_instance_id +1) || ')'
3617: || ' INTO ( PARTITION ' || l_partition_name || ','

Line 3625: END IF; -- l_table_name = 'MSC_ATP_SUMMARY_SO' THEN

3621: || l_split_partition || ' AT ( -1, '
3622: || to_char(p_instance_id +1) || ')'
3623: || ' INTO ( PARTITION ' || l_partition_name || ','
3624: || ' PARTITION ' ||l_split_partition || ')';
3625: END IF; -- l_table_name = 'MSC_ATP_SUMMARY_SO' THEN
3626: msc_util.msc_log('l_sql_stmt := ' || l_sql_stmt);
3627: ad_ddl.do_ddl(APPLSYS_SCHEMA => p_applsys_schema,
3628: APPLICATION_SHORT_NAME => 'MSC',
3629: STATEMENT_TYPE => ad_ddl.alter_table,

Line 3746: IF l_table_name = 'MSC_ATP_SUMMARY_SO' THEN

3742: IF l_count = 0 THEN
3743: ---partition doesn't exist
3744:
3745:
3746: IF l_table_name = 'MSC_ATP_SUMMARY_SO' THEN
3747: l_sql_stmt := 'alter table ' || l_table_name || ' split partition '
3748: || l_split_partition || ' AT ( '
3749: || to_char(instance_ids(j) +1) || ')'
3750: || ' INTO ( PARTITION ' || l_partition_name || ','

Line 3758: END IF; -- l_table_name = 'MSC_ATP_SUMMARY_SO' THEN

3754: || l_split_partition || ' AT ( -1, '
3755: || to_char(instance_ids(j) +1) || ')'
3756: || ' INTO ( PARTITION ' || l_partition_name || ','
3757: || ' PARTITION ' ||l_split_partition || ')';
3758: END IF; -- l_table_name = 'MSC_ATP_SUMMARY_SO' THEN
3759: msc_util.msc_log('l_sql_stmt := ' || l_sql_stmt);
3760: ad_ddl.do_ddl(APPLSYS_SCHEMA => l_applsys_schema,
3761: APPLICATION_SHORT_NAME => 'MSC',
3762: STATEMENT_TYPE => ad_ddl.alter_table,