APPS.WSH_CARRIERS_GRP dependencies on FND_LOOKUP_VALUES_VL

Line 1568: FROM fnd_lookup_values_vl

1564:
1565:
1566: CURSOR Check_Ship_Method_Exists(p_ship_method_code VARCHAR2) IS
1567: SELECT count(*)
1568: FROM fnd_lookup_values_vl
1569: WHERE lookup_code = p_ship_method_code
1570: AND lookup_type = 'SHIP_METHOD';
1571:
1572:

Line 1576: FROM fnd_lookup_values_vl

1572:
1573:
1574: CURSOR Get_Ship_Method_By_Meaning(p_ship_method_meaning VARCHAR2) IS
1575: SELECT lookup_code
1576: FROM fnd_lookup_values_vl
1577: WHERE meaning = p_ship_method_meaning
1578: AND lookup_type = 'SHIP_METHOD';
1579:
1580:

Line 1623: FROM fnd_lookup_values_vl

1619: IF l_count > 0 THEN
1620:
1621: SELECT max(to_number(substr(lookup_code,1,6)))
1622: INTO l_maxnum
1623: FROM fnd_lookup_values_vl
1624: WHERE substr(lookup_code,7, length(lookup_code)) = substr(l_code,7,length(l_code))
1625: AND lookup_type = 'SHIP_METHOD';
1626:
1627: SELECT lpad(to_char(l_maxnum),6,'0') into l_code1 from dual;