DBA Data[Home] [Help]

APPS.BOM_VALIDATE_SUB_OP_RES dependencies on WIP_ENTITIES

Line 114: , WIP_ENTITIES we

110: SELECT 'Sub Res does not exist'
111: FROM SYS.DUAL
112: WHERE EXISTS (SELECT NULL
113: FROM WIP_DISCRETE_JOBS wdj
114: , WIP_ENTITIES we
115: , WIP_ENTITIES we1
116: , WIP_ENTITIES we2
117: WHERE (wdj.status_type <> 1
118: OR

Line 115: , WIP_ENTITIES we1

111: FROM SYS.DUAL
112: WHERE EXISTS (SELECT NULL
113: FROM WIP_DISCRETE_JOBS wdj
114: , WIP_ENTITIES we
115: , WIP_ENTITIES we1
116: , WIP_ENTITIES we2
117: WHERE (wdj.status_type <> 1
118: OR
119: NOT EXISTS (SELECT NULL

Line 116: , WIP_ENTITIES we2

112: WHERE EXISTS (SELECT NULL
113: FROM WIP_DISCRETE_JOBS wdj
114: , WIP_ENTITIES we
115: , WIP_ENTITIES we1
116: , WIP_ENTITIES we2
117: WHERE (wdj.status_type <> 1
118: OR
119: NOT EXISTS (SELECT NULL
120: FROM WIP_SUB_OPERATION_RESOURCES wsor