DBA Data[Home] [Help]

APPS.ENG_VALIDATE_REVISED_ITEM dependencies on WIP_ENTITIES

Line 2305: , WIP_ENTITIES we1

2301: SELECT 'WO Range is invalid'
2302: FROM SYS.DUAL
2303: WHERE NOT EXISTS ( SELECT 'Valid WO'
2304: FROM WIP_DISCRETE_JOBS wdj1
2305: , WIP_ENTITIES we1
2306: WHERE wdj1.status_type = 1
2307: AND ( wdj1.common_bom_sequence_id = p_bill_sequence_id
2308: OR wdj1.common_routing_sequence_id = p_routing_sequence_id
2309: )

Line 2318: , WIP_ENTITIES we2

2314: AND we1.wip_entity_name <= NVL(p_to_wo_num, p_from_wo_num)
2315: )
2316: OR EXISTS ( SELECT 'Invalid WO'
2317: FROM WIP_DISCRETE_JOBS wdj2
2318: , WIP_ENTITIES we2
2319: WHERE ( wdj2.status_type <> 1 OR
2320: wdj2.scheduled_start_date < p_start_effective_date )
2321: AND ( wdj2.common_bom_sequence_id = p_bill_sequence_id
2322: OR wdj2.common_routing_sequence_id = p_routing_sequence_id