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_LA_SALES_TAX_PVT dependencies on OKC_RULE_GROUPS_B

Line 58: okc_rule_groups_b rgp,

54: CURSOR check_feetype_csr (p_contract_id IN NUMBER)
55: IS
56: SELECT NVL(rule_information11,'BILLED') feetype
57: FROM okc_rules_b rl,
58: okc_rule_groups_b rgp,
59: okc_k_lines_b cle
60: WHERE rl.dnz_chr_id = p_contract_id
61: AND rl.rule_information_category = 'LAASTX'
62: AND NVL(rule_information11,'BILLED') <> 'BILLED'

Line 90: okc_rule_groups_b rgp,

86: CURSOR check_lines_csr (p_contract_id IN NUMBER, l_fee_type IN VARCHAR2 )
87: IS
88: SELECT count(NVL(rule_information11, l_fee_type))
89: FROM okc_rules_b rl,
90: okc_rule_groups_b rgp,
91: okc_k_lines_b cle
92: WHERE rl.dnz_chr_id = p_contract_id
93: AND rl.rule_information_category = 'LAASTX'
94: AND NVL(rule_information11, l_fee_type) = l_fee_type

Line 107: okc_rule_groups_b rg1,

103: CURSOR get_fee_amt_csr1(p_contract_id IN NUMBER, p_feetype IN VARCHAR2)
104: IS
105: SELECT NVL(SUM(NVL(TOTAL_TAX,0)),0)
106: FROM okl_tax_sources txs,
107: okc_rule_groups_b rg1,
108: okc_rules_b rl1,
109: okc_rule_groups_b rg2,
110: okc_rules_b rl2,
111: okc_k_lines_b cle

Line 109: okc_rule_groups_b rg2,

105: SELECT NVL(SUM(NVL(TOTAL_TAX,0)),0)
106: FROM okl_tax_sources txs,
107: okc_rule_groups_b rg1,
108: okc_rules_b rl1,
109: okc_rule_groups_b rg2,
110: okc_rules_b rl2,
111: okc_k_lines_b cle
112: WHERE txs.KHR_ID = p_contract_id
113: AND txs.khr_id = rg1.dnz_chr_id

Line 141: ,okc_rule_groups_b rg1

137: CURSOR get_fee_amt_csr2 (p_contract_id IN NUMBER, p_feetype IN VARCHAR2)
138: IS
139: SELECT NVL(SUM(NVL(TOTAL_TAX,0)),0)
140: FROM okl_tax_sources txs
141: ,okc_rule_groups_b rg1
142: ,okc_rules_b rl1
143: ,okc_k_lines_b cle
144: WHERE txs.KHR_ID = p_Contract_id
145: AND txs.khr_id = rg1.dnz_chr_id

Line 167: okc_rule_groups_b rg1,

163: CURSOR billing_required_csr1(p_contract_id IN NUMBER,
164: p_transaction_id IN NUMBER) IS
165: SELECT 1
166: FROM okl_tax_sources txs,
167: okc_rule_groups_b rg1,
168: okc_rules_b rl1,
169: okc_k_lines_b cle
170: WHERE txs.khr_id = p_contract_id
171: AND txs.trx_id = p_transaction_id

Line 195: okc_rule_groups_b rg1,

191: CURSOR billing_required_csr2(p_contract_id IN NUMBER,
192: p_transaction_id IN NUMBER) IS
193: SELECT 1
194: FROM okl_tax_sources txs,
195: okc_rule_groups_b rg1,
196: okc_rules_b rl1,
197: okc_k_lines_b cle
198: WHERE txs.khr_id = p_contract_id
199: AND txs.trx_id = p_transaction_id

Line 300: FROM OKC_RULE_GROUPS_B rgp

296:
297: CURSOR l_asset_tax_rule_group(p_chr_id okc_k_headers_b.id%TYPE,
298: p_cle_id NUMBER) IS -- 5179119
299: SELECT id
300: FROM OKC_RULE_GROUPS_B rgp
301: WHERE rgp.dnz_chr_id = p_chr_id
302: AND rgp.cle_id is NOT NULL
303: AND rgp.rgd_code = 'LAASTX'
304: AND rgp.cle_id = p_cle_id; -- 5179119

Line 1467: okc_rule_groups_b rg1,

1463: CURSOR get_asset_csr1 (p_fee_type IN VARCHAR2)
1464: IS
1465: SELECT cle.id, cle.name, cle.item_description
1466: FROM okc_k_lines_v cle,
1467: okc_rule_groups_b rg1,
1468: okc_rules_b rl1,
1469: okc_line_styles_b lse,
1470: okc_rule_groups_b rg2,
1471: okc_rules_b rl2

Line 1470: okc_rule_groups_b rg2,

1466: FROM okc_k_lines_v cle,
1467: okc_rule_groups_b rg1,
1468: okc_rules_b rl1,
1469: okc_line_styles_b lse,
1470: okc_rule_groups_b rg2,
1471: okc_rules_b rl2
1472: WHERE cle.chr_ID = p_contract_id
1473: AND cle.lse_id = lse.id
1474: AND lse.lty_code = 'FREE_FORM1'

Line 1499: okc_rule_groups_b rg1,

1495: CURSOR get_asset_csr2 (p_fee_type IN VARCHAR2)
1496: IS
1497: SELECT cle.id, cle.name, cle.item_description
1498: FROM okc_k_lines_v cle,
1499: okc_rule_groups_b rg1,
1500: okc_rules_b rl1,
1501: okc_line_styles_b lse
1502: WHERE cle.dnz_chr_id = p_contract_id
1503: AND cle.lse_id = lse.id

Line 1574: FROM okc_rule_groups_b rgp_lafexp,

1570: rul_lafexp.rgp_id,
1571: rul_lafexp.dnz_chr_id,
1572: rul_lafexp.rule_information_category,
1573: TO_NUMBER(rul_lafexp.rule_information2) amount
1574: FROM okc_rule_groups_b rgp_lafexp,
1575: okc_rules_b rul_lafexp
1576: WHERE rgp_lafexp.dnz_chr_id = p_chr_id
1577: AND rgp_lafexp.cle_id = p_fee_cle_id
1578: AND rgp_lafexp.rgd_code = 'LAFEXP'

Line 1609: okc_rule_groups_b rgp,

1605: cim_cov_asset.id cim_cov_asset_id
1606: FROM okc_k_lines_b cleb_cov_asset,
1607: okc_k_items cim_cov_asset,
1608: okc_k_lines_b cleb_fin,
1609: okc_rule_groups_b rgp,
1610: okc_rules_b rul
1611: WHERE cleb_cov_asset.cle_id = p_fee_cle_id
1612: AND cleb_cov_asset.dnz_chr_id = p_chr_id
1613: AND cim_cov_asset.cle_id = cleb_cov_asset.id

Line 1637: okc_rule_groups_b rgp,

1633: cim_cov_asset.id cim_cov_asset_id
1634: FROM okc_k_lines_b cleb_cov_asset,
1635: okc_k_items cim_cov_asset,
1636: okc_k_lines_b cleb_fin,
1637: okc_rule_groups_b rgp,
1638: okc_rules_b rul
1639: WHERE cleb_cov_asset.cle_id = p_fee_cle_id
1640: AND cleb_cov_asset.dnz_chr_id = p_chr_id
1641: AND cim_cov_asset.cle_id = cleb_cov_asset.id

Line 2361: okc_rule_groups_b rg1,

2357: CURSOR get_asset_csr1 (p_fee_type IN VARCHAR2)
2358: IS
2359: SELECT cle.id, cle.name, cle.item_description
2360: FROM okc_k_lines_v cle,
2361: okc_rule_groups_b rg1,
2362: okc_rules_b rl1,
2363: okc_line_styles_b lse,
2364: okc_rule_groups_b rg2,
2365: okc_rules_b rl2

Line 2364: okc_rule_groups_b rg2,

2360: FROM okc_k_lines_v cle,
2361: okc_rule_groups_b rg1,
2362: okc_rules_b rl1,
2363: okc_line_styles_b lse,
2364: okc_rule_groups_b rg2,
2365: okc_rules_b rl2
2366: WHERE cle.chr_ID = p_contract_id
2367: AND cle.lse_id = lse.id
2368: AND lse.lty_code = 'FREE_FORM1'

Line 2394: okc_rule_groups_b rg1,

2390: CURSOR get_asset_csr2 (p_fee_type IN VARCHAR2)
2391: IS
2392: SELECT cle.id, cle.name, cle.item_description
2393: FROM okc_k_lines_v cle,
2394: okc_rule_groups_b rg1,
2395: okc_rules_b rl1,
2396: okc_line_styles_b lse
2397: WHERE cle.dnz_chr_ID = p_contract_id
2398: AND cle.lse_id = lse.id

Line 5657: cursor l_hdrrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

5653: FROM okc_k_headers_b
5654: WHERE id = p_chr_id;
5655: l_authoring_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;
5656:
5657: cursor l_hdrrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
5658: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
5659: chrId NUMBER) IS
5660: select crl.object1_id1,
5661: crl.RULE_INFORMATION1,

Line 5670: from OKC_RULE_GROUPS_B crg,

5666: crl.RULE_INFORMATION6,
5667: crl.RULE_INFORMATION7,
5668: crl.RULE_INFORMATION10,
5669: crl.RULE_INFORMATION11
5670: from OKC_RULE_GROUPS_B crg,
5671: OKC_RULES_B crl
5672: where crl.rgp_id = crg.id
5673: and crg.RGD_CODE = rgcode
5674: and crl.RULE_INFORMATION_CATEGORY = rlcat

Line 5678: cursor l_rl_csr1( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,

5674: and crl.RULE_INFORMATION_CATEGORY = rlcat
5675: and crg.dnz_chr_id = chrId;
5676:
5677:
5678: cursor l_rl_csr1( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
5679: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
5680: chrId NUMBER,
5681: cleId NUMBER ) IS
5682: select crl.id slh_id,

Line 5692: from OKC_RULE_GROUPS_B crg,

5688: crl.RULE_INFORMATION6,
5689: crl.RULE_INFORMATION7,
5690: crl.RULE_INFORMATION8,
5691: crl.RULE_INFORMATION10
5692: from OKC_RULE_GROUPS_B crg,
5693: OKC_RULES_B crl
5694: where crl.rgp_id = crg.id
5695: and crg.RGD_CODE = rgcode
5696: and crl.RULE_INFORMATION_CATEGORY = rlcat

Line 5768: FROM OKC_RULE_GROUPS_B crg,

5764: CURSOR l_asset_tax_rule_csr(p_cleId OKC_K_LINES_B.ID%TYPE) IS
5765: SELECT crl.id slh_id,
5766: crl.object1_id1,
5767: crl.RULE_INFORMATION11
5768: FROM OKC_RULE_GROUPS_B crg,
5769: OKC_RULES_B crl
5770: WHERE crl.rgp_id = crg.id
5771: AND crg.RGD_CODE = 'LAASTX'
5772: AND crl.RULE_INFORMATION_CATEGORY = 'LAASTX'

Line 6370: FROM okc_rule_groups_b rgp,

6366:
6367: -- Bug# 6512668: Exclude asset lines in Abandoned status
6368: CURSOR l_upfront_tax_other_assets(p_line_upfront_tax OKC_RULES_B.RULE_INFORMATION11%TYPE) IS
6369: SELECT 'Y'
6370: FROM okc_rule_groups_b rgp,
6371: okc_rules_b rule,
6372: okc_k_lines_b cle
6373: WHERE rule.rgp_id = rgp.id
6374: AND rgd_code = 'LAASTX'

Line 6516: okc_rule_groups_b rgp,

6512: TO_NUMBER(sll.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12)) - 1) end_date,
6513: styt.name stream_type
6514: FROM okc_rules_b sll,
6515: okc_rules_b slh,
6516: okc_rule_groups_b rgp,
6517: okl_strm_type_b sty,
6518: okl_strm_type_tl styt
6519: WHERE rgp.dnz_chr_id = p_chr_id
6520: AND rgp.cle_id = p_fee_line_id

Line 6537: okc_rule_groups_b rgp,

6533: p_fee_line_id IN OKL_K_LINES.ID%TYPE) IS
6534:
6535: SELECT slh.id
6536: FROM okc_rules_b slh,
6537: okc_rule_groups_b rgp,
6538: okl_strm_type_b sty,
6539: okl_strm_type_tl styt
6540: WHERE rgp.dnz_chr_id = p_chr_id
6541: AND rgp.cle_id = p_fee_line_id

Line 6555: okc_rule_groups_b rgp,

6551: SELECT styt.name stream_type,
6552: rule.id rule_id,
6553: rgp.id rgp_id
6554: FROM okc_rules_b rule,
6555: okc_rule_groups_b rgp,
6556: okl_strm_type_b sty,
6557: okl_strm_type_tl styt
6558: WHERE NVL(rgp.cle_id, -1) = p_kle_id
6559: AND rgp.dnz_chr_id = p_khr_id

Line 6568: p_rgp_id OKC_RULE_GROUPS_B.ID%TYPE) IS

6564: AND styt.LANGUAGE = USERENV('LANG')
6565: AND sty.id = styt.id;
6566:
6567: CURSOR l_strm_sll_csr (p_rule_id OKC_RULES_B.ID%TYPE,
6568: p_rgp_id OKC_RULE_GROUPS_B.ID%TYPE) IS
6569: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date,
6570: sll.rule_information1 seq,
6571: sll.rule_information6 amt,
6572: sll.rule_information7 stub_day,