APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKL_PROD_QLTY_VAL_UV

Line 3681: --dkagrawa changed query to use view okl_prod_qlty_val_uv than product_parameters_v for performance

3677:
3678: l_type VARCHAR2(1) := 'N';
3679: l_proc_name VARCHAR2(35) := 'CHECK_PRODUCT_TYPE';
3680:
3681: --dkagrawa changed query to use view okl_prod_qlty_val_uv than product_parameters_v for performance
3682: CURSOR prod_type_csr(p_product_name okl_products_v.name%TYPE,
3683: p_product_id okl_products_v.id%TYPE) IS
3684: SELECT 'Y'
3685: FROM okl_products prod,

Line 3686: okl_prod_qlty_val_uv pqv

3682: CURSOR prod_type_csr(p_product_name okl_products_v.name%TYPE,
3683: p_product_id okl_products_v.id%TYPE) IS
3684: SELECT 'Y'
3685: FROM okl_products prod,
3686: okl_prod_qlty_val_uv pqv
3687: WHERE ((prod.name = p_product_name
3688: AND
3689: p_product_name IS NOT NULL
3690: )