[Home] [Help]
317: mdrs.setup_hours,
318: mdrs.resource_cost
319: from
320: msc_bis_res_summary mdrs,
321: msc_trading_partners mtp
322: where mdrs.plan_id = p_plan_id
323: and l_plan_type = 6
324: and nvl(mdrs.period_type, 0) = 1
325: and mdrs.sr_instance_id = mtp.sr_instance_id(+)
339: to_number(null) setup_hours,
340: mbid.production_cost
341: from
342: msc_bis_inv_detail mbid,
343: msc_trading_partners mtp
344: where mbid.plan_id = p_plan_id
345: and nvl(mbid.detail_level, 0) = 1
346: and nvl(mbid.period_type, 0) = 1
347: and l_plan_type in (1,101,102,103,105)
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,'||
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'||
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,'||
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'||