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_BILL_UPFRONT_TAX_PVT dependencies on OKL_INVOICE_FORMATS_V

Line 197: --, okl_invoice_formats_v inf --sechawla 26-may-09 6826580

193: SELECT to_number(rul.rule_information1), -- inf.id, --sechawla 26-may-09 6826580
194: rul.rule_information4 review_invoice_yn
195: FROM okc_rule_groups_v rgp,
196: okc_rules_v rul
197: --, okl_invoice_formats_v inf --sechawla 26-may-09 6826580
198: WHERE rgp.dnz_chr_id = cp_khr_id
199: AND rgp.chr_id = rgp.dnz_chr_id
200: AND rgp.id = rul.rgp_id
201: AND rgp.cle_id IS NULL

Line 206: l_inf_id okl_invoice_formats_v.id%TYPE;

202: AND rgp.rgd_code = 'LABILL'
203: AND rul.rule_information_category = 'LAINVD';
204: -- AND rul.rule_information1 = inf.name; --sechawla 26-may-09 6826580
205:
206: l_inf_id okl_invoice_formats_v.id%TYPE;
207:
208: CURSOR pvt_label_csr(cp_khr_id IN NUMBER) IS
209: SELECT rule_information1 private_label
210: FROM okc_rule_groups_b a,

Line 756: --, okl_invoice_formats_v inf --sechawla 26-may-09 6826580

752: SELECT to_number(rul.rule_information1), --inf.id, --sechawla 26-may-09 6826580
753: rul.rule_information4 review_invoice_yn
754: FROM okc_rule_groups_v rgp,
755: okc_rules_v rul
756: --, okl_invoice_formats_v inf --sechawla 26-may-09 6826580
757: WHERE rgp.dnz_chr_id = cp_khr_id
758: AND rgp.chr_id = rgp.dnz_chr_id
759: AND rgp.id = rul.rgp_id
760: AND rgp.cle_id IS NULL