DBA Data[Home] [Help]

APPS.MRP_LINE_SCHEDULE_ALGORITHM dependencies on WIP_DISCRETE_JOBS

Line 275: FROM wip_discrete_jobs

271: SELECT NVL(SUM(NVL(start_quantity,0)
272: - NVL(quantity_completed,0)
273: - NVL(quantity_scrapped,0)),0)
274: INTO v_sum_dj
275: FROM wip_discrete_jobs
276: WHERE line_id = p_line_id
277: AND organization_id = p_org_id
278: --fix bug#3783650
279: --AND to_number(to_char(scheduled_completion_date,'J'))