APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKL_PROD_QLTY_VAL_UV

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

3845:
3846: l_type VARCHAR2(1) := 'N';
3847: l_proc_name VARCHAR2(35) := 'CHECK_PRODUCT_TYPE';
3848:
3849: --dkagrawa changed query to use view okl_prod_qlty_val_uv than product_parameters_v for performance
3850: CURSOR prod_type_csr(p_product_name okl_products_v.name%TYPE,
3851: p_product_id okl_products_v.id%TYPE) IS
3852: SELECT 'Y'
3853: FROM okl_products prod,

Line 3854: okl_prod_qlty_val_uv pqv

3850: CURSOR prod_type_csr(p_product_name okl_products_v.name%TYPE,
3851: p_product_id okl_products_v.id%TYPE) IS
3852: SELECT 'Y'
3853: FROM okl_products prod,
3854: okl_prod_qlty_val_uv pqv
3855: WHERE ((prod.name = p_product_name
3856: AND
3857: p_product_name IS NOT NULL
3858: )