APPS.MSC_SUPPLY_PKG dependencies on FND_GLOBAL

Line 216: fnd_global.user_id, sysdate,

212: sum(case when l_plan_type <>5 then supply_tbl.drp_supply_as_demand else to_number(null) end ) drp_supply_as_demand,
213: sum(case when l_plan_type <>5 then supply_tbl.return_order_qty else to_number(null) end ) return_order_qty,
214: sum(case when l_plan_type <>5 then supply_tbl.return_fcst else to_number(null) end ) return_fcst,
215:
216: fnd_global.user_id, sysdate,
217: sysdate, fnd_global.user_id, fnd_global.login_id,
218: fnd_global.conc_program_id, fnd_global.conc_login_id,
219: fnd_global.prog_appl_id, fnd_global.conc_request_id
220: from

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

213: sum(case when l_plan_type <>5 then supply_tbl.return_order_qty else to_number(null) end ) return_order_qty,
214: sum(case when l_plan_type <>5 then supply_tbl.return_fcst else to_number(null) end ) return_fcst,
215:
216: fnd_global.user_id, sysdate,
217: sysdate, fnd_global.user_id, fnd_global.login_id,
218: fnd_global.conc_program_id, fnd_global.conc_login_id,
219: fnd_global.prog_appl_id, fnd_global.conc_request_id
220: from
221: (select /*+ ordered */

Line 218: fnd_global.conc_program_id, fnd_global.conc_login_id,

214: sum(case when l_plan_type <>5 then supply_tbl.return_fcst else to_number(null) end ) return_fcst,
215:
216: fnd_global.user_id, sysdate,
217: sysdate, fnd_global.user_id, fnd_global.login_id,
218: fnd_global.conc_program_id, fnd_global.conc_login_id,
219: fnd_global.prog_appl_id, fnd_global.conc_request_id
220: from
221: (select /*+ ordered */
222: decode(sign(ms.organization_id), -1, -23453, ms.sr_instance_id) sr_instance_id,

Line 219: fnd_global.prog_appl_id, fnd_global.conc_request_id

215:
216: fnd_global.user_id, sysdate,
217: sysdate, fnd_global.user_id, fnd_global.login_id,
218: fnd_global.conc_program_id, fnd_global.conc_login_id,
219: fnd_global.prog_appl_id, fnd_global.conc_request_id
220: from
221: (select /*+ ordered */
222: decode(sign(ms.organization_id), -1, -23453, ms.sr_instance_id) sr_instance_id,
223: decode(sign(ms.organization_id), -1, -23453, ms.organization_id) organization_id,

Line 513: fnd_global.user_id, sysdate,

509: to_number(0) aggr_type,
510: to_number(-23453) category_set_id,
511: to_number(-23453) sr_category_id,
512: sum(wip_tbl.wip_qty),
513: fnd_global.user_id, sysdate,
514: sysdate, fnd_global.user_id, fnd_global.login_id,
515: fnd_global.conc_program_id, fnd_global.conc_login_id,
516: fnd_global.prog_appl_id, fnd_global.conc_request_id
517: from

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

510: to_number(-23453) category_set_id,
511: to_number(-23453) sr_category_id,
512: sum(wip_tbl.wip_qty),
513: fnd_global.user_id, sysdate,
514: sysdate, fnd_global.user_id, fnd_global.login_id,
515: fnd_global.conc_program_id, fnd_global.conc_login_id,
516: fnd_global.prog_appl_id, fnd_global.conc_request_id
517: from
518: (select

Line 515: fnd_global.conc_program_id, fnd_global.conc_login_id,

511: to_number(-23453) sr_category_id,
512: sum(wip_tbl.wip_qty),
513: fnd_global.user_id, sysdate,
514: sysdate, fnd_global.user_id, fnd_global.login_id,
515: fnd_global.conc_program_id, fnd_global.conc_login_id,
516: fnd_global.prog_appl_id, fnd_global.conc_request_id
517: from
518: (select
519: ms.sr_instance_id,

Line 516: fnd_global.prog_appl_id, fnd_global.conc_request_id

512: sum(wip_tbl.wip_qty),
513: fnd_global.user_id, sysdate,
514: sysdate, fnd_global.user_id, fnd_global.login_id,
515: fnd_global.conc_program_id, fnd_global.conc_login_id,
516: fnd_global.prog_appl_id, fnd_global.conc_request_id
517: from
518: (select
519: ms.sr_instance_id,
520: ms.organization_id,

Line 696: fnd_global.user_id, sysdate,

692: sum(f.buy_order_count),
693: sum(f.drp_supply_as_demand),
694: sum(f.return_order_qty),
695: sum(f.return_fcst),
696: fnd_global.user_id, sysdate,
697: sysdate, fnd_global.user_id, fnd_global.login_id,
698: fnd_global.conc_program_id, fnd_global.conc_login_id,
699: fnd_global.prog_appl_id, fnd_global.conc_request_id
700: from

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

693: sum(f.drp_supply_as_demand),
694: sum(f.return_order_qty),
695: sum(f.return_fcst),
696: fnd_global.user_id, sysdate,
697: sysdate, fnd_global.user_id, fnd_global.login_id,
698: fnd_global.conc_program_id, fnd_global.conc_login_id,
699: fnd_global.prog_appl_id, fnd_global.conc_request_id
700: from
701: msc_supplies_f f,

Line 698: fnd_global.conc_program_id, fnd_global.conc_login_id,

694: sum(f.return_order_qty),
695: sum(f.return_fcst),
696: fnd_global.user_id, sysdate,
697: sysdate, fnd_global.user_id, fnd_global.login_id,
698: fnd_global.conc_program_id, fnd_global.conc_login_id,
699: fnd_global.prog_appl_id, fnd_global.conc_request_id
700: from
701: msc_supplies_f f,
702: msc_phub_item_categories_mv ic1,

Line 699: fnd_global.prog_appl_id, fnd_global.conc_request_id

695: sum(f.return_fcst),
696: fnd_global.user_id, sysdate,
697: sysdate, fnd_global.user_id, fnd_global.login_id,
698: fnd_global.conc_program_id, fnd_global.conc_login_id,
699: fnd_global.prog_appl_id, fnd_global.conc_request_id
700: from
701: msc_supplies_f f,
702: msc_phub_item_categories_mv ic1,
703: msc_phub_item_categories_mv ic2,

Line 811: fnd_global.user_id, sysdate,

807: sum(f.buy_order_count),
808: sum(f.drp_supply_as_demand),
809: sum(f.return_order_qty),
810: sum(f.return_fcst),
811: fnd_global.user_id, sysdate,
812: sysdate, fnd_global.user_id, fnd_global.login_id,
813: fnd_global.conc_program_id, fnd_global.conc_login_id,
814: fnd_global.prog_appl_id, fnd_global.conc_request_id
815: from

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

808: sum(f.drp_supply_as_demand),
809: sum(f.return_order_qty),
810: sum(f.return_fcst),
811: fnd_global.user_id, sysdate,
812: sysdate, fnd_global.user_id, fnd_global.login_id,
813: fnd_global.conc_program_id, fnd_global.conc_login_id,
814: fnd_global.prog_appl_id, fnd_global.conc_request_id
815: from
816: msc_supplies_f f,

Line 813: fnd_global.conc_program_id, fnd_global.conc_login_id,

809: sum(f.return_order_qty),
810: sum(f.return_fcst),
811: fnd_global.user_id, sysdate,
812: sysdate, fnd_global.user_id, fnd_global.login_id,
813: fnd_global.conc_program_id, fnd_global.conc_login_id,
814: fnd_global.prog_appl_id, fnd_global.conc_request_id
815: from
816: msc_supplies_f f,
817: msc_phub_dates_mv d

Line 814: fnd_global.prog_appl_id, fnd_global.conc_request_id

810: sum(f.return_fcst),
811: fnd_global.user_id, sysdate,
812: sysdate, fnd_global.user_id, fnd_global.login_id,
813: fnd_global.conc_program_id, fnd_global.conc_login_id,
814: fnd_global.prog_appl_id, fnd_global.conc_request_id
815: from
816: msc_supplies_f f,
817: msc_phub_dates_mv d
818: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 877: fnd_global.user_id, sysdate,

873: sum(f.buy_order_count),
874: sum(f.drp_supply_as_demand),
875: sum(f.return_order_qty),
876: sum(f.return_fcst),
877: fnd_global.user_id, sysdate,
878: sysdate, fnd_global.user_id, fnd_global.login_id,
879: fnd_global.conc_program_id, fnd_global.conc_login_id,
880: fnd_global.prog_appl_id, fnd_global.conc_request_id
881: from

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

874: sum(f.drp_supply_as_demand),
875: sum(f.return_order_qty),
876: sum(f.return_fcst),
877: fnd_global.user_id, sysdate,
878: sysdate, fnd_global.user_id, fnd_global.login_id,
879: fnd_global.conc_program_id, fnd_global.conc_login_id,
880: fnd_global.prog_appl_id, fnd_global.conc_request_id
881: from
882: msc_supplies_f f,

Line 879: fnd_global.conc_program_id, fnd_global.conc_login_id,

875: sum(f.return_order_qty),
876: sum(f.return_fcst),
877: fnd_global.user_id, sysdate,
878: sysdate, fnd_global.user_id, fnd_global.login_id,
879: fnd_global.conc_program_id, fnd_global.conc_login_id,
880: fnd_global.prog_appl_id, fnd_global.conc_request_id
881: from
882: msc_supplies_f f,
883: msc_phub_dates_mv d

Line 880: fnd_global.prog_appl_id, fnd_global.conc_request_id

876: sum(f.return_fcst),
877: fnd_global.user_id, sysdate,
878: sysdate, fnd_global.user_id, fnd_global.login_id,
879: fnd_global.conc_program_id, fnd_global.conc_login_id,
880: fnd_global.prog_appl_id, fnd_global.conc_request_id
881: from
882: msc_supplies_f f,
883: msc_phub_dates_mv d
884: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 953: fnd_global.user_id, sysdate,

949: to_number(42) aggr_type,
950: l_category_set_id1 category_set_id,
951: nvl(q.sr_category_id, -23453),
952: sum(f.wip_qty),
953: fnd_global.user_id, sysdate,
954: sysdate, fnd_global.user_id, fnd_global.login_id,
955: fnd_global.conc_program_id, fnd_global.conc_login_id,
956: fnd_global.prog_appl_id, fnd_global.conc_request_id
957: from

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

950: l_category_set_id1 category_set_id,
951: nvl(q.sr_category_id, -23453),
952: sum(f.wip_qty),
953: fnd_global.user_id, sysdate,
954: sysdate, fnd_global.user_id, fnd_global.login_id,
955: fnd_global.conc_program_id, fnd_global.conc_login_id,
956: fnd_global.prog_appl_id, fnd_global.conc_request_id
957: from
958: msc_item_wips_f f,

Line 955: fnd_global.conc_program_id, fnd_global.conc_login_id,

951: nvl(q.sr_category_id, -23453),
952: sum(f.wip_qty),
953: fnd_global.user_id, sysdate,
954: sysdate, fnd_global.user_id, fnd_global.login_id,
955: fnd_global.conc_program_id, fnd_global.conc_login_id,
956: fnd_global.prog_appl_id, fnd_global.conc_request_id
957: from
958: msc_item_wips_f f,
959: msc_phub_item_categories_mv q

Line 956: fnd_global.prog_appl_id, fnd_global.conc_request_id

952: sum(f.wip_qty),
953: fnd_global.user_id, sysdate,
954: sysdate, fnd_global.user_id, fnd_global.login_id,
955: fnd_global.conc_program_id, fnd_global.conc_login_id,
956: fnd_global.prog_appl_id, fnd_global.conc_request_id
957: from
958: msc_item_wips_f f,
959: msc_phub_item_categories_mv q
960: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 995: fnd_global.user_id, sysdate,

991: d.mfg_period_start_date wip_start_date,
992: decode(f.aggr_type, 42, 1016, 43, 1017, 1018) aggr_type,
993: f.category_set_id, f.sr_category_id,
994: sum(f.wip_qty),
995: fnd_global.user_id, sysdate,
996: sysdate, fnd_global.user_id, fnd_global.login_id,
997: fnd_global.conc_program_id, fnd_global.conc_login_id,
998: fnd_global.prog_appl_id, fnd_global.conc_request_id
999: from

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

992: decode(f.aggr_type, 42, 1016, 43, 1017, 1018) aggr_type,
993: f.category_set_id, f.sr_category_id,
994: sum(f.wip_qty),
995: fnd_global.user_id, sysdate,
996: sysdate, fnd_global.user_id, fnd_global.login_id,
997: fnd_global.conc_program_id, fnd_global.conc_login_id,
998: fnd_global.prog_appl_id, fnd_global.conc_request_id
999: from
1000: msc_item_wips_f f,

Line 997: fnd_global.conc_program_id, fnd_global.conc_login_id,

993: f.category_set_id, f.sr_category_id,
994: sum(f.wip_qty),
995: fnd_global.user_id, sysdate,
996: sysdate, fnd_global.user_id, fnd_global.login_id,
997: fnd_global.conc_program_id, fnd_global.conc_login_id,
998: fnd_global.prog_appl_id, fnd_global.conc_request_id
999: from
1000: msc_item_wips_f f,
1001: msc_phub_dates_mv d

Line 998: fnd_global.prog_appl_id, fnd_global.conc_request_id

994: sum(f.wip_qty),
995: fnd_global.user_id, sysdate,
996: sysdate, fnd_global.user_id, fnd_global.login_id,
997: fnd_global.conc_program_id, fnd_global.conc_login_id,
998: fnd_global.prog_appl_id, fnd_global.conc_request_id
999: from
1000: msc_item_wips_f f,
1001: msc_phub_dates_mv d
1002: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 1023: fnd_global.user_id, sysdate,

1019: d.fis_period_start_date wip_start_date,
1020: decode(f.aggr_type, 42, 1019, 43, 1020, 1021) aggr_type,
1021: f.category_set_id, f.sr_category_id,
1022: sum(f.wip_qty),
1023: fnd_global.user_id, sysdate,
1024: sysdate, fnd_global.user_id, fnd_global.login_id,
1025: fnd_global.conc_program_id, fnd_global.conc_login_id,
1026: fnd_global.prog_appl_id, fnd_global.conc_request_id
1027: from

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

1020: decode(f.aggr_type, 42, 1019, 43, 1020, 1021) aggr_type,
1021: f.category_set_id, f.sr_category_id,
1022: sum(f.wip_qty),
1023: fnd_global.user_id, sysdate,
1024: sysdate, fnd_global.user_id, fnd_global.login_id,
1025: fnd_global.conc_program_id, fnd_global.conc_login_id,
1026: fnd_global.prog_appl_id, fnd_global.conc_request_id
1027: from
1028: msc_item_wips_f f,

Line 1025: fnd_global.conc_program_id, fnd_global.conc_login_id,

1021: f.category_set_id, f.sr_category_id,
1022: sum(f.wip_qty),
1023: fnd_global.user_id, sysdate,
1024: sysdate, fnd_global.user_id, fnd_global.login_id,
1025: fnd_global.conc_program_id, fnd_global.conc_login_id,
1026: fnd_global.prog_appl_id, fnd_global.conc_request_id
1027: from
1028: msc_item_wips_f f,
1029: msc_phub_dates_mv d

Line 1026: fnd_global.prog_appl_id, fnd_global.conc_request_id

1022: sum(f.wip_qty),
1023: fnd_global.user_id, sysdate,
1024: sysdate, fnd_global.user_id, fnd_global.login_id,
1025: fnd_global.conc_program_id, fnd_global.conc_login_id,
1026: fnd_global.prog_appl_id, fnd_global.conc_request_id
1027: from
1028: msc_item_wips_f f,
1029: msc_phub_dates_mv d
1030: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

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

1198: ' f.buy_order_count,'||
1199: ' f.return_fcst,';
1200: end if;
1201: l_sql := l_sql||
1202: ' fnd_global.user_id, sysdate,'||
1203: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
1204: ' from'||
1205: ' '||l_apps_schema||'.msc_supplies_f'||l_suffix||' f,'||
1206: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,';

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

1199: ' f.return_fcst,';
1200: end if;
1201: l_sql := l_sql||
1202: ' fnd_global.user_id, sysdate,'||
1203: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
1204: ' from'||
1205: ' '||l_apps_schema||'.msc_supplies_f'||l_suffix||' f,'||
1206: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,';
1207: if (p_source_version >= '12.1.3') then l_sql := l_sql||

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

1311: ' mi.item_name,'||
1312: ' f.vmi_flag,'||
1313: ' f.wip_start_date,'||
1314: ' f.wip_qty,'||
1315: ' fnd_global.user_id, sysdate,'||
1316: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
1317: ' from'||
1318: ' '||l_apps_schema||'.msc_item_wips_f'||l_suffix||' f,'||
1319: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||

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

1312: ' f.vmi_flag,'||
1313: ' f.wip_start_date,'||
1314: ' f.wip_qty,'||
1315: ' fnd_global.user_id, sysdate,'||
1316: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
1317: ' from'||
1318: ' '||l_apps_schema||'.msc_item_wips_f'||l_suffix||' f,'||
1319: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
1320: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi'||

Line 1497: fnd_global.user_id, sysdate,

1493: buy_order_value,
1494: buy_order_value2,
1495: buy_order_count,
1496: 0, -23453, -23453,
1497: fnd_global.user_id, sysdate,
1498: fnd_global.user_id, sysdate, fnd_global.login_id
1499: from msc_st_supplies_f
1500: where st_transaction_id=p_st_transaction_id and error_code=0;
1501:

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

1494: buy_order_value2,
1495: buy_order_count,
1496: 0, -23453, -23453,
1497: fnd_global.user_id, sysdate,
1498: fnd_global.user_id, sysdate, fnd_global.login_id
1499: from msc_st_supplies_f
1500: where st_transaction_id=p_st_transaction_id and error_code=0;
1501:
1502: msc_phub_util.log('msc_supply_pkg.import_supplies_f: inserted='||sql%rowcount);

Line 1574: fnd_global.user_id, sysdate,

1570: vmi_flag,
1571: wip_start_date,
1572: wip_qty,
1573: 0, -23453, -23453,
1574: fnd_global.user_id, sysdate,
1575: fnd_global.user_id, sysdate, fnd_global.login_id
1576: from msc_st_item_wips_f
1577: where st_transaction_id=p_st_transaction_id and error_code=0;
1578:

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

1571: wip_start_date,
1572: wip_qty,
1573: 0, -23453, -23453,
1574: fnd_global.user_id, sysdate,
1575: fnd_global.user_id, sysdate, fnd_global.login_id
1576: from msc_st_item_wips_f
1577: where st_transaction_id=p_st_transaction_id and error_code=0;
1578:
1579: msc_phub_util.log('msc_supply_pkg.import_item_wips_f: inserted='||sql%rowcount);