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 76: okc_rule_groups_b rgp,

72: CURSOR check_feetype_csr (p_contract_id IN NUMBER)
73: IS
74: SELECT NVL(rule_information11,'BILLED') feetype
75: FROM okc_rules_b rl,
76: okc_rule_groups_b rgp,
77: okc_k_lines_b cle
78: WHERE rl.dnz_chr_id = p_contract_id
79: AND rl.rule_information_category = 'LAASTX'
80: AND NVL(rule_information11,'BILLED') <> 'BILLED'

Line 108: okc_rule_groups_b rgp,

104: CURSOR check_lines_csr (p_contract_id IN NUMBER, l_fee_type IN VARCHAR2 )
105: IS
106: SELECT count(NVL(rule_information11, l_fee_type))
107: FROM okc_rules_b rl,
108: okc_rule_groups_b rgp,
109: okc_k_lines_b cle
110: WHERE rl.dnz_chr_id = p_contract_id
111: AND rl.rule_information_category = 'LAASTX'
112: AND NVL(rule_information11, l_fee_type) = l_fee_type

Line 125: okc_rule_groups_b rg1,

121: CURSOR get_fee_amt_csr1(p_contract_id IN NUMBER, p_feetype IN VARCHAR2)
122: IS
123: SELECT NVL(SUM(NVL(TOTAL_TAX,0)),0)
124: FROM okl_tax_sources txs,
125: okc_rule_groups_b rg1,
126: okc_rules_b rl1,
127: okc_rule_groups_b rg2,
128: okc_rules_b rl2,
129: okc_k_lines_b cle

Line 127: okc_rule_groups_b rg2,

123: SELECT NVL(SUM(NVL(TOTAL_TAX,0)),0)
124: FROM okl_tax_sources txs,
125: okc_rule_groups_b rg1,
126: okc_rules_b rl1,
127: okc_rule_groups_b rg2,
128: okc_rules_b rl2,
129: okc_k_lines_b cle
130: WHERE txs.KHR_ID = p_contract_id
131: AND txs.khr_id = rg1.dnz_chr_id

Line 159: ,okc_rule_groups_b rg1

155: CURSOR get_fee_amt_csr2 (p_contract_id IN NUMBER, p_feetype IN VARCHAR2)
156: IS
157: SELECT NVL(SUM(NVL(TOTAL_TAX,0)),0)
158: FROM okl_tax_sources txs
159: ,okc_rule_groups_b rg1
160: ,okc_rules_b rl1
161: ,okc_k_lines_b cle
162: WHERE txs.KHR_ID = p_Contract_id
163: AND txs.khr_id = rg1.dnz_chr_id

Line 185: okc_rule_groups_b rg1,

181: CURSOR billing_required_csr1(p_contract_id IN NUMBER,
182: p_transaction_id IN NUMBER) IS
183: SELECT 1
184: FROM okl_tax_sources txs,
185: okc_rule_groups_b rg1,
186: okc_rules_b rl1,
187: okc_k_lines_b cle
188: WHERE txs.khr_id = p_contract_id
189: AND txs.trx_id = p_transaction_id

Line 213: okc_rule_groups_b rg1,

209: CURSOR billing_required_csr2(p_contract_id IN NUMBER,
210: p_transaction_id IN NUMBER) IS
211: SELECT 1
212: FROM okl_tax_sources txs,
213: okc_rule_groups_b rg1,
214: okc_rules_b rl1,
215: okc_k_lines_b cle
216: WHERE txs.khr_id = p_contract_id
217: AND txs.trx_id = p_transaction_id

Line 458: FROM OKC_RULE_GROUPS_B rgp

454:
455: CURSOR l_asset_tax_rule_group(p_chr_id okc_k_headers_b.id%TYPE,
456: p_cle_id NUMBER) IS -- 5179119
457: SELECT id
458: FROM OKC_RULE_GROUPS_B rgp
459: WHERE rgp.dnz_chr_id = p_chr_id
460: AND rgp.cle_id is NOT NULL
461: AND rgp.rgd_code = 'LAASTX'
462: AND rgp.cle_id = p_cle_id; -- 5179119

Line 1653: okc_rule_groups_b rg1,

1649: CURSOR get_asset_csr1 (p_fee_type IN VARCHAR2)
1650: IS
1651: SELECT cle.id, cle.name, cle.item_description
1652: FROM okc_k_lines_v cle,
1653: okc_rule_groups_b rg1,
1654: okc_rules_b rl1,
1655: okc_line_styles_b lse,
1656: okc_rule_groups_b rg2,
1657: okc_rules_b rl2

Line 1656: okc_rule_groups_b rg2,

1652: FROM okc_k_lines_v cle,
1653: okc_rule_groups_b rg1,
1654: okc_rules_b rl1,
1655: okc_line_styles_b lse,
1656: okc_rule_groups_b rg2,
1657: okc_rules_b rl2
1658: WHERE cle.chr_ID = p_contract_id
1659: AND cle.lse_id = lse.id
1660: AND lse.lty_code = 'FREE_FORM1'

Line 1685: okc_rule_groups_b rg1,

1681: CURSOR get_asset_csr2 (p_fee_type IN VARCHAR2)
1682: IS
1683: SELECT cle.id, cle.name, cle.item_description
1684: FROM okc_k_lines_v cle,
1685: okc_rule_groups_b rg1,
1686: okc_rules_b rl1,
1687: okc_line_styles_b lse
1688: WHERE cle.dnz_chr_id = p_contract_id
1689: AND cle.lse_id = lse.id

Line 1769: FROM okc_rule_groups_b rgp_lafexp,

1765: rul_lafexp.rgp_id,
1766: rul_lafexp.dnz_chr_id,
1767: rul_lafexp.rule_information_category,
1768: TO_NUMBER(rul_lafexp.rule_information2) amount
1769: FROM okc_rule_groups_b rgp_lafexp,
1770: okc_rules_b rul_lafexp
1771: WHERE rgp_lafexp.dnz_chr_id = p_chr_id
1772: AND rgp_lafexp.cle_id = p_fee_cle_id
1773: AND rgp_lafexp.rgd_code = 'LAFEXP'

Line 1804: okc_rule_groups_b rgp,

1800: cim_cov_asset.id cim_cov_asset_id
1801: FROM okc_k_lines_b cleb_cov_asset,
1802: okc_k_items cim_cov_asset,
1803: okc_k_lines_b cleb_fin,
1804: okc_rule_groups_b rgp,
1805: okc_rules_b rul
1806: WHERE cleb_cov_asset.cle_id = p_fee_cle_id
1807: AND cleb_cov_asset.dnz_chr_id = p_chr_id
1808: AND cim_cov_asset.cle_id = cleb_cov_asset.id

Line 1832: okc_rule_groups_b rgp,

1828: cim_cov_asset.id cim_cov_asset_id
1829: FROM okc_k_lines_b cleb_cov_asset,
1830: okc_k_items cim_cov_asset,
1831: okc_k_lines_b cleb_fin,
1832: okc_rule_groups_b rgp,
1833: okc_rules_b rul
1834: WHERE cleb_cov_asset.cle_id = p_fee_cle_id
1835: AND cleb_cov_asset.dnz_chr_id = p_chr_id
1836: AND cim_cov_asset.cle_id = cleb_cov_asset.id

Line 2565: okc_rule_groups_b rg1,

2561: CURSOR get_asset_csr1 (p_fee_type IN VARCHAR2)
2562: IS
2563: SELECT cle.id, cle.name, cle.item_description
2564: FROM okc_k_lines_v cle,
2565: okc_rule_groups_b rg1,
2566: okc_rules_b rl1,
2567: okc_line_styles_b lse,
2568: okc_rule_groups_b rg2,
2569: okc_rules_b rl2

Line 2568: okc_rule_groups_b rg2,

2564: FROM okc_k_lines_v cle,
2565: okc_rule_groups_b rg1,
2566: okc_rules_b rl1,
2567: okc_line_styles_b lse,
2568: okc_rule_groups_b rg2,
2569: okc_rules_b rl2
2570: WHERE cle.chr_ID = p_contract_id
2571: AND cle.lse_id = lse.id
2572: AND lse.lty_code = 'FREE_FORM1'

Line 2598: okc_rule_groups_b rg1,

2594: CURSOR get_asset_csr2 (p_fee_type IN VARCHAR2)
2595: IS
2596: SELECT cle.id, cle.name, cle.item_description
2597: FROM okc_k_lines_v cle,
2598: okc_rule_groups_b rg1,
2599: okc_rules_b rl1,
2600: okc_line_styles_b lse
2601: WHERE cle.dnz_chr_ID = p_contract_id
2602: AND cle.lse_id = lse.id

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

6049: FROM okc_k_headers_b
6050: WHERE id = p_chr_id;
6051: l_authoring_org_id OKC_K_HEADERS_B.AUTHORING_ORG_ID%TYPE;
6052:
6053: cursor l_hdrrl_csr( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
6054: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
6055: chrId NUMBER) IS
6056: select crl.object1_id1,
6057: crl.RULE_INFORMATION1,

Line 6066: from OKC_RULE_GROUPS_B crg,

6062: crl.RULE_INFORMATION6,
6063: crl.RULE_INFORMATION7,
6064: crl.RULE_INFORMATION10,
6065: crl.RULE_INFORMATION11
6066: from OKC_RULE_GROUPS_B crg,
6067: OKC_RULES_B crl
6068: where crl.rgp_id = crg.id
6069: and crg.RGD_CODE = rgcode
6070: and crl.RULE_INFORMATION_CATEGORY = rlcat

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

6070: and crl.RULE_INFORMATION_CATEGORY = rlcat
6071: and crg.dnz_chr_id = chrId;
6072:
6073:
6074: cursor l_rl_csr1( rgcode OKC_RULE_GROUPS_B.RGD_CODE%TYPE,
6075: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,
6076: chrId NUMBER,
6077: cleId NUMBER ) IS
6078: select crl.id slh_id,

Line 6088: from OKC_RULE_GROUPS_B crg,

6084: crl.RULE_INFORMATION6,
6085: crl.RULE_INFORMATION7,
6086: crl.RULE_INFORMATION8,
6087: crl.RULE_INFORMATION10
6088: from OKC_RULE_GROUPS_B crg,
6089: OKC_RULES_B crl
6090: where crl.rgp_id = crg.id
6091: and crg.RGD_CODE = rgcode
6092: and crl.RULE_INFORMATION_CATEGORY = rlcat

Line 6164: FROM OKC_RULE_GROUPS_B crg,

6160: CURSOR l_asset_tax_rule_csr(p_cleId OKC_K_LINES_B.ID%TYPE) IS
6161: SELECT crl.id slh_id,
6162: crl.object1_id1,
6163: crl.RULE_INFORMATION11
6164: FROM OKC_RULE_GROUPS_B crg,
6165: OKC_RULES_B crl
6166: WHERE crl.rgp_id = crg.id
6167: AND crg.RGD_CODE = 'LAASTX'
6168: AND crl.RULE_INFORMATION_CATEGORY = 'LAASTX'

Line 6251: FROM okc_rule_groups_b crg,

6247:
6248: -- ER# 9327076 - Cursor to check line level setup for upfront tax
6249: CURSOR chk_line_upfront_tax (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
6250: SELECT '!'
6251: FROM okc_rule_groups_b crg,
6252: okc_rules_b crl
6253: WHERE crl.rgp_id = crg.ID
6254: AND crg.rgd_code = 'LAASTX'
6255: AND crl.rule_information_category = 'LAASTX'

Line 6914: FROM okc_rule_groups_b rgp,

6910:
6911: -- Bug# 6512668: Exclude asset lines in Abandoned status
6912: CURSOR l_upfront_tax_other_assets(p_line_upfront_tax OKC_RULES_B.RULE_INFORMATION11%TYPE) IS
6913: SELECT 'Y'
6914: FROM okc_rule_groups_b rgp,
6915: okc_rules_b rule,
6916: okc_k_lines_b cle
6917: WHERE rule.rgp_id = rgp.id
6918: AND rgd_code = 'LAASTX'

Line 7063: okc_rule_groups_b rgp,

7059: TO_NUMBER(sll.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12)) - 1) end_date,
7060: styt.name stream_type
7061: FROM okc_rules_b sll,
7062: okc_rules_b slh,
7063: okc_rule_groups_b rgp,
7064: okl_strm_type_b sty,
7065: okl_strm_type_tl styt
7066: WHERE rgp.dnz_chr_id = p_chr_id
7067: AND rgp.cle_id = p_fee_line_id

Line 7084: okc_rule_groups_b rgp,

7080: p_fee_line_id IN OKL_K_LINES.ID%TYPE) IS
7081:
7082: SELECT slh.id
7083: FROM okc_rules_b slh,
7084: okc_rule_groups_b rgp,
7085: okl_strm_type_b sty,
7086: okl_strm_type_tl styt
7087: WHERE rgp.dnz_chr_id = p_chr_id
7088: AND rgp.cle_id = p_fee_line_id

Line 7102: okc_rule_groups_b rgp,

7098: SELECT styt.name stream_type,
7099: rule.id rule_id,
7100: rgp.id rgp_id
7101: FROM okc_rules_b rule,
7102: okc_rule_groups_b rgp,
7103: okl_strm_type_b sty,
7104: okl_strm_type_tl styt
7105: WHERE NVL(rgp.cle_id, -1) = p_kle_id
7106: AND rgp.dnz_chr_id = p_khr_id

Line 7115: p_rgp_id OKC_RULE_GROUPS_B.ID%TYPE) IS

7111: AND styt.LANGUAGE = USERENV('LANG')
7112: AND sty.id = styt.id;
7113:
7114: CURSOR l_strm_sll_csr (p_rule_id OKC_RULES_B.ID%TYPE,
7115: p_rgp_id OKC_RULE_GROUPS_B.ID%TYPE) IS
7116: SELECT Fnd_Date.canonical_to_date(sll.rule_information2) start_date,
7117: sll.rule_information1 seq,
7118: sll.rule_information6 amt,
7119: sll.rule_information7 stub_day,