APPS.WMS_XDOCK_PEGGING_PUB dependencies on DUAL

Line 407: FROM dual

403: -- Test for an OE demand input that is tied to a WIP supply and one that is not. }}
404: BEGIN
405: SELECT 1
406: INTO l_wip_exists
407: FROM dual
408: WHERE EXISTS (SELECT reservation_id
409: FROM mtl_reservations
410: WHERE organization_id = p_organization_id
411: AND inventory_item_id = p_inventory_item_id

Line 461: FROM dual

457: -- and one that is not. }}
458: BEGIN
459: SELECT 1
460: INTO l_non_wip_exists
461: FROM dual
462: WHERE EXISTS (SELECT reservation_id
463: FROM mtl_reservations
464: WHERE organization_id = p_organization_id
465: AND inventory_item_id = p_inventory_item_id

Line 2988: IF(NVL(OE_DUAL_UOM_UTIL.get_fulfillment_base(p_wsh_release_table(l_wdd_index).source_line_id),'P') = 'S') THEN

2984: l_primary_uom_code := l_item_params_tb(l_inventory_item_id).primary_uom_code;
2985:
2986: --16509516 and 16466246
2987: --For Order Lines Fulfilled by Secondary UoM, do not consider them to XDock
2988: IF(NVL(OE_DUAL_UOM_UTIL.get_fulfillment_base(p_wsh_release_table(l_wdd_index).source_line_id),'P') = 'S') THEN
2989: IF (l_debug = 1) THEN
2990: print_debug('Do not crossdock FB=S Lines, Order Line: '||p_wsh_release_table(l_wdd_index).source_line_id);
2991: print_debug('Skip this Delivery Detail, WDD: '||p_wsh_release_table(l_wdd_index).delivery_detail_id);
2992: END IF;