[Home] [Help]
159: ) r,
160: msc_exception_details med2,
161: msc_form_query q,
162: msc_trading_partners mtp2,
163: msc_department_resources mdp
164: where q.query_id = p_query_id
165: and q.number1 = msc_hp_util.ft_end_pegging
166: and r.sr_instance_id = q.number2
167: and r.end_pegging_id = q.number3
211: 1 data_flag,
212: fnd_global.user_id, sysdate,
213: sysdate, fnd_global.user_id, fnd_global.login_id
214: from
215: msc_department_resources mdp,
216: msc_trading_partners mtp
217: where mdp.plan_id = p_plan_id
218: and mdp.sr_instance_id = mtp.sr_instance_id
219: and mdp.organization_id = mtp.sr_tp_id
323: to_number(null) work_order,
324: to_number(null) total_resource_cost
325: from
326: msc_resource_requirements mrr,
327: msc_department_resources mdr,
328: msc_hp_col_dtls b,
329: msc_hp_row_dtls h
330: where h.query_id = p_query_id
331: and mrr.plan_id = h.plan_id
362: to_number(null) work_order,
363: to_number(null) total_resource_cost
364: from
365: msc_resource_requirements mrr,
366: msc_department_resources mdr,
367: msc_hp_col_dtls b,
368: msc_hp_row_dtls h
369: where h.query_id = p_query_id
370: and mrr.plan_id = h.plan_id
495: mdr.resource_cost * (1 + nvl(mdr2.dept_overhead_cost,0)) end)
496: total_resource_cost
497: from
498: msc_resource_requirements mrr,
499: msc_department_resources mdr,
500: msc_department_resources mdr2,
501: msc_supplies ms,
502: msc_hp_col_dtls b,
503: msc_hp_row_dtls h
496: total_resource_cost
497: from
498: msc_resource_requirements mrr,
499: msc_department_resources mdr,
500: msc_department_resources mdr2,
501: msc_supplies ms,
502: msc_hp_col_dtls b,
503: msc_hp_row_dtls h
504: where h.query_id = p_query_id