DBA Data[Home] [Help]

APPS.MSC_RESOURCE_PKG dependencies on FND_GLOBAL

Line 57: fnd_global.user_id created_by,

53: to_number(0) aggr_type,
54: to_number(-23453) category_set_id,
55: to_number(-23453) sr_category_id,
56: '-23453' resource_group,
57: fnd_global.user_id created_by,
58: sysdate creation_date,
59: sysdate last_update_date,
60: fnd_global.user_id last_updated_by,
61: fnd_global.login_id last_update_login,

Line 60: fnd_global.user_id last_updated_by,

56: '-23453' resource_group,
57: fnd_global.user_id created_by,
58: sysdate creation_date,
59: sysdate last_update_date,
60: fnd_global.user_id last_updated_by,
61: fnd_global.login_id last_update_login,
62: fnd_global.conc_program_id program_id,
63: fnd_global.conc_login_id program_login_id,
64: fnd_global.prog_appl_id program_application_id,

Line 61: fnd_global.login_id last_update_login,

57: fnd_global.user_id created_by,
58: sysdate creation_date,
59: sysdate last_update_date,
60: fnd_global.user_id last_updated_by,
61: fnd_global.login_id last_update_login,
62: fnd_global.conc_program_id program_id,
63: fnd_global.conc_login_id program_login_id,
64: fnd_global.prog_appl_id program_application_id,
65: fnd_global.conc_request_id request_id,

Line 62: fnd_global.conc_program_id program_id,

58: sysdate creation_date,
59: sysdate last_update_date,
60: fnd_global.user_id last_updated_by,
61: fnd_global.login_id last_update_login,
62: fnd_global.conc_program_id program_id,
63: fnd_global.conc_login_id program_login_id,
64: fnd_global.prog_appl_id program_application_id,
65: fnd_global.conc_request_id request_id,
66: sum(required_hours),

Line 63: fnd_global.conc_login_id program_login_id,

59: sysdate last_update_date,
60: fnd_global.user_id last_updated_by,
61: fnd_global.login_id last_update_login,
62: fnd_global.conc_program_id program_id,
63: fnd_global.conc_login_id program_login_id,
64: fnd_global.prog_appl_id program_application_id,
65: fnd_global.conc_request_id request_id,
66: sum(required_hours),
67: sum(available_hours) ,

Line 64: fnd_global.prog_appl_id program_application_id,

60: fnd_global.user_id last_updated_by,
61: fnd_global.login_id last_update_login,
62: fnd_global.conc_program_id program_id,
63: fnd_global.conc_login_id program_login_id,
64: fnd_global.prog_appl_id program_application_id,
65: fnd_global.conc_request_id request_id,
66: sum(required_hours),
67: sum(available_hours) ,
68: sum(setup_time_hrs) ,

Line 65: fnd_global.conc_request_id request_id,

61: fnd_global.login_id last_update_login,
62: fnd_global.conc_program_id program_id,
63: fnd_global.conc_login_id program_login_id,
64: fnd_global.prog_appl_id program_application_id,
65: fnd_global.conc_request_id request_id,
66: sum(required_hours),
67: sum(available_hours) ,
68: sum(setup_time_hrs) ,
69: sum(order_quantity) ,

Line 348: fnd_global.user_id, sysdate,

344: sum(f.resource_hours),
345: sum(f.no_of_orders),
346: sum(f.resource_cost),
347: sum(f.resource_cost2),
348: fnd_global.user_id, sysdate,
349: sysdate, fnd_global.user_id, fnd_global.login_id,
350: fnd_global.conc_program_id, fnd_global.conc_login_id,
351: fnd_global.prog_appl_id, fnd_global.conc_request_id
352: from

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

345: sum(f.no_of_orders),
346: sum(f.resource_cost),
347: sum(f.resource_cost2),
348: fnd_global.user_id, sysdate,
349: sysdate, fnd_global.user_id, fnd_global.login_id,
350: fnd_global.conc_program_id, fnd_global.conc_login_id,
351: fnd_global.prog_appl_id, fnd_global.conc_request_id
352: from
353: msc_resources_f f

Line 350: fnd_global.conc_program_id, fnd_global.conc_login_id,

346: sum(f.resource_cost),
347: sum(f.resource_cost2),
348: fnd_global.user_id, sysdate,
349: sysdate, fnd_global.user_id, fnd_global.login_id,
350: fnd_global.conc_program_id, fnd_global.conc_login_id,
351: fnd_global.prog_appl_id, fnd_global.conc_request_id
352: from
353: msc_resources_f f
354: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 351: fnd_global.prog_appl_id, fnd_global.conc_request_id

347: sum(f.resource_cost2),
348: fnd_global.user_id, sysdate,
349: sysdate, fnd_global.user_id, fnd_global.login_id,
350: fnd_global.conc_program_id, fnd_global.conc_login_id,
351: fnd_global.prog_appl_id, fnd_global.conc_request_id
352: from
353: msc_resources_f f
354: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
355: and f.aggr_type=0

Line 382: fnd_global.user_id, sysdate,

378: sum(f.resource_hours),
379: sum(f.no_of_orders),
380: sum(f.resource_cost),
381: sum(f.resource_cost2),
382: fnd_global.user_id, sysdate,
383: sysdate, fnd_global.user_id, fnd_global.login_id,
384: fnd_global.conc_program_id, fnd_global.conc_login_id,
385: fnd_global.prog_appl_id, fnd_global.conc_request_id
386: from

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

379: sum(f.no_of_orders),
380: sum(f.resource_cost),
381: sum(f.resource_cost2),
382: fnd_global.user_id, sysdate,
383: sysdate, fnd_global.user_id, fnd_global.login_id,
384: fnd_global.conc_program_id, fnd_global.conc_login_id,
385: fnd_global.prog_appl_id, fnd_global.conc_request_id
386: from
387: msc_resources_f f,

Line 384: fnd_global.conc_program_id, fnd_global.conc_login_id,

380: sum(f.resource_cost),
381: sum(f.resource_cost2),
382: fnd_global.user_id, sysdate,
383: sysdate, fnd_global.user_id, fnd_global.login_id,
384: fnd_global.conc_program_id, fnd_global.conc_login_id,
385: fnd_global.prog_appl_id, fnd_global.conc_request_id
386: from
387: msc_resources_f f,
388: msc_department_resources r

Line 385: fnd_global.prog_appl_id, fnd_global.conc_request_id

381: sum(f.resource_cost2),
382: fnd_global.user_id, sysdate,
383: sysdate, fnd_global.user_id, fnd_global.login_id,
384: fnd_global.conc_program_id, fnd_global.conc_login_id,
385: fnd_global.prog_appl_id, fnd_global.conc_request_id
386: from
387: msc_resources_f f,
388: msc_department_resources r
389: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 439: fnd_global.user_id, sysdate,

435: sum(f.resource_hours),
436: sum(f.no_of_orders),
437: sum(f.resource_cost),
438: sum(f.resource_cost2),
439: fnd_global.user_id, sysdate,
440: sysdate, fnd_global.user_id, fnd_global.login_id,
441: fnd_global.conc_program_id, fnd_global.conc_login_id,
442: fnd_global.prog_appl_id, fnd_global.conc_request_id
443: from

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

436: sum(f.no_of_orders),
437: sum(f.resource_cost),
438: sum(f.resource_cost2),
439: fnd_global.user_id, sysdate,
440: sysdate, fnd_global.user_id, fnd_global.login_id,
441: fnd_global.conc_program_id, fnd_global.conc_login_id,
442: fnd_global.prog_appl_id, fnd_global.conc_request_id
443: from
444: msc_resources_f f,

Line 441: fnd_global.conc_program_id, fnd_global.conc_login_id,

437: sum(f.resource_cost),
438: sum(f.resource_cost2),
439: fnd_global.user_id, sysdate,
440: sysdate, fnd_global.user_id, fnd_global.login_id,
441: fnd_global.conc_program_id, fnd_global.conc_login_id,
442: fnd_global.prog_appl_id, fnd_global.conc_request_id
443: from
444: msc_resources_f f,
445: msc_phub_mfg_cal_periods_mv mp

Line 442: fnd_global.prog_appl_id, fnd_global.conc_request_id

438: sum(f.resource_cost2),
439: fnd_global.user_id, sysdate,
440: sysdate, fnd_global.user_id, fnd_global.login_id,
441: fnd_global.conc_program_id, fnd_global.conc_login_id,
442: fnd_global.prog_appl_id, fnd_global.conc_request_id
443: from
444: msc_resources_f f,
445: msc_phub_mfg_cal_periods_mv mp
446: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id

Line 472: fnd_global.user_id, sysdate,

468: sum(f.resource_hours),
469: sum(f.no_of_orders),
470: sum(f.resource_cost),
471: sum(f.resource_cost2),
472: fnd_global.user_id, sysdate,
473: sysdate, fnd_global.user_id, fnd_global.login_id,
474: fnd_global.conc_program_id, fnd_global.conc_login_id,
475: fnd_global.prog_appl_id, fnd_global.conc_request_id
476: from

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

469: sum(f.no_of_orders),
470: sum(f.resource_cost),
471: sum(f.resource_cost2),
472: fnd_global.user_id, sysdate,
473: sysdate, fnd_global.user_id, fnd_global.login_id,
474: fnd_global.conc_program_id, fnd_global.conc_login_id,
475: fnd_global.prog_appl_id, fnd_global.conc_request_id
476: from
477: msc_resources_f f,

Line 474: fnd_global.conc_program_id, fnd_global.conc_login_id,

470: sum(f.resource_cost),
471: sum(f.resource_cost2),
472: fnd_global.user_id, sysdate,
473: sysdate, fnd_global.user_id, fnd_global.login_id,
474: fnd_global.conc_program_id, fnd_global.conc_login_id,
475: fnd_global.prog_appl_id, fnd_global.conc_request_id
476: from
477: msc_resources_f f,
478: msc_phub_fiscal_periods_mv fp

Line 475: fnd_global.prog_appl_id, fnd_global.conc_request_id

471: sum(f.resource_cost2),
472: fnd_global.user_id, sysdate,
473: sysdate, fnd_global.user_id, fnd_global.login_id,
474: fnd_global.conc_program_id, fnd_global.conc_login_id,
475: fnd_global.prog_appl_id, fnd_global.conc_request_id
476: from
477: msc_resources_f f,
478: msc_phub_fiscal_periods_mv fp
479: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id