[Home] [Help]
242: and wip_entity_id <> l_rep_we_id)
243: AND nvl(wro.quantity_issued, 0) >= nvl(wro.quantity_relieved, 0)
244: -- If there is a PUSH comp and the whole qty is scrapped, qty_rel > qty_iss
245: AND not exists (select 'obsolete operation'
246: from wip_operations wo
247: where wo.wip_entity_id = wro.wip_entity_id
248: and wo.organization_id = wro.organization_id
249: and wo.operation_seq_num = wro.operation_seq_num
250: and wo.count_point_type = 3);
268: from wsm_sm_resulting_jobs
269: where transaction_id = p_txn_id
270: and wip_entity_id <> l_rep_we_id)
271: AND not exists (select 'obsolete operation'
272: from wip_operations wo
273: where wo.wip_entity_id = wro.wip_entity_id
274: and wo.organization_id = wro.organization_id
275: and wo.operation_seq_num = wro.operation_seq_num
276: and wo.count_point_type = 3);
302: where transaction_id = p_txn_id
303: and wip_entity_id = l_rep_we_id)
304: AND wro.quantity_issued > NVL(wro.quantity_relieved, 0) -- Added to fix bug #2797647
305: AND not exists (select 'obsolete operation'
306: from wip_operations wo
307: where wo.wip_entity_id = wro.wip_entity_id
308: and wo.organization_id = wro.organization_id
309: and wo.operation_seq_num = wro.operation_seq_num
310: and wo.count_point_type = 3);