APPS.WMS_TASK_MGMT_PUB dependencies on MTL_MOBILE_LOGIN_HIST

Line 619: FROM MTL_MOBILE_LOGIN_HIST MMLH,

615: WHERE wdt1.status = 9
616: AND wdt1.TRANSACTION_TEMP_ID =p_task_rec.TRANSACTION_NUMBER
617: AND EXISTS
618: (SELECT 1
619: FROM MTL_MOBILE_LOGIN_HIST MMLH,
620: WMS_DISPATCHED_TASKS wdt
621: WHERE wdt1.TRANSACTION_TEMP_ID = wdt.TRANSACTION_TEMP_ID
622: AND MMLH.USER_ID = wdt1.LAST_UPDATED_BY
623: AND MMLH.LOGOFF_DATE IS NULL