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.AP_ETAX_SERVICES_PKG dependencies on AP_SELF_ASSESSED_TAX_DIST_ALL

Line 3607: UPDATE ap_self_assessed_tax_dist_all

3603: --Bug9494315
3604:
3605: --Bug9777752
3606:
3607: UPDATE ap_self_assessed_tax_dist_all
3608: SET distribution_class = 'PERMANENT'
3609: WHERE invoice_id = l_inv_header_rec.invoice_id
3610: AND distribution_class = 'CANDIDATE'
3611: AND line_type_lookup_code IN ('REC_TAX','NONREC_TAX','TRV','TERV','TIPV');

Line 4389: FROM ap_self_assessed_tax_dist_all

4385: corrected_invoice_dist_id,
4386: invoice_distribution_id,
4387: detail_tax_dist_id,
4388: accounting_event_id
4389: FROM ap_self_assessed_tax_dist_all
4390: WHERE invoice_id = p_invoice_header_rec.invoice_id
4391: AND line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX', 'TRV', 'TERV', 'TIPV')
4392: AND (related_id IS NULL
4393: OR (related_id = invoice_distribution_id

Line 12922: -- Bug 6694536. Added cursor to fetch reversal lines from ap_self_assessed_tax_dist_all.

12918:
12919: l_reverse_tax_dist c_reverse_tax_dist%rowtype ;
12920:
12921: /*
12922: -- Bug 6694536. Added cursor to fetch reversal lines from ap_self_assessed_tax_dist_all.
12923: -- Cursor is similar to c_reverse_tax_dist, except it is using ap_self_assessed_tax_dist_all
12924: -- to fetch lines.
12925: */
12926:

Line 12923: -- Cursor is similar to c_reverse_tax_dist, except it is using ap_self_assessed_tax_dist_all

12919: l_reverse_tax_dist c_reverse_tax_dist%rowtype ;
12920:
12921: /*
12922: -- Bug 6694536. Added cursor to fetch reversal lines from ap_self_assessed_tax_dist_all.
12923: -- Cursor is similar to c_reverse_tax_dist, except it is using ap_self_assessed_tax_dist_all
12924: -- to fetch lines.
12925: */
12926:
12927: cursor c_rev_self_assess_tax_dist is

Line 13116: from ap_self_assessed_tax_dist_all tax_dist,

13112: zx_dist.self_assessed_flag self_assessed_flag,
13113: -- bug 6805655
13114: tax_dist.self_assessed_tax_liab_ccid self_assessed_tax_liab_ccid,
13115: (-1)*tax_dist.prepay_tax_diff_amount prepay_tax_diff_amount -- BUG 7338249 bug 9040333 added (-1)* as this is reversal
13116: from ap_self_assessed_tax_dist_all tax_dist,
13117: ap_invoice_distributions_all item_dist,
13118: zx_rec_nrec_dist zx_dist
13119: where tax_dist.invoice_id = p_invoice_id
13120: /* -- Bug8575619 start */

Line 13143: FROM ap_self_assessed_tax_dist_all aid

13139: and aid.detail_tax_dist_id = zx_dist.rec_nrec_tax_dist_id)
13140: */
13141: AND NOT EXISTS
13142: (SELECT aid.detail_tax_dist_id
13143: FROM ap_self_assessed_tax_dist_all aid
13144: WHERE aid.invoice_id = p_invoice_id
13145: AND aid.detail_tax_dist_id = zx_dist.rec_nrec_tax_dist_id
13146: AND aid.line_type_lookup_code IN ('REC_TAX','NONREC_TAX'))
13147: -- bug 6896627

Line 13151: -- Bug 6694536. Added cursor to fetch reversal lines from ap_self_assessed_tax_dist_all.

13147: -- bug 6896627
13148: ;
13149:
13150: /*
13151: -- Bug 6694536. Added cursor to fetch reversal lines from ap_self_assessed_tax_dist_all.
13152: -- Cursor is similar to c_reverse_tax_dist_1, except it is using ap_self_assessed_tax_dist_all
13153: -- to fetch lines. Second cursor for performance reasons(bug 6056777)
13154: */
13155:

Line 13152: -- Cursor is similar to c_reverse_tax_dist_1, except it is using ap_self_assessed_tax_dist_all

13148: ;
13149:
13150: /*
13151: -- Bug 6694536. Added cursor to fetch reversal lines from ap_self_assessed_tax_dist_all.
13152: -- Cursor is similar to c_reverse_tax_dist_1, except it is using ap_self_assessed_tax_dist_all
13153: -- to fetch lines. Second cursor for performance reasons(bug 6056777)
13154: */
13155:
13156: cursor c_rev_self_assess_tax_dist_1 is

Line 13345: from ap_self_assessed_tax_dist_all tax_dist,

13341: zx_dist.self_assessed_flag self_assessed_flag,
13342: -- bug 6805655
13343: tax_dist.self_assessed_tax_liab_ccid self_assessed_tax_liab_ccid,
13344: (-1)*tax_dist.prepay_tax_diff_amount prepay_tax_diff_amount-- BUG 7338249 bug 9040333 added (-1)* as this is reversal
13345: from ap_self_assessed_tax_dist_all tax_dist,
13346: ap_invoice_distributions_all item_dist,
13347: zx_rec_nrec_dist zx_dist
13348: where tax_dist.invoice_id = p_invoice_id
13349: /* -- Bug8575619 start */

Line 13372: FROM ap_self_assessed_tax_dist_all aid

13368: */
13369:
13370: AND NOT EXISTS
13371: (SELECT aid.detail_tax_dist_id
13372: FROM ap_self_assessed_tax_dist_all aid
13373: WHERE aid.invoice_id = p_invoice_id
13374: AND aid.detail_tax_dist_id = zx_dist.rec_nrec_tax_dist_id
13375: AND aid.line_type_lookup_code IN ('REC_TAX','NONREC_TAX'))
13376: -- bug 6896627

Line 13789: -- reversed. Fetched tax distributions from ap_self_assessed_tax_dist_all.

13785: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
13786: END IF;
13787:
13788: -- Populating zx_reverse_dist_gt with self assessed entries that has to be
13789: -- reversed. Fetched tax distributions from ap_self_assessed_tax_dist_all.
13790: -- ITEM line is already reversed in Discard method. reverse_dist refers to
13791: -- the reversed item line.
13792:
13793: INSERT INTO zx_reverse_dist_gt(

Line 13831: ap_self_assessed_tax_dist_all tax_dist,

13827: zx_dist.trx_line_id reversed_trx_line_id,
13828: zx_dist.trx_line_dist_id reversed_trx_line_dist_id,
13829: zx_dist.tax_line_id reversed_tax_line_id
13830: from ap_invoice_distributions_all item_dist,
13831: ap_self_assessed_tax_dist_all tax_dist,
13832: ap_invoice_distributions_all reverse_dist,
13833: zx_rec_nrec_dist zx_dist
13834: where tax_dist.invoice_id = p_invoice_id
13835: and tax_dist.invoice_id = item_dist.invoice_id

Line 13858: FROM ap_self_assessed_tax_dist_all tax_dist

13854: IF l_rev_sa_dist_count = 0 THEN
13855: IF p_line_number IS NULL THEN
13856: SELECT COUNT(1)
13857: INTO l_unrev_sa_dist_count
13858: FROM ap_self_assessed_tax_dist_all tax_dist
13859: WHERE tax_dist.invoice_id = p_invoice_id
13860: AND tax_dist.line_type_lookup_code IN ('NONREC_TAX', 'REC_TAX' )
13861: AND tax_dist.charge_applicable_to_dist_id IS NOT NULL
13862: AND tax_dist.detail_tax_dist_id IS NOT NULL

Line 13865: FROM ap_self_assessed_tax_dist_all rev_tax_dist

13861: AND tax_dist.charge_applicable_to_dist_id IS NOT NULL
13862: AND tax_dist.detail_tax_dist_id IS NOT NULL
13863: AND tax_dist.parent_reversal_id IS NULL
13864: AND NOT EXISTS ( SELECT 1
13865: FROM ap_self_assessed_tax_dist_all rev_tax_dist
13866: WHERE rev_tax_dist.invoice_id = p_invoice_id
13867: AND rev_tax_dist.parent_reversal_id = tax_dist.invoice_distribution_id
13868: )
13869: AND ROWNUM = 1 ;

Line 13873: FROM ap_self_assessed_tax_dist_all tax_dist

13869: AND ROWNUM = 1 ;
13870: ELSE
13871: SELECT COUNT(1)
13872: INTO l_unrev_sa_dist_count
13873: FROM ap_self_assessed_tax_dist_all tax_dist
13874: WHERE tax_dist.invoice_id = p_invoice_id
13875: AND tax_dist.line_type_lookup_code IN ('NONREC_TAX', 'REC_TAX' )
13876: AND tax_dist.charge_applicable_to_dist_id IS NOT NULL
13877: AND tax_dist.detail_tax_dist_id IS NOT NULL

Line 13880: FROM ap_self_assessed_tax_dist_all rev_tax_dist

13876: AND tax_dist.charge_applicable_to_dist_id IS NOT NULL
13877: AND tax_dist.detail_tax_dist_id IS NOT NULL
13878: AND tax_dist.parent_reversal_id IS NULL
13879: AND NOT EXISTS ( SELECT 1
13880: FROM ap_self_assessed_tax_dist_all rev_tax_dist
13881: WHERE rev_tax_dist.invoice_id = p_invoice_id
13882: AND rev_tax_dist.parent_reversal_id = tax_dist.invoice_distribution_id
13883: )
13884: AND tax_dist.charge_applicable_to_dist_id IN

Line 14643: INSERT INTO ap_self_assessed_tax_dist_all (

14639: END;
14640: END IF;
14641: --bug 13101979 ends
14642:
14643: INSERT INTO ap_self_assessed_tax_dist_all (
14644: accounting_date,
14645: accrual_posted_flag,
14646: assets_addition_flag,
14647: assets_tracking_flag,

Line 15378: l_debug_info := 'Inserting reverse entries into ap_self_assessed_tax_dist_all';

15374:
15375:
15376: IF l_self_assess_tax_dist_exist THEN -- Marker 8
15377:
15378: l_debug_info := 'Inserting reverse entries into ap_self_assessed_tax_dist_all';
15379: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
15380: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
15381: END IF;
15382:

Line 15389: INSERT INTO ap_self_assessed_tax_dist_all (

15385: FETCH c_rev_self_assess_tax_dist_1
15386: INTO l_self_assess_rev_tax_dist_1;
15387: EXIT WHEN c_rev_self_assess_tax_dist_1%NOTFOUND;
15388:
15389: INSERT INTO ap_self_assessed_tax_dist_all (
15390: accounting_date,
15391: accrual_posted_flag,
15392: assets_addition_flag,
15393: assets_tracking_flag,

Line 15822: UPDATE ap_self_assessed_tax_dist_all aid

15818: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
15819: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
15820: END IF;
15821:
15822: UPDATE ap_self_assessed_tax_dist_all aid
15823: SET reversal_flag = (select reverse_flag
15824: from zx_rec_nrec_dist zx
15825: where zx.rec_nrec_tax_dist_id = aid.detail_tax_dist_id)
15826: WHERE aid.invoice_id = p_invoice_id

Line 15836: UPDATE ap_self_assessed_tax_dist_all aid

15832: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
15833: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
15834: END IF;
15835:
15836: UPDATE ap_self_assessed_tax_dist_all aid
15837: SET aid.related_id =
15838: (SELECT invoice_distribution_id
15839: FROM ap_self_assessed_tax_dist_all aid1
15840: WHERE aid1.invoice_id = aid.invoice_id

Line 15839: FROM ap_self_assessed_tax_dist_all aid1

15835:
15836: UPDATE ap_self_assessed_tax_dist_all aid
15837: SET aid.related_id =
15838: (SELECT invoice_distribution_id
15839: FROM ap_self_assessed_tax_dist_all aid1
15840: WHERE aid1.invoice_id = aid.invoice_id
15841: AND aid1.invoice_line_number = aid.invoice_line_number
15842: AND aid1.parent_reversal_id =
15843: (SELECT related_id

Line 15844: FROM ap_self_assessed_tax_dist_all aid2

15840: WHERE aid1.invoice_id = aid.invoice_id
15841: AND aid1.invoice_line_number = aid.invoice_line_number
15842: AND aid1.parent_reversal_id =
15843: (SELECT related_id
15844: FROM ap_self_assessed_tax_dist_all aid2
15845: WHERE aid2.invoice_id = aid.invoice_id
15846: AND aid2.invoice_line_number = aid.invoice_line_number
15847: AND aid2.invoice_distribution_id = aid.parent_reversal_id)
15848: )

Line 16309: From ap_self_assessed_tax_dist_all

16305: AND distribution_class = 'CANDIDATE'
16306: And line_type_lookup_code In('NONREC_TAX', 'REC_TAX', 'TRV', 'TERV', 'TIPV')
16307: UNION
16308: Select distinct detail_tax_dist_id
16309: From ap_self_assessed_tax_dist_all
16310: Where invoice_id = p_invoice_id
16311: AND distribution_class = 'CANDIDATE'
16312: And line_type_lookup_code In('NONREC_TAX', 'REC_TAX', 'TRV', 'TERV', 'TIPV'));
16313: --bug9749528

Line 16461: FROM ap_self_assessed_tax_dist_all asat,

16457: END IF;
16458:
16459: SELECT 'Tax Distributions Exist'
16460: INTO l_dummy
16461: FROM ap_self_assessed_tax_dist_all asat,
16462: zx_rec_nrec_dist zx_dist
16463: WHERE invoice_id = p_invoice_id
16464: AND asat.detail_tax_dist_id = zx_dist.rec_nrec_tax_dist_id
16465: AND zx_dist.self_assessed_flag = 'Y'

Line 17398: FROM ap_self_assessed_tax_dist_all aid_reverse,

17394: CURSOR c_reverse_dist_sa (c_invoice_id NUMBER) IS
17395: SELECT aid_reverse.invoice_distribution_id invoice_distribution_id,
17396: aid_parent.invoice_distribution_id parent_reversal_id,
17397: aid_parent.dist_code_combination_id parent_ccid
17398: FROM ap_self_assessed_tax_dist_all aid_reverse,
17399: ap_self_assessed_tax_dist_all aid_parent,
17400: zx_rec_nrec_dist zx
17401: WHERE aid_reverse.invoice_id = c_invoice_id
17402: AND aid_reverse.detail_tax_dist_id = zx.rec_nrec_tax_dist_id

Line 17399: ap_self_assessed_tax_dist_all aid_parent,

17395: SELECT aid_reverse.invoice_distribution_id invoice_distribution_id,
17396: aid_parent.invoice_distribution_id parent_reversal_id,
17397: aid_parent.dist_code_combination_id parent_ccid
17398: FROM ap_self_assessed_tax_dist_all aid_reverse,
17399: ap_self_assessed_tax_dist_all aid_parent,
17400: zx_rec_nrec_dist zx
17401: WHERE aid_reverse.invoice_id = c_invoice_id
17402: AND aid_reverse.detail_tax_dist_id = zx.rec_nrec_tax_dist_id
17403: AND aid_parent.detail_tax_dist_id = zx.reversed_tax_dist_id

Line 17508: UPDATE ap_self_assessed_tax_dist_all aid

17504: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
17505: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
17506: END IF;
17507:
17508: UPDATE ap_self_assessed_tax_dist_all aid
17509: SET related_id = (SELECT DECODE(MIN(nrtax.invoice_distribution_id),
17510: NULL, MIN(other.invoice_distribution_id),
17511: MIN(nrtax.invoice_distribution_id))
17512: FROM ap_self_assessed_tax_dist_all nrtax,

Line 17512: FROM ap_self_assessed_tax_dist_all nrtax,

17508: UPDATE ap_self_assessed_tax_dist_all aid
17509: SET related_id = (SELECT DECODE(MIN(nrtax.invoice_distribution_id),
17510: NULL, MIN(other.invoice_distribution_id),
17511: MIN(nrtax.invoice_distribution_id))
17512: FROM ap_self_assessed_tax_dist_all nrtax,
17513: ap_self_assessed_tax_dist_all other
17514: WHERE nrtax.invoice_id = aid.invoice_id
17515: AND other.invoice_id = aid.invoice_id
17516: AND nrtax.detail_tax_dist_id = aid.detail_tax_dist_id

Line 17513: ap_self_assessed_tax_dist_all other

17509: SET related_id = (SELECT DECODE(MIN(nrtax.invoice_distribution_id),
17510: NULL, MIN(other.invoice_distribution_id),
17511: MIN(nrtax.invoice_distribution_id))
17512: FROM ap_self_assessed_tax_dist_all nrtax,
17513: ap_self_assessed_tax_dist_all other
17514: WHERE nrtax.invoice_id = aid.invoice_id
17515: AND other.invoice_id = aid.invoice_id
17516: AND nrtax.detail_tax_dist_id = aid.detail_tax_dist_id
17517: AND other.detail_tax_dist_id = aid.detail_tax_dist_id

Line 17525: FROM ap_self_assessed_tax_dist_all aid1

17521: GROUP BY 1)
17522: WHERE aid.invoice_id = P_Invoice_Header_Rec.invoice_id
17523: AND aid.line_type_lookup_code in ('NONREC_TAX', 'TIPV', 'TRV', 'TERV')
17524: AND EXISTS (SELECT aid1.detail_tax_dist_id
17525: FROM ap_self_assessed_tax_dist_all aid1
17526: WHERE aid1.invoice_id = aid.invoice_id
17527: AND aid1.detail_tax_dist_id = aid.detail_tax_dist_id
17528: HAVING count(*) > 1
17529: GROUP BY aid1.detail_tax_dist_id);

Line 17557: UPDATE ap_self_assessed_tax_dist_all aid

17553: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
17554: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
17555: END IF;
17556:
17557: UPDATE ap_self_assessed_tax_dist_all aid
17558: SET rounding_amt =
17559: (SELECT zd.func_curr_rounding_adjustment
17560: FROM zx_rec_nrec_dist zd
17561: WHERE zd.rec_nrec_tax_dist_id = aid.detail_tax_dist_id)

Line 17850: UPDATE ap_self_assessed_tax_dist_all

17846:
17847: IF l_reveral_dist_tab.count > 0 THEN
17848: FOR h in l_reveral_dist_tab.first .. l_reveral_dist_tab.last LOOP
17849:
17850: UPDATE ap_self_assessed_tax_dist_all
17851: SET parent_reversal_id = l_reveral_dist_tab(h).parent_reversal_id
17852: ,dist_code_combination_id = l_reveral_dist_tab(h).parent_ccid
17853: WHERE invoice_distribution_id = l_reveral_dist_tab(h).invoice_distribution_id
17854: AND nvl(reversal_flag, 'N') <> 'Y';

Line 17883: UPDATE ap_self_assessed_tax_dist_all aid

17879: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
17880: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
17881: END IF;
17882:
17883: UPDATE ap_self_assessed_tax_dist_all aid
17884: SET reversal_flag = (select reverse_flag
17885: from zx_rec_nrec_dist zx
17886: where zx.rec_nrec_tax_dist_id = aid.detail_tax_dist_id)
17887: WHERE aid.invoice_id = p_invoice_header_rec.invoice_id