APPS.WMS_TASK_DISPATCH_ENGINE dependencies on WMS_EXPRESS_PICK_TASK

Line 5004: AND wms_express_pick_task.is_express_pick_task_eligible(wdtv.task_id) = 'S'

5000: AND wdtv.ZONE = sub.secondary_inventory_name
5001: AND wdtv.organization_id = sub.organization_id
5002: AND wdtv.move_order_line_id = mol.line_id(+) -- join task to MOL, outer join for tasks do not have MOL
5003: AND Nvl(wdtv.pick_slip_number, -1) <> l_opt_task_pick_slip -- bug 2832818
5004: AND wms_express_pick_task.is_express_pick_task_eligible(wdtv.task_id) = 'S'
5005: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
5006: (
5007: SELECT NULL
5008: FROM mtl_material_transactions_temp mmtt

Line 5310: AND wms_express_pick_task.is_express_pick_task_eligible(wdtv.task_id) = 'S'

5306: AND wdtv.locator_id = loc.inventory_location_id(+)
5307: AND wdtv.ZONE = sub.secondary_inventory_name
5308: AND wdtv.organization_id = sub.organization_id
5309: AND wdtv.move_order_line_id = mol.line_id(+) -- join task to MOL, outer join for tasks do not have MOL
5310: AND wms_express_pick_task.is_express_pick_task_eligible(wdtv.task_id) = 'S'
5311: AND Nvl(wdtv.pick_slip_number, -1) <> l_opt_task_pick_slip -- bug 2832818
5312: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
5313: (
5314: SELECT NULL

Line 5618: AND wms_express_pick_task.is_express_pick_task_eligible(wdtv.task_id) = 'S'

5614: AND wdtv.locator_id = loc.inventory_location_id(+)
5615: AND wdtv.ZONE = sub.secondary_inventory_name
5616: AND wdtv.organization_id = sub.organization_id
5617: AND wdtv.move_order_line_id = mol.line_id(+) -- join task to MOL, outer join for tasks do not have MOL
5618: AND wms_express_pick_task.is_express_pick_task_eligible(wdtv.task_id) = 'S'
5619: AND Nvl(wdtv.pick_slip_number, -1) <> l_opt_task_pick_slip -- bug 2832818
5620: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
5621: (
5622: SELECT NULL

Line 5921: AND wms_express_pick_task.is_express_pick_task_eligible(wdtv.task_id) = 'S'

5917: AND wdtv.locator_id = loc.inventory_location_id(+)
5918: AND wdtv.ZONE = sub.secondary_inventory_name
5919: AND wdtv.organization_id = sub.organization_id
5920: AND wdtv.move_order_line_id = mol.line_id(+) -- join task to MOL, outer join for tasks do not have MOL
5921: AND wms_express_pick_task.is_express_pick_task_eligible(wdtv.task_id) = 'S'
5922: AND Nvl(wdtv.pick_slip_number, -1) <> l_opt_task_pick_slip -- bug 2832818
5923: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
5924: (
5925: SELECT NULL

Line 6226: AND wms_express_pick_task.is_express_pick_task_eligible(wdtv.task_id) = 'S'

6222: AND wdtv.locator_id = loc.inventory_location_id(+)
6223: AND wdtv.ZONE = sub.secondary_inventory_name
6224: AND wdtv.organization_id = sub.organization_id
6225: AND wdtv.move_order_line_id = mol.line_id(+) -- join task to MOL, outer join for tasks do not have MOL
6226: AND wms_express_pick_task.is_express_pick_task_eligible(wdtv.task_id) = 'S'
6227: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
6228: (
6229: SELECT NULL
6230: FROM mtl_material_transactions_temp mmtt

Line 6525: AND wms_express_pick_task.is_express_pick_task_eligible(wdtv.task_id) = 'S'

6521: AND wdtv.locator_id = loc.inventory_location_id(+)
6522: AND wdtv.ZONE = sub.secondary_inventory_name
6523: AND wdtv.organization_id = sub.organization_id
6524: AND wdtv.move_order_line_id = mol.line_id(+) -- join task to MOL, outer join for tasks do not have MOL
6525: AND wms_express_pick_task.is_express_pick_task_eligible(wdtv.task_id) = 'S'
6526: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
6527: (
6528: SELECT NULL
6529: FROM mtl_material_transactions_temp mmtt

Line 7236: IF wms_express_pick_task.is_express_pick_task_eligible(l_opt_task_id) <> 'S' THEN

7232: -- bug 2648133
7233: /*
7234: IF l_is_express_pick = 1 THEN
7235:
7236: IF wms_express_pick_task.is_express_pick_task_eligible(l_opt_task_id) <> 'S' THEN
7237: EXIT;
7238: END IF;
7239:
7240: END IF;