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 106: FROM okl_tax_sources txs,

102: -- Bug# 6512668: Exclude asset lines in Abandoned status
103: CURSOR get_fee_amt_csr1(p_contract_id IN NUMBER, p_feetype IN VARCHAR2)
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,

Line 140: FROM okl_tax_sources txs

136: -- Bug# 6512668: Exclude asset lines in Abandoned status
137: CURSOR get_fee_amt_csr2 (p_contract_id IN NUMBER, p_feetype IN VARCHAR2)
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

Line 166: FROM okl_tax_sources txs,

162: -- Bug# 6512668: Exclude asset lines in Abandoned status
163: CURSOR billing_required_csr1(p_contract_id IN NUMBER,
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

Line 194: FROM okl_tax_sources txs,

190: -- Bug# 6512668: Exclude asset lines in Abandoned status
191: CURSOR billing_required_csr2(p_contract_id IN NUMBER,
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

Line 219: FROM okl_tax_sources txs

215: -- This cursor gets biling amount at contract header level
216: CURSOR contract_billing_csr(p_contract_id IN NUMBER,
217: p_transaction_id IN NUMBER) IS
218: SELECT 1
219: FROM okl_tax_sources txs
220: WHERE txs.khr_id = p_contract_id
221: AND txs.trx_id = p_transaction_id
222: AND txs.kle_id IS NULL
223: AND txs.tax_line_status_code = 'ACTIVE'

Line 1361: FROM okl_tax_sources txs

1357: -- This cursor gets billed upfront tax amount at contract
1358: -- header level
1359: CURSOR contract_billed_tax_csr(p_contract_id IN NUMBER) IS
1360: SELECT NVL(SUM(NVL(total_tax,0)),0)
1361: FROM okl_tax_sources txs
1362: WHERE txs.khr_id = p_contract_id
1363: AND txs.kle_id IS NULL
1364: AND txs.tax_line_status_code = 'ACTIVE'
1365: AND txs.tax_call_type_code = 'UPFRONT_TAX';

Line 1518: FROM okl_tax_sources txs

1514: -- Cursor to get tax amounts for assets
1515: CURSOR get_asset_tax_amt_csr (asset_line_id IN NUMBER)
1516: IS
1517: SELECT NVL(SUM(NVL(total_tax,0)),0)
1518: FROM okl_tax_sources txs
1519: WHERE txs.khr_ID = p_contract_id
1520: AND txs.trx_id = p_transaction_id
1521: AND txs.kle_id = asset_line_id
1522: AND txs.tax_line_status_code = 'ACTIVE'

Line 2414: FROM okl_tax_sources txs

2410: -- Cursor to get tax amounts for assets
2411: CURSOR get_asset_tax_amt_csr (asset_line_id IN NUMBER)
2412: IS
2413: SELECT NVL(SUM(NVL(TOTAL_TAX,0)),0)
2414: FROM okl_tax_sources txs
2415: WHERE txs.KHR_ID = p_contract_id
2416: AND txs.trx_id = p_transaction_id
2417: AND txs.kle_id = asset_line_id
2418: AND txs.TAX_LINE_STATUS_CODE = 'ACTIVE'

Line 3219: , okl_tax_sources txs

3215: , txl.tax_line_id tax_line_id
3216: , txl.tax_amt tax_amount
3217: FROM OKC_RULES_V rul
3218: , OKC_RULE_GROUPS_V rgp
3219: , okl_tax_sources txs
3220: , zx_lines txl
3221: WHERE rul.rgp_id = rgp.id
3222: AND rgp.dnz_chr_id = p_contract_id
3223: AND rgp.rgd_code = 'LAASTX'

Line 3257: , okl_tax_sources txs

3253: , txl.tax_line_id tax_line_id
3254: , txl.tax_amt tax_amount
3255: FROM OKC_RULES_V rul
3256: , OKC_RULE_GROUPS_V rgp
3257: , okl_tax_sources txs
3258: , zx_lines txl
3259: WHERE rul.rgp_id = rgp.id
3260: AND rgp.dnz_chr_id = p_contract_id
3261: AND rgp.rgd_code = 'LAASTX'

Line 3293: , okl_tax_sources txs

3289: , txl.tax_line_id tax_line_id
3290: , txl.tax_amt tax_amount
3291: FROM OKC_RULES_V rul
3292: , OKC_RULE_GROUPS_V rgp
3293: , okl_tax_sources txs
3294: , zx_lines txl
3295: WHERE rul.rgp_id = rgp.id
3296: AND rgp.dnz_chr_id = p_contract_id
3297: AND rgp.rgd_code = 'LAASTX'

Line 3326: FROM okl_tax_sources txs

3322: , txs.kle_id asset_id
3323: , txs.id tax_header_id
3324: , txl.tax_line_id tax_line_id
3325: , txl.tax_amt tax_amount
3326: FROM okl_tax_sources txs
3327: , zx_lines txl
3328: WHERE txs.khr_id = p_contract_id
3329: AND txs.kle_id IS NULL
3330: AND txs.TAX_LINE_STATUS_CODE = 'ACTIVE'

Line 3376: , okl_tax_sources txs

3372: , txl.tax_line_id tax_line_id
3373: , txl.tax_amt tax_amount
3374: FROM OKC_RULES_V rul
3375: , OKC_RULE_GROUPS_V rgp
3376: , okl_tax_sources txs
3377: , zx_lines txl
3378: WHERE rul.rgp_id = rgp.id
3379: AND rgp.dnz_chr_id = p_contract_id
3380: AND rgp.rgd_code = 'LAASTX'

Line 3404: FROM okl_tax_sources

3400: AND (txs.trx_id,txs.trx_line_id)
3401: IN
3402: (SELECT adjusted_doc_trx_id
3403: ,adjusted_doc_trx_line_id
3404: FROM okl_tax_sources
3405: WHERE trx_id = p_rbk_trx_id
3406: AND tax_line_status_code = 'INACTIVE'
3407: AND adjusted_doc_trx_id IS NOT NULL
3408: AND adjusted_doc_trx_line_id IS NOT NULL);

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 3449: FROM okl_tax_sources

3445: AND (txs.trx_id,txs.trx_line_id)
3446: IN
3447: (SELECT adjusted_doc_trx_id
3448: ,adjusted_doc_trx_line_id
3449: FROM okl_tax_sources
3450: WHERE trx_id = p_rbk_trx_id
3451: AND tax_line_status_code = 'INACTIVE'
3452: AND adjusted_doc_trx_id IS NOT NULL
3453: AND adjusted_doc_trx_line_id IS NOT NULL);

Line 3468: , okl_tax_sources txs

3464: , txl.tax_line_id tax_line_id
3465: , txl.tax_amt tax_amount
3466: FROM OKC_RULES_V rul
3467: , OKC_RULE_GROUPS_V rgp
3468: , okl_tax_sources txs
3469: , zx_lines txl
3470: WHERE rul.rgp_id = rgp.id
3471: AND rgp.dnz_chr_id = p_contract_id
3472: AND rgp.rgd_code = 'LAASTX'

Line 3494: FROM okl_tax_sources

3490: AND (txs.trx_id,txs.trx_line_id)
3491: IN
3492: (SELECT adjusted_doc_trx_id
3493: ,adjusted_doc_trx_line_id
3494: FROM okl_tax_sources
3495: WHERE trx_id = p_rbk_trx_id
3496: AND tax_line_status_code = 'INACTIVE'
3497: AND adjusted_doc_trx_id IS NOT NULL
3498: AND adjusted_doc_trx_line_id IS NOT NULL);

Line 3510: FROM okl_tax_sources txs

3506: , txs.kle_id asset_id
3507: , txs.id tax_header_id
3508: , txl.tax_line_id tax_line_id
3509: , txl.tax_amt tax_amount
3510: FROM okl_tax_sources txs
3511: , zx_lines txl
3512: WHERE txs.khr_id = p_contract_id
3513: AND txs.kle_id IS NULL
3514: AND txs.TAX_LINE_STATUS_CODE = 'INACTIVE'

Line 3530: FROM okl_tax_sources

3526: AND (txs.trx_id,txs.trx_line_id)
3527: IN
3528: (SELECT adjusted_doc_trx_id
3529: ,adjusted_doc_trx_line_id
3530: FROM okl_tax_sources
3531: WHERE trx_id = p_rbk_trx_id
3532: AND tax_line_status_code = 'INACTIVE'
3533: AND adjusted_doc_trx_id IS NOT NULL
3534: AND adjusted_doc_trx_line_id IS NOT NULL);

Line 5817: FROM okl_tax_sources txs

5813: --l_fee_asset_rec l_fee_asset_csr%ROWTYPE;
5814:
5815: CURSOR l_tax_amt_csr IS
5816: SELECT SUM(NVL(TOTAL_TAX,0))
5817: FROM okl_tax_sources txs
5818: --,okl_tax_trx_details txl
5819: WHERE txs.khr_id = p_chr_id
5820: --AND txs.id = txl.txs_id
5821: AND txs.tax_line_status_code = 'ACTIVE'

Line 5827: FROM okl_tax_sources txs

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