DBA Data[Home] [Help]

APPS.OEXPURGE dependencies on WIP_DISCRETE_JOBS

Line 205: wip_discrete_jobs wdj

201: CURSOR SO_PROBLEM_CHECK IS
202: SELECT 'Open work orders for this sales order'
203: FROM mtl_sales_orders mso,
204: wip_so_allocations wsa,
205: wip_discrete_jobs wdj
206: WHERE mso.segment1 = p_order_number
207: AND mso.segment2 = p_order_type_name
208: AND mso.sales_order_id = wsa.demand_source_header_id
209: AND wsa.wip_entity_id = wdj.wip_entity_id