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 59: okc_k_lines_b cle

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

Line 91: okc_k_lines_b cle

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

Line 111: okc_k_lines_b cle

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
115: AND txs.khr_id = rl1.dnz_chr_id

Line 143: ,okc_k_lines_b cle

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
147: AND txs.khr_id = rl1.dnz_chr_id

Line 169: okc_k_lines_b cle

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
173: -- AND txs.tax_line_status_code = 'ACTIVE'

Line 197: okc_k_lines_b cle

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
201: -- AND txs.tax_line_status_code = 'ACTIVE'

Line 537: l_orig_system_id1 okc_k_lines_b.orig_system_id1%type;

533: ln_rule_id okc_rules_v.id%TYPE;
534: lv_asset_k_rule_information5 okc_rules_v.rule_information5%TYPE;
535: l_ak_prompt varchar2(100);
536: l_rebook_yn varchar2(1) := 'N';
537: l_orig_system_id1 okc_k_lines_b.orig_system_id1%type;
538:
539: lv_k_rule_information1 okc_rules_v.rule_information1%TYPE := null;
540: lv_k_rule_information2 okc_rules_v.rule_information1%TYPE := null;
541: lv_k_rule_information3 okc_rules_v.rule_information3%TYPE := null;

Line 582: okc_k_lines_b cle

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
586: AND rgp.rgd_code = 'LAASTX'

Line 1534: okc_k_lines_b cleb_fee,

1530: cleb_fee.end_date,
1531: cim_fee.id cim_fee_id,
1532: cim_fee.object1_id1
1533: FROM okl_k_lines kle_fee,
1534: okc_k_lines_b cleb_fee,
1535: okc_k_items cim_fee
1536: WHERE cleb_fee.id = p_fee_cle_id
1537: AND kle_fee.id = cleb_fee.id
1538: AND cim_fee.cle_id = cleb_fee.id

Line 1552: FROM okc_k_lines_b cleb_cov_asset,

1548: p_fin_asset_cle_id IN NUMBER) IS
1549: SELECT cleb_cov_asset.id cleb_cov_asset_id,
1550: NVL(kle_cov_asset.capital_amount,kle_cov_asset.amount) amount,
1551: cim_cov_asset.id cim_cov_asset_id
1552: FROM okc_k_lines_b cleb_cov_asset,
1553: okl_k_lines kle_cov_asset,
1554: okc_k_items cim_cov_asset
1555: WHERE cleb_cov_asset.cle_id = p_fee_cle_id
1556: AND cleb_cov_asset.dnz_chr_id = p_chr_id

Line 1590: FROM okc_k_lines_b cle,

1586: -- Bug# 6512668: Exclude fee lines in Abandoned status
1587: CURSOR check_fee_csr(p_chr_id IN NUMBER,
1588: p_fee_type IN VARCHAR2 ) IS
1589: SELECT cle.id
1590: FROM okc_k_lines_b cle,
1591: okl_k_lines kle
1592: WHERE cle.id = kle.id
1593: AND cle.dnz_chr_id = p_chr_id
1594: AND kle.fee_purpose_code = 'SALESTAX'

Line 1598: l_del_fee_line_id OKC_K_LINES_B.id%TYPE;

1594: AND kle.fee_purpose_code = 'SALESTAX'
1595: AND kle.fee_type = p_fee_type
1596: AND cle.sts_code <> 'ABANDONED';
1597:
1598: l_del_fee_line_id OKC_K_LINES_B.id%TYPE;
1599: l_del_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
1600:
1601: -- Bug# 6512668: Exclude asset lines in Abandoned status
1602: CURSOR l_del_cov_asset_csr1(p_chr_id IN NUMBER,

Line 1606: FROM okc_k_lines_b cleb_cov_asset,

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

Line 1608: okc_k_lines_b cleb_fin,

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

Line 1634: FROM okc_k_lines_b cleb_cov_asset,

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

Line 1636: okc_k_lines_b cleb_fin,

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

Line 2080: FROM okc_k_lines_b cle,

2076: -- Bug# 6512668: Exclude fee line in Abandoned status
2077: CURSOR l_fee_csr (p_chr_id IN NUMBER) IS
2078: SELECT cle.id,
2079: kle.fee_type
2080: FROM okc_k_lines_b cle,
2081: okl_k_lines kle
2082: WHERE cle.id = kle.id
2083: AND cle.dnz_chr_id = p_chr_id
2084: AND cle.chr_id = p_chr_id

Line 2332: FROM OKC_K_LINES_b cle,

2328: -- Cursor to check if financed fee exists
2329: -- Bug# 6512668: Exclude fee line in Abandoned status
2330: CURSOR check_fee_csr ( l_fee_type IN VARCHAR2 ) IS
2331: SELECT cle.id
2332: FROM OKC_K_LINES_b cle,
2333: OKL_K_LINES KLE
2334: WHERE cle.id = kle.id
2335: AND cle.dnz_chr_id = p_contract_id
2336: AND kle.fee_purpose_code = 'SALESTAX'

Line 2340: l_fee_line_id OKC_K_LINES_B.id%TYPE;

2336: AND kle.fee_purpose_code = 'SALESTAX'
2337: AND kle.fee_type = l_fee_type
2338: AND cle.sts_code <> 'ABANDONED';
2339:
2340: l_fee_line_id OKC_K_LINES_B.id%TYPE;
2341: -- R12B Authoring OA Migration
2342:
2343: -- cursor to get item id
2344: CURSOR stream_csr (stream_type_id IN NUMBER) IS

Line 3039: FROM okc_k_lines_b

3035: --Bug# 6619311
3036: CURSOR assetBillTo_csr(p_cle_id IN NUMBER)
3037: IS
3038: SELECT bill_to_site_use_id cust_acct_site_id
3039: FROM okc_k_lines_b
3040: WHERE id = p_cle_id;
3041:
3042: l_assetBillTo_rec assetBillTo_csr%ROWTYPE;
3043: l_acc_gen_primary_key_tbl1 okl_account_dist_pvt.acc_gen_primary_key;

Line 4247: FROM okc_k_lines_b cle,

4243: -- Bug# 6512668: Exclude fee line in Abandoned status
4244: CURSOR check_st_fee_csr(p_chr_id IN NUMBER,
4245: p_fee_type IN VARCHAR2) IS
4246: SELECT cle.id
4247: FROM okc_k_lines_b cle,
4248: okl_k_lines kle
4249: WHERE cle.id = kle.id
4250: AND cle.dnz_chr_id = p_chr_id
4251: AND kle.fee_purpose_code = 'SALESTAX'

Line 4255: l_del_fee_line_id OKC_K_LINES_B.id%TYPE;

4251: AND kle.fee_purpose_code = 'SALESTAX'
4252: AND kle.fee_type = NVL(p_fee_type,kle.fee_type)
4253: AND cle.sts_code <> 'ABANDONED';
4254:
4255: l_del_fee_line_id OKC_K_LINES_B.id%TYPE;
4256: l_del_fee_types_rec OKL_MAINTAIN_FEE_PVT.fee_types_rec_type;
4257: l_fee_type_to_delete OKL_K_LINES.fee_type%TYPE;
4258:
4259: BEGIN

Line 5733: okc_k_lines_b cleb,

5729: kle.fee_type,
5730: kle.amount
5731: --decode(kle.fee_type,'CAPITALIZED',kle.capital_amount,kle.amount) amount
5732: FROM
5733: okc_k_lines_b cleb,
5734: okc_k_lines_tl clet,
5735: okl_k_lines kle,
5736: okc_line_styles_v sty,
5737: okc_statuses_v sts

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

5746: AND kle.id = cleb.id;
5747: l_st_fee_rec st_fee_csr%ROWTYPE;
5748: l_fee_amount okl_k_lines.amount%TYPE;
5749:
5750: CURSOR st_fee_link_asset_csr(p_cleId OKC_K_LINES_B.ID%TYPE) IS
5751: SELECT cleb.id,
5752: nvl(kle.amount,0) amount,
5753: nvl(kle.capital_amount,0) capital_amount
5754: FROM okc_k_lines_b cleb,

Line 5754: FROM okc_k_lines_b cleb,

5750: CURSOR st_fee_link_asset_csr(p_cleId OKC_K_LINES_B.ID%TYPE) IS
5751: SELECT cleb.id,
5752: nvl(kle.amount,0) amount,
5753: nvl(kle.capital_amount,0) capital_amount
5754: FROM okc_k_lines_b cleb,
5755: okl_k_lines kle,
5756: okc_line_styles_b sty
5757: WHERE cle_id = p_cleId
5758: AND cleb.id = kle.id

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

5760: AND sty.lty_code = 'LINK_FEE_ASSET';
5761:
5762: l_st_fee_link_asset_rec st_fee_link_asset_csr%ROWTYPE;
5763:
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,

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

5785: AND lty_code = 'FREE_FORM1'
5786: AND cle.sts_code = sts.code
5787: AND sts.ste_code not in ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
5788:
5789: --CURSOR l_fee_asset_csr(p_assetId OKC_K_LINES_B.ID%TYPE, p_fee_type OKL_K_LINES.FEE_TYPE%TYPE) IS
5790: CURSOR l_fee_asset_csr(p_assetId OKC_K_LINES_B.ID%TYPE) IS
5791: SELECT item.object1_id1,cleb.id,cleb.cle_id,
5792: clet_asset.name,
5793: kle.amount,

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

5786: AND cle.sts_code = sts.code
5787: AND sts.ste_code not in ( 'HOLD', 'TERMINATED', 'EXPIRED', 'CANCELLED');
5788:
5789: --CURSOR l_fee_asset_csr(p_assetId OKC_K_LINES_B.ID%TYPE, p_fee_type OKL_K_LINES.FEE_TYPE%TYPE) IS
5790: CURSOR l_fee_asset_csr(p_assetId OKC_K_LINES_B.ID%TYPE) IS
5791: SELECT item.object1_id1,cleb.id,cleb.cle_id,
5792: clet_asset.name,
5793: kle.amount,
5794: kle.fee_type

Line 5795: FROM okc_k_lines_b fee_line,

5791: SELECT item.object1_id1,cleb.id,cleb.cle_id,
5792: clet_asset.name,
5793: kle.amount,
5794: kle.fee_type
5795: FROM okc_k_lines_b fee_line,
5796: okc_k_lines_b cleb,
5797: okl_k_lines kle,
5798: okc_k_items item,
5799: okc_k_lines_tl clet_asset,

Line 5796: okc_k_lines_b cleb,

5792: clet_asset.name,
5793: kle.amount,
5794: kle.fee_type
5795: FROM okc_k_lines_b fee_line,
5796: okc_k_lines_b cleb,
5797: okl_k_lines kle,
5798: okc_k_items item,
5799: okc_k_lines_tl clet_asset,
5800: okc_line_styles_b sty

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

5821: AND txs.tax_line_status_code = 'ACTIVE'
5822: AND txs.tax_call_type_code = 'UPFRONT_TAX';
5823: l_tax_amount NUMBER;
5824:
5825: CURSOR l_tax_line_amt_csr(p_asset_id OKC_K_LINES_B.ID%TYPE) IS
5826: SELECT SUM(NVL(TOTAL_TAX,0)) tax_amount -- SUM added for 4740150 issue
5827: FROM okl_tax_sources txs
5828: --,okl_tax_trx_details txl
5829: WHERE txs.khr_id = p_chr_id

Line 5839: FROM okc_k_lines_b cleb,

5835:
5836: -- R12B Authoring OA Migration
5837: CURSOR st_fee_count_csr (p_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
5838: SELECT COUNT(cleb.id)
5839: FROM okc_k_lines_b cleb,
5840: okl_k_lines kle,
5841: okc_line_styles_b sty,
5842: okc_statuses_b sts
5843: WHERE cleb.lse_id = sty.id

Line 6372: okc_k_lines_b cle

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'
6376: AND rgp.dnz_chr_id = p_chr_id

Line 6495: FROM okc_k_lines_b cleb,

6491: SELECT kle.id,
6492: kle.amount,
6493: cleb.end_date,
6494: cleb.start_date
6495: FROM okc_k_lines_b cleb,
6496: okl_k_lines kle,
6497: okc_statuses_b okcsts
6498: WHERE cleb.dnz_chr_id = p_chr_id
6499: AND kle.id = cleb.id

Line 6550: p_kle_id OKC_K_LINES_B.ID%TYPE) IS

6546: AND styt.language = USERENV('LANG')
6547: AND sty.id = styt.id;
6548:
6549: CURSOR l_strm_slh_csr (p_khr_id OKC_K_HEADERS_B.ID%TYPE,
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,