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 OKL_TAX_SOURCES

Line 124: FROM okl_tax_sources txs,

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

Line 158: FROM okl_tax_sources txs

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

Line 184: FROM okl_tax_sources txs,

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

Line 212: FROM okl_tax_sources txs,

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

Line 237: FROM okl_tax_sources txs

233: -- This cursor gets biling amount at contract header level
234: CURSOR contract_billing_csr(p_contract_id IN NUMBER,
235: p_transaction_id IN NUMBER) IS
236: SELECT 1
237: FROM okl_tax_sources txs
238: WHERE txs.khr_id = p_contract_id
239: AND txs.trx_id = p_transaction_id
240: AND txs.kle_id IS NULL
241: AND txs.tax_line_status_code = 'ACTIVE'

Line 279: FROM okl_tax_sources

275: FUNCTION check_prior_upfront_tax(p_chr_id IN OKC_K_HEADERS_B.ID%TYPE)
276: RETURN BOOLEAN IS
277: CURSOR c_chk_upfront(cp_chr_id OKC_K_HEADERS_B.ID%TYPE) IS
278: SELECT 'x'
279: FROM okl_tax_sources
280: WHERE khr_id = cp_chr_id
281: AND tax_call_type_code = 'UPFRONT_TAX' ;
282: l_chk VARCHAR2(1) := '?';
283:

Line 1547: FROM okl_tax_sources txs

1543: -- This cursor gets billed upfront tax amount at contract
1544: -- header level
1545: CURSOR contract_billed_tax_csr(p_contract_id IN NUMBER) IS
1546: SELECT NVL(SUM(NVL(total_tax,0)),0)
1547: FROM okl_tax_sources txs
1548: WHERE txs.khr_id = p_contract_id
1549: AND txs.kle_id IS NULL
1550: AND txs.tax_line_status_code = 'ACTIVE'
1551: AND txs.tax_call_type_code = 'UPFRONT_TAX';

Line 1704: FROM okl_tax_sources txs

1700: -- Cursor to get tax amounts for assets
1701: CURSOR get_asset_tax_amt_csr (asset_line_id IN NUMBER)
1702: IS
1703: SELECT NVL(SUM(NVL(total_tax,0)),0)
1704: FROM okl_tax_sources txs
1705: WHERE txs.khr_ID = p_contract_id
1706: AND txs.trx_id = p_transaction_id
1707: AND txs.kle_id = asset_line_id
1708: AND txs.tax_line_status_code = 'ACTIVE'

Line 2618: FROM okl_tax_sources txs

2614: -- Cursor to get tax amounts for assets
2615: CURSOR get_asset_tax_amt_csr (asset_line_id IN NUMBER)
2616: IS
2617: SELECT NVL(SUM(NVL(TOTAL_TAX,0)),0)
2618: FROM okl_tax_sources txs
2619: WHERE txs.KHR_ID = p_contract_id
2620: AND txs.trx_id = p_transaction_id
2621: AND txs.kle_id = asset_line_id
2622: AND txs.TAX_LINE_STATUS_CODE = 'ACTIVE'

Line 3423: , okl_tax_sources txs

3419: , txl.tax_line_id tax_line_id
3420: , txl.tax_amt tax_amount
3421: FROM OKC_RULES_V rul
3422: , OKC_RULE_GROUPS_V rgp
3423: , okl_tax_sources txs
3424: , zx_lines txl
3425: WHERE rul.rgp_id = rgp.id
3426: AND rgp.dnz_chr_id = p_contract_id
3427: AND rgp.rgd_code = 'LAASTX'

Line 3461: , okl_tax_sources txs

3457: , txl.tax_line_id tax_line_id
3458: , txl.tax_amt tax_amount
3459: FROM OKC_RULES_V rul
3460: , OKC_RULE_GROUPS_V rgp
3461: , okl_tax_sources txs
3462: , zx_lines txl
3463: WHERE rul.rgp_id = rgp.id
3464: AND rgp.dnz_chr_id = p_contract_id
3465: AND rgp.rgd_code = 'LAASTX'

Line 3497: , okl_tax_sources txs

3493: , txl.tax_line_id tax_line_id
3494: , txl.tax_amt tax_amount
3495: FROM OKC_RULES_V rul
3496: , OKC_RULE_GROUPS_V rgp
3497: , okl_tax_sources txs
3498: , zx_lines txl
3499: WHERE rul.rgp_id = rgp.id
3500: AND rgp.dnz_chr_id = p_contract_id
3501: AND rgp.rgd_code = 'LAASTX'

Line 3530: FROM okl_tax_sources txs

3526: , txs.kle_id asset_id
3527: , txs.id tax_header_id
3528: , txl.tax_line_id tax_line_id
3529: , txl.tax_amt tax_amount
3530: FROM okl_tax_sources txs
3531: , zx_lines txl
3532: WHERE txs.khr_id = p_contract_id
3533: AND txs.kle_id IS NULL
3534: AND txs.TAX_LINE_STATUS_CODE = 'ACTIVE'

Line 3580: , okl_tax_sources txs

3576: , txl.tax_line_id tax_line_id
3577: , txl.tax_amt tax_amount
3578: FROM OKC_RULES_V rul
3579: , OKC_RULE_GROUPS_V rgp
3580: , okl_tax_sources txs
3581: , zx_lines txl
3582: WHERE rul.rgp_id = rgp.id
3583: AND rgp.dnz_chr_id = p_contract_id
3584: AND rgp.rgd_code = 'LAASTX'

Line 3608: FROM okl_tax_sources

3604: AND (txs.trx_id,txs.trx_line_id)
3605: IN
3606: (SELECT adjusted_doc_trx_id
3607: ,adjusted_doc_trx_line_id
3608: FROM okl_tax_sources
3609: WHERE trx_id = p_rbk_trx_id
3610: AND tax_line_status_code = 'INACTIVE'
3611: AND adjusted_doc_trx_id IS NOT NULL
3612: AND adjusted_doc_trx_line_id IS NOT NULL);

Line 3627: , okl_tax_sources txs

3623: , txl.tax_line_id tax_line_id
3624: , txl.tax_amt tax_amount
3625: FROM OKC_RULES_V rul
3626: , OKC_RULE_GROUPS_V rgp
3627: , okl_tax_sources txs
3628: , zx_lines txl
3629: WHERE rul.rgp_id = rgp.id
3630: AND rgp.dnz_chr_id = p_contract_id
3631: AND rgp.rgd_code = 'LAASTX'

Line 3653: FROM okl_tax_sources

3649: AND (txs.trx_id,txs.trx_line_id)
3650: IN
3651: (SELECT adjusted_doc_trx_id
3652: ,adjusted_doc_trx_line_id
3653: FROM okl_tax_sources
3654: WHERE trx_id = p_rbk_trx_id
3655: AND tax_line_status_code = 'INACTIVE'
3656: AND adjusted_doc_trx_id IS NOT NULL
3657: AND adjusted_doc_trx_line_id IS NOT NULL);

Line 3672: , okl_tax_sources txs

3668: , txl.tax_line_id tax_line_id
3669: , txl.tax_amt tax_amount
3670: FROM OKC_RULES_V rul
3671: , OKC_RULE_GROUPS_V rgp
3672: , okl_tax_sources txs
3673: , zx_lines txl
3674: WHERE rul.rgp_id = rgp.id
3675: AND rgp.dnz_chr_id = p_contract_id
3676: AND rgp.rgd_code = 'LAASTX'

Line 3698: FROM okl_tax_sources

3694: AND (txs.trx_id,txs.trx_line_id)
3695: IN
3696: (SELECT adjusted_doc_trx_id
3697: ,adjusted_doc_trx_line_id
3698: FROM okl_tax_sources
3699: WHERE trx_id = p_rbk_trx_id
3700: AND tax_line_status_code = 'INACTIVE'
3701: AND adjusted_doc_trx_id IS NOT NULL
3702: AND adjusted_doc_trx_line_id IS NOT NULL);

Line 3714: FROM okl_tax_sources txs

3710: , txs.kle_id asset_id
3711: , txs.id tax_header_id
3712: , txl.tax_line_id tax_line_id
3713: , txl.tax_amt tax_amount
3714: FROM okl_tax_sources txs
3715: , zx_lines txl
3716: WHERE txs.khr_id = p_contract_id
3717: AND txs.kle_id IS NULL
3718: AND txs.TAX_LINE_STATUS_CODE = 'INACTIVE'

Line 3734: FROM okl_tax_sources

3730: AND (txs.trx_id,txs.trx_line_id)
3731: IN
3732: (SELECT adjusted_doc_trx_id
3733: ,adjusted_doc_trx_line_id
3734: FROM okl_tax_sources
3735: WHERE trx_id = p_rbk_trx_id
3736: AND tax_line_status_code = 'INACTIVE'
3737: AND adjusted_doc_trx_id IS NOT NULL
3738: AND adjusted_doc_trx_line_id IS NOT NULL);

Line 6213: FROM okl_tax_sources txs

6209: --l_fee_asset_rec l_fee_asset_csr%ROWTYPE;
6210:
6211: CURSOR l_tax_amt_csr IS
6212: SELECT SUM(NVL(TOTAL_TAX,0))
6213: FROM okl_tax_sources txs
6214: --,okl_tax_trx_details txl
6215: WHERE txs.khr_id = p_chr_id
6216: --AND txs.id = txl.txs_id
6217: AND txs.tax_line_status_code = 'ACTIVE'

Line 6223: FROM okl_tax_sources txs

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
6226: -- AND txs.id = txl.txs_id
6227: AND txs.tax_line_status_code = 'ACTIVE'