APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on DUAL

Line 1237: FROM DUAL

1233: BEGIN
1234: --- check validity
1235: SELECT 'failed'
1236: INTO l_validity_check
1237: FROM DUAL
1238: WHERE EXISTS( SELECT subinventory_code
1239: FROM wms_item_locations_kfv
1240: WHERE concatenated_segments = p_concat_segs
1241: AND p_sub_code <> subinventory_code

Line 1286: FROM DUAL

1282: BEGIN
1283: --- check validity
1284: SELECT 'failed'
1285: INTO l_validity_check
1286: FROM DUAL
1287: WHERE EXISTS( SELECT subinventory_code
1288: FROM mtl_item_locations_kfv
1289: WHERE concatenated_segments = p_concat_segs
1290: AND p_sub_code <> subinventory_code

Line 2030: FROM DUAL

2026: BEGIN
2027: /* Bug #1613379
2028: SELECT 1
2029: INTO loc_exists
2030: FROM DUAL
2031: WHERE exists (select 1
2032: FROM mtl_item_locations
2033: WHERE organization_id = p_organization_id
2034: AND subinventory_code = p_subinventory_code);

Line 3030: FROM dual

3026: BEGIN
3027: -- Check for invalid item control codes.
3028: SELECT 1
3029: INTO l_invalid_count
3030: FROM dual
3031: WHERE EXISTS (SELECT a.inventory_item_id
3032: FROM mtl_system_items a
3033: , mtl_system_items b
3034: WHERE a.inventory_item_id = b.inventory_item_id

Line 3453: FROM DUAL

3449: BEGIN
3450: BEGIN
3451: SELECT 'Y'
3452: INTO oth_val
3453: FROM DUAL
3454: WHERE EXISTS( SELECT wlpn.license_plate_number
3455: FROM wms_license_plate_numbers wlpn
3456: WHERE (wlpn.organization_id = p_org_id
3457: AND wlpn.lpn_context = 5

Line 3754: FROM DUAL

3750: , ''
3751: , 0
3752: , 1 dummy
3753: , 'N' enable_locator_alias
3754: FROM DUAL
3755: WHERE 'All Subinventories' LIKE (p_subinventory_code)
3756: ORDER BY dummy DESC, secondary_inventory_name;
3757: ELSE -- Organization_id is not null
3758: OPEN x_zones FOR

Line 3776: FROM DUAL

3772: , ''
3773: , 0
3774: , 1 dummy
3775: , 'N' enable_locator_alias
3776: FROM DUAL
3777: WHERE 'All Subinventories' LIKE (p_subinventory_code)
3778: ORDER BY dummy DESC, secondary_inventory_name;
3779: END IF;
3780:

Line 3806: FROM DUAL

3802: , 'All Locators'
3803: , ''
3804: , 1 dummy
3805: , ''
3806: FROM DUAL
3807: WHERE 'All Locators' LIKE (p_concatenated_segments)
3808: ORDER BY dummy DESC, concatenated_segments;
3809: END get_with_all_loc;
3810:

Line 7094: from dual;*/

7090: AND ID_FLEX_NUM = '101';
7091:
7092: /*SELECT LENGTH(REGEXP_REPLACE(L_LOCATOR, '[^[:punct:]]')) / LENGTH(L_Delimiter)
7093: into no_of_delimiters
7094: from dual;*/
7095:
7096: Select (Length(L_Locator) - Length(Replace(L_Locator, L_Delimiter)))
7097: into no_of_delimiters
7098: From Dual;

Line 7098: From Dual;

7094: from dual;*/
7095:
7096: Select (Length(L_Locator) - Length(Replace(L_Locator, L_Delimiter)))
7097: into no_of_delimiters
7098: From Dual;
7099:
7100: IF L_SEGMENT_COUNT <> NO_OF_DELIMITERS+1
7101: THEN
7102: P_LOC_EXISTS := 'Y'; --This will throw error in LocatorKFF.java page because delimiters are not same as number of segment passed.

Line 7109: FROM DUAL;

7105: FOR C1REC IN C1 LOOP
7106:
7107: SELECT INSTR(L_LOCATOR,L_DELIMITER )
7108: INTO L_DEL_POS
7109: FROM DUAL;
7110:
7111: IF L_DEL_POS <> 0
7112: THEN
7113: IF L_DEL_POS = 1 THEN

Line 7117: FROM DUAL;

7113: IF L_DEL_POS = 1 THEN
7114: L_WHERE_CLAUSE := L_WHERE_CLAUSE || C1REC.APPLICATION_COLUMN_NAME||' is null ';
7115: SELECT SUBSTR(L_LOCATOR,L_DEL_POS+1)
7116: INTO L_LOCATOR
7117: FROM DUAL;
7118: IF L_LOCATOR IS NOT NULL THEN
7119: L_WHERE_CLAUSE := L_WHERE_CLAUSE ||' and ' ;
7120: end if;
7121: else

Line 7124: FROM DUAL;

7120: end if;
7121: else
7122: SELECT SUBSTR(L_LOCATOR,1,L_DEL_POS-1) , SUBSTR(L_LOCATOR,L_DEL_POS+1)
7123: INTO L_SEGMENT , L_LOCATOR
7124: FROM DUAL;
7125:
7126: L_WHERE_CLAUSE := L_WHERE_CLAUSE || C1REC.APPLICATION_COLUMN_NAME||' = '|| ''''||L_SEGMENT ||''''|| ' and ';
7127: end if;
7128: ELSE