APPS.WMS_TASK_DISPATCH_ENGINE dependencies on WMS_EXPRESS_PICK_TASK

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

4661: AND wdtv.ZONE = sub.secondary_inventory_name
4662: AND wdtv.organization_id = sub.organization_id
4663: AND wdtv.move_order_line_id = mol.line_id(+) -- join task to MOL, outer join for tasks do not have MOL
4664: AND Nvl(wdtv.pick_slip_number, -1) <> l_opt_task_pick_slip -- bug 2832818
4665: AND wms_express_pick_task.is_express_pick_task_eligible(wdtv.task_id) = 'S'
4666: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
4667: (
4668: SELECT NULL
4669: FROM mtl_material_transactions_temp mmtt

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

4967: AND wdtv.locator_id = loc.inventory_location_id(+)
4968: AND wdtv.ZONE = sub.secondary_inventory_name
4969: AND wdtv.organization_id = sub.organization_id
4970: AND wdtv.move_order_line_id = mol.line_id(+) -- join task to MOL, outer join for tasks do not have MOL
4971: AND wms_express_pick_task.is_express_pick_task_eligible(wdtv.task_id) = 'S'
4972: AND Nvl(wdtv.pick_slip_number, -1) <> l_opt_task_pick_slip -- bug 2832818
4973: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
4974: (
4975: SELECT NULL

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

5275: AND wdtv.locator_id = loc.inventory_location_id(+)
5276: AND wdtv.ZONE = sub.secondary_inventory_name
5277: AND wdtv.organization_id = sub.organization_id
5278: AND wdtv.move_order_line_id = mol.line_id(+) -- join task to MOL, outer join for tasks do not have MOL
5279: AND wms_express_pick_task.is_express_pick_task_eligible(wdtv.task_id) = 'S'
5280: AND Nvl(wdtv.pick_slip_number, -1) <> l_opt_task_pick_slip -- bug 2832818
5281: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
5282: (
5283: SELECT NULL

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

5578: AND wdtv.locator_id = loc.inventory_location_id(+)
5579: AND wdtv.ZONE = sub.secondary_inventory_name
5580: AND wdtv.organization_id = sub.organization_id
5581: AND wdtv.move_order_line_id = mol.line_id(+) -- join task to MOL, outer join for tasks do not have MOL
5582: AND wms_express_pick_task.is_express_pick_task_eligible(wdtv.task_id) = 'S'
5583: AND Nvl(wdtv.pick_slip_number, -1) <> l_opt_task_pick_slip -- bug 2832818
5584: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
5585: (
5586: SELECT NULL

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

5883: AND wdtv.locator_id = loc.inventory_location_id(+)
5884: AND wdtv.ZONE = sub.secondary_inventory_name
5885: AND wdtv.organization_id = sub.organization_id
5886: AND wdtv.move_order_line_id = mol.line_id(+) -- join task to MOL, outer join for tasks do not have MOL
5887: AND wms_express_pick_task.is_express_pick_task_eligible(wdtv.task_id) = 'S'
5888: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
5889: (
5890: SELECT NULL
5891: FROM mtl_material_transactions_temp mmtt

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

6182: AND wdtv.locator_id = loc.inventory_location_id(+)
6183: AND wdtv.ZONE = sub.secondary_inventory_name
6184: AND wdtv.organization_id = sub.organization_id
6185: AND wdtv.move_order_line_id = mol.line_id(+) -- join task to MOL, outer join for tasks do not have MOL
6186: AND wms_express_pick_task.is_express_pick_task_eligible(wdtv.task_id) = 'S'
6187: AND NOT EXISTS -- exclude child tasks for consolidated bulk tasks
6188: (
6189: SELECT NULL
6190: FROM mtl_material_transactions_temp mmtt

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

6893: -- bug 2648133
6894: /*
6895: IF l_is_express_pick = 1 THEN
6896:
6897: IF wms_express_pick_task.is_express_pick_task_eligible(l_opt_task_id) <> 'S' THEN
6898: EXIT;
6899: END IF;
6900:
6901: END IF;