APPS.MSC_ITEM_PKG dependencies on FND_GLOBAL

Line 172: fnd_global.user_id, sysdate,

168: --bnaghi -sales_order_value and forecast_qty not calculated for DRP plan
169: decode(l_plan_type,5,to_number(null),sum(nvl(f.sales_order_qty,0) * nvl(i.list_price,0)*(1-nvl(i.average_discount,0)/100))) sales_order_value,
170: decode(l_plan_type,5,to_number(null),sum(decode(nvl(f.order_type,0), -29,nvl(f.demand_qty,0), 0))) forecast_qty,
171:
172: fnd_global.user_id, sysdate,
173: sysdate, fnd_global.user_id, fnd_global.login_id,
174: fnd_global.conc_program_id, fnd_global.conc_login_id,
175: fnd_global.prog_appl_id, fnd_global.conc_request_id
176: from

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

169: decode(l_plan_type,5,to_number(null),sum(nvl(f.sales_order_qty,0) * nvl(i.list_price,0)*(1-nvl(i.average_discount,0)/100))) sales_order_value,
170: decode(l_plan_type,5,to_number(null),sum(decode(nvl(f.order_type,0), -29,nvl(f.demand_qty,0), 0))) forecast_qty,
171:
172: fnd_global.user_id, sysdate,
173: sysdate, fnd_global.user_id, fnd_global.login_id,
174: fnd_global.conc_program_id, fnd_global.conc_login_id,
175: fnd_global.prog_appl_id, fnd_global.conc_request_id
176: from
177: msc_demands_f f,

Line 174: fnd_global.conc_program_id, fnd_global.conc_login_id,

170: decode(l_plan_type,5,to_number(null),sum(decode(nvl(f.order_type,0), -29,nvl(f.demand_qty,0), 0))) forecast_qty,
171:
172: fnd_global.user_id, sysdate,
173: sysdate, fnd_global.user_id, fnd_global.login_id,
174: fnd_global.conc_program_id, fnd_global.conc_login_id,
175: fnd_global.prog_appl_id, fnd_global.conc_request_id
176: from
177: msc_demands_f f,
178: msc_hub_query d,

Line 175: fnd_global.prog_appl_id, fnd_global.conc_request_id

171:
172: fnd_global.user_id, sysdate,
173: sysdate, fnd_global.user_id, fnd_global.login_id,
174: fnd_global.conc_program_id, fnd_global.conc_login_id,
175: fnd_global.prog_appl_id, fnd_global.conc_request_id
176: from
177: msc_demands_f f,
178: msc_hub_query d,
179: msc_apcc_item_d i

Line 328: fnd_global.user_id, sysdate,

324:
325: sum((case when f.supply_type in (1,2,3,8,11,12,14,27,49,53,80)
326: then nvl(f.supply_qty, 0) else 0 end) * nvl(i.standard_cost,0)) scheduled_rept_value,
327:
328: fnd_global.user_id, sysdate,
329: sysdate, fnd_global.user_id, fnd_global.login_id,
330: fnd_global.conc_program_id, fnd_global.conc_login_id,
331: fnd_global.prog_appl_id, fnd_global.conc_request_id
332: from

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

325: sum((case when f.supply_type in (1,2,3,8,11,12,14,27,49,53,80)
326: then nvl(f.supply_qty, 0) else 0 end) * nvl(i.standard_cost,0)) scheduled_rept_value,
327:
328: fnd_global.user_id, sysdate,
329: sysdate, fnd_global.user_id, fnd_global.login_id,
330: fnd_global.conc_program_id, fnd_global.conc_login_id,
331: fnd_global.prog_appl_id, fnd_global.conc_request_id
332: from
333: msc_supplies_f f,

Line 330: fnd_global.conc_program_id, fnd_global.conc_login_id,

326: then nvl(f.supply_qty, 0) else 0 end) * nvl(i.standard_cost,0)) scheduled_rept_value,
327:
328: fnd_global.user_id, sysdate,
329: sysdate, fnd_global.user_id, fnd_global.login_id,
330: fnd_global.conc_program_id, fnd_global.conc_login_id,
331: fnd_global.prog_appl_id, fnd_global.conc_request_id
332: from
333: msc_supplies_f f,
334: msc_hub_query d,

Line 331: fnd_global.prog_appl_id, fnd_global.conc_request_id

327:
328: fnd_global.user_id, sysdate,
329: sysdate, fnd_global.user_id, fnd_global.login_id,
330: fnd_global.conc_program_id, fnd_global.conc_login_id,
331: fnd_global.prog_appl_id, fnd_global.conc_request_id
332: from
333: msc_supplies_f f,
334: msc_hub_query d,
335: msc_apcc_item_d i

Line 412: fnd_global.user_id, sysdate,

408: nvl(i.standard_cost,0)) sup_end_pgd_to_ss_value,
409: sum(decode(mfp2.demand_id, -1, mfp.allocated_quantity, 0) *
410: nvl(i.standard_cost,0)) sup_end_pgd_to_excess_value,
411:
412: fnd_global.user_id, sysdate,
413: sysdate, fnd_global.user_id, fnd_global.login_id,
414: fnd_global.conc_program_id, fnd_global.conc_login_id,
415: fnd_global.prog_appl_id, fnd_global.conc_request_id
416: from

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

409: sum(decode(mfp2.demand_id, -1, mfp.allocated_quantity, 0) *
410: nvl(i.standard_cost,0)) sup_end_pgd_to_excess_value,
411:
412: fnd_global.user_id, sysdate,
413: sysdate, fnd_global.user_id, fnd_global.login_id,
414: fnd_global.conc_program_id, fnd_global.conc_login_id,
415: fnd_global.prog_appl_id, fnd_global.conc_request_id
416: from
417: msc_full_pegging mfp,

Line 414: fnd_global.conc_program_id, fnd_global.conc_login_id,

410: nvl(i.standard_cost,0)) sup_end_pgd_to_excess_value,
411:
412: fnd_global.user_id, sysdate,
413: sysdate, fnd_global.user_id, fnd_global.login_id,
414: fnd_global.conc_program_id, fnd_global.conc_login_id,
415: fnd_global.prog_appl_id, fnd_global.conc_request_id
416: from
417: msc_full_pegging mfp,
418: msc_supplies ms,

Line 415: fnd_global.prog_appl_id, fnd_global.conc_request_id

411:
412: fnd_global.user_id, sysdate,
413: sysdate, fnd_global.user_id, fnd_global.login_id,
414: fnd_global.conc_program_id, fnd_global.conc_login_id,
415: fnd_global.prog_appl_id, fnd_global.conc_request_id
416: from
417: msc_full_pegging mfp,
418: msc_supplies ms,
419: msc_apcc_item_d i,

Line 487: fnd_global.user_id, sysdate,

483: nvl(i.list_price,0)*(1-nvl(i.average_discount,0)/100)) dmd_pgd_to_plnd_order_value,
484: sum((case when mfp.supply_type in (18) then mfp.allocated_quantity else 0 end) *
485: nvl(i.list_price,0)*(1-nvl(i.average_discount,0)/100)) dmd_pgd_to_onhand_value,
486:
487: fnd_global.user_id, sysdate,
488: sysdate, fnd_global.user_id, fnd_global.login_id,
489: fnd_global.conc_program_id, fnd_global.conc_login_id,
490: fnd_global.prog_appl_id, fnd_global.conc_request_id
491: from

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

484: sum((case when mfp.supply_type in (18) then mfp.allocated_quantity else 0 end) *
485: nvl(i.list_price,0)*(1-nvl(i.average_discount,0)/100)) dmd_pgd_to_onhand_value,
486:
487: fnd_global.user_id, sysdate,
488: sysdate, fnd_global.user_id, fnd_global.login_id,
489: fnd_global.conc_program_id, fnd_global.conc_login_id,
490: fnd_global.prog_appl_id, fnd_global.conc_request_id
491: from
492: msc_full_pegging mfp,

Line 489: fnd_global.conc_program_id, fnd_global.conc_login_id,

485: nvl(i.list_price,0)*(1-nvl(i.average_discount,0)/100)) dmd_pgd_to_onhand_value,
486:
487: fnd_global.user_id, sysdate,
488: sysdate, fnd_global.user_id, fnd_global.login_id,
489: fnd_global.conc_program_id, fnd_global.conc_login_id,
490: fnd_global.prog_appl_id, fnd_global.conc_request_id
491: from
492: msc_full_pegging mfp,
493: msc_apcc_item_d i,

Line 490: fnd_global.prog_appl_id, fnd_global.conc_request_id

486:
487: fnd_global.user_id, sysdate,
488: sysdate, fnd_global.user_id, fnd_global.login_id,
489: fnd_global.conc_program_id, fnd_global.conc_login_id,
490: fnd_global.prog_appl_id, fnd_global.conc_request_id
491: from
492: msc_full_pegging mfp,
493: msc_apcc_item_d i,
494: msc_demands md

Line 548: fnd_global.user_id, sysdate,

544:
545: sum(decode(exception_type,5,exception_count,0)) no_activity_item_count,
546: sum(decode(exception_type,2,exception_count,0)) stock_outs_count,
547:
548: fnd_global.user_id, sysdate,
549: sysdate, fnd_global.user_id, fnd_global.login_id,
550: fnd_global.conc_program_id, fnd_global.conc_login_id,
551: fnd_global.prog_appl_id, fnd_global.conc_request_id
552: from

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

545: sum(decode(exception_type,5,exception_count,0)) no_activity_item_count,
546: sum(decode(exception_type,2,exception_count,0)) stock_outs_count,
547:
548: fnd_global.user_id, sysdate,
549: sysdate, fnd_global.user_id, fnd_global.login_id,
550: fnd_global.conc_program_id, fnd_global.conc_login_id,
551: fnd_global.prog_appl_id, fnd_global.conc_request_id
552: from
553: msc_exceptions_f me

Line 550: fnd_global.conc_program_id, fnd_global.conc_login_id,

546: sum(decode(exception_type,2,exception_count,0)) stock_outs_count,
547:
548: fnd_global.user_id, sysdate,
549: sysdate, fnd_global.user_id, fnd_global.login_id,
550: fnd_global.conc_program_id, fnd_global.conc_login_id,
551: fnd_global.prog_appl_id, fnd_global.conc_request_id
552: from
553: msc_exceptions_f me
554: where me.exception_type in (5,2)

Line 551: fnd_global.prog_appl_id, fnd_global.conc_request_id

547:
548: fnd_global.user_id, sysdate,
549: sysdate, fnd_global.user_id, fnd_global.login_id,
550: fnd_global.conc_program_id, fnd_global.conc_login_id,
551: fnd_global.prog_appl_id, fnd_global.conc_request_id
552: from
553: msc_exceptions_f me
554: where me.exception_type in (5,2)
555: and me.plan_id=p_plan_id

Line 719: fnd_global.user_id, sysdate,

715: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) onhand_value2,
716: f.scheduled_rept_value,
717: f.scheduled_rept_value *
718: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) scheduled_rept_value2,
719: fnd_global.user_id, sysdate,
720: sysdate, fnd_global.user_id, fnd_global.login_id,
721: fnd_global.conc_program_id, fnd_global.conc_login_id,
722: fnd_global.prog_appl_id, fnd_global.conc_request_id
723: from

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

716: f.scheduled_rept_value,
717: f.scheduled_rept_value *
718: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) scheduled_rept_value2,
719: fnd_global.user_id, sysdate,
720: sysdate, fnd_global.user_id, fnd_global.login_id,
721: fnd_global.conc_program_id, fnd_global.conc_login_id,
722: fnd_global.prog_appl_id, fnd_global.conc_request_id
723: from
724: (select

Line 721: fnd_global.conc_program_id, fnd_global.conc_login_id,

717: f.scheduled_rept_value *
718: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) scheduled_rept_value2,
719: fnd_global.user_id, sysdate,
720: sysdate, fnd_global.user_id, fnd_global.login_id,
721: fnd_global.conc_program_id, fnd_global.conc_login_id,
722: fnd_global.prog_appl_id, fnd_global.conc_request_id
723: from
724: (select
725: f.sr_instance_id,

Line 722: fnd_global.prog_appl_id, fnd_global.conc_request_id

718: decode(f.currency_code, fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) scheduled_rept_value2,
719: fnd_global.user_id, sysdate,
720: sysdate, fnd_global.user_id, fnd_global.login_id,
721: fnd_global.conc_program_id, fnd_global.conc_login_id,
722: fnd_global.prog_appl_id, fnd_global.conc_request_id
723: from
724: (select
725: f.sr_instance_id,
726: f.organization_id,

Line 837: fnd_global.user_id, sysdate,

833: sum(nvl(f.supply_qty,0) - nvl(f.demand_qty,0)) pab_qty,
834: sum((nvl(f.supply_qty,0) - nvl(f.demand_qty,0)) * nvl(i.standard_cost,0)) pab_value,
835: sum((nvl(f.supply_qty,0) - nvl(f.demand_qty,0)) * nvl(i.unit_volume,1)) pab_volume,
836:
837: fnd_global.user_id, sysdate,
838: sysdate, fnd_global.user_id, fnd_global.login_id,
839: fnd_global.conc_program_id, fnd_global.conc_login_id,
840: fnd_global.prog_appl_id, fnd_global.conc_request_id
841: from

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

834: sum((nvl(f.supply_qty,0) - nvl(f.demand_qty,0)) * nvl(i.standard_cost,0)) pab_value,
835: sum((nvl(f.supply_qty,0) - nvl(f.demand_qty,0)) * nvl(i.unit_volume,1)) pab_volume,
836:
837: fnd_global.user_id, sysdate,
838: sysdate, fnd_global.user_id, fnd_global.login_id,
839: fnd_global.conc_program_id, fnd_global.conc_login_id,
840: fnd_global.prog_appl_id, fnd_global.conc_request_id
841: from
842: msc_item_orders_f f,

Line 839: fnd_global.conc_program_id, fnd_global.conc_login_id,

835: sum((nvl(f.supply_qty,0) - nvl(f.demand_qty,0)) * nvl(i.unit_volume,1)) pab_volume,
836:
837: fnd_global.user_id, sysdate,
838: sysdate, fnd_global.user_id, fnd_global.login_id,
839: fnd_global.conc_program_id, fnd_global.conc_login_id,
840: fnd_global.prog_appl_id, fnd_global.conc_request_id
841: from
842: msc_item_orders_f f,
843: msc_apcc_item_d i,

Line 840: fnd_global.prog_appl_id, fnd_global.conc_request_id

836:
837: fnd_global.user_id, sysdate,
838: sysdate, fnd_global.user_id, fnd_global.login_id,
839: fnd_global.conc_program_id, fnd_global.conc_login_id,
840: fnd_global.prog_appl_id, fnd_global.conc_request_id
841: from
842: msc_item_orders_f f,
843: msc_apcc_item_d i,
844: msc_hub_query d

Line 904: fnd_global.user_id, sysdate,

900: t.pab_qty * nvl(i.standard_cost, 0) pab_value,
901: t.pab_qty * nvl(i.unit_volume, 1) pab_volume,
902: t.pab_qty inv_build_target,
903:
904: fnd_global.user_id, sysdate,
905: sysdate, fnd_global.user_id, fnd_global.login_id,
906: fnd_global.conc_program_id, fnd_global.conc_login_id,
907: fnd_global.prog_appl_id, fnd_global.conc_request_id
908: from

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

901: t.pab_qty * nvl(i.unit_volume, 1) pab_volume,
902: t.pab_qty inv_build_target,
903:
904: fnd_global.user_id, sysdate,
905: sysdate, fnd_global.user_id, fnd_global.login_id,
906: fnd_global.conc_program_id, fnd_global.conc_login_id,
907: fnd_global.prog_appl_id, fnd_global.conc_request_id
908: from
909: (select

Line 906: fnd_global.conc_program_id, fnd_global.conc_login_id,

902: t.pab_qty inv_build_target,
903:
904: fnd_global.user_id, sysdate,
905: sysdate, fnd_global.user_id, fnd_global.login_id,
906: fnd_global.conc_program_id, fnd_global.conc_login_id,
907: fnd_global.prog_appl_id, fnd_global.conc_request_id
908: from
909: (select
910: mbid.plan_id,

Line 907: fnd_global.prog_appl_id, fnd_global.conc_request_id

903:
904: fnd_global.user_id, sysdate,
905: sysdate, fnd_global.user_id, fnd_global.login_id,
906: fnd_global.conc_program_id, fnd_global.conc_login_id,
907: fnd_global.prog_appl_id, fnd_global.conc_request_id
908: from
909: (select
910: mbid.plan_id,
911: mbid.sr_instance_id,

Line 986: fnd_global.user_id, sysdate,

982: t.transit_ltvar_ss_percent*t.total_unpooled_safety_stock/100 transit_ltvar_ss_qty,
983: t.mfg_ltvar_ss_percent*t.total_unpooled_safety_stock/100 mfg_ltvar_ss_qty,
984: t.total_unpooled_safety_stock,
985:
986: fnd_global.user_id, sysdate,
987: sysdate, fnd_global.user_id, fnd_global.login_id,
988: fnd_global.conc_program_id, fnd_global.conc_login_id,
989: fnd_global.prog_appl_id, fnd_global.conc_request_id
990: from

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

983: t.mfg_ltvar_ss_percent*t.total_unpooled_safety_stock/100 mfg_ltvar_ss_qty,
984: t.total_unpooled_safety_stock,
985:
986: fnd_global.user_id, sysdate,
987: sysdate, fnd_global.user_id, fnd_global.login_id,
988: fnd_global.conc_program_id, fnd_global.conc_login_id,
989: fnd_global.prog_appl_id, fnd_global.conc_request_id
990: from
991: (select

Line 988: fnd_global.conc_program_id, fnd_global.conc_login_id,

984: t.total_unpooled_safety_stock,
985:
986: fnd_global.user_id, sysdate,
987: sysdate, fnd_global.user_id, fnd_global.login_id,
988: fnd_global.conc_program_id, fnd_global.conc_login_id,
989: fnd_global.prog_appl_id, fnd_global.conc_request_id
990: from
991: (select
992: f.plan_id,

Line 989: fnd_global.prog_appl_id, fnd_global.conc_request_id

985:
986: fnd_global.user_id, sysdate,
987: sysdate, fnd_global.user_id, fnd_global.login_id,
988: fnd_global.conc_program_id, fnd_global.conc_login_id,
989: fnd_global.prog_appl_id, fnd_global.conc_request_id
990: from
991: (select
992: f.plan_id,
993: f.sr_instance_id,

Line 1093: fnd_global.user_id, sysdate,

1089: nvl(t.max_quantity_dos, 0) max_inventory_level_dos,
1090: nvl(t.target_quantity, 0) target_inventory_level,
1091: nvl(t.target_quantity_dos, 0) target_inventory_level_dos,
1092:
1093: fnd_global.user_id, sysdate,
1094: sysdate, fnd_global.user_id, fnd_global.login_id,
1095: fnd_global.conc_program_id, fnd_global.conc_login_id,
1096: fnd_global.prog_appl_id, fnd_global.conc_request_id
1097: from

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

1090: nvl(t.target_quantity, 0) target_inventory_level,
1091: nvl(t.target_quantity_dos, 0) target_inventory_level_dos,
1092:
1093: fnd_global.user_id, sysdate,
1094: sysdate, fnd_global.user_id, fnd_global.login_id,
1095: fnd_global.conc_program_id, fnd_global.conc_login_id,
1096: fnd_global.prog_appl_id, fnd_global.conc_request_id
1097: from
1098: (select

Line 1095: fnd_global.conc_program_id, fnd_global.conc_login_id,

1091: nvl(t.target_quantity_dos, 0) target_inventory_level_dos,
1092:
1093: fnd_global.user_id, sysdate,
1094: sysdate, fnd_global.user_id, fnd_global.login_id,
1095: fnd_global.conc_program_id, fnd_global.conc_login_id,
1096: fnd_global.prog_appl_id, fnd_global.conc_request_id
1097: from
1098: (select
1099: f.plan_id,

Line 1096: fnd_global.prog_appl_id, fnd_global.conc_request_id

1092:
1093: fnd_global.user_id, sysdate,
1094: sysdate, fnd_global.user_id, fnd_global.login_id,
1095: fnd_global.conc_program_id, fnd_global.conc_login_id,
1096: fnd_global.prog_appl_id, fnd_global.conc_request_id
1097: from
1098: (select
1099: f.plan_id,
1100: f.sr_instance_id,

Line 1173: fnd_global.user_id, sysdate,

1169: avg(inventory_value_post) inventory_value_post,
1170: avg(inventory_value_no_post) inventory_value_no_post,
1171: avg(inventory_value) inventory_value,
1172:
1173: fnd_global.user_id, sysdate,
1174: sysdate, fnd_global.user_id, fnd_global.login_id,
1175: fnd_global.conc_program_id, fnd_global.conc_login_id,
1176: fnd_global.prog_appl_id, fnd_global.conc_request_id
1177: from

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

1170: avg(inventory_value_no_post) inventory_value_no_post,
1171: avg(inventory_value) inventory_value,
1172:
1173: fnd_global.user_id, sysdate,
1174: sysdate, fnd_global.user_id, fnd_global.login_id,
1175: fnd_global.conc_program_id, fnd_global.conc_login_id,
1176: fnd_global.prog_appl_id, fnd_global.conc_request_id
1177: from
1178: msc_bis_inv_detail mbid,

Line 1175: fnd_global.conc_program_id, fnd_global.conc_login_id,

1171: avg(inventory_value) inventory_value,
1172:
1173: fnd_global.user_id, sysdate,
1174: sysdate, fnd_global.user_id, fnd_global.login_id,
1175: fnd_global.conc_program_id, fnd_global.conc_login_id,
1176: fnd_global.prog_appl_id, fnd_global.conc_request_id
1177: from
1178: msc_bis_inv_detail mbid,
1179: msc_phub_dates_mv d,

Line 1176: fnd_global.prog_appl_id, fnd_global.conc_request_id

1172:
1173: fnd_global.user_id, sysdate,
1174: sysdate, fnd_global.user_id, fnd_global.login_id,
1175: fnd_global.conc_program_id, fnd_global.conc_login_id,
1176: fnd_global.prog_appl_id, fnd_global.conc_request_id
1177: from
1178: msc_bis_inv_detail mbid,
1179: msc_phub_dates_mv d,
1180: msc_apcc_item_d i

Line 1250: fnd_global.user_id, sysdate,

1246: nvl(i.unit_volume,1)) iqi_volume,
1247: sum(mwr.avg_daily_demand) avg_daily_demand,
1248: sum(mwr.avg_daily_demand * nvl(i.unit_volume,1)) avg_daily_demand_volume,
1249:
1250: fnd_global.user_id, sysdate,
1251: sysdate, fnd_global.user_id, fnd_global.login_id,
1252: fnd_global.conc_program_id, fnd_global.conc_login_id,
1253: fnd_global.prog_appl_id, fnd_global.conc_request_id
1254: from

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

1247: sum(mwr.avg_daily_demand) avg_daily_demand,
1248: sum(mwr.avg_daily_demand * nvl(i.unit_volume,1)) avg_daily_demand_volume,
1249:
1250: fnd_global.user_id, sysdate,
1251: sysdate, fnd_global.user_id, fnd_global.login_id,
1252: fnd_global.conc_program_id, fnd_global.conc_login_id,
1253: fnd_global.prog_appl_id, fnd_global.conc_request_id
1254: from
1255: msc_whse_requirements mwr,

Line 1252: fnd_global.conc_program_id, fnd_global.conc_login_id,

1248: sum(mwr.avg_daily_demand * nvl(i.unit_volume,1)) avg_daily_demand_volume,
1249:
1250: fnd_global.user_id, sysdate,
1251: sysdate, fnd_global.user_id, fnd_global.login_id,
1252: fnd_global.conc_program_id, fnd_global.conc_login_id,
1253: fnd_global.prog_appl_id, fnd_global.conc_request_id
1254: from
1255: msc_whse_requirements mwr,
1256: msc_phub_dates_mv d,

Line 1253: fnd_global.prog_appl_id, fnd_global.conc_request_id

1249:
1250: fnd_global.user_id, sysdate,
1251: sysdate, fnd_global.user_id, fnd_global.login_id,
1252: fnd_global.conc_program_id, fnd_global.conc_login_id,
1253: fnd_global.prog_appl_id, fnd_global.conc_request_id
1254: from
1255: msc_whse_requirements mwr,
1256: msc_phub_dates_mv d,
1257: msc_apcc_item_d i

Line 1307: fnd_global.user_id, sysdate,

1303: nvl(i.vmi_flag,0) vmi_flag,
1304: d.mfg_week_end_date order_date,
1305: sum(nvl(f.demand_qty,0)) / l_plan_days avg_daily_demand,
1306: sum(nvl(f.demand_qty,0) * nvl(i.unit_volume,1)) / l_plan_days avg_daily_demand,
1307: fnd_global.user_id, sysdate,
1308: sysdate, fnd_global.user_id, fnd_global.login_id,
1309: fnd_global.conc_program_id, fnd_global.conc_login_id,
1310: fnd_global.prog_appl_id, fnd_global.conc_request_id
1311: from

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

1304: d.mfg_week_end_date order_date,
1305: sum(nvl(f.demand_qty,0)) / l_plan_days avg_daily_demand,
1306: sum(nvl(f.demand_qty,0) * nvl(i.unit_volume,1)) / l_plan_days avg_daily_demand,
1307: fnd_global.user_id, sysdate,
1308: sysdate, fnd_global.user_id, fnd_global.login_id,
1309: fnd_global.conc_program_id, fnd_global.conc_login_id,
1310: fnd_global.prog_appl_id, fnd_global.conc_request_id
1311: from
1312: msc_demands_f f,

Line 1309: fnd_global.conc_program_id, fnd_global.conc_login_id,

1305: sum(nvl(f.demand_qty,0)) / l_plan_days avg_daily_demand,
1306: sum(nvl(f.demand_qty,0) * nvl(i.unit_volume,1)) / l_plan_days avg_daily_demand,
1307: fnd_global.user_id, sysdate,
1308: sysdate, fnd_global.user_id, fnd_global.login_id,
1309: fnd_global.conc_program_id, fnd_global.conc_login_id,
1310: fnd_global.prog_appl_id, fnd_global.conc_request_id
1311: from
1312: msc_demands_f f,
1313: msc_phub_dates_mv d,

Line 1310: fnd_global.prog_appl_id, fnd_global.conc_request_id

1306: sum(nvl(f.demand_qty,0) * nvl(i.unit_volume,1)) / l_plan_days avg_daily_demand,
1307: fnd_global.user_id, sysdate,
1308: sysdate, fnd_global.user_id, fnd_global.login_id,
1309: fnd_global.conc_program_id, fnd_global.conc_login_id,
1310: fnd_global.prog_appl_id, fnd_global.conc_request_id
1311: from
1312: msc_demands_f f,
1313: msc_phub_dates_mv d,
1314: msc_apcc_item_d i

Line 1446: fnd_global.user_id, sysdate,

1442: f.iqi_volume,
1443: f.avg_daily_demand,
1444: f.avg_daily_demand_volume,
1445:
1446: fnd_global.user_id, sysdate,
1447: sysdate, fnd_global.user_id, fnd_global.login_id,
1448: fnd_global.conc_program_id, fnd_global.conc_login_id,
1449: fnd_global.prog_appl_id, fnd_global.conc_request_id
1450: from

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

1443: f.avg_daily_demand,
1444: f.avg_daily_demand_volume,
1445:
1446: fnd_global.user_id, sysdate,
1447: sysdate, fnd_global.user_id, fnd_global.login_id,
1448: fnd_global.conc_program_id, fnd_global.conc_login_id,
1449: fnd_global.prog_appl_id, fnd_global.conc_request_id
1450: from
1451: (select

Line 1448: fnd_global.conc_program_id, fnd_global.conc_login_id,

1444: f.avg_daily_demand_volume,
1445:
1446: fnd_global.user_id, sysdate,
1447: sysdate, fnd_global.user_id, fnd_global.login_id,
1448: fnd_global.conc_program_id, fnd_global.conc_login_id,
1449: fnd_global.prog_appl_id, fnd_global.conc_request_id
1450: from
1451: (select
1452: f.sr_instance_id,

Line 1449: fnd_global.prog_appl_id, fnd_global.conc_request_id

1445:
1446: fnd_global.user_id, sysdate,
1447: sysdate, fnd_global.user_id, fnd_global.login_id,
1448: fnd_global.conc_program_id, fnd_global.conc_login_id,
1449: fnd_global.prog_appl_id, fnd_global.conc_request_id
1450: from
1451: (select
1452: f.sr_instance_id,
1453: f.organization_id,

Line 1652: fnd_global.user_id, sysdate,

1648: sum(f.iqi_value),
1649: sum(f.iqi_volume),
1650: sum(f.avg_daily_demand),
1651: sum(f.avg_daily_demand_volume),
1652: fnd_global.user_id, sysdate,
1653: sysdate, fnd_global.user_id, fnd_global.login_id,
1654: fnd_global.conc_program_id, fnd_global.conc_login_id,
1655: fnd_global.prog_appl_id, fnd_global.conc_request_id
1656: from

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

1649: sum(f.iqi_volume),
1650: sum(f.avg_daily_demand),
1651: sum(f.avg_daily_demand_volume),
1652: fnd_global.user_id, sysdate,
1653: sysdate, fnd_global.user_id, fnd_global.login_id,
1654: fnd_global.conc_program_id, fnd_global.conc_login_id,
1655: fnd_global.prog_appl_id, fnd_global.conc_request_id
1656: from
1657: msc_item_inventory_f f,

Line 1654: fnd_global.conc_program_id, fnd_global.conc_login_id,

1650: sum(f.avg_daily_demand),
1651: sum(f.avg_daily_demand_volume),
1652: fnd_global.user_id, sysdate,
1653: sysdate, fnd_global.user_id, fnd_global.login_id,
1654: fnd_global.conc_program_id, fnd_global.conc_login_id,
1655: fnd_global.prog_appl_id, fnd_global.conc_request_id
1656: from
1657: msc_item_inventory_f f,
1658: msc_phub_item_categories_mv q

Line 1655: fnd_global.prog_appl_id, fnd_global.conc_request_id

1651: sum(f.avg_daily_demand_volume),
1652: fnd_global.user_id, sysdate,
1653: sysdate, fnd_global.user_id, fnd_global.login_id,
1654: fnd_global.conc_program_id, fnd_global.conc_login_id,
1655: fnd_global.prog_appl_id, fnd_global.conc_request_id
1656: from
1657: msc_item_inventory_f f,
1658: msc_phub_item_categories_mv q
1659: where f.plan_id=p_plan_id and f.plan_run_id=p_plan_run_id

Line 1822: fnd_global.user_id, sysdate,

1818: sum(f.sup_end_pgd_to_excess_value2),
1819: sum(f.dmd_pgd_to_schd_recp_value2),
1820: sum(f.dmd_pgd_to_plnd_order_value2),
1821: sum(f.dmd_pgd_to_onhand_value2),
1822: fnd_global.user_id, sysdate,
1823: sysdate, fnd_global.user_id, fnd_global.login_id,
1824: fnd_global.conc_program_id, fnd_global.conc_login_id,
1825: fnd_global.prog_appl_id, fnd_global.conc_request_id
1826: from

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

1819: sum(f.dmd_pgd_to_schd_recp_value2),
1820: sum(f.dmd_pgd_to_plnd_order_value2),
1821: sum(f.dmd_pgd_to_onhand_value2),
1822: fnd_global.user_id, sysdate,
1823: sysdate, fnd_global.user_id, fnd_global.login_id,
1824: fnd_global.conc_program_id, fnd_global.conc_login_id,
1825: fnd_global.prog_appl_id, fnd_global.conc_request_id
1826: from
1827: msc_item_orders_f f,

Line 1824: fnd_global.conc_program_id, fnd_global.conc_login_id,

1820: sum(f.dmd_pgd_to_plnd_order_value2),
1821: sum(f.dmd_pgd_to_onhand_value2),
1822: fnd_global.user_id, sysdate,
1823: sysdate, fnd_global.user_id, fnd_global.login_id,
1824: fnd_global.conc_program_id, fnd_global.conc_login_id,
1825: fnd_global.prog_appl_id, fnd_global.conc_request_id
1826: from
1827: msc_item_orders_f f,
1828: msc_phub_item_categories_mv q

Line 1825: fnd_global.prog_appl_id, fnd_global.conc_request_id

1821: sum(f.dmd_pgd_to_onhand_value2),
1822: fnd_global.user_id, sysdate,
1823: sysdate, fnd_global.user_id, fnd_global.login_id,
1824: fnd_global.conc_program_id, fnd_global.conc_login_id,
1825: fnd_global.prog_appl_id, fnd_global.conc_request_id
1826: from
1827: msc_item_orders_f f,
1828: msc_phub_item_categories_mv q
1829: where f.plan_id=p_plan_id and f.plan_run_id=p_plan_run_id

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

1974: ' f.avg_daily_demand_volume,'||
1975: ' f.pab_volume,';
1976: end if;
1977: l_sql := l_sql||
1978: ' fnd_global.user_id, sysdate,'||
1979: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
1980: ' from'||
1981: ' '||l_apps_schema||'.msc_item_inventory_f'||l_suffix||' f,'||
1982: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||

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

1975: ' f.pab_volume,';
1976: end if;
1977: l_sql := l_sql||
1978: ' fnd_global.user_id, sysdate,'||
1979: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
1980: ' from'||
1981: ' '||l_apps_schema||'.msc_item_inventory_f'||l_suffix||' f,'||
1982: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
1983: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||

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

2165: ' f.scheduled_rept_value,'||
2166: ' f.scheduled_rept_value2,';
2167: end if;
2168: l_sql := l_sql||
2169: ' fnd_global.user_id, sysdate,'||
2170: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
2171: ' from'||
2172: ' '||l_apps_schema||'.msc_item_orders_f'||l_suffix||' f,'||
2173: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||

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

2166: ' f.scheduled_rept_value2,';
2167: end if;
2168: l_sql := l_sql||
2169: ' fnd_global.user_id, sysdate,'||
2170: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
2171: ' from'||
2172: ' '||l_apps_schema||'.msc_item_orders_f'||l_suffix||' f,'||
2173: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
2174: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp2,'||

Line 2334: fnd_global.user_id, sysdate,

2330: iqi_volume,
2331: avg_daily_demand,
2332: avg_daily_demand_volume,
2333: 0, -23453, -23453,
2334: fnd_global.user_id, sysdate,
2335: fnd_global.user_id, sysdate, fnd_global.login_id
2336: from msc_st_item_inventory_f
2337: where st_transaction_id=p_st_transaction_id and error_code=0;
2338:

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

2331: avg_daily_demand,
2332: avg_daily_demand_volume,
2333: 0, -23453, -23453,
2334: fnd_global.user_id, sysdate,
2335: fnd_global.user_id, sysdate, fnd_global.login_id
2336: from msc_st_item_inventory_f
2337: where st_transaction_id=p_st_transaction_id and error_code=0;
2338:
2339: msc_phub_util.log('msc_item_pkg.import_item_inventory_f: inserted='||sql%rowcount);

Line 2523: fnd_global.user_id, sysdate,

2519: onhand_value2,
2520: scheduled_rept_value,
2521: scheduled_rept_value2,
2522: 0, -23453, -23453,
2523: fnd_global.user_id, sysdate,
2524: fnd_global.user_id, sysdate, fnd_global.login_id
2525: from msc_st_item_orders_f
2526: where st_transaction_id=p_st_transaction_id and error_code=0;
2527:

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

2520: scheduled_rept_value,
2521: scheduled_rept_value2,
2522: 0, -23453, -23453,
2523: fnd_global.user_id, sysdate,
2524: fnd_global.user_id, sysdate, fnd_global.login_id
2525: from msc_st_item_orders_f
2526: where st_transaction_id=p_st_transaction_id and error_code=0;
2527:
2528: msc_phub_util.log('msc_item_pkg.import_item_orders_f: inserted='||sql%rowcount);