DBA Data[Home] [Help]

APPS.WMS_WAVEPLAN_TASKS_PVT dependencies on MTL_MOBILE_LOGIN_HIST

Line 11134: EXISTS ( SELECT 1 FROM MTL_MOBILE_LOGIN_HIST MMLH, WMS_DISPATCHED_TASKS WDT

11130: BULK COLLECT INTO l_transaction_temp_ids, l_task_type_ids, l_statuses
11131: FROM wms_waveplan_tasks_temp wwtt
11132: WHERE RESULT = 'X' AND
11133: status_id = 9 AND
11134: EXISTS ( SELECT 1 FROM MTL_MOBILE_LOGIN_HIST MMLH, WMS_DISPATCHED_TASKS WDT
11135: WHERE WDT.TRANSACTION_TEMP_ID = WWTT.TRANSACTION_TEMP_ID AND
11136: MMLH.USER_ID = WDT.LAST_UPDATED_BY AND
11137: MMLH.LOGOFF_DATE IS NULL AND
11138: MMLH.EVENT_MESSAGE IS NULL