APPS.INV_ITEM_INQ dependencies on WMS_DISPATCHED_TASKS

Line 1040: wms_dispatched_tasks w

1036: and mlk.lookup_code = lpn.lpn_context(+)
1037: and not exists (select wlpn.lpn_id
1038: from wms_license_plate_numbers wlpn,
1039: mtl_material_transactions_temp t,
1040: wms_dispatched_tasks w
1041: where w.status = 4
1042: and w.task_type <> 2
1043: and w.transaction_temp_id = t.transaction_temp_id
1044: and wlpn.lpn_id = lpn.lpn_id

Line 1656: wms_dispatched_tasks w

1652: AND nvl(ms.lot_number, '$@#$%') = decode(p_lot_number, NULL, nvl(ms.lot_number, '$@#$%'), p_lot_number)
1653: AND ms.current_status =3
1654: and not exists (select w.status
1655: from mtl_material_transactions_temp t,
1656: wms_dispatched_tasks w
1657: where w.status = 4
1658: and w.task_type <> 2
1659: and w.transaction_temp_id = t.transaction_temp_id
1660: and (t.content_lpn_id = ms.lpn_id or

Line 1715: wms_dispatched_tasks w

1711: --Show serial numbers irrespective of the status of the serial number.
1712: --AND ms.current_status in (3, 4, 5, 7)
1713: AND NOT EXISTS (SELECT w.status
1714: FROM mtl_material_transactions_temp t,
1715: wms_dispatched_tasks w
1716: WHERE w.status = 4
1717: AND w.task_type <> 2
1718: AND w.transaction_temp_id = t.transaction_temp_id
1719: AND (t.content_lpn_id = ms.lpn_id or

Line 2549: wms_dispatched_tasks w

2545: AND nvl(ms.end_item_unit_number, '$@#$%') = decode(p_unit_number, NULL, nvl(ms.end_item_unit_number, '$@#$%'), p_unit_number)
2546: AND ms.current_status =3
2547: and not exists (select w.status
2548: from mtl_material_transactions_temp t,
2549: wms_dispatched_tasks w
2550: where w.status = 4
2551: and w.task_type <> 2
2552: and w.transaction_temp_id = t.transaction_temp_id
2553: and (t.content_lpn_id = ms.lpn_id or