APPS.ENG_VALIDATE_REVISED_ITEM dependencies on WIP_DISCRETE_JOBS

Line 2184: FROM WIP_DISCRETE_JOBS

2180: , p_routing_sequence_id NUMBER )
2181: IS
2182: SELECT scheduled_start_date
2183: , start_quantity
2184: FROM WIP_DISCRETE_JOBS
2185: WHERE status_type = 1
2186: AND wip_entity_id = p_wip_entity_id
2187: AND ( common_bom_sequence_id = p_bill_sequence_id
2188: OR common_routing_sequence_id = p_routing_sequence_id

Line 2204: FROM WIP_DISCRETE_JOBS wdj1

2200: IS
2201: SELECT 'Lot Number is invalid'
2202: FROM SYS.DUAL
2203: WHERE NOT EXISTS ( SELECT 'Valid Lot'
2204: FROM WIP_DISCRETE_JOBS wdj1
2205: WHERE wdj1.lot_number = p_lot_number
2206: AND wdj1.status_type = 1
2207: AND wdj1.scheduled_start_date >= p_start_effective_date
2208: AND wdj1.organization_Id = p_org_id

Line 2212: FROM WIP_DISCRETE_JOBS wdj2

2208: AND wdj1.organization_Id = p_org_id
2209: AND wdj1.primary_item_id = p_rev_item_id
2210: )
2211: OR EXISTS (SELECT 'Invalid Lot'
2212: FROM WIP_DISCRETE_JOBS wdj2
2213: WHERE wdj2.lot_number = p_lot_number
2214: AND ( wdj2.status_type <> 1 OR
2215: wdj2.scheduled_start_date < p_start_effective_date)
2216: AND wdj2.organization_Id = p_org_id

Line 2232: FROM WIP_DISCRETE_JOBS wdj1

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

Line 2245: FROM WIP_DISCRETE_JOBS wdj2

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