APPS.MSC_DEMAND_PKG dependencies on FND_GLOBAL

Line 402: fnd_global.user_id, sysdate,

398: 81,nvl(md.service_level, 50),
399: null))) service_level,
400: decode(l_plan_type,5,to_number(null),avg(md.demand_fulfillment_lead_time)) demand_fulfillment_lead_time,
401:
402: fnd_global.user_id, sysdate,
403: sysdate, fnd_global.user_id, fnd_global.login_id,
404: fnd_global.conc_program_id, fnd_global.conc_login_id,
405: fnd_global.prog_appl_id, fnd_global.conc_request_id
406: from msc_demands md

Line 403: sysdate, fnd_global.user_id, fnd_global.login_id,

399: null))) service_level,
400: decode(l_plan_type,5,to_number(null),avg(md.demand_fulfillment_lead_time)) demand_fulfillment_lead_time,
401:
402: fnd_global.user_id, sysdate,
403: sysdate, fnd_global.user_id, fnd_global.login_id,
404: fnd_global.conc_program_id, fnd_global.conc_login_id,
405: fnd_global.prog_appl_id, fnd_global.conc_request_id
406: from msc_demands md
407: where md.plan_id = p_plan_id

Line 404: fnd_global.conc_program_id, fnd_global.conc_login_id,

400: decode(l_plan_type,5,to_number(null),avg(md.demand_fulfillment_lead_time)) demand_fulfillment_lead_time,
401:
402: fnd_global.user_id, sysdate,
403: sysdate, fnd_global.user_id, fnd_global.login_id,
404: fnd_global.conc_program_id, fnd_global.conc_login_id,
405: fnd_global.prog_appl_id, fnd_global.conc_request_id
406: from msc_demands md
407: where md.plan_id = p_plan_id
408: and not (md.organization_id=-1 and md.origination_type=29) -- avoid double counting global forecast

Line 405: fnd_global.prog_appl_id, fnd_global.conc_request_id

401:
402: fnd_global.user_id, sysdate,
403: sysdate, fnd_global.user_id, fnd_global.login_id,
404: fnd_global.conc_program_id, fnd_global.conc_login_id,
405: fnd_global.prog_appl_id, fnd_global.conc_request_id
406: from msc_demands md
407: where md.plan_id = p_plan_id
408: and not (md.organization_id=-1 and md.origination_type=29) -- avoid double counting global forecast
409: and md.origination_type not in (83) -- 10044668 Unconstrained Demand is not real demand

Line 509: fnd_global.user_id, sysdate,

505: sum(md.using_requirement_quantity) indep_demand_qty,
506: sum(md.using_requirement_quantity) forecast_qty,
507: avg(md.demand_fulfillment_lead_time) demand_fulfillment_lead_time,
508:
509: fnd_global.user_id, sysdate,
510: sysdate, fnd_global.user_id, fnd_global.login_id,
511: fnd_global.conc_program_id, fnd_global.conc_login_id,
512: fnd_global.prog_appl_id, fnd_global.conc_request_id
513: from

Line 510: sysdate, fnd_global.user_id, fnd_global.login_id,

506: sum(md.using_requirement_quantity) forecast_qty,
507: avg(md.demand_fulfillment_lead_time) demand_fulfillment_lead_time,
508:
509: fnd_global.user_id, sysdate,
510: sysdate, fnd_global.user_id, fnd_global.login_id,
511: fnd_global.conc_program_id, fnd_global.conc_login_id,
512: fnd_global.prog_appl_id, fnd_global.conc_request_id
513: from
514: (select distinct

Line 511: fnd_global.conc_program_id, fnd_global.conc_login_id,

507: avg(md.demand_fulfillment_lead_time) demand_fulfillment_lead_time,
508:
509: fnd_global.user_id, sysdate,
510: sysdate, fnd_global.user_id, fnd_global.login_id,
511: fnd_global.conc_program_id, fnd_global.conc_login_id,
512: fnd_global.prog_appl_id, fnd_global.conc_request_id
513: from
514: (select distinct
515: decode(nvl(md2.bucket_type,1), 1, d.calendar_date, 2, d.mfg_week_start_date, d.mfg_period_start_date) order_date,

Line 512: fnd_global.prog_appl_id, fnd_global.conc_request_id

508:
509: fnd_global.user_id, sysdate,
510: sysdate, fnd_global.user_id, fnd_global.login_id,
511: fnd_global.conc_program_id, fnd_global.conc_login_id,
512: fnd_global.prog_appl_id, fnd_global.conc_request_id
513: from
514: (select distinct
515: decode(nvl(md2.bucket_type,1), 1, d.calendar_date, 2, d.mfg_week_start_date, d.mfg_period_start_date) order_date,
516: md2.organization_id,

Line 630: fnd_global.user_id, sysdate,

626: sum(mso.primary_uom_quantity) indep_demand_qty,
627: sum(mso.primary_uom_quantity) sales_order_qty,
628: sum(decode(nvl(mso.primary_uom_quantity,0),0,0,1)) sales_order_count,
629:
630: fnd_global.user_id, sysdate,
631: sysdate, fnd_global.user_id, fnd_global.login_id,
632: fnd_global.conc_program_id, fnd_global.conc_login_id,
633: fnd_global.prog_appl_id, fnd_global.conc_request_id
634: from

Line 631: sysdate, fnd_global.user_id, fnd_global.login_id,

627: sum(mso.primary_uom_quantity) sales_order_qty,
628: sum(decode(nvl(mso.primary_uom_quantity,0),0,0,1)) sales_order_count,
629:
630: fnd_global.user_id, sysdate,
631: sysdate, fnd_global.user_id, fnd_global.login_id,
632: fnd_global.conc_program_id, fnd_global.conc_login_id,
633: fnd_global.prog_appl_id, fnd_global.conc_request_id
634: from
635: msc_sales_orders mso

Line 632: fnd_global.conc_program_id, fnd_global.conc_login_id,

628: sum(decode(nvl(mso.primary_uom_quantity,0),0,0,1)) sales_order_count,
629:
630: fnd_global.user_id, sysdate,
631: sysdate, fnd_global.user_id, fnd_global.login_id,
632: fnd_global.conc_program_id, fnd_global.conc_login_id,
633: fnd_global.prog_appl_id, fnd_global.conc_request_id
634: from
635: msc_sales_orders mso
636: where p_plan_id=-1

Line 633: fnd_global.prog_appl_id, fnd_global.conc_request_id

629:
630: fnd_global.user_id, sysdate,
631: sysdate, fnd_global.user_id, fnd_global.login_id,
632: fnd_global.conc_program_id, fnd_global.conc_login_id,
633: fnd_global.prog_appl_id, fnd_global.conc_request_id
634: from
635: msc_sales_orders mso
636: where p_plan_id=-1
637: and mso.sr_instance_id = l_sr_instance_id

Line 774: fnd_global.user_id, sysdate,

770: nvl(least(sum(decode(md1.origination_type,29,nvl(md1.probability,0),null)),1),1)
771: ) late_order_qty,
772: min(nvl(md1.service_level, 50)) service_level,
773:
774: fnd_global.user_id, sysdate,
775: sysdate, fnd_global.user_id, fnd_global.login_id,
776: fnd_global.conc_program_id, fnd_global.conc_login_id,
777: fnd_global.prog_appl_id, fnd_global.conc_request_id
778: from msc_demands md1,msc_trading_partners mtp1,

Line 775: sysdate, fnd_global.user_id, fnd_global.login_id,

771: ) late_order_qty,
772: min(nvl(md1.service_level, 50)) service_level,
773:
774: fnd_global.user_id, sysdate,
775: sysdate, fnd_global.user_id, fnd_global.login_id,
776: fnd_global.conc_program_id, fnd_global.conc_login_id,
777: fnd_global.prog_appl_id, fnd_global.conc_request_id
778: from msc_demands md1,msc_trading_partners mtp1,
779: msc_exception_details med1

Line 776: fnd_global.conc_program_id, fnd_global.conc_login_id,

772: min(nvl(md1.service_level, 50)) service_level,
773:
774: fnd_global.user_id, sysdate,
775: sysdate, fnd_global.user_id, fnd_global.login_id,
776: fnd_global.conc_program_id, fnd_global.conc_login_id,
777: fnd_global.prog_appl_id, fnd_global.conc_request_id
778: from msc_demands md1,msc_trading_partners mtp1,
779: msc_exception_details med1
780: where md1.plan_id=med1.plan_id

Line 777: fnd_global.prog_appl_id, fnd_global.conc_request_id

773:
774: fnd_global.user_id, sysdate,
775: sysdate, fnd_global.user_id, fnd_global.login_id,
776: fnd_global.conc_program_id, fnd_global.conc_login_id,
777: fnd_global.prog_appl_id, fnd_global.conc_request_id
778: from msc_demands md1,msc_trading_partners mtp1,
779: msc_exception_details med1
780: where md1.plan_id=med1.plan_id
781: and md1.plan_id=p_plan_id

Line 865: fnd_global.user_id, sysdate,

861: t.part_condition,
862:
863: sum(t.constrained_fcst) constrained_fcst, -- take from MSD_DEM_CONSTRAINED_FORECAST_V
864:
865: fnd_global.user_id, sysdate,
866: sysdate, fnd_global.user_id, fnd_global.login_id,
867: fnd_global.conc_program_id, fnd_global.conc_login_id,
868: fnd_global.prog_appl_id, fnd_global.conc_request_id
869: from

Line 866: sysdate, fnd_global.user_id, fnd_global.login_id,

862:
863: sum(t.constrained_fcst) constrained_fcst, -- take from MSD_DEM_CONSTRAINED_FORECAST_V
864:
865: fnd_global.user_id, sysdate,
866: sysdate, fnd_global.user_id, fnd_global.login_id,
867: fnd_global.conc_program_id, fnd_global.conc_login_id,
868: fnd_global.prog_appl_id, fnd_global.conc_request_id
869: from
870: (select

Line 867: fnd_global.conc_program_id, fnd_global.conc_login_id,

863: sum(t.constrained_fcst) constrained_fcst, -- take from MSD_DEM_CONSTRAINED_FORECAST_V
864:
865: fnd_global.user_id, sysdate,
866: sysdate, fnd_global.user_id, fnd_global.login_id,
867: fnd_global.conc_program_id, fnd_global.conc_login_id,
868: fnd_global.prog_appl_id, fnd_global.conc_request_id
869: from
870: (select
871: md.sr_instance_id,

Line 868: fnd_global.prog_appl_id, fnd_global.conc_request_id

864:
865: fnd_global.user_id, sysdate,
866: sysdate, fnd_global.user_id, fnd_global.login_id,
867: fnd_global.conc_program_id, fnd_global.conc_login_id,
868: fnd_global.prog_appl_id, fnd_global.conc_request_id
869: from
870: (select
871: md.sr_instance_id,
872: md.organization_id,

Line 1038: fnd_global.user_id, sysdate,

1034:
1035: sum(decode(md.assembly_demand_comp_date, null,
1036: md.using_requirement_quantity, md.daily_demand_rate)) sales_order_sd,
1037:
1038: fnd_global.user_id, sysdate,
1039: sysdate, fnd_global.user_id, fnd_global.login_id,
1040: fnd_global.conc_program_id, fnd_global.conc_login_id,
1041: fnd_global.prog_appl_id, fnd_global.conc_request_id
1042: from msc_demands md

Line 1039: sysdate, fnd_global.user_id, fnd_global.login_id,

1035: sum(decode(md.assembly_demand_comp_date, null,
1036: md.using_requirement_quantity, md.daily_demand_rate)) sales_order_sd,
1037:
1038: fnd_global.user_id, sysdate,
1039: sysdate, fnd_global.user_id, fnd_global.login_id,
1040: fnd_global.conc_program_id, fnd_global.conc_login_id,
1041: fnd_global.prog_appl_id, fnd_global.conc_request_id
1042: from msc_demands md
1043: where md.plan_id = p_plan_id

Line 1040: fnd_global.conc_program_id, fnd_global.conc_login_id,

1036: md.using_requirement_quantity, md.daily_demand_rate)) sales_order_sd,
1037:
1038: fnd_global.user_id, sysdate,
1039: sysdate, fnd_global.user_id, fnd_global.login_id,
1040: fnd_global.conc_program_id, fnd_global.conc_login_id,
1041: fnd_global.prog_appl_id, fnd_global.conc_request_id
1042: from msc_demands md
1043: where md.plan_id = p_plan_id
1044: and md.origination_type = 30

Line 1041: fnd_global.prog_appl_id, fnd_global.conc_request_id

1037:
1038: fnd_global.user_id, sysdate,
1039: sysdate, fnd_global.user_id, fnd_global.login_id,
1040: fnd_global.conc_program_id, fnd_global.conc_login_id,
1041: fnd_global.prog_appl_id, fnd_global.conc_request_id
1042: from msc_demands md
1043: where md.plan_id = p_plan_id
1044: and md.origination_type = 30
1045: and p_plan_id <> -1

Line 1120: fnd_global.user_id, sysdate,

1116:
1117: sum(decode(md.assembly_demand_comp_date, null,
1118: md.using_requirement_quantity, md.daily_demand_rate)) sales_order_rd,
1119:
1120: fnd_global.user_id, sysdate,
1121: sysdate, fnd_global.user_id, fnd_global.login_id,
1122: fnd_global.conc_program_id, fnd_global.conc_login_id,
1123: fnd_global.prog_appl_id, fnd_global.conc_request_id
1124: from msc_demands md

Line 1121: sysdate, fnd_global.user_id, fnd_global.login_id,

1117: sum(decode(md.assembly_demand_comp_date, null,
1118: md.using_requirement_quantity, md.daily_demand_rate)) sales_order_rd,
1119:
1120: fnd_global.user_id, sysdate,
1121: sysdate, fnd_global.user_id, fnd_global.login_id,
1122: fnd_global.conc_program_id, fnd_global.conc_login_id,
1123: fnd_global.prog_appl_id, fnd_global.conc_request_id
1124: from msc_demands md
1125: where md.plan_id = p_plan_id

Line 1122: fnd_global.conc_program_id, fnd_global.conc_login_id,

1118: md.using_requirement_quantity, md.daily_demand_rate)) sales_order_rd,
1119:
1120: fnd_global.user_id, sysdate,
1121: sysdate, fnd_global.user_id, fnd_global.login_id,
1122: fnd_global.conc_program_id, fnd_global.conc_login_id,
1123: fnd_global.prog_appl_id, fnd_global.conc_request_id
1124: from msc_demands md
1125: where md.plan_id = p_plan_id
1126: and md.origination_type = 30

Line 1123: fnd_global.prog_appl_id, fnd_global.conc_request_id

1119:
1120: fnd_global.user_id, sysdate,
1121: sysdate, fnd_global.user_id, fnd_global.login_id,
1122: fnd_global.conc_program_id, fnd_global.conc_login_id,
1123: fnd_global.prog_appl_id, fnd_global.conc_request_id
1124: from msc_demands md
1125: where md.plan_id = p_plan_id
1126: and md.origination_type = 30
1127: and p_plan_id <> -1

Line 1201: fnd_global.user_id, sysdate,

1197: -- sales_order_pd on promise_ship_date
1198: sum(decode(md.assembly_demand_comp_date, null,
1199: md.using_requirement_quantity, md.daily_demand_rate)) sales_order_pd,
1200:
1201: fnd_global.user_id, sysdate,
1202: sysdate, fnd_global.user_id, fnd_global.login_id,
1203: fnd_global.conc_program_id, fnd_global.conc_login_id,
1204: fnd_global.prog_appl_id, fnd_global.conc_request_id
1205: from msc_demands md

Line 1202: sysdate, fnd_global.user_id, fnd_global.login_id,

1198: sum(decode(md.assembly_demand_comp_date, null,
1199: md.using_requirement_quantity, md.daily_demand_rate)) sales_order_pd,
1200:
1201: fnd_global.user_id, sysdate,
1202: sysdate, fnd_global.user_id, fnd_global.login_id,
1203: fnd_global.conc_program_id, fnd_global.conc_login_id,
1204: fnd_global.prog_appl_id, fnd_global.conc_request_id
1205: from msc_demands md
1206: where md.plan_id = p_plan_id

Line 1203: fnd_global.conc_program_id, fnd_global.conc_login_id,

1199: md.using_requirement_quantity, md.daily_demand_rate)) sales_order_pd,
1200:
1201: fnd_global.user_id, sysdate,
1202: sysdate, fnd_global.user_id, fnd_global.login_id,
1203: fnd_global.conc_program_id, fnd_global.conc_login_id,
1204: fnd_global.prog_appl_id, fnd_global.conc_request_id
1205: from msc_demands md
1206: where md.plan_id = p_plan_id
1207: and md.origination_type = 30

Line 1204: fnd_global.prog_appl_id, fnd_global.conc_request_id

1200:
1201: fnd_global.user_id, sysdate,
1202: sysdate, fnd_global.user_id, fnd_global.login_id,
1203: fnd_global.conc_program_id, fnd_global.conc_login_id,
1204: fnd_global.prog_appl_id, fnd_global.conc_request_id
1205: from msc_demands md
1206: where md.plan_id = p_plan_id
1207: and md.origination_type = 30
1208: and p_plan_id <> -1

Line 1362: fnd_global.user_id, sysdate,

1358: f.sales_order_rd_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sales_order_rd_value2,
1359: f.sales_order_pd,
1360: f.sales_order_pd_value,
1361: f.sales_order_pd_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sales_order_pd_value2,
1362: fnd_global.user_id, sysdate,
1363: sysdate, fnd_global.user_id, fnd_global.login_id,
1364: fnd_global.conc_program_id, fnd_global.conc_login_id,
1365: fnd_global.prog_appl_id, fnd_global.conc_request_id
1366: from

Line 1363: sysdate, fnd_global.user_id, fnd_global.login_id,

1359: f.sales_order_pd,
1360: f.sales_order_pd_value,
1361: f.sales_order_pd_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sales_order_pd_value2,
1362: fnd_global.user_id, sysdate,
1363: sysdate, fnd_global.user_id, fnd_global.login_id,
1364: fnd_global.conc_program_id, fnd_global.conc_login_id,
1365: fnd_global.prog_appl_id, fnd_global.conc_request_id
1366: from
1367: (select /*+ ordered */

Line 1364: fnd_global.conc_program_id, fnd_global.conc_login_id,

1360: f.sales_order_pd_value,
1361: f.sales_order_pd_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sales_order_pd_value2,
1362: fnd_global.user_id, sysdate,
1363: sysdate, fnd_global.user_id, fnd_global.login_id,
1364: fnd_global.conc_program_id, fnd_global.conc_login_id,
1365: fnd_global.prog_appl_id, fnd_global.conc_request_id
1366: from
1367: (select /*+ ordered */
1368: f.sr_instance_id,

Line 1365: fnd_global.prog_appl_id, fnd_global.conc_request_id

1361: f.sales_order_pd_value * decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) sales_order_pd_value2,
1362: fnd_global.user_id, sysdate,
1363: sysdate, fnd_global.user_id, fnd_global.login_id,
1364: fnd_global.conc_program_id, fnd_global.conc_login_id,
1365: fnd_global.prog_appl_id, fnd_global.conc_request_id
1366: from
1367: (select /*+ ordered */
1368: f.sr_instance_id,
1369: f.organization_id,

Line 1506: fnd_global.user_id, sysdate,

1502: to_number(0) aggr_type, to_number(-23453), to_number(-23453),
1503: sum(nvl(f.constrained_fcst,0)) cum_constrained_fcst,
1504: sum(nvl(f.constrained_fcst_value,0)) cum_constrained_fcst_value,
1505: sum(nvl(f.constrained_fcst_value2,0)) cum_constrained_fcst_value2,
1506: fnd_global.user_id, sysdate,
1507: sysdate, fnd_global.user_id, fnd_global.login_id,
1508: fnd_global.conc_program_id, fnd_global.conc_login_id,
1509: fnd_global.prog_appl_id, fnd_global.conc_request_id
1510: from

Line 1507: sysdate, fnd_global.user_id, fnd_global.login_id,

1503: sum(nvl(f.constrained_fcst,0)) cum_constrained_fcst,
1504: sum(nvl(f.constrained_fcst_value,0)) cum_constrained_fcst_value,
1505: sum(nvl(f.constrained_fcst_value2,0)) cum_constrained_fcst_value2,
1506: fnd_global.user_id, sysdate,
1507: sysdate, fnd_global.user_id, fnd_global.login_id,
1508: fnd_global.conc_program_id, fnd_global.conc_login_id,
1509: fnd_global.prog_appl_id, fnd_global.conc_request_id
1510: from
1511: msc_demands_f f,

Line 1508: fnd_global.conc_program_id, fnd_global.conc_login_id,

1504: sum(nvl(f.constrained_fcst_value,0)) cum_constrained_fcst_value,
1505: sum(nvl(f.constrained_fcst_value2,0)) cum_constrained_fcst_value2,
1506: fnd_global.user_id, sysdate,
1507: sysdate, fnd_global.user_id, fnd_global.login_id,
1508: fnd_global.conc_program_id, fnd_global.conc_login_id,
1509: fnd_global.prog_appl_id, fnd_global.conc_request_id
1510: from
1511: msc_demands_f f,
1512: msc_phub_dates_mv d

Line 1509: fnd_global.prog_appl_id, fnd_global.conc_request_id

1505: sum(nvl(f.constrained_fcst_value2,0)) cum_constrained_fcst_value2,
1506: fnd_global.user_id, sysdate,
1507: sysdate, fnd_global.user_id, fnd_global.login_id,
1508: fnd_global.conc_program_id, fnd_global.conc_login_id,
1509: fnd_global.prog_appl_id, fnd_global.conc_request_id
1510: from
1511: msc_demands_f f,
1512: msc_phub_dates_mv d
1513: where f.plan_id=p_plan_id

Line 1689: fnd_global.user_id, sysdate,

1685: sum(f.late_order_value),
1686: sum(f.late_order_value2),
1687: min(service_level),
1688: avg(f.demand_fulfillment_lead_time),
1689: fnd_global.user_id, sysdate,
1690: sysdate, fnd_global.user_id, fnd_global.login_id,
1691: fnd_global.conc_program_id, fnd_global.conc_login_id,
1692: fnd_global.prog_appl_id, fnd_global.conc_request_id
1693: from

Line 1690: sysdate, fnd_global.user_id, fnd_global.login_id,

1686: sum(f.late_order_value2),
1687: min(service_level),
1688: avg(f.demand_fulfillment_lead_time),
1689: fnd_global.user_id, sysdate,
1690: sysdate, fnd_global.user_id, fnd_global.login_id,
1691: fnd_global.conc_program_id, fnd_global.conc_login_id,
1692: fnd_global.prog_appl_id, fnd_global.conc_request_id
1693: from
1694: msc_demands_f f,

Line 1691: fnd_global.conc_program_id, fnd_global.conc_login_id,

1687: min(service_level),
1688: avg(f.demand_fulfillment_lead_time),
1689: fnd_global.user_id, sysdate,
1690: sysdate, fnd_global.user_id, fnd_global.login_id,
1691: fnd_global.conc_program_id, fnd_global.conc_login_id,
1692: fnd_global.prog_appl_id, fnd_global.conc_request_id
1693: from
1694: msc_demands_f f,
1695: msc_phub_item_categories_mv q

Line 1692: fnd_global.prog_appl_id, fnd_global.conc_request_id

1688: avg(f.demand_fulfillment_lead_time),
1689: fnd_global.user_id, sysdate,
1690: sysdate, fnd_global.user_id, fnd_global.login_id,
1691: fnd_global.conc_program_id, fnd_global.conc_login_id,
1692: fnd_global.prog_appl_id, fnd_global.conc_request_id
1693: from
1694: msc_demands_f f,
1695: msc_phub_item_categories_mv q
1696: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 1825: fnd_global.user_id, sysdate,

1821: sum(f.late_order_value),
1822: sum(f.late_order_value2),
1823: min(f.service_level),
1824: avg(f.demand_fulfillment_lead_time),
1825: fnd_global.user_id, sysdate,
1826: sysdate, fnd_global.user_id, fnd_global.login_id,
1827: fnd_global.conc_program_id, fnd_global.conc_login_id,
1828: fnd_global.prog_appl_id, fnd_global.conc_request_id
1829: from

Line 1826: sysdate, fnd_global.user_id, fnd_global.login_id,

1822: sum(f.late_order_value2),
1823: min(f.service_level),
1824: avg(f.demand_fulfillment_lead_time),
1825: fnd_global.user_id, sysdate,
1826: sysdate, fnd_global.user_id, fnd_global.login_id,
1827: fnd_global.conc_program_id, fnd_global.conc_login_id,
1828: fnd_global.prog_appl_id, fnd_global.conc_request_id
1829: from
1830: msc_demands_f f,

Line 1827: fnd_global.conc_program_id, fnd_global.conc_login_id,

1823: min(f.service_level),
1824: avg(f.demand_fulfillment_lead_time),
1825: fnd_global.user_id, sysdate,
1826: sysdate, fnd_global.user_id, fnd_global.login_id,
1827: fnd_global.conc_program_id, fnd_global.conc_login_id,
1828: fnd_global.prog_appl_id, fnd_global.conc_request_id
1829: from
1830: msc_demands_f f,
1831: msc_phub_dates_mv d

Line 1828: fnd_global.prog_appl_id, fnd_global.conc_request_id

1824: avg(f.demand_fulfillment_lead_time),
1825: fnd_global.user_id, sysdate,
1826: sysdate, fnd_global.user_id, fnd_global.login_id,
1827: fnd_global.conc_program_id, fnd_global.conc_login_id,
1828: fnd_global.prog_appl_id, fnd_global.conc_request_id
1829: from
1830: msc_demands_f f,
1831: msc_phub_dates_mv d
1832: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 1901: fnd_global.user_id, sysdate,

1897: sum(f.late_order_value),
1898: sum(f.late_order_value2),
1899: min(f.service_level),
1900: avg(f.demand_fulfillment_lead_time),
1901: fnd_global.user_id, sysdate,
1902: sysdate, fnd_global.user_id, fnd_global.login_id,
1903: fnd_global.conc_program_id, fnd_global.conc_login_id,
1904: fnd_global.prog_appl_id, fnd_global.conc_request_id
1905: from

Line 1902: sysdate, fnd_global.user_id, fnd_global.login_id,

1898: sum(f.late_order_value2),
1899: min(f.service_level),
1900: avg(f.demand_fulfillment_lead_time),
1901: fnd_global.user_id, sysdate,
1902: sysdate, fnd_global.user_id, fnd_global.login_id,
1903: fnd_global.conc_program_id, fnd_global.conc_login_id,
1904: fnd_global.prog_appl_id, fnd_global.conc_request_id
1905: from
1906: msc_demands_f f,

Line 1903: fnd_global.conc_program_id, fnd_global.conc_login_id,

1899: min(f.service_level),
1900: avg(f.demand_fulfillment_lead_time),
1901: fnd_global.user_id, sysdate,
1902: sysdate, fnd_global.user_id, fnd_global.login_id,
1903: fnd_global.conc_program_id, fnd_global.conc_login_id,
1904: fnd_global.prog_appl_id, fnd_global.conc_request_id
1905: from
1906: msc_demands_f f,
1907: msc_phub_dates_mv d

Line 1904: fnd_global.prog_appl_id, fnd_global.conc_request_id

1900: avg(f.demand_fulfillment_lead_time),
1901: fnd_global.user_id, sysdate,
1902: sysdate, fnd_global.user_id, fnd_global.login_id,
1903: fnd_global.conc_program_id, fnd_global.conc_login_id,
1904: fnd_global.prog_appl_id, fnd_global.conc_request_id
1905: from
1906: msc_demands_f f,
1907: msc_phub_dates_mv d
1908: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 1986: fnd_global.user_id, sysdate,

1982: nvl(q.sr_category_id, -23453),
1983: sum(f.cum_constrained_fcst),
1984: sum(f.cum_constrained_fcst_value),
1985: sum(f.cum_constrained_fcst_value2),
1986: fnd_global.user_id, sysdate,
1987: sysdate, fnd_global.user_id, fnd_global.login_id,
1988: fnd_global.conc_program_id, fnd_global.conc_login_id,
1989: fnd_global.prog_appl_id, fnd_global.conc_request_id
1990: from

Line 1987: sysdate, fnd_global.user_id, fnd_global.login_id,

1983: sum(f.cum_constrained_fcst),
1984: sum(f.cum_constrained_fcst_value),
1985: sum(f.cum_constrained_fcst_value2),
1986: fnd_global.user_id, sysdate,
1987: sysdate, fnd_global.user_id, fnd_global.login_id,
1988: fnd_global.conc_program_id, fnd_global.conc_login_id,
1989: fnd_global.prog_appl_id, fnd_global.conc_request_id
1990: from
1991: msc_demands_cum_f f,

Line 1988: fnd_global.conc_program_id, fnd_global.conc_login_id,

1984: sum(f.cum_constrained_fcst_value),
1985: sum(f.cum_constrained_fcst_value2),
1986: fnd_global.user_id, sysdate,
1987: sysdate, fnd_global.user_id, fnd_global.login_id,
1988: fnd_global.conc_program_id, fnd_global.conc_login_id,
1989: fnd_global.prog_appl_id, fnd_global.conc_request_id
1990: from
1991: msc_demands_cum_f f,
1992: msc_phub_item_categories_mv q

Line 1989: fnd_global.prog_appl_id, fnd_global.conc_request_id

1985: sum(f.cum_constrained_fcst_value2),
1986: fnd_global.user_id, sysdate,
1987: sysdate, fnd_global.user_id, fnd_global.login_id,
1988: fnd_global.conc_program_id, fnd_global.conc_login_id,
1989: fnd_global.prog_appl_id, fnd_global.conc_request_id
1990: from
1991: msc_demands_cum_f f,
1992: msc_phub_item_categories_mv q
1993: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 2185: ' fnd_global.user_id, sysdate,'||

2181: ' f.sales_order_pd_value,'||
2182: ' f.sales_order_pd_value2,';
2183: end if;
2184: l_sql := l_sql||
2185: ' fnd_global.user_id, sysdate,'||
2186: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
2187: ' from'||
2188: ' '||l_apps_schema||'.msc_demands_f'||l_suffix||' f,'||
2189: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||

Line 2186: ' fnd_global.user_id, sysdate, fnd_global.login_id'||

2182: ' f.sales_order_pd_value2,';
2183: end if;
2184: l_sql := l_sql||
2185: ' fnd_global.user_id, sysdate,'||
2186: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
2187: ' from'||
2188: ' '||l_apps_schema||'.msc_demands_f'||l_suffix||' f,'||
2189: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
2190: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||

Line 2313: ' fnd_global.user_id, sysdate,'||

2309: ' f.demand_class,'||
2310: ' f.cum_constrained_fcst,'||
2311: ' f.cum_constrained_fcst_value,'||
2312: ' f.cum_constrained_fcst_value2,'||
2313: ' fnd_global.user_id, sysdate,'||
2314: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
2315: ' from'||
2316: ' '||l_apps_schema||'.msc_demands_cum_f'||l_suffix||' f,'||
2317: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||

Line 2314: ' fnd_global.user_id, sysdate, fnd_global.login_id'||

2310: ' f.cum_constrained_fcst,'||
2311: ' f.cum_constrained_fcst_value,'||
2312: ' f.cum_constrained_fcst_value2,'||
2313: ' fnd_global.user_id, sysdate,'||
2314: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
2315: ' from'||
2316: ' '||l_apps_schema||'.msc_demands_cum_f'||l_suffix||' f,'||
2317: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
2318: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||

Line 2517: fnd_global.user_id, sysdate,

2513: constrained_fcst_value2,
2514: service_level,
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:

Line 2518: fnd_global.user_id, sysdate, fnd_global.login_id

2514: service_level,
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);

Line 2626: fnd_global.user_id, sysdate,

2622: cum_constrained_fcst,
2623: cum_constrained_fcst_value,
2624: cum_constrained_fcst_value2,
2625: 0, -23453, -23453,
2626: fnd_global.user_id, sysdate,
2627: fnd_global.user_id, sysdate, fnd_global.login_id
2628: from msc_st_demands_cum_f
2629: where st_transaction_id=p_st_transaction_id and error_code=0;
2630:

Line 2627: fnd_global.user_id, sysdate, fnd_global.login_id

2623: cum_constrained_fcst_value,
2624: cum_constrained_fcst_value2,
2625: 0, -23453, -23453,
2626: fnd_global.user_id, sysdate,
2627: fnd_global.user_id, sysdate, fnd_global.login_id
2628: from msc_st_demands_cum_f
2629: where st_transaction_id=p_st_transaction_id and error_code=0;
2630:
2631: msc_phub_util.log('msc_demand_pkg.import_demands_cum_f: inserted='||sql%rowcount);