[Home] [Help]
1112: and mlk.lookup_code = lpn.lpn_context(+)
1113: and not exists (select wlpn.lpn_id
1114: from wms_license_plate_numbers wlpn,
1115: mtl_material_transactions_temp t,
1116: wms_dispatched_tasks w
1117: where w.status = 4
1118: and w.task_type <> 2
1119: and w.transaction_temp_id = t.transaction_temp_id
1120: and wlpn.lpn_id = lpn.lpn_id
1728: AND nvl(ms.lot_number, '$@#$%') = decode(p_lot_number, NULL, nvl(ms.lot_number, '$@#$%'), p_lot_number)
1729: AND ms.current_status =3
1730: and not exists (select w.status
1731: from mtl_material_transactions_temp t,
1732: wms_dispatched_tasks w
1733: where w.status = 4
1734: and w.task_type <> 2
1735: and w.transaction_temp_id = t.transaction_temp_id
1736: and (t.content_lpn_id = ms.lpn_id or
1787: --Show serial numbers irrespective of the status of the serial number.
1788: --AND ms.current_status in (3, 4, 5, 7)
1789: AND NOT EXISTS (SELECT w.status
1790: FROM mtl_material_transactions_temp t,
1791: wms_dispatched_tasks w
1792: WHERE w.status = 4
1793: AND w.task_type <> 2
1794: AND w.transaction_temp_id = t.transaction_temp_id
1795: AND (t.content_lpn_id = ms.lpn_id or
2641: AND nvl(ms.end_item_unit_number, '$@#$%') = decode(p_unit_number, NULL, nvl(ms.end_item_unit_number, '$@#$%'), p_unit_number)
2642: AND ms.current_status =3
2643: and not exists (select w.status
2644: from mtl_material_transactions_temp t,
2645: wms_dispatched_tasks w
2646: where w.status = 4
2647: and w.task_type <> 2
2648: and w.transaction_temp_id = t.transaction_temp_id
2649: and (t.content_lpn_id = ms.lpn_id or