[Home] [Help]
92: to_number(null) no_of_orders,
93: to_number(null) resource_cost,
94: to_number(null) resource_cost2
95: from msc_resource_requirements mrr,
96: msc_department_resources mdr,
97: msc_plans mp
98: where mp.plan_id = p_plan_id
99: and mrr.plan_id = mp.plan_id
100: and mdr.plan_id = mrr.plan_id
140: to_number(null) no_of_orders,
141: to_number(null) resource_cost,
142: to_number(null) resource_cost2
143: from msc_net_resource_avail mra,
144: msc_department_resources mdr,
145: msc_plans mp
146: where mp.plan_id = p_plan_id
147: and mra.plan_id = mp.plan_id
148: and mdr.plan_id = mra.plan_id
190: to_number(null) resource_cost2
191: from
192: msc_resource_requirements mrr,
193: msc_supplies ms ,
194: msc_department_resources mdr,
195: msc_plans mp
196: where mp.plan_id = p_plan_id
197: and mrr.plan_id = mp.plan_id
198: and mrr.parent_id = 2
258: mdrs.setup_hours,
259: mdrs.resource_cost
260: from
261: msc_bis_res_summary mdrs,
262: msc_department_resources mdr,
263: msc_trading_partners mtp,
264: msc_plans mp
265: where mdrs.plan_id = p_plan_id
266: and mp.plan_id = mdrs.plan_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
390: and f.aggr_type=0
391: and r.plan_id(+) = f.plan_id
392: and r.sr_instance_id(+) = f.sr_instance_id