APPS.MSC_RESOURCE_PKG dependencies on FND_GLOBAL

Line 107: fnd_global.user_id, sysdate,

103: decode(mdr.line_flag,
104: 2, decode(mrr.end_date, null, mrr.resource_hours, mrr.daily_resource_hours),
105: mdr.max_rate * mrr.daily_resource_hours))) setup_time_hrs,
106:
107: fnd_global.user_id, sysdate,
108: sysdate, fnd_global.user_id, fnd_global.login_id,
109: fnd_global.conc_program_id, fnd_global.conc_login_id,
110: fnd_global.prog_appl_id, fnd_global.conc_request_id
111: from msc_resource_requirements mrr,

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

104: 2, decode(mrr.end_date, null, mrr.resource_hours, mrr.daily_resource_hours),
105: mdr.max_rate * mrr.daily_resource_hours))) setup_time_hrs,
106:
107: fnd_global.user_id, sysdate,
108: sysdate, fnd_global.user_id, fnd_global.login_id,
109: fnd_global.conc_program_id, fnd_global.conc_login_id,
110: fnd_global.prog_appl_id, fnd_global.conc_request_id
111: from msc_resource_requirements mrr,
112: msc_department_resources mdr

Line 109: fnd_global.conc_program_id, fnd_global.conc_login_id,

105: mdr.max_rate * mrr.daily_resource_hours))) setup_time_hrs,
106:
107: fnd_global.user_id, sysdate,
108: sysdate, fnd_global.user_id, fnd_global.login_id,
109: fnd_global.conc_program_id, fnd_global.conc_login_id,
110: fnd_global.prog_appl_id, fnd_global.conc_request_id
111: from msc_resource_requirements mrr,
112: msc_department_resources mdr
113: where mrr.plan_id = p_plan_id

Line 110: fnd_global.prog_appl_id, fnd_global.conc_request_id

106:
107: fnd_global.user_id, sysdate,
108: sysdate, fnd_global.user_id, fnd_global.login_id,
109: fnd_global.conc_program_id, fnd_global.conc_login_id,
110: fnd_global.prog_appl_id, fnd_global.conc_request_id
111: from msc_resource_requirements mrr,
112: msc_department_resources mdr
113: where mrr.plan_id = p_plan_id
114: and mdr.plan_id = mrr.plan_id

Line 171: fnd_global.user_id, sysdate,

167:
168: sum(mra.capacity_units * decode(mra.from_time,null,1,((decode(sign(mra.to_time-mra.from_time),
169: -1, mra.to_time+86400, mra.to_time) - mra.from_time)/3600))) available_hours,
170:
171: fnd_global.user_id, sysdate,
172: sysdate, fnd_global.user_id, fnd_global.login_id,
173: fnd_global.conc_program_id, fnd_global.conc_login_id,
174: fnd_global.prog_appl_id, fnd_global.conc_request_id
175: from msc_net_resource_avail mra

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

168: sum(mra.capacity_units * decode(mra.from_time,null,1,((decode(sign(mra.to_time-mra.from_time),
169: -1, mra.to_time+86400, mra.to_time) - mra.from_time)/3600))) available_hours,
170:
171: fnd_global.user_id, sysdate,
172: sysdate, fnd_global.user_id, fnd_global.login_id,
173: fnd_global.conc_program_id, fnd_global.conc_login_id,
174: fnd_global.prog_appl_id, fnd_global.conc_request_id
175: from msc_net_resource_avail mra
176: where mra.plan_id = p_plan_id

Line 173: fnd_global.conc_program_id, fnd_global.conc_login_id,

169: -1, mra.to_time+86400, mra.to_time) - mra.from_time)/3600))) available_hours,
170:
171: fnd_global.user_id, sysdate,
172: sysdate, fnd_global.user_id, fnd_global.login_id,
173: fnd_global.conc_program_id, fnd_global.conc_login_id,
174: fnd_global.prog_appl_id, fnd_global.conc_request_id
175: from msc_net_resource_avail mra
176: where mra.plan_id = p_plan_id
177: and mra.resource_id > 0

Line 174: fnd_global.prog_appl_id, fnd_global.conc_request_id

170:
171: fnd_global.user_id, sysdate,
172: sysdate, fnd_global.user_id, fnd_global.login_id,
173: fnd_global.conc_program_id, fnd_global.conc_login_id,
174: fnd_global.prog_appl_id, fnd_global.conc_request_id
175: from msc_net_resource_avail mra
176: where mra.plan_id = p_plan_id
177: and mra.resource_id > 0
178: and mra.capacity_units >= 0 -- bug 10010498

Line 231: fnd_global.user_id, sysdate,

227: sum(nvl(mrr.cummulative_quantity, ms.new_order_quantity)) order_quantity,
228: sum(mrr.resource_hours) resource_hours,
229: 1 no_of_orders,
230:
231: fnd_global.user_id, sysdate,
232: sysdate, fnd_global.user_id, fnd_global.login_id,
233: fnd_global.conc_program_id, fnd_global.conc_login_id,
234: fnd_global.prog_appl_id, fnd_global.conc_request_id
235: from

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

228: sum(mrr.resource_hours) resource_hours,
229: 1 no_of_orders,
230:
231: fnd_global.user_id, sysdate,
232: sysdate, fnd_global.user_id, fnd_global.login_id,
233: fnd_global.conc_program_id, fnd_global.conc_login_id,
234: fnd_global.prog_appl_id, fnd_global.conc_request_id
235: from
236: msc_resource_requirements mrr,

Line 233: fnd_global.conc_program_id, fnd_global.conc_login_id,

229: 1 no_of_orders,
230:
231: fnd_global.user_id, sysdate,
232: sysdate, fnd_global.user_id, fnd_global.login_id,
233: fnd_global.conc_program_id, fnd_global.conc_login_id,
234: fnd_global.prog_appl_id, fnd_global.conc_request_id
235: from
236: msc_resource_requirements mrr,
237: msc_supplies ms,

Line 234: fnd_global.prog_appl_id, fnd_global.conc_request_id

230:
231: fnd_global.user_id, sysdate,
232: sysdate, fnd_global.user_id, fnd_global.login_id,
233: fnd_global.conc_program_id, fnd_global.conc_login_id,
234: fnd_global.prog_appl_id, fnd_global.conc_request_id
235: from
236: msc_resource_requirements mrr,
237: msc_supplies ms,
238: msc_department_resources mdr

Line 300: fnd_global.user_id, sysdate,

296: t1.setup_hours setup_time_hrs,
297: t1.resource_cost,
298: t1.resource_cost * decode(decode(l_plan_type, 6, l_owning_currency_code, t1.currency_code),
299: fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) resource_cost2,
300: fnd_global.user_id, sysdate,
301: sysdate, fnd_global.user_id, fnd_global.login_id,
302: fnd_global.conc_program_id, fnd_global.conc_login_id,
303: fnd_global.prog_appl_id, fnd_global.conc_request_id
304: from

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

297: t1.resource_cost,
298: t1.resource_cost * decode(decode(l_plan_type, 6, l_owning_currency_code, t1.currency_code),
299: fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) resource_cost2,
300: fnd_global.user_id, sysdate,
301: sysdate, fnd_global.user_id, fnd_global.login_id,
302: fnd_global.conc_program_id, fnd_global.conc_login_id,
303: fnd_global.prog_appl_id, fnd_global.conc_request_id
304: from
305: /* For SNO plan don't filter detail_level.

Line 302: fnd_global.conc_program_id, fnd_global.conc_login_id,

298: t1.resource_cost * decode(decode(l_plan_type, 6, l_owning_currency_code, t1.currency_code),
299: fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) resource_cost2,
300: fnd_global.user_id, sysdate,
301: sysdate, fnd_global.user_id, fnd_global.login_id,
302: fnd_global.conc_program_id, fnd_global.conc_login_id,
303: fnd_global.prog_appl_id, fnd_global.conc_request_id
304: from
305: /* For SNO plan don't filter detail_level.
306: */

Line 303: fnd_global.prog_appl_id, fnd_global.conc_request_id

299: fnd_profile.value('MSC_HUB_CUR_CODE_RPT'), 1, nvl(mcc.conv_rate, 0)) resource_cost2,
300: fnd_global.user_id, sysdate,
301: sysdate, fnd_global.user_id, fnd_global.login_id,
302: fnd_global.conc_program_id, fnd_global.conc_login_id,
303: fnd_global.prog_appl_id, fnd_global.conc_request_id
304: from
305: /* For SNO plan don't filter detail_level.
306: */
307: (select /*+ ordered */

Line 406: fnd_global.user_id, sysdate,

402: sum(f.resource_hours),
403: sum(f.no_of_orders),
404: sum(f.resource_cost),
405: sum(f.resource_cost2),
406: fnd_global.user_id, sysdate,
407: sysdate, fnd_global.user_id, fnd_global.login_id,
408: fnd_global.conc_program_id, fnd_global.conc_login_id,
409: fnd_global.prog_appl_id, fnd_global.conc_request_id
410: from msc_st_resources_f f

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

403: sum(f.no_of_orders),
404: sum(f.resource_cost),
405: sum(f.resource_cost2),
406: fnd_global.user_id, sysdate,
407: sysdate, fnd_global.user_id, fnd_global.login_id,
408: fnd_global.conc_program_id, fnd_global.conc_login_id,
409: fnd_global.prog_appl_id, fnd_global.conc_request_id
410: from msc_st_resources_f f
411: where f.st_transaction_id=l_transfer_id

Line 408: fnd_global.conc_program_id, fnd_global.conc_login_id,

404: sum(f.resource_cost),
405: sum(f.resource_cost2),
406: fnd_global.user_id, sysdate,
407: sysdate, fnd_global.user_id, fnd_global.login_id,
408: fnd_global.conc_program_id, fnd_global.conc_login_id,
409: fnd_global.prog_appl_id, fnd_global.conc_request_id
410: from msc_st_resources_f f
411: where f.st_transaction_id=l_transfer_id
412: group by

Line 409: fnd_global.prog_appl_id, fnd_global.conc_request_id

405: sum(f.resource_cost2),
406: fnd_global.user_id, sysdate,
407: sysdate, fnd_global.user_id, fnd_global.login_id,
408: fnd_global.conc_program_id, fnd_global.conc_login_id,
409: fnd_global.prog_appl_id, fnd_global.conc_request_id
410: from msc_st_resources_f f
411: where f.st_transaction_id=l_transfer_id
412: group by
413: sr_instance_id,

Line 455: fnd_global.user_id, sysdate,

451: d.calendar_date analysis_date,
452: to_number(0) aggr_type,
453: '-23453' resource_group,
454: sum(nvl(f.available_hours, 0) - nvl(f.required_hours, 0)) cum_net_resource_avail,
455: fnd_global.user_id, sysdate,
456: sysdate, fnd_global.user_id, fnd_global.login_id,
457: fnd_global.conc_program_id, fnd_global.conc_login_id,
458: fnd_global.prog_appl_id, fnd_global.conc_request_id
459: from

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

452: to_number(0) aggr_type,
453: '-23453' resource_group,
454: sum(nvl(f.available_hours, 0) - nvl(f.required_hours, 0)) cum_net_resource_avail,
455: fnd_global.user_id, sysdate,
456: sysdate, fnd_global.user_id, fnd_global.login_id,
457: fnd_global.conc_program_id, fnd_global.conc_login_id,
458: fnd_global.prog_appl_id, fnd_global.conc_request_id
459: from
460: msc_resources_f f,

Line 457: fnd_global.conc_program_id, fnd_global.conc_login_id,

453: '-23453' resource_group,
454: sum(nvl(f.available_hours, 0) - nvl(f.required_hours, 0)) cum_net_resource_avail,
455: fnd_global.user_id, sysdate,
456: sysdate, fnd_global.user_id, fnd_global.login_id,
457: fnd_global.conc_program_id, fnd_global.conc_login_id,
458: fnd_global.prog_appl_id, fnd_global.conc_request_id
459: from
460: msc_resources_f f,
461: msc_phub_dates_mv d

Line 458: fnd_global.prog_appl_id, fnd_global.conc_request_id

454: sum(nvl(f.available_hours, 0) - nvl(f.required_hours, 0)) cum_net_resource_avail,
455: fnd_global.user_id, sysdate,
456: sysdate, fnd_global.user_id, fnd_global.login_id,
457: fnd_global.conc_program_id, fnd_global.conc_login_id,
458: fnd_global.prog_appl_id, fnd_global.conc_request_id
459: from
460: msc_resources_f f,
461: msc_phub_dates_mv d
462: where f.plan_id=p_plan_id

Line 560: fnd_global.user_id, sysdate,

556: sum(f.resource_hours),
557: sum(f.no_of_orders),
558: sum(f.resource_cost),
559: sum(f.resource_cost2),
560: fnd_global.user_id, sysdate,
561: sysdate, fnd_global.user_id, fnd_global.login_id,
562: fnd_global.conc_program_id, fnd_global.conc_login_id,
563: fnd_global.prog_appl_id, fnd_global.conc_request_id
564: from

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

557: sum(f.no_of_orders),
558: sum(f.resource_cost),
559: sum(f.resource_cost2),
560: fnd_global.user_id, sysdate,
561: sysdate, fnd_global.user_id, fnd_global.login_id,
562: fnd_global.conc_program_id, fnd_global.conc_login_id,
563: fnd_global.prog_appl_id, fnd_global.conc_request_id
564: from
565: msc_resources_f f

Line 562: fnd_global.conc_program_id, fnd_global.conc_login_id,

558: sum(f.resource_cost),
559: sum(f.resource_cost2),
560: fnd_global.user_id, sysdate,
561: sysdate, fnd_global.user_id, fnd_global.login_id,
562: fnd_global.conc_program_id, fnd_global.conc_login_id,
563: fnd_global.prog_appl_id, fnd_global.conc_request_id
564: from
565: msc_resources_f f
566: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 563: fnd_global.prog_appl_id, fnd_global.conc_request_id

559: sum(f.resource_cost2),
560: fnd_global.user_id, sysdate,
561: sysdate, fnd_global.user_id, fnd_global.login_id,
562: fnd_global.conc_program_id, fnd_global.conc_login_id,
563: fnd_global.prog_appl_id, fnd_global.conc_request_id
564: from
565: msc_resources_f f
566: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
567: and f.aggr_type=0

Line 591: fnd_global.user_id, sysdate,

587: sum(f.resource_hours),
588: sum(f.no_of_orders),
589: sum(f.resource_cost),
590: sum(f.resource_cost2),
591: fnd_global.user_id, sysdate,
592: sysdate, fnd_global.user_id, fnd_global.login_id,
593: fnd_global.conc_program_id, fnd_global.conc_login_id,
594: fnd_global.prog_appl_id, fnd_global.conc_request_id
595: from

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

588: sum(f.no_of_orders),
589: sum(f.resource_cost),
590: sum(f.resource_cost2),
591: fnd_global.user_id, sysdate,
592: sysdate, fnd_global.user_id, fnd_global.login_id,
593: fnd_global.conc_program_id, fnd_global.conc_login_id,
594: fnd_global.prog_appl_id, fnd_global.conc_request_id
595: from
596: msc_resources_f f,

Line 593: fnd_global.conc_program_id, fnd_global.conc_login_id,

589: sum(f.resource_cost),
590: sum(f.resource_cost2),
591: fnd_global.user_id, sysdate,
592: sysdate, fnd_global.user_id, fnd_global.login_id,
593: fnd_global.conc_program_id, fnd_global.conc_login_id,
594: fnd_global.prog_appl_id, fnd_global.conc_request_id
595: from
596: msc_resources_f f,
597: msc_phub_resources_mv r

Line 594: fnd_global.prog_appl_id, fnd_global.conc_request_id

590: sum(f.resource_cost2),
591: fnd_global.user_id, sysdate,
592: sysdate, fnd_global.user_id, fnd_global.login_id,
593: fnd_global.conc_program_id, fnd_global.conc_login_id,
594: fnd_global.prog_appl_id, fnd_global.conc_request_id
595: from
596: msc_resources_f f,
597: msc_phub_resources_mv r
598: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 648: fnd_global.user_id, sysdate,

644: sum(f.resource_hours),
645: sum(f.no_of_orders),
646: sum(f.resource_cost),
647: sum(f.resource_cost2),
648: fnd_global.user_id, sysdate,
649: sysdate, fnd_global.user_id, fnd_global.login_id,
650: fnd_global.conc_program_id, fnd_global.conc_login_id,
651: fnd_global.prog_appl_id, fnd_global.conc_request_id
652: from

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

645: sum(f.no_of_orders),
646: sum(f.resource_cost),
647: sum(f.resource_cost2),
648: fnd_global.user_id, sysdate,
649: sysdate, fnd_global.user_id, fnd_global.login_id,
650: fnd_global.conc_program_id, fnd_global.conc_login_id,
651: fnd_global.prog_appl_id, fnd_global.conc_request_id
652: from
653: msc_resources_f f,

Line 650: fnd_global.conc_program_id, fnd_global.conc_login_id,

646: sum(f.resource_cost),
647: sum(f.resource_cost2),
648: fnd_global.user_id, sysdate,
649: sysdate, fnd_global.user_id, fnd_global.login_id,
650: fnd_global.conc_program_id, fnd_global.conc_login_id,
651: fnd_global.prog_appl_id, fnd_global.conc_request_id
652: from
653: msc_resources_f f,
654: msc_phub_dates_mv d

Line 651: fnd_global.prog_appl_id, fnd_global.conc_request_id

647: sum(f.resource_cost2),
648: fnd_global.user_id, sysdate,
649: sysdate, fnd_global.user_id, fnd_global.login_id,
650: fnd_global.conc_program_id, fnd_global.conc_login_id,
651: fnd_global.prog_appl_id, fnd_global.conc_request_id
652: from
653: msc_resources_f f,
654: msc_phub_dates_mv d
655: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 682: fnd_global.user_id, sysdate,

678: sum(f.resource_hours),
679: sum(f.no_of_orders),
680: sum(f.resource_cost),
681: sum(f.resource_cost2),
682: fnd_global.user_id, sysdate,
683: sysdate, fnd_global.user_id, fnd_global.login_id,
684: fnd_global.conc_program_id, fnd_global.conc_login_id,
685: fnd_global.prog_appl_id, fnd_global.conc_request_id
686: from

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

679: sum(f.no_of_orders),
680: sum(f.resource_cost),
681: sum(f.resource_cost2),
682: fnd_global.user_id, sysdate,
683: sysdate, fnd_global.user_id, fnd_global.login_id,
684: fnd_global.conc_program_id, fnd_global.conc_login_id,
685: fnd_global.prog_appl_id, fnd_global.conc_request_id
686: from
687: msc_resources_f f,

Line 684: fnd_global.conc_program_id, fnd_global.conc_login_id,

680: sum(f.resource_cost),
681: sum(f.resource_cost2),
682: fnd_global.user_id, sysdate,
683: sysdate, fnd_global.user_id, fnd_global.login_id,
684: fnd_global.conc_program_id, fnd_global.conc_login_id,
685: fnd_global.prog_appl_id, fnd_global.conc_request_id
686: from
687: msc_resources_f f,
688: msc_phub_dates_mv d

Line 685: fnd_global.prog_appl_id, fnd_global.conc_request_id

681: sum(f.resource_cost2),
682: fnd_global.user_id, sysdate,
683: sysdate, fnd_global.user_id, fnd_global.login_id,
684: fnd_global.conc_program_id, fnd_global.conc_login_id,
685: fnd_global.prog_appl_id, fnd_global.conc_request_id
686: from
687: msc_resources_f f,
688: msc_phub_dates_mv d
689: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 746: fnd_global.user_id, sysdate,

742: f.inventory_item_id, f.analysis_date,
743: to_number(81) aggr_type,
744: '-23453' resource_group,
745: sum(f.cum_net_resource_avail),
746: fnd_global.user_id, sysdate,
747: sysdate, fnd_global.user_id, fnd_global.login_id,
748: fnd_global.conc_program_id, fnd_global.conc_login_id,
749: fnd_global.prog_appl_id, fnd_global.conc_request_id
750: from

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

743: to_number(81) aggr_type,
744: '-23453' resource_group,
745: sum(f.cum_net_resource_avail),
746: fnd_global.user_id, sysdate,
747: sysdate, fnd_global.user_id, fnd_global.login_id,
748: fnd_global.conc_program_id, fnd_global.conc_login_id,
749: fnd_global.prog_appl_id, fnd_global.conc_request_id
750: from
751: msc_resources_cum_f f

Line 748: fnd_global.conc_program_id, fnd_global.conc_login_id,

744: '-23453' resource_group,
745: sum(f.cum_net_resource_avail),
746: fnd_global.user_id, sysdate,
747: sysdate, fnd_global.user_id, fnd_global.login_id,
748: fnd_global.conc_program_id, fnd_global.conc_login_id,
749: fnd_global.prog_appl_id, fnd_global.conc_request_id
750: from
751: msc_resources_cum_f f
752: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 749: fnd_global.prog_appl_id, fnd_global.conc_request_id

745: sum(f.cum_net_resource_avail),
746: fnd_global.user_id, sysdate,
747: sysdate, fnd_global.user_id, fnd_global.login_id,
748: fnd_global.conc_program_id, fnd_global.conc_login_id,
749: fnd_global.prog_appl_id, fnd_global.conc_request_id
750: from
751: msc_resources_cum_f f
752: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
753: and f.aggr_type=0

Line 770: fnd_global.user_id, sysdate,

766: f.inventory_item_id, f.analysis_date,
767: to_number(82) aggr_type,
768: nvl(r.resource_group_id, '-23453') resource_group,
769: sum(f.cum_net_resource_avail),
770: fnd_global.user_id, sysdate,
771: sysdate, fnd_global.user_id, fnd_global.login_id,
772: fnd_global.conc_program_id, fnd_global.conc_login_id,
773: fnd_global.prog_appl_id, fnd_global.conc_request_id
774: from

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

767: to_number(82) aggr_type,
768: nvl(r.resource_group_id, '-23453') resource_group,
769: sum(f.cum_net_resource_avail),
770: fnd_global.user_id, sysdate,
771: sysdate, fnd_global.user_id, fnd_global.login_id,
772: fnd_global.conc_program_id, fnd_global.conc_login_id,
773: fnd_global.prog_appl_id, fnd_global.conc_request_id
774: from
775: msc_resources_cum_f f,

Line 772: fnd_global.conc_program_id, fnd_global.conc_login_id,

768: nvl(r.resource_group_id, '-23453') resource_group,
769: sum(f.cum_net_resource_avail),
770: fnd_global.user_id, sysdate,
771: sysdate, fnd_global.user_id, fnd_global.login_id,
772: fnd_global.conc_program_id, fnd_global.conc_login_id,
773: fnd_global.prog_appl_id, fnd_global.conc_request_id
774: from
775: msc_resources_cum_f f,
776: msc_phub_resources_mv r

Line 773: fnd_global.prog_appl_id, fnd_global.conc_request_id

769: sum(f.cum_net_resource_avail),
770: fnd_global.user_id, sysdate,
771: sysdate, fnd_global.user_id, fnd_global.login_id,
772: fnd_global.conc_program_id, fnd_global.conc_login_id,
773: fnd_global.prog_appl_id, fnd_global.conc_request_id
774: from
775: msc_resources_cum_f f,
776: msc_phub_resources_mv r
777: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

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

861: ' f.resource_hours,'||
862: ' f.no_of_orders,'||
863: ' f.resource_cost,'||
864: ' f.resource_cost2,'||
865: ' fnd_global.user_id, sysdate,'||
866: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
867: ' from'||
868: ' '||l_apps_schema||'.msc_resources_f'||l_suffix||' f,'||
869: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||

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

862: ' f.no_of_orders,'||
863: ' f.resource_cost,'||
864: ' f.resource_cost2,'||
865: ' fnd_global.user_id, sysdate,'||
866: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
867: ' from'||
868: ' '||l_apps_schema||'.msc_resources_f'||l_suffix||' f,'||
869: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
870: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi,'||

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

949: if (p_source_version >= '12.1.3') then l_sql := l_sql||
950: ' f.cum_net_resource_avail,';
951: end if;
952: l_sql := l_sql||
953: ' fnd_global.user_id, sysdate,'||
954: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
955: ' from'||
956: ' '||l_apps_schema||'.msc_resources_cum_f'||l_suffix||' f,'||
957: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||

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

950: ' f.cum_net_resource_avail,';
951: end if;
952: l_sql := l_sql||
953: ' fnd_global.user_id, sysdate,'||
954: ' fnd_global.user_id, sysdate, fnd_global.login_id'||
955: ' from'||
956: ' '||l_apps_schema||'.msc_resources_cum_f'||l_suffix||' f,'||
957: ' '||l_apps_schema||'.msc_trading_partners'||l_suffix||' mtp,'||
958: ' '||l_apps_schema||'.msc_items'||l_suffix||' mi,'||

Line 1056: fnd_global.user_id, sysdate,

1052: no_of_orders,
1053: resource_cost,
1054: resource_cost2,
1055: 0, '-23453',
1056: fnd_global.user_id, sysdate,
1057: fnd_global.user_id, sysdate, fnd_global.login_id
1058: from msc_st_resources_f
1059: where st_transaction_id=p_st_transaction_id and error_code=0;
1060:

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

1053: resource_cost,
1054: resource_cost2,
1055: 0, '-23453',
1056: fnd_global.user_id, sysdate,
1057: fnd_global.user_id, sysdate, fnd_global.login_id
1058: from msc_st_resources_f
1059: where st_transaction_id=p_st_transaction_id and error_code=0;
1060:
1061: msc_phub_util.log('msc_resource_pkg.import_resources_f: inserted='||sql%rowcount);

Line 1138: fnd_global.user_id, sysdate,

1134: nvl(inventory_item_id, -23453),
1135: analysis_date,
1136: cum_net_resource_avail,
1137: 0, '-23453',
1138: fnd_global.user_id, sysdate,
1139: fnd_global.user_id, sysdate, fnd_global.login_id
1140: from msc_st_resources_cum_f
1141: where st_transaction_id=p_st_transaction_id and error_code=0;
1142:

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

1135: analysis_date,
1136: cum_net_resource_avail,
1137: 0, '-23453',
1138: fnd_global.user_id, sysdate,
1139: fnd_global.user_id, sysdate, fnd_global.login_id
1140: from msc_st_resources_cum_f
1141: where st_transaction_id=p_st_transaction_id and error_code=0;
1142:
1143: msc_phub_util.log('msc_resource_pkg.import_resources_cum_f: inserted='||sql%rowcount);