[Home] [Help]
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
115: and mdr.sr_instance_id = mrr.sr_instance_id
116: and mdr.organization_id = mrr.organization_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
239: where mrr.plan_id = p_plan_id
240: and nvl(mrr.parent_id, l_constrained_plan) = 2
241: and nvl(mrr.schedule_flag,2) = 1
242: and mdr.plan_id = mrr.plan_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,'||
871: ' '||l_apps_schema||'.msc_department_resources'||l_suffix||' mdr'||
872: ' where f.plan_run_id=:p_plan_run_id'||
873: ' and f.aggr_type=0'||
874: ' and mtp.partner_type(+)=3'||
875: ' and mtp.sr_instance_id(+)=f.sr_instance_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,'||
959: ' '||l_apps_schema||'.msc_department_resources'||l_suffix||' mdr'||
960: ' where f.plan_run_id=:p_plan_run_id'||
961: ' and f.aggr_type=0'||
962: ' and mtp.partner_type(+)=3'||
963: ' and mtp.sr_instance_id(+)=f.sr_instance_id'||