APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on DUAL

Line 900: FROM DUAL

896: BEGIN
897: --- check validity
898: SELECT 'failed'
899: INTO l_validity_check
900: FROM DUAL
901: WHERE EXISTS( SELECT subinventory_code
902: FROM wms_item_locations_kfv
903: WHERE concatenated_segments = p_concat_segs
904: AND p_sub_code <> subinventory_code

Line 949: FROM DUAL

945: BEGIN
946: --- check validity
947: SELECT 'failed'
948: INTO l_validity_check
949: FROM DUAL
950: WHERE EXISTS( SELECT subinventory_code
951: FROM mtl_item_locations_kfv
952: WHERE concatenated_segments = p_concat_segs
953: AND p_sub_code <> subinventory_code

Line 1655: FROM DUAL

1651: BEGIN
1652: /* Bug #1613379
1653: SELECT 1
1654: INTO loc_exists
1655: FROM DUAL
1656: WHERE exists (select 1
1657: FROM mtl_item_locations
1658: WHERE organization_id = p_organization_id
1659: AND subinventory_code = p_subinventory_code);

Line 2653: FROM dual

2649: BEGIN
2650: -- Check for invalid item control codes.
2651: SELECT 1
2652: INTO l_invalid_count
2653: FROM dual
2654: WHERE EXISTS (SELECT a.inventory_item_id
2655: FROM mtl_system_items a
2656: , mtl_system_items b
2657: WHERE a.inventory_item_id = b.inventory_item_id

Line 3058: FROM DUAL

3054: BEGIN
3055: BEGIN
3056: SELECT 'Y'
3057: INTO oth_val
3058: FROM DUAL
3059: WHERE EXISTS( SELECT wlpn.license_plate_number
3060: FROM wms_license_plate_numbers wlpn
3061: WHERE (wlpn.organization_id = p_org_id
3062: AND wlpn.lpn_context = 5

Line 3355: FROM DUAL

3351: , ''
3352: , 0
3353: , 1 dummy
3354: , 'N' enable_locator_alias
3355: FROM DUAL
3356: WHERE 'All Subinventories' LIKE (p_subinventory_code)
3357: ORDER BY dummy DESC, secondary_inventory_name;
3358: ELSE -- Organization_id is not null
3359: OPEN x_zones FOR

Line 3377: FROM DUAL

3373: , ''
3374: , 0
3375: , 1 dummy
3376: , 'N' enable_locator_alias
3377: FROM DUAL
3378: WHERE 'All Subinventories' LIKE (p_subinventory_code)
3379: ORDER BY dummy DESC, secondary_inventory_name;
3380: END IF;
3381:

Line 3406: FROM DUAL

3402: , 'All Locators'
3403: , ''
3404: , 1 dummy
3405: , ''
3406: FROM DUAL
3407: WHERE 'All Locators' LIKE (p_concatenated_segments)
3408: ORDER BY dummy DESC, concatenated_segments;
3409: END get_with_all_loc;
3410: