DBA Data[Home] [Help]

APPS.MRP_CRP_HORIZONTAL_PLAN dependencies on WIP_DISCRETE_JOBS

Line 204: wip_discrete_jobs jobs,

200: NVL(res.usage_rate_or_amount*muc2.conversion_rate/
201: muc1.conversion_rate, 0),
202: 0))/compute_days_between (g_spread_load,res.start_date,res.completion_date)
203: FROM mtl_uom_conversions muc2,
204: wip_discrete_jobs jobs,
205: wip_operations op,
206: wip_operation_resources res,
207: mrp_form_query list,
208: mtl_uom_conversions muc1

Line 396: FROM wip_discrete_jobs jobs,

392: jobs.scheduled_start_date,
393: to_date(NULL),
394: SUM(GREATEST( 0, (jobs.net_quantity - jobs.quantity_completed
395: - jobs.quantity_scrapped)))
396: FROM wip_discrete_jobs jobs,
397: mrp_form_query list
398: WHERE jobs.scheduled_start_date 399: AND jobs.status_type IN (JOB_UNRELEASED,
400: JOB_COMPLETE, JOB_HOLD, JOB_RELEASED)