APPS.ENG_VALIDATE_REVISED_ITEM dependencies on WIP_DISCRETE_JOBS

Line 2256: FROM WIP_DISCRETE_JOBS

2252: , p_routing_sequence_id NUMBER )
2253: IS
2254: SELECT scheduled_start_date
2255: , start_quantity
2256: FROM WIP_DISCRETE_JOBS
2257: WHERE status_type = 1
2258: AND wip_entity_id = p_wip_entity_id
2259: AND ( common_bom_sequence_id = p_bill_sequence_id
2260: OR common_routing_sequence_id = p_routing_sequence_id

Line 2276: FROM WIP_DISCRETE_JOBS wdj1

2272: IS
2273: SELECT 'Lot Number is invalid'
2274: FROM SYS.DUAL
2275: WHERE NOT EXISTS ( SELECT 'Valid Lot'
2276: FROM WIP_DISCRETE_JOBS wdj1
2277: WHERE wdj1.lot_number = p_lot_number
2278: AND wdj1.status_type = 1
2279: AND wdj1.scheduled_start_date >= p_start_effective_date
2280: AND wdj1.organization_Id = p_org_id

Line 2284: FROM WIP_DISCRETE_JOBS wdj2

2280: AND wdj1.organization_Id = p_org_id
2281: AND wdj1.primary_item_id = p_rev_item_id
2282: )
2283: OR EXISTS (SELECT 'Invalid Lot'
2284: FROM WIP_DISCRETE_JOBS wdj2
2285: WHERE wdj2.lot_number = p_lot_number
2286: AND ( wdj2.status_type <> 1 OR
2287: wdj2.scheduled_start_date < p_start_effective_date)
2288: AND wdj2.organization_Id = p_org_id

Line 2304: FROM WIP_DISCRETE_JOBS wdj1

2300: IS
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

Line 2317: FROM WIP_DISCRETE_JOBS wdj2

2313: AND we1.wip_entity_name >= p_from_wo_num
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