DBA Data[Home] [Help]

APPS.BOM_VALIDATE_OP_SEQ dependencies on WIP_OPERATIONS

Line 160: FROM WIP_OPERATIONS wo

156: FROM WIP_DISCRETE_JOBS wdj
157: WHERE (wdj.status_type <> 1
158: OR
159: NOT EXISTS(SELECT NULL
160: FROM WIP_OPERATIONS wo
161: WHERE operation_seq_num = p_operation_seq_num
162: AND wip_entity_id = wdj.wip_entity_id)
163: )
164: AND wdj.lot_number = p_lot_number

Line 184: FROM WIP_OPERATIONS wo

180: , WIP_ENTITIES we2
181: WHERE (wdj.status_type <> 1
182: OR
183: NOT EXISTS (SELECT NULL
184: FROM WIP_OPERATIONS wo
185: WHERE operation_seq_num = p_operation_seq_num
186: AND wip_entity_id = wdj.wip_entity_id )
187: )
188: AND wdj.wip_entity_id = we.wip_entity_id

Line 206: FROM WIP_OPERATIONS wo

202: FROM WIP_DISCRETE_JOBS wdj
203: WHERE (wdj.status_type <> 1
204: OR
205: NOT EXISTS(SELECT NULL
206: FROM WIP_OPERATIONS wo
207: WHERE operation_seq_num = p_operation_seq_num
208: AND wip_entity_id = wdj.wip_entity_id )
209: )
210: AND wdj.wip_entity_id = p_from_wip_entity_id