DBA Data[Home] [Help]

APPS.ENG_VALIDATE_REVISED_ITEM dependencies on WIP_ENTITIES

Line 2233: , WIP_ENTITIES we1

2229: SELECT 'WO Range is invalid'
2230: FROM SYS.DUAL
2231: WHERE NOT EXISTS ( SELECT 'Valid WO'
2232: FROM WIP_DISCRETE_JOBS wdj1
2233: , WIP_ENTITIES we1
2234: WHERE wdj1.status_type = 1
2235: AND ( wdj1.common_bom_sequence_id = p_bill_sequence_id
2236: OR wdj1.common_routing_sequence_id = p_routing_sequence_id
2237: )

Line 2246: , WIP_ENTITIES we2

2242: AND we1.wip_entity_name <= NVL(p_to_wo_num, p_from_wo_num)
2243: )
2244: OR EXISTS ( SELECT 'Invalid WO'
2245: FROM WIP_DISCRETE_JOBS wdj2
2246: , WIP_ENTITIES we2
2247: WHERE ( wdj2.status_type <> 1 OR
2248: wdj2.scheduled_start_date < p_start_effective_date )
2249: AND ( wdj2.common_bom_sequence_id = p_bill_sequence_id
2250: OR wdj2.common_routing_sequence_id = p_routing_sequence_id