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_DEMAND_PKG dependencies on MSC_ST_DEMANDS_F

Line 76: -- msc_st_demands_f:demands

72: p_plan_id||','||p_plan_run_id||','||l_plan_type||','||
73: l_sr_instance_id||','||l_plan_start_date||','||l_plan_cutoff_date||','||
74: l_transfer_id||','||l_refresh_mode||','||l_item_rn_qid);
75:
76: -- msc_st_demands_f:demands
77: insert /*+ append nologging */ into msc_st_demands_f (
78: st_transaction_id,
79: error_code,
80: sr_instance_id,

Line 77: insert /+ append nologging / into msc_st_demands_f (

73: l_sr_instance_id||','||l_plan_start_date||','||l_plan_cutoff_date||','||
74: l_transfer_id||','||l_refresh_mode||','||l_item_rn_qid);
75:
76: -- msc_st_demands_f:demands
77: insert /*+ append nologging */ into msc_st_demands_f (
78: st_transaction_id,
79: error_code,
80: sr_instance_id,
81: organization_id,

Line 449: msc_phub_util.log('insert into msc_st_demands_f:demands: '||sql%rowcount);

445: trunc(nvl(md.firm_date,md.using_assembly_demand_date)) ),
446: -1 * md.origination_type,
447: nvl(md.item_type_value,1);
448:
449: msc_phub_util.log('insert into msc_st_demands_f:demands: '||sql%rowcount);
450: commit;
451:
452: -- msc_st_demands_f:ods_forecast
453: insert /*+ append nologging */ into msc_st_demands_f (

Line 452: -- msc_st_demands_f:ods_forecast

448:
449: msc_phub_util.log('insert into msc_st_demands_f:demands: '||sql%rowcount);
450: commit;
451:
452: -- msc_st_demands_f:ods_forecast
453: insert /*+ append nologging */ into msc_st_demands_f (
454: st_transaction_id,
455: error_code,
456: sr_instance_id,

Line 453: insert /+ append nologging / into msc_st_demands_f (

449: msc_phub_util.log('insert into msc_st_demands_f:demands: '||sql%rowcount);
450: commit;
451:
452: -- msc_st_demands_f:ods_forecast
453: insert /*+ append nologging */ into msc_st_demands_f (
454: st_transaction_id,
455: error_code,
456: sr_instance_id,
457: organization_id,

Line 574: msc_phub_util.log('insert into msc_st_demands_f:ods_forecast: '||sql%rowcount);

570: md.order_date,
571: -1 * md.origination_type,
572: nvl(md.item_type_value,1);
573:
574: msc_phub_util.log('insert into msc_st_demands_f:ods_forecast: '||sql%rowcount);
575: commit;
576:
577: -- msc_st_demands_f:ods_sales_orders
578: insert /*+ append nologging */ into msc_st_demands_f (

Line 577: -- msc_st_demands_f:ods_sales_orders

573:
574: msc_phub_util.log('insert into msc_st_demands_f:ods_forecast: '||sql%rowcount);
575: commit;
576:
577: -- msc_st_demands_f:ods_sales_orders
578: insert /*+ append nologging */ into msc_st_demands_f (
579: st_transaction_id,
580: error_code,
581: sr_instance_id,

Line 578: insert /+ append nologging / into msc_st_demands_f (

574: msc_phub_util.log('insert into msc_st_demands_f:ods_forecast: '||sql%rowcount);
575: commit;
576:
577: -- msc_st_demands_f:ods_sales_orders
578: insert /*+ append nologging */ into msc_st_demands_f (
579: st_transaction_id,
580: error_code,
581: sr_instance_id,
582: organization_id,

Line 654: msc_phub_util.log('insert into msc_st_demands_f:ods_sales_orders: '||sql%rowcount);

650: decode(sign(mso.ship_to_site_use_id), 1, mso.ship_to_site_use_id, -23453),
651: nvl(mso.demand_class, '-23453'),
652: trunc(mso.requirement_date);
653:
654: msc_phub_util.log('insert into msc_st_demands_f:ods_sales_orders: '||sql%rowcount);
655: commit;
656:
657: -- msc_st_demands_f:exceptions
658: insert /*+ append nologging */ into msc_st_demands_f (

Line 657: -- msc_st_demands_f:exceptions

653:
654: msc_phub_util.log('insert into msc_st_demands_f:ods_sales_orders: '||sql%rowcount);
655: commit;
656:
657: -- msc_st_demands_f:exceptions
658: insert /*+ append nologging */ into msc_st_demands_f (
659: st_transaction_id,
660: error_code,
661: sr_instance_id,

Line 658: insert /+ append nologging / into msc_st_demands_f (

654: msc_phub_util.log('insert into msc_st_demands_f:ods_sales_orders: '||sql%rowcount);
655: commit;
656:
657: -- msc_st_demands_f:exceptions
658: insert /*+ append nologging */ into msc_st_demands_f (
659: st_transaction_id,
660: error_code,
661: sr_instance_id,
662: organization_id,

Line 815: msc_phub_util.log('insert into msc_st_demands_f:exceptions: '||sql%rowcount);

811: -1 * md1.origination_type,
812: nvl(mtp1.currency_code, l_owning_currency_code),
813: nvl(md1.item_type_value,1);
814:
815: msc_phub_util.log('insert into msc_st_demands_f:exceptions: '||sql%rowcount);
816: commit;
817:
818: -- msc_st_demands_f:constrained_fcst
819: insert /*+ append nologging */ into msc_st_demands_f (

Line 818: -- msc_st_demands_f:constrained_fcst

814:
815: msc_phub_util.log('insert into msc_st_demands_f:exceptions: '||sql%rowcount);
816: commit;
817:
818: -- msc_st_demands_f:constrained_fcst
819: insert /*+ append nologging */ into msc_st_demands_f (
820: st_transaction_id,
821: error_code,
822: sr_instance_id,

Line 819: insert /+ append nologging / into msc_st_demands_f (

815: msc_phub_util.log('insert into msc_st_demands_f:exceptions: '||sql%rowcount);
816: commit;
817:
818: -- msc_st_demands_f:constrained_fcst
819: insert /*+ append nologging */ into msc_st_demands_f (
820: st_transaction_id,
821: error_code,
822: sr_instance_id,
823: organization_id,

Line 984: msc_phub_util.log('insert into msc_st_demands_f:constrained_fcst: '||sql%rowcount);

980: t.order_type,
981: nvl(mtp1.currency_code, l_owning_currency_code),
982: t.part_condition;
983:
984: msc_phub_util.log('insert into msc_st_demands_f:constrained_fcst: '||sql%rowcount);
985: commit;
986:
987: -- msc_st_demands_f:sales_order_sd
988: -- bnaghi : fact not available for DRP plan

Line 987: -- msc_st_demands_f:sales_order_sd

983:
984: msc_phub_util.log('insert into msc_st_demands_f:constrained_fcst: '||sql%rowcount);
985: commit;
986:
987: -- msc_st_demands_f:sales_order_sd
988: -- bnaghi : fact not available for DRP plan
989: insert /*+ append nologging */ into msc_st_demands_f (
990: st_transaction_id,
991: error_code,

Line 989: insert /+ append nologging / into msc_st_demands_f (

985: commit;
986:
987: -- msc_st_demands_f:sales_order_sd
988: -- bnaghi : fact not available for DRP plan
989: insert /*+ append nologging */ into msc_st_demands_f (
990: st_transaction_id,
991: error_code,
992: sr_instance_id,
993: organization_id,

Line 1066: msc_phub_util.log('insert into msc_st_demands_f:sales_order_sd: '||sql%rowcount);

1062: trunc(nvl(nvl(md.dmd_satisfied_date, md.schedule_ship_date),
1063: md.using_assembly_demand_date)),
1064: nvl(md.item_type_value, 1);
1065:
1066: msc_phub_util.log('insert into msc_st_demands_f:sales_order_sd: '||sql%rowcount);
1067: commit;
1068:
1069: -- msc_st_demands_f:sales_order_rd
1070: -- bnaghi : fact not available for DRP plan

Line 1069: -- msc_st_demands_f:sales_order_rd

1065:
1066: msc_phub_util.log('insert into msc_st_demands_f:sales_order_sd: '||sql%rowcount);
1067: commit;
1068:
1069: -- msc_st_demands_f:sales_order_rd
1070: -- bnaghi : fact not available for DRP plan
1071: insert /*+ append nologging */ into msc_st_demands_f (
1072: st_transaction_id,
1073: error_code,

Line 1071: insert /+ append nologging / into msc_st_demands_f (

1067: commit;
1068:
1069: -- msc_st_demands_f:sales_order_rd
1070: -- bnaghi : fact not available for DRP plan
1071: insert /*+ append nologging */ into msc_st_demands_f (
1072: st_transaction_id,
1073: error_code,
1074: sr_instance_id,
1075: organization_id,

Line 1147: msc_phub_util.log('insert into msc_st_demands_f:sales_order_rd: '||sql%rowcount);

1143: decode(md.sr_instance_id, -1, l_sr_instance_id, md.sr_instance_id),
1144: trunc(nvl(md.request_ship_date, md.using_assembly_demand_date)),
1145: nvl(md.item_type_value, 1);
1146:
1147: msc_phub_util.log('insert into msc_st_demands_f:sales_order_rd: '||sql%rowcount);
1148: commit;
1149:
1150: -- msc_st_demands_f:sales_order_pd
1151: -- bnaghi : fact not available for DRP plan

Line 1150: -- msc_st_demands_f:sales_order_pd

1146:
1147: msc_phub_util.log('insert into msc_st_demands_f:sales_order_rd: '||sql%rowcount);
1148: commit;
1149:
1150: -- msc_st_demands_f:sales_order_pd
1151: -- bnaghi : fact not available for DRP plan
1152: insert /*+ append nologging */ into msc_st_demands_f (
1153: st_transaction_id,
1154: error_code,

Line 1152: insert /+ append nologging / into msc_st_demands_f (

1148: commit;
1149:
1150: -- msc_st_demands_f:sales_order_pd
1151: -- bnaghi : fact not available for DRP plan
1152: insert /*+ append nologging */ into msc_st_demands_f (
1153: st_transaction_id,
1154: error_code,
1155: sr_instance_id,
1156: organization_id,

Line 1227: msc_phub_util.log('insert into msc_st_demands_f:sales_order_pd: '||sql%rowcount);

1223: md.organization_id),
1224: decode(md.sr_instance_id, -1, l_sr_instance_id, md.sr_instance_id),
1225: trunc(nvl(md.promise_ship_date, md.using_assembly_demand_date)),
1226: nvl(md.item_type_value, 1);
1227: msc_phub_util.log('insert into msc_st_demands_f:sales_order_pd: '||sql%rowcount);
1228: commit;
1229:
1230: -- msc_demands_f:final
1231: msc_phub_util.gather_table_stats(msc_phub_util.stats_st, 'MSC_ST_DEMANDS_F', l_transfer_id);

Line 1231: msc_phub_util.gather_table_stats(msc_phub_util.stats_st, 'MSC_ST_DEMANDS_F', l_transfer_id);

1227: msc_phub_util.log('insert into msc_st_demands_f:sales_order_pd: '||sql%rowcount);
1228: commit;
1229:
1230: -- msc_demands_f:final
1231: msc_phub_util.gather_table_stats(msc_phub_util.stats_st, 'MSC_ST_DEMANDS_F', l_transfer_id);
1232: insert into msc_demands_f (
1233: plan_id,
1234: plan_run_id,
1235: io_plan_flag,

Line 1418: msc_st_demands_f f,

1414: sum(f.sales_order_rd * nvl(msi.list_price,0)*(1-nvl(msi.average_discount,0)/100)) sales_order_rd_value,
1415: sum(f.sales_order_pd) sales_order_pd,
1416: sum(f.sales_order_pd * nvl(msi.list_price,0)*(1-nvl(msi.average_discount,0)/100)) sales_order_pd_value
1417: from
1418: msc_st_demands_f f,
1419: msc_trading_partners mtp,
1420: msc_apcc_item_d msi
1421: where f.st_transaction_id=l_transfer_id
1422: and mtp.partner_type(+)=3

Line 2034: delete from msc_st_demands_f where st_transaction_id=p_st_transaction_id;

2030: msc_phub_util.log('msc_demand_pkg.export_demands_f');
2031: retcode := 0;
2032: errbuf := null;
2033:
2034: delete from msc_st_demands_f where st_transaction_id=p_st_transaction_id;
2035: commit;
2036:
2037: l_sql :=
2038: ' insert into msc_st_demands_f('||

Line 2038: ' insert into msc_st_demands_f('||

2034: delete from msc_st_demands_f where st_transaction_id=p_st_transaction_id;
2035: commit;
2036:
2037: l_sql :=
2038: ' insert into msc_st_demands_f('||
2039: ' st_transaction_id,'||
2040: ' error_code,'||
2041: ' sr_instance_id,'||
2042: ' organization_id,'||

Line 2354: l_staging_table varchar2(30) := 'msc_st_demands_f';

2350: p_st_transaction_id number, p_plan_id number, p_plan_run_id number,
2351: p_plan_type number, p_plan_start_date date, p_plan_cutoff_date date,
2352: p_upload_mode number, p_overwrite_after_date date, p_def_instance_code varchar2)
2353: is
2354: l_staging_table varchar2(30) := 'msc_st_demands_f';
2355: l_fact_table varchar2(30) := 'msc_demands_f';
2356: l_result number := 0;
2357: begin
2358: msc_phub_util.log('msc_demand_pkg.import_demands_f');

Line 2519: from msc_st_demands_f

2515: demand_fulfillment_lead_time,
2516: 0, -23453, -23453,
2517: fnd_global.user_id, sysdate,
2518: fnd_global.user_id, sysdate, fnd_global.login_id
2519: from msc_st_demands_f
2520: where st_transaction_id=p_st_transaction_id and error_code=0;
2521:
2522: msc_phub_util.log('msc_demand_pkg.import_demands_f: inserted='||sql%rowcount);
2523: commit;