eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_TASK_DISPATCH_GEN dependencies on WMS_EXPRESS_PICK_TASK

Line 342: AND wms_express_pick_task.is_express_pick_task(task_id) = 'S'

338: FROM wms_dispatched_tasks wdt
339: WHERE wdt.person_id = l_user_id
340: AND wdt.organization_id = l_org_id
341: AND wdt.task_type IN(1, 3, 4, 5, 6)
342: AND wms_express_pick_task.is_express_pick_task(task_id) = 'S'
343: AND wdt.status <= 3
344: AND ((wdt.task_type = 3
345: AND exists
346: (SELECT NVL(cycle_count_entry_id,-1)

Line 430: AND WMS_EXPRESS_PICK_TASK.IS_EXPRESS_PICK_TASK(wdt.TASK_ID) = 'S'

426: WHERE wdt.person_id = l_user_id
427: AND wdt.organization_id = l_org_id
428: AND wdt.status <= 3
429: AND wdt.task_type IN (1, 4, 5, 6)
430: AND WMS_EXPRESS_PICK_TASK.IS_EXPRESS_PICK_TASK(wdt.TASK_ID) = 'S'
431: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
432: AND mmtt.subinventory_code = nvl(p_sign_on_zone,mmtt.subinventory_code) --Added bug3771517
433: AND sub.organization_id = mmtt.organization_id
434: AND sub.secondary_inventory_name = mmtt.subinventory_code

Line 450: AND WMS_EXPRESS_PICK_TASK.IS_EXPRESS_PICK_TASK(wdt.TASK_ID) = 'S'

446: WHERE wdt.person_id = l_user_id
447: AND wdt.organization_id = l_org_id
448: AND wdt.status <= 3
449: AND wdt.task_type = 3
450: AND WMS_EXPRESS_PICK_TASK.IS_EXPRESS_PICK_TASK(wdt.TASK_ID) = 'S'
451: AND wdt.transaction_temp_id = mcce.cycle_count_entry_id
452: AND sub.organization_id = mcce.organization_id
453: AND mcce.subinventory = nvl(p_sign_on_zone,mcce.subinventory) --Added bug3771517
454: AND sub.secondary_inventory_name = mcce.subinventory