75: FROM WIP_DISCRETE_JOBS wdj
76: WHERE (wdj.status_type <> 1
77: OR
78: NOT EXISTS(SELECT NULL
79: FROM WIP_OPERATION_RESOURCES wor
80: WHERE wor.resource_seq_num = p_resource_seq_num
81: AND wor.operation_seq_num = p_operation_seq_num
82: AND wor.wip_entity_id = wdj.wip_entity_id)
83: )
101: , WIP_ENTITIES we2
102: WHERE (wdj.status_type <> 1
103: OR
104: NOT EXISTS (SELECT NULL
105: FROM WIP_OPERATION_RESOURCES wor
106: WHERE resource_seq_num = p_resource_seq_num
107: AND operation_seq_num = p_operation_seq_num
108: AND wip_entity_id = wdj.wip_entity_id)
109: )
127: FROM WIP_DISCRETE_JOBS wdj
128: WHERE (wdj.status_type <> 1
129: OR
130: NOT EXISTS(SELECT NULL
131: FROM WIP_OPERATION_RESOURCES wor
132: WHERE resource_seq_num = p_resource_seq_num
133: AND operation_seq_num = p_operation_seq_num
134: AND wip_entity_id = wdj.wip_entity_id)
135: )