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.

[Home] [Help]

APPS.OKL_LA_SALES_TAX_PVT dependencies on OKC_RULE_GROUPS_V

Line 280: OKC_RULE_GROUPS_V rgp

276: CURSOR get_contract_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS
277: SELECT rul.rule_information1, rul.rule_information3, rul.rule_information4,
278: rul.rule_information5, rul.rule_information6, rul.rule_information7
279: FROM OKC_RULES_V rul,
280: OKC_RULE_GROUPS_V rgp
281: WHERE rul.rgp_id = rgp.id
282: AND rgp.dnz_chr_id = p_chr_id
283: AND rgp.cle_id is NULL
284: AND rgp.rgd_code = 'LAHDTX'

Line 290: OKC_RULE_GROUPS_V rgp

286:
287: CURSOR l_hdr_upfront_tax(p_chr_id okc_k_headers_b.id%TYPE) IS
288: SELECT rul.rule_information1
289: FROM OKC_RULES_V rul,
290: OKC_RULE_GROUPS_V rgp
291: WHERE rul.rgp_id = rgp.id
292: AND rgp.dnz_chr_id = p_chr_id
293: AND rgp.cle_id is NULL
294: AND rgp.rgd_code = 'LAHDTX'

Line 554: OKC_RULE_GROUPS_V rgp

550: CURSOR get_contract_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE) IS
551: SELECT rul.rule_information1, rul.rule_information3, rul.rule_information4,
552: rul.rule_information5, rul.rule_information6, rul.rule_information7
553: FROM OKC_RULES_V rul,
554: OKC_RULE_GROUPS_V rgp
555: WHERE rul.rgp_id = rgp.id
556: AND rgp.dnz_chr_id = p_chr_id
557: AND rgp.cle_id is NULL
558: AND rgp.rgd_code = 'LAHDTX'

Line 581: OKC_RULE_GROUPS_V rgp,

577: CURSOR get_asset_sales_tax_info(p_chr_id okc_k_headers_b.id%TYPE,
578: p_cle_id okc_k_lines_v.id%TYPE) IS
579: SELECT rul.id, rul.rule_information5, cle.ORIG_SYSTEM_ID1
580: FROM OKC_RULES_V rul,
581: OKC_RULE_GROUPS_V rgp,
582: okc_k_lines_b cle
583: WHERE rul.rgp_id = rgp.id
584: AND rgp.dnz_chr_id = p_chr_id
585: AND rgp.cle_id = p_cle_id

Line 595: OKC_RULE_GROUPS_V rgp

591: CURSOR get_sales_tax_prc_info(p_chr_id okc_k_headers_b.id%TYPE) IS
592: SELECT rul.rule_information1, rul.rule_information2,
593: rul.rule_information3, rul.rule_information4, rul.rule_information4
594: FROM OKC_RULES_V rul,
595: OKC_RULE_GROUPS_V rgp
596: WHERE rul.rgp_id = rgp.id
597: AND rgp.dnz_chr_id = p_chr_id
598: AND rgp.cle_id is NULL
599: AND rgp.rgd_code = 'LAHDTX'

Line 3218: , OKC_RULE_GROUPS_V rgp

3214: , txs.id tax_header_id
3215: , txl.tax_line_id tax_line_id
3216: , txl.tax_amt tax_amount
3217: FROM OKC_RULES_V rul
3218: , OKC_RULE_GROUPS_V rgp
3219: , okl_tax_sources txs
3220: , zx_lines txl
3221: WHERE rul.rgp_id = rgp.id
3222: AND rgp.dnz_chr_id = p_contract_id

Line 3256: , OKC_RULE_GROUPS_V rgp

3252: , txs.id tax_header_id
3253: , txl.tax_line_id tax_line_id
3254: , txl.tax_amt tax_amount
3255: FROM OKC_RULES_V rul
3256: , OKC_RULE_GROUPS_V rgp
3257: , okl_tax_sources txs
3258: , zx_lines txl
3259: WHERE rul.rgp_id = rgp.id
3260: AND rgp.dnz_chr_id = p_contract_id

Line 3292: , OKC_RULE_GROUPS_V rgp

3288: , txs.id tax_header_id
3289: , txl.tax_line_id tax_line_id
3290: , txl.tax_amt tax_amount
3291: FROM OKC_RULES_V rul
3292: , OKC_RULE_GROUPS_V rgp
3293: , okl_tax_sources txs
3294: , zx_lines txl
3295: WHERE rul.rgp_id = rgp.id
3296: AND rgp.dnz_chr_id = p_contract_id

Line 3375: , OKC_RULE_GROUPS_V rgp

3371: , txs.id tax_header_id
3372: , txl.tax_line_id tax_line_id
3373: , txl.tax_amt tax_amount
3374: FROM OKC_RULES_V rul
3375: , OKC_RULE_GROUPS_V rgp
3376: , okl_tax_sources txs
3377: , zx_lines txl
3378: WHERE rul.rgp_id = rgp.id
3379: AND rgp.dnz_chr_id = p_contract_id

Line 3422: , OKC_RULE_GROUPS_V rgp

3418: , txs.id tax_header_id
3419: , txl.tax_line_id tax_line_id
3420: , txl.tax_amt tax_amount
3421: FROM OKC_RULES_V rul
3422: , OKC_RULE_GROUPS_V rgp
3423: , okl_tax_sources txs
3424: , zx_lines txl
3425: WHERE rul.rgp_id = rgp.id
3426: AND rgp.dnz_chr_id = p_contract_id

Line 3467: , OKC_RULE_GROUPS_V rgp

3463: , txs.id tax_header_id
3464: , txl.tax_line_id tax_line_id
3465: , txl.tax_amt tax_amount
3466: FROM OKC_RULES_V rul
3467: , OKC_RULE_GROUPS_V rgp
3468: , okl_tax_sources txs
3469: , zx_lines txl
3470: WHERE rul.rgp_id = rgp.id
3471: AND rgp.dnz_chr_id = p_contract_id