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_K_LINES_B

Line 77: okc_k_lines_b cle

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'
81: AND rgp.id = rl.rgp_id

Line 109: okc_k_lines_b cle

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
113: AND rgp.id = rl.rgp_id

Line 129: okc_k_lines_b cle

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
132: AND txs.kle_id = rg1.cle_id
133: AND txs.khr_id = rl1.dnz_chr_id

Line 161: ,okc_k_lines_b cle

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
164: AND txs.kle_id = rg1.cle_id
165: AND txs.khr_id = rl1.dnz_chr_id

Line 187: okc_k_lines_b cle

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
190: -- R12B ebtax: Active and Inactive lines will be billed during rebook
191: -- AND txs.tax_line_status_code = 'ACTIVE'

Line 215: okc_k_lines_b cle

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
218: -- R12B ebtax: Active and Inactive lines will be billed during rebook
219: -- AND txs.tax_line_status_code = 'ACTIVE'

Line 312: ,okc_k_lines_b cleb

308: WHERE nvl(chr.orig_system_source_code,'XXXX') <> 'OKL_RELEASE'
309: and chr.ID = cp_chr_id
310: AND exists ( SELECT '1'
311: FROM okl_k_lines kle
312: ,okc_k_lines_b cleb
313: WHERE cleb.dnz_chr_id = chr.id
314: AND cleb.chr_id = chr.id
315: AND cleb.id = kle.id
316: AND cleb.lse_id = 33

Line 321: ,okc_k_lines_b cleb

317: AND cleb.sts_code <> 'ABANDONED'
318: AND nvl(kle.re_lease_yn,'N') = 'Y')
319: AND exists ( SELECT '1'
320: FROM okl_k_lines kle
321: ,okc_k_lines_b cleb
322: WHERE cleb.dnz_chr_id = chr.id
323: AND cleb.chr_id = chr.id
324: AND cleb.id = kle.id
325: AND cleb.lse_id = 33

Line 338: ,okc_k_lines_b cleb

334: FROM okc_k_headers_b
335: WHERE id = cp_chr_id )
336: AND exists ( SELECT '1'
337: FROM okl_k_lines kle
338: ,okc_k_lines_b cleb
339: WHERE cleb.dnz_chr_id = chr.id
340: AND cleb.chr_id = chr.id
341: AND cleb.id = kle.id
342: AND cleb.lse_id = 33

Line 347: ,okc_k_lines_b cleb

343: AND cleb.sts_code <> 'ABANDONED'
344: AND nvl(kle.re_lease_yn,'N') = 'Y')
345: AND not exists ( SELECT '1'
346: FROM okl_k_lines kle
347: ,okc_k_lines_b cleb
348: WHERE cleb.dnz_chr_id = chr.id
349: AND cleb.chr_id = chr.id
350: AND cleb.id = kle.id
351: AND cleb.lse_id = 33

Line 695: l_orig_system_id1 okc_k_lines_b.orig_system_id1%type;

691: ln_rule_id okc_rules_v.id%TYPE;
692: lv_asset_k_rule_information5 okc_rules_v.rule_information5%TYPE;
693: l_ak_prompt varchar2(100);
694: l_rebook_yn varchar2(1) := 'N';
695: l_orig_system_id1 okc_k_lines_b.orig_system_id1%type;
696:
697: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE := null;
698: lv_k_rule_information2 okc_rules_v.rule_information1%TYPE := null;
699: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE := null;

Line 740: okc_k_lines_b cle

736: p_cle_id okc_k_lines_v.id%TYPE) IS
737: SELECT rul.id, rul.rule_information5, cle.ORIG_SYSTEM_ID1
738: FROM OKC_RULES_V rul,
739: OKC_RULE_GROUPS_V rgp,
740: okc_k_lines_b cle
741: WHERE rul.rgp_id = rgp.id
742: AND rgp.dnz_chr_id = p_chr_id
743: AND rgp.cle_id = p_cle_id
744: AND rgp.rgd_code = 'LAASTX'

Line 1720: okc_k_lines_b cleb_fee,

1716: cleb_fee.end_date,
1717: cim_fee.id cim_fee_id,
1718: cim_fee.object1_id1
1719: FROM okl_k_lines kle_fee,
1720: okc_k_lines_b cleb_fee,
1721: okc_k_items cim_fee
1722: WHERE cleb_fee.id = p_fee_cle_id
1723: AND kle_fee.id = cleb_fee.id
1724: AND cim_fee.cle_id = cleb_fee.id

Line 1747: FROM okc_k_lines_b cleb_cov_asset,

1743: p_fin_asset_cle_id IN NUMBER) IS
1744: SELECT cleb_cov_asset.id cleb_cov_asset_id,
1745: NVL(kle_cov_asset.capital_amount,kle_cov_asset.amount) amount,
1746: cim_cov_asset.id cim_cov_asset_id
1747: FROM okc_k_lines_b cleb_cov_asset,
1748: okl_k_lines kle_cov_asset,
1749: okc_k_items cim_cov_asset
1750: WHERE cleb_cov_asset.cle_id = p_fee_cle_id
1751: AND cleb_cov_asset.dnz_chr_id = p_chr_id

Line 1785: FROM okc_k_lines_b cle,

1781: -- Bug# 6512668: Exclude fee lines in Abandoned status
1782: CURSOR check_fee_csr(p_chr_id IN NUMBER,
1783: p_fee_type IN VARCHAR2 ) IS
1784: SELECT cle.id
1785: FROM okc_k_lines_b cle,
1786: okl_k_lines kle
1787: WHERE cle.id = kle.id
1788: AND cle.dnz_chr_id = p_chr_id
1789: AND kle.fee_purpose_code = 'SALESTAX'

Line 1793: l_del_fee_line_id OKC_K_LINES_B.id%TYPE;

1789: AND kle.fee_purpose_code = 'SALESTAX'
1790: AND kle.fee_type = p_fee_type
1791: AND cle.sts_code <> 'ABANDONED';
1792:
1793: l_del_fee_line_id OKC_K_LINES_B.id%TYPE;
1794: l_del_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
1795:
1796: -- Bug# 6512668: Exclude asset lines in Abandoned status
1797: CURSOR l_del_cov_asset_csr1(p_chr_id IN NUMBER,

Line 1801: FROM okc_k_lines_b cleb_cov_asset,

1797: CURSOR l_del_cov_asset_csr1(p_chr_id IN NUMBER,
1798: p_fee_cle_id IN NUMBER) IS
1799: SELECT cleb_cov_asset.id cleb_cov_asset_id,
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

Line 1803: okc_k_lines_b cleb_fin,

1799: SELECT cleb_cov_asset.id cleb_cov_asset_id,
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

Line 1829: FROM okc_k_lines_b cleb_cov_asset,

1825: CURSOR l_del_cov_asset_csr2(p_chr_id IN NUMBER,
1826: p_fee_cle_id IN NUMBER) IS
1827: SELECT cleb_cov_asset.id cleb_cov_asset_id,
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

Line 1831: okc_k_lines_b cleb_fin,

1827: SELECT cleb_cov_asset.id cleb_cov_asset_id,
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

Line 2283: FROM okc_k_lines_b cle,

2279: -- Bug# 6512668: Exclude fee line in Abandoned status
2280: CURSOR l_fee_csr (p_chr_id IN NUMBER) IS
2281: SELECT cle.id,
2282: kle.fee_type
2283: FROM okc_k_lines_b cle,
2284: okl_k_lines kle
2285: WHERE cle.id = kle.id
2286: AND cle.dnz_chr_id = p_chr_id
2287: AND cle.chr_id = p_chr_id

Line 2535: FROM OKC_K_LINES_b cle,

2531: -- Cursor to check if financed fee exists
2532: -- Bug# 6512668: Exclude fee line in Abandoned status
2533: CURSOR check_fee_csr ( l_fee_type IN VARCHAR2 ) IS
2534: SELECT cle.id
2535: FROM OKC_K_LINES_b cle,
2536: OKL_K_LINES KLE
2537: WHERE cle.id = kle.id
2538: AND cle.dnz_chr_id = p_contract_id
2539: AND kle.fee_purpose_code = 'SALESTAX'

Line 2543: l_fee_line_id OKC_K_LINES_B.id%TYPE;

2539: AND kle.fee_purpose_code = 'SALESTAX'
2540: AND kle.fee_type = l_fee_type
2541: AND cle.sts_code <> 'ABANDONED';
2542:
2543: l_fee_line_id OKC_K_LINES_B.id%TYPE;
2544: -- R12B Authoring OA Migration
2545:
2546: -- cursor to get item id
2547: CURSOR stream_csr (stream_type_id IN NUMBER) IS

Line 3243: FROM okc_k_lines_b

3239: --Bug# 6619311
3240: CURSOR assetBillTo_csr(p_cle_id IN NUMBER)
3241: IS
3242: SELECT bill_to_site_use_id cust_acct_site_id
3243: FROM okc_k_lines_b
3244: WHERE id = p_cle_id;
3245:
3246: l_assetBillTo_rec assetBillTo_csr%ROWTYPE;
3247: l_acc_gen_primary_key_tbl1 okl_account_dist_pvt.acc_gen_primary_key;

Line 4451: FROM okc_k_lines_b cle,

4447: -- Bug# 6512668: Exclude fee line in Abandoned status
4448: CURSOR check_st_fee_csr(p_chr_id IN NUMBER,
4449: p_fee_type IN VARCHAR2) IS
4450: SELECT cle.id
4451: FROM okc_k_lines_b cle,
4452: okl_k_lines kle
4453: WHERE cle.id = kle.id
4454: AND cle.dnz_chr_id = p_chr_id
4455: AND kle.fee_purpose_code = 'SALESTAX'

Line 4459: l_del_fee_line_id OKC_K_LINES_B.id%TYPE;

4455: AND kle.fee_purpose_code = 'SALESTAX'
4456: AND kle.fee_type = NVL(p_fee_type,kle.fee_type)
4457: AND cle.sts_code <> 'ABANDONED';
4458:
4459: l_del_fee_line_id OKC_K_LINES_B.id%TYPE;
4460: l_del_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
4461: l_fee_type_to_delete OKL_K_LINES.fee_type%TYPE;
4462:
4463: BEGIN

Line 5396: FROM okc_k_lines_b CLEB

5392: AND rul.rule_information_category = 'LARLES'; */
5393:
5394: CURSOR l_chk_rel_ast_csr (p_chr_id IN NUMBER) IS
5395: SELECT COUNT(KLE.id) new_asset_cnt
5396: FROM okc_k_lines_b CLEB
5397: ,okl_k_lines KLE
5398: WHERE CLEB.id = KLE.id
5399: AND CLEB.dnz_chr_id = p_chr_id
5400: AND CLEB.chr_id = p_chr_id

Line 6129: okc_k_lines_b cleb,

6125: kle.fee_type,
6126: kle.amount
6127: --decode(kle.fee_type,'CAPITALIZED',kle.capital_amount,kle.amount) amount
6128: FROM
6129: okc_k_lines_b cleb,
6130: okc_k_lines_tl clet,
6131: okl_k_lines kle,
6132: okc_line_styles_v sty,
6133: okc_statuses_v sts

Line 6146: CURSOR st_fee_link_asset_csr(p_cleId OKC_K_LINES_B.ID%TYPE) IS

6142: AND kle.id = cleb.id;
6143: l_st_fee_rec st_fee_csr%ROWTYPE;
6144: l_fee_amount okl_k_lines.amount%TYPE;
6145:
6146: CURSOR st_fee_link_asset_csr(p_cleId OKC_K_LINES_B.ID%TYPE) IS
6147: SELECT cleb.id,
6148: nvl(kle.amount,0) amount,
6149: nvl(kle.capital_amount,0) capital_amount
6150: FROM okc_k_lines_b cleb,

Line 6150: FROM okc_k_lines_b cleb,

6146: CURSOR st_fee_link_asset_csr(p_cleId OKC_K_LINES_B.ID%TYPE) IS
6147: SELECT cleb.id,
6148: nvl(kle.amount,0) amount,
6149: nvl(kle.capital_amount,0) capital_amount
6150: FROM okc_k_lines_b cleb,
6151: okl_k_lines kle,
6152: okc_line_styles_b sty
6153: WHERE cle_id = p_cleId
6154: AND cleb.id = kle.id

Line 6160: CURSOR l_asset_tax_rule_csr(p_cleId OKC_K_LINES_B.ID%TYPE) IS

6156: AND sty.lty_code = 'LINK_FEE_ASSET';
6157:
6158: l_st_fee_link_asset_rec st_fee_link_asset_csr%ROWTYPE;
6159:
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,

Line 6185: --CURSOR l_fee_asset_csr(p_assetId OKC_K_LINES_B.ID%TYPE, p_fee_type OKL_K_LINES.FEE_TYPE%TYPE) IS

6181: AND lty_code = 'FREE_FORM1'
6182: AND cle.sts_code = sts.code
6183: AND sts.ste_code not in ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
6184:
6185: --CURSOR l_fee_asset_csr(p_assetId OKC_K_LINES_B.ID%TYPE, p_fee_type OKL_K_LINES.FEE_TYPE%TYPE) IS
6186: CURSOR l_fee_asset_csr(p_assetId OKC_K_LINES_B.ID%TYPE) IS
6187: SELECT item.object1_id1,cleb.id,cleb.cle_id,
6188: clet_asset.name,
6189: kle.amount,

Line 6186: CURSOR l_fee_asset_csr(p_assetId OKC_K_LINES_B.ID%TYPE) IS

6182: AND cle.sts_code = sts.code
6183: AND sts.ste_code not in ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
6184:
6185: --CURSOR l_fee_asset_csr(p_assetId OKC_K_LINES_B.ID%TYPE, p_fee_type OKL_K_LINES.FEE_TYPE%TYPE) IS
6186: CURSOR l_fee_asset_csr(p_assetId OKC_K_LINES_B.ID%TYPE) IS
6187: SELECT item.object1_id1,cleb.id,cleb.cle_id,
6188: clet_asset.name,
6189: kle.amount,
6190: kle.fee_type

Line 6191: FROM okc_k_lines_b fee_line,

6187: SELECT item.object1_id1,cleb.id,cleb.cle_id,
6188: clet_asset.name,
6189: kle.amount,
6190: kle.fee_type
6191: FROM okc_k_lines_b fee_line,
6192: okc_k_lines_b cleb,
6193: okl_k_lines kle,
6194: okc_k_items item,
6195: okc_k_lines_tl clet_asset,

Line 6192: okc_k_lines_b cleb,

6188: clet_asset.name,
6189: kle.amount,
6190: kle.fee_type
6191: FROM okc_k_lines_b fee_line,
6192: okc_k_lines_b cleb,
6193: okl_k_lines kle,
6194: okc_k_items item,
6195: okc_k_lines_tl clet_asset,
6196: okc_line_styles_b sty

Line 6221: CURSOR l_tax_line_amt_csr(p_asset_id OKC_K_LINES_B.ID%TYPE) IS

6217: AND txs.tax_line_status_code = 'ACTIVE'
6218: AND txs.tax_call_type_code = 'UPFRONT_TAX';
6219: l_tax_amount NUMBER;
6220:
6221: CURSOR l_tax_line_amt_csr(p_asset_id OKC_K_LINES_B.ID%TYPE) IS
6222: SELECT SUM(NVL(TOTAL_TAX,0)) tax_amount -- SUM added for 4740150 issue
6223: FROM okl_tax_sources txs
6224: --,okl_tax_trx_details txl
6225: WHERE txs.khr_id = p_chr_id

Line 6235: FROM okc_k_lines_b cleb,

6231:
6232: -- R12B Authoring OA Migration
6233: CURSOR st_fee_count_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
6234: SELECT COUNT(cleb.id)
6235: FROM okc_k_lines_b cleb,
6236: okl_k_lines kle,
6237: okc_line_styles_b sty,
6238: okc_statuses_b sts
6239: WHERE cleb.lse_id = sty.id

Line 6276: FROM okc_k_lines_b CLEB

6272: AND rul.rule_information_category = 'LARLES';*/
6273:
6274: CURSOR l_chk_rel_ast_csr (p_chr_id IN NUMBER) IS
6275: SELECT COUNT(KLE.id) new_asset_cnt
6276: FROM okc_k_lines_b CLEB
6277: ,okl_k_lines KLE
6278: WHERE CLEB.id = KLE.id
6279: AND CLEB.dnz_chr_id = p_chr_id
6280: AND CLEB.chr_id = p_chr_id

Line 6916: okc_k_lines_b cle

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'
6919: AND rule_information_category = 'LAASTX'
6920: AND rgp.dnz_chr_id = p_chr_id

Line 7042: FROM okc_k_lines_b cleb,

7038: SELECT kle.id,
7039: kle.amount,
7040: cleb.end_date,
7041: cleb.start_date
7042: FROM okc_k_lines_b cleb,
7043: okl_k_lines kle,
7044: okc_statuses_b okcsts
7045: WHERE cleb.dnz_chr_id = p_chr_id
7046: AND kle.id = cleb.id

Line 7097: p_kle_id OKC_K_LINES_B.ID%TYPE) IS

7093: AND styt.language = USERENV('LANG')
7094: AND sty.id = styt.id;
7095:
7096: CURSOR l_strm_slh_csr (p_khr_id OKC_K_HEADERS_B.ID%TYPE,
7097: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
7098: SELECT styt.name stream_type,
7099: rule.id rule_id,
7100: rgp.id rgp_id
7101: FROM okc_rules_b rule,