DBA Data[Home] [Help]

APPS.INV_TXN_VALIDATIONS dependencies on WMS_DISPATCHED_TASKS

Line 2154: from mtl_material_transactions_temp mmtt,wms_dispatched_tasks wdt

2150: EXIT WHEN c_lpn_content%NOTFOUND;
2151:
2152: select count(*)
2153: into l_cnt
2154: from mtl_material_transactions_temp mmtt,wms_dispatched_tasks wdt
2155: where mmtt.lpn_id = l_lpn_id
2156: and mmtt.transaction_temp_id = wdt.transaction_temp_id
2157: and wdt.status=4 -- Loaded task
2158: and mmtt.organization_id = p_org_id;