APPS.MSC_RES_PLAN_PKG dependencies on STANDARD

Line 293: non_standard_jobs,

289: row_index,
290: analysis_date,
291: required_hours,
292: available_hours,
293: non_standard_jobs,
294: planned_order,
295: work_order,
296: total_resource_cost,
297: created_by, creation_date,

Line 305: sum(non_standard_jobs) non_standard_jobs,

301: row_index,
302: analysis_date,
303: sum(required_hours) required_hours,
304: sum(available_hours) available_hours,
305: sum(non_standard_jobs) non_standard_jobs,
306: sum(planned_order) planned_order,
307: sum(work_order) work_order,
308: sum(total_resource_cost) total_resource_cost,
309: fnd_global.user_id, sysdate,

Line 321: to_number(null) non_standard_jobs,

317: sum(decode(mdr.line_flag,
318: 2, decode(mrr.end_date, null, mrr.resource_hours, mrr.daily_resource_hours),
319: mdr.max_rate * mrr.daily_resource_hours)) required_hours,
320: to_number(null) available_hours,
321: to_number(null) non_standard_jobs,
322: to_number(null) planned_order,
323: to_number(null) work_order,
324: to_number(null) total_resource_cost
325: from

Line 360: to_number(null) non_standard_jobs,

356: decode(p_summary, 1, -1, h.row_index) row_index,
357: b.bkt_start_date analysis_date,
358: avg(mrr.resource_hours) required_hours,
359: to_number(null) available_hours,
360: to_number(null) non_standard_jobs,
361: to_number(null) planned_order,
362: to_number(null) work_order,
363: to_number(null) total_resource_cost
364: from

Line 402: to_number(null) non_standard_jobs,

398: to_number(null) required_hours,
399: sum(mra.capacity_units * decode(mra.from_time, null, 0,
400: (decode(sign(mra.to_time-mra.from_time),
401: -1, mra.to_time+86400, mra.to_time) - mra.from_time)/3600)) available_hours,
402: to_number(null) non_standard_jobs,
403: to_number(null) planned_order,
404: to_number(null) work_order,
405: to_number(null) total_resource_cost
406: from

Line 446: to_number(null) non_standard_jobs,

442: to_number(null) required_hours,
443: sum(a2.capacity_units * decode(a2.from_time, null, 0,
444: (decode(sign(a2.to_time-a2.from_time),
445: -1, a2.to_time+86400, a2.to_time) - a2.from_time)/3600)) available_hours,
446: to_number(null) non_standard_jobs,
447: to_number(null) planned_order,
448: to_number(null) work_order,
449: to_number(null) total_resource_cost
450: from

Line 481: (case when mrr.supply_type in (3,4,5,7,27,60) then mrr.resource_hours end)))) non_standard_jobs,

477: to_number(null) available_hours,
478: sum(decode(ms.order_type, 7, decode(mrr.batch_number, null,
479: (decode(mdr.line_flag, 2, decode(mrr.end_date, null, mrr.resource_hours, mrr.daily_resource_hours),
480: mdr.max_rate * mrr.daily_resource_hours)),
481: (case when mrr.supply_type in (3,4,5,7,27,60) then mrr.resource_hours end)))) non_standard_jobs,
482: sum(decode(ms.order_type, 5, decode(mrr.batch_number, null,
483: (decode(mdr.line_flag, 2, decode(mrr.end_date, null, mrr.resource_hours, mrr.daily_resource_hours),
484: mdr.max_rate * mrr.daily_resource_hours)),
485: (case when mrr.supply_type in (3,4,5,7,27,60) then mrr.resource_hours end)))) planned_order,