eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SETUPPMVALUES_PVT dependencies on OKL_PRODUCTS

Line 139: okl_products pdtv,

135:
136: CURSOR okl_pmvv_chk_csr(p_ptl_id NUMBER
137: ) IS
138: SELECT '1' FROM okl_pdt_templates_v ptvv,
139: okl_products pdtv,
140: okl_k_headers_v khdr
141: WHERE ptvv.id = p_ptl_id
142: AND ptvv.id = pdtv.ptl_id
143: AND pdtv.id = khdr.pdt_id;

Line 145: CURSOR okl_pmv_ptl_fk_csr (p_ptl_id IN Okl_Products_V.ID%TYPE,

141: WHERE ptvv.id = p_ptl_id
142: AND ptvv.id = pdtv.ptl_id
143: AND pdtv.id = khdr.pdt_id;
144:
145: CURSOR okl_pmv_ptl_fk_csr (p_ptl_id IN Okl_Products_V.ID%TYPE,
146: p_date IN Okl_Products_V.TO_DATE%TYPE
147: ) IS
148: SELECT '1'
149: FROM Okl_pdt_templates_V ptl

Line 146: p_date IN Okl_Products_V.TO_DATE%TYPE

142: AND ptvv.id = pdtv.ptl_id
143: AND pdtv.id = khdr.pdt_id;
144:
145: CURSOR okl_pmv_ptl_fk_csr (p_ptl_id IN Okl_Products_V.ID%TYPE,
146: p_date IN Okl_Products_V.TO_DATE%TYPE
147: ) IS
148: SELECT '1'
149: FROM Okl_pdt_templates_V ptl
150: WHERE ptl.ID = p_ptl_id