APPS.BOM_VALIDATE_SUB_OP_RES dependencies on WIP_DISCRETE_JOBS

Line 69: FROM WIP_DISCRETE_JOBS wdj

65: IS
66: SELECT 'Sub Res does not exist'
67: FROM SYS.DUAL
68: WHERE EXISTS (SELECT NULL
69: FROM WIP_DISCRETE_JOBS wdj
70: WHERE wdj.lot_number = p_lot_number
71: AND (wdj.status_type <> 1
72: OR
73: NOT EXISTS(SELECT NULL

Line 92: FROM WIP_DISCRETE_JOBS wdj

88: IS
89: SELECT 'Sub Res does not exist'
90: FROM DUAL
91: WHERE NOT EXISTS ( SELECT NULL
92: FROM WIP_DISCRETE_JOBS wdj
93: WHERE wdj.lot_number = p_lot_number
94: AND wdj.status_type = 1
95: AND EXISTS ( SELECT NULL
96: FROM WIP_SUB_OPERATION_RESOURCES wsor

Line 113: FROM WIP_DISCRETE_JOBS wdj

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

Line 143: FROM WIP_DISCRETE_JOBS wdj

139: IS
140: SELECT 'Sub Res does not exist'
141: FROM SYS.DUAL
142: WHERE EXISTS (SELECT NULL
143: FROM WIP_DISCRETE_JOBS wdj
144: WHERE (wdj.status_type <> 1
145: OR
146: NOT EXISTS(SELECT NULL
147: FROM WIP_SUB_OPERATION_RESOURCES wsor