APPS.OKS_AUTH_UTIL_PVT dependencies on OKX_UNITS_OF_MEASURE_V

Line 757: l_uom_desc OKx_UNITS_OF_MEASURE_v.unit_of_measure_tl%TYPE;

753:
754: rowcount NUMBER ;
755: l_display_name VARCHAR2(2000); -- 4915711 --
756: j NUMBER;
757: l_uom_desc OKx_UNITS_OF_MEASURE_v.unit_of_measure_tl%TYPE;
758:
759: CURSOR l_site_name_csr(l_install_site_id NUMBER) IS
760: SELECT S.DESCRIPTION
761: FROM OKX_PARTY_SITES_V S

Line 767: FROM OKX_UNITS_OF_MEASURE_V

763:
764: CURSOR l_csr_uom_desc(p_uom_code IN VARCHAR2)
765: IS
766: SELECT unit_of_measure_tl
767: FROM OKX_UNITS_OF_MEASURE_V
768: WHERE uom_code = p_uom_code ;
769:
770:
771: l_gen_name OKX_SYSTEM_ITEMS_V.name%TYPE;

Line 1496: l_uom_desc OKx_UNITS_OF_MEASURE_v.unit_of_measure_tl%TYPE;

1492: CONNECT BY PRIOR a.config_parent_id = a.customer_product_id;
1493:
1494: l_display_name VARCHAR2(2000); -- 4915711 --
1495: j NUMBER;
1496: l_uom_desc OKx_UNITS_OF_MEASURE_v.unit_of_measure_tl%TYPE;
1497: l_install_site_name VARCHAR2(1000);
1498:
1499: CURSOR l_site_name_csr(l_install_site_id NUMBER) IS
1500: SELECT S.DESCRIPTION

Line 1507: FROM OKX_UNITS_OF_MEASURE_V

1503:
1504: CURSOR l_csr_uom_desc(p_uom_code IN VARCHAR2)
1505: IS
1506: SELECT unit_of_measure_tl
1507: FROM OKX_UNITS_OF_MEASURE_V
1508: WHERE uom_code = p_uom_code ;
1509:
1510:
1511: l_gen_name OKX_SYSTEM_ITEMS_V.name%TYPE;