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_RULES_B

Line 57: FROM okc_rules_b rl,

53: -- Bug# 6512668: Exclude asset lines in Abandoned status
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'

Line 75: FROM okc_rules_b rl

71: rule_information2,
72: rule_information3,
73: rule_information4,
74: rule_information5
75: FROM okc_rules_b rl
76: WHERE rl.dnz_chr_id = p_contract_id
77: AND rl.rule_information_category = 'LASTPR';
78:
79: -- The following checks if all the lines have the asset upfront tax as

Line 89: FROM okc_rules_b rl,

85: -- Bug# 6512668: Exclude asset lines in Abandoned status
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'

Line 108: okc_rules_b rl1,

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
112: WHERE txs.KHR_ID = p_contract_id

Line 110: okc_rules_b rl2,

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
114: AND txs.kle_id = rg1.cle_id

Line 142: ,okc_rules_b rl1

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
146: AND txs.kle_id = rg1.cle_id

Line 168: okc_rules_b rl1,

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
172: -- R12B ebtax: Active and Inactive lines will be billed during rebook

Line 196: okc_rules_b rl1,

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
200: -- R12B ebtax: Active and Inactive lines will be billed during rebook

Line 602: CURSOR get_segment_prompt(p_ri okc_rules_b.rule_information1%TYPE) IS

598: AND rgp.cle_id is NULL
599: AND rgp.rgd_code = 'LAHDTX'
600: AND rul.rule_information_category = 'LASTPR';
601:
602: CURSOR get_segment_prompt(p_ri okc_rules_b.rule_information1%TYPE) IS
603: select col.form_left_prompt
604: from fnd_descr_flex_col_usage_vl col,
605: okc_rule_defs_v rdef
606: where col.application_id = 540

Line 1468: okc_rules_b rl1,

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
1472: WHERE cle.chr_ID = p_contract_id

Line 1471: okc_rules_b rl2

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'
1475: AND cle.dnz_chr_id = rg1.dnz_chr_id

Line 1500: okc_rules_b rl1,

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
1504: AND lse.lty_code = 'FREE_FORM1'

Line 1575: okc_rules_b rul_lafexp

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'
1579: AND rul_lafexp.rgp_id = rgp_lafexp.id

Line 1610: okc_rules_b rul

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
1614: AND cim_cov_asset.dnz_chr_id = cleb_cov_asset.dnz_chr_id

Line 1638: okc_rules_b rul

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
1642: AND cim_cov_asset.dnz_chr_id = cleb_cov_asset.dnz_chr_id

Line 2362: okc_rules_b rl1,

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
2366: WHERE cle.chr_ID = p_contract_id

Line 2365: okc_rules_b rl2

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'
2369: AND cle.dnz_chr_id = rg1.dnz_chr_id

Line 2395: okc_rules_b rl1,

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
2399: AND lse.lty_code = 'FREE_FORM1'

Line 3031: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;

3027:
3028: -- Cursors plucked from OKL_LA_JE_PVT for a/c - END
3029: l_acc_gen_primary_key_tbl okl_account_dist_pvt.acc_gen_primary_key;
3030: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
3031: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
3032:
3033: account_data_exception EXCEPTION;
3034:
3035: --Bug# 6619311

Line 3564: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;

3560: TYPE ac_tax_line_tbl IS TABLE OF ac_tax_line_rec
3561: INDEX BY BINARY_INTEGER;
3562: l_accoutable_tax_lines ac_tax_line_tbl;
3563: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;
3564: l_inv_acct_code OKC_RULES_B.Rule_Information1%TYPE;
3565: upfront_tax_acct_exception EXCEPTION;
3566:
3567: --Bug# 6619311
3568: l_billed_sty_id NUMBER;

Line 4237: l_fee_type OKC_RULES_B.rule_information1%TYPE;

4233:
4234: rule_info_csr_rec rule_info_csr%ROWTYPE;
4235: l_asset_count NUMBER := 0;
4236: l_stream_id NUMBER := 0;
4237: l_fee_type OKC_RULES_B.rule_information1%TYPE;
4238: l_prev_fee_type OKC_RULES_B.rule_information1%TYPE;
4239: l_multiple_fee_type VARCHAR2(1) := Okl_Api.G_FALSE;
4240: pre_book_exception exception;
4241:

Line 4238: l_prev_fee_type OKC_RULES_B.rule_information1%TYPE;

4234: rule_info_csr_rec rule_info_csr%ROWTYPE;
4235: l_asset_count NUMBER := 0;
4236: l_stream_id NUMBER := 0;
4237: l_fee_type OKC_RULES_B.rule_information1%TYPE;
4238: l_prev_fee_type OKC_RULES_B.rule_information1%TYPE;
4239: l_multiple_fee_type VARCHAR2(1) := Okl_Api.G_FALSE;
4240: pre_book_exception exception;
4241:
4242: -- Cursor to check if sales tax fee exists

Line 4604: l_fee_type OKC_RULES_B.rule_information1%TYPE;

4600: l_source_table VARCHAR2(30) := 'OKL_TRX_CONTRACTS';
4601: l_billed_assets NUMBER :=0;
4602: l_asset_count NUMBER :=0;
4603: l_multiple_fee_type VARCHAR2(1) := Okl_Api.G_FALSE;
4604: l_fee_type OKC_RULES_B.rule_information1%TYPE;
4605: l_prev_fee_type OKC_RULES_B.rule_information1%TYPE;
4606: l_contract_bill_tax NUMBER :=0;
4607: booking_exception exception;
4608:

Line 4605: l_prev_fee_type OKC_RULES_B.rule_information1%TYPE;

4601: l_billed_assets NUMBER :=0;
4602: l_asset_count NUMBER :=0;
4603: l_multiple_fee_type VARCHAR2(1) := Okl_Api.G_FALSE;
4604: l_fee_type OKC_RULES_B.rule_information1%TYPE;
4605: l_prev_fee_type OKC_RULES_B.rule_information1%TYPE;
4606: l_contract_bill_tax NUMBER :=0;
4607: booking_exception exception;
4608:
4609: BEGIN

Line 4897: l_fee_type OKC_RULES_B.rule_information1%TYPE;

4893: rule_info_csr_rec rule_info_csr%ROWTYPE;
4894: l_asset_count NUMBER;
4895: l_billed_assets NUMBER :=0;
4896: l_multiple_fee_type VARCHAR2(1) := Okl_Api.G_FALSE;
4897: l_fee_type OKC_RULES_B.rule_information1%TYPE;
4898: l_prev_fee_type OKC_RULES_B.rule_information1%TYPE;
4899: rebook_exception EXCEPTION;
4900:
4901: BEGIN

Line 4898: l_prev_fee_type OKC_RULES_B.rule_information1%TYPE;

4894: l_asset_count NUMBER;
4895: l_billed_assets NUMBER :=0;
4896: l_multiple_fee_type VARCHAR2(1) := Okl_Api.G_FALSE;
4897: l_fee_type OKC_RULES_B.rule_information1%TYPE;
4898: l_prev_fee_type OKC_RULES_B.rule_information1%TYPE;
4899: rebook_exception EXCEPTION;
4900:
4901: BEGIN
4902:

Line 5182: FROM okc_rules_b rul

5178:
5179: -- Bug 6155565
5180: CURSOR l_chk_rel_ast_csr (p_chr_id IN NUMBER) IS
5181: SELECT NVL(rule_information1,'N')
5182: FROM okc_rules_b rul
5183: WHERE rul.dnz_chr_id = p_chr_id
5184: AND rul.rule_information_category = 'LARLES';
5185:
5186: l_release_asset_yn VARCHAR2(1);

Line 5658: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

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,
5662: crl.RULE_INFORMATION2,

Line 5671: OKC_RULES_B crl

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
5675: and crg.dnz_chr_id = chrId;

Line 5679: rlcat OKC_RULES_B.RULE_INFORMATION_CATEGORY%TYPE,

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,
5683: crl.object1_id1,

Line 5693: OKC_RULES_B crl

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
5697: and crg.dnz_chr_id = chrId

Line 5769: OKC_RULES_B crl

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'
5773: AND crg.dnz_chr_id = p_chr_id

Line 6368: CURSOR l_upfront_tax_other_assets(p_line_upfront_tax OKC_RULES_B.RULE_INFORMATION11%TYPE) IS

6364: l_exists boolean;
6365: l_mix_fin_cap VARCHAR2(1);
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

Line 6371: okc_rules_b rule,

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'
6375: AND rule_information_category = 'LAASTX'

Line 6514: FROM okc_rules_b sll,

6510: DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12) mpp,
6511: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
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

Line 6515: okc_rules_b slh,

6511: TRUNC(ADD_MONTHS(Fnd_Date.canonical_to_date(sll.rule_information2),
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

Line 6536: FROM okc_rules_b slh,

6532: CURSOR l_fn_fee_pmtH_csr (p_chr_id IN OKC_K_HEADERS_B.ID%TYPE,
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

Line 6554: FROM okc_rules_b rule,

6550: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
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

Line 6567: CURSOR l_strm_sll_csr (p_rule_id OKC_RULES_B.ID%TYPE,

6563: AND TO_NUMBER(rule.object1_id1) = sty.id
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,

Line 6574: FROM okc_rules_b sll

6570: sll.rule_information1 seq,
6571: sll.rule_information6 amt,
6572: sll.rule_information7 stub_day,
6573: sll.rule_information13 rate
6574: FROM okc_rules_b sll
6575: WHERE sll.rgp_id = p_rgp_id
6576: AND sll.object2_id1 = TO_CHAR(p_rule_id)
6577: AND sll.rule_information_category = 'LASLL'
6578: ORDER BY 1,2;