APPS.MRP_HORIZONTAL_PLAN_SC dependencies on WIP_DISCRETE_JOBS

Line 230: --- WIP Discrete Jobs

226: -- -------------------------------------------------------------
227:
228: CURSOR mrp_current_activity_ont_I IS
229: ------------------------
230: --- WIP Discrete Jobs
231: -----------------------
232: SELECT
233: items.inventory_item_id item_id,
234: items.organization_id org_id,

Line 244: wip_discrete_jobs jobs,

240: - jobs.quantity_scrapped))) new_quantity,
241: SUM(GREATEST( 0, (jobs.net_quantity - jobs.quantity_completed
242: - jobs.quantity_scrapped))) old_quantity
243: FROM mrp_form_query list,
244: wip_discrete_jobs jobs,
245: mrp_system_items items,
246: mrp_sub_inventories msi
247: WHERE (arg_res_level = 1
248: OR (arg_res_level = 2

Line 294: wip_discrete_jobs jobs,

290: SUM(GREATEST(0, (jobs.net_quantity - jobs.quantity_completed
291: - jobs.quantity_scrapped))*NVL(items.shrinkage_rate, 0)) new_quantity,
292: 0 old_quantity
293: FROM mrp_form_query list,
294: wip_discrete_jobs jobs,
295: mrp_system_items items,
296: mrp_sub_inventories msi
297: WHERE (arg_res_level = 1
298: OR (arg_res_level = 2

Line 348: wip_discrete_jobs jobs,

344: 0 old_quantity
345: FROM mrp_form_query list,
346: wip_operations wo,
347: wip_requirement_operations ops,
348: wip_discrete_jobs jobs,
349: mrp_system_items items,
350: mrp_sub_inventories msi
351: WHERE (arg_res_level = 1
352: OR (arg_res_level = 2