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 3542: FROM ap_self_assessed_tax_dist_all

3538: corrected_invoice_dist_id,
3539: invoice_distribution_id,
3540: detail_tax_dist_id,
3541: accounting_event_id
3542: FROM ap_self_assessed_tax_dist_all
3543: WHERE invoice_id = p_invoice_header_rec.invoice_id
3544: AND line_type_lookup_code IN ('REC_TAX', 'NONREC_TAX', 'TRV', 'TERV', 'TIPV')
3545: AND (related_id IS NULL
3546: OR (related_id = invoice_distribution_id

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

10192:
10193: l_reverse_tax_dist c_reverse_tax_dist%rowtype ;
10194:
10195: /*
10196: -- Bug 6694536. Added cursor to fetch reversal lines from ap_self_assessed_tax_dist_all.
10197: -- Cursor is similar to c_reverse_tax_dist, except it is using ap_self_assessed_tax_dist_all
10198: -- to fetch lines.
10199: */
10200:

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

10193: l_reverse_tax_dist c_reverse_tax_dist%rowtype ;
10194:
10195: /*
10196: -- Bug 6694536. Added cursor to fetch reversal lines from ap_self_assessed_tax_dist_all.
10197: -- Cursor is similar to c_reverse_tax_dist, except it is using ap_self_assessed_tax_dist_all
10198: -- to fetch lines.
10199: */
10200:
10201: cursor c_rev_self_assess_tax_dist is

Line 10386: from ap_self_assessed_tax_dist_all tax_dist,

10382: zx_dist.self_assessed_flag self_assessed_flag,
10383: -- bug 6805655
10384: tax_dist.self_assessed_tax_liab_ccid self_assessed_tax_liab_ccid,
10385: tax_dist.prepay_tax_diff_amount -- BUG 7338249
10386: from ap_self_assessed_tax_dist_all tax_dist,
10387: ap_invoice_distributions_all item_dist,
10388: zx_rec_nrec_dist zx_dist
10389: where tax_dist.invoice_id = p_invoice_id
10390: and tax_dist.line_type_lookup_code IN ('NONREC_TAX', 'REC_TAX')

Line 10405: FROM ap_self_assessed_tax_dist_all aid

10401: and aid.detail_tax_dist_id = zx_dist.rec_nrec_tax_dist_id)
10402: */
10403: AND NOT EXISTS
10404: (SELECT aid.detail_tax_dist_id
10405: FROM ap_self_assessed_tax_dist_all aid
10406: WHERE aid.invoice_id = p_invoice_id
10407: AND aid.detail_tax_dist_id = zx_dist.rec_nrec_tax_dist_id
10408: AND aid.line_type_lookup_code IN ('REC_TAX','NONREC_TAX'))
10409: -- bug 6896627

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

10409: -- bug 6896627
10410: ;
10411:
10412: /*
10413: -- Bug 6694536. Added cursor to fetch reversal lines from ap_self_assessed_tax_dist_all.
10414: -- Cursor is similar to c_reverse_tax_dist_1, except it is using ap_self_assessed_tax_dist_all
10415: -- to fetch lines. Second cursor for performance reasons(bug 6056777)
10416: */
10417:

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

10410: ;
10411:
10412: /*
10413: -- Bug 6694536. Added cursor to fetch reversal lines from ap_self_assessed_tax_dist_all.
10414: -- Cursor is similar to c_reverse_tax_dist_1, except it is using ap_self_assessed_tax_dist_all
10415: -- to fetch lines. Second cursor for performance reasons(bug 6056777)
10416: */
10417:
10418: cursor c_rev_self_assess_tax_dist_1 is

Line 10603: from ap_self_assessed_tax_dist_all tax_dist,

10599: zx_dist.self_assessed_flag self_assessed_flag,
10600: -- bug 6805655
10601: tax_dist.self_assessed_tax_liab_ccid self_assessed_tax_liab_ccid,
10602: tax_dist.prepay_tax_diff_amount -- BUG 7338249
10603: from ap_self_assessed_tax_dist_all tax_dist,
10604: ap_invoice_distributions_all item_dist,
10605: zx_rec_nrec_dist zx_dist
10606: where tax_dist.invoice_id = p_invoice_id
10607: and tax_dist.line_type_lookup_code IN ('NONREC_TAX', 'REC_TAX')

Line 10622: FROM ap_self_assessed_tax_dist_all aid

10618: */
10619:
10620: AND NOT EXISTS
10621: (SELECT aid.detail_tax_dist_id
10622: FROM ap_self_assessed_tax_dist_all aid
10623: WHERE aid.invoice_id = p_invoice_id
10624: AND aid.detail_tax_dist_id = zx_dist.rec_nrec_tax_dist_id
10625: AND aid.line_type_lookup_code IN ('REC_TAX','NONREC_TAX'))
10626: -- bug 6896627

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

10732: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
10733: END IF;
10734:
10735: -- Populating zx_reverse_dist_gt with self assessed entries that has to be
10736: -- reversed. Fetched tax distributions from ap_self_assessed_tax_dist_all.
10737: -- ITEM line is already reversed in Discard method. reverse_dist refers to
10738: -- the reversed item line.
10739:
10740: INSERT INTO zx_reverse_dist_gt(

Line 10778: ap_self_assessed_tax_dist_all tax_dist,

10774: zx_dist.trx_line_id reversed_trx_line_id,
10775: zx_dist.trx_line_dist_id reversed_trx_line_dist_id,
10776: zx_dist.tax_line_id reversed_tax_line_id
10777: from ap_invoice_distributions_all item_dist,
10778: ap_self_assessed_tax_dist_all tax_dist,
10779: ap_invoice_distributions_all reverse_dist,
10780: zx_rec_nrec_dist zx_dist
10781: where tax_dist.invoice_id = p_invoice_id
10782: and tax_dist.invoice_id = item_dist.invoice_id

Line 11189: INSERT INTO ap_self_assessed_tax_dist_all (

11185: FETCH c_rev_self_assess_tax_dist
11186: INTO l_self_assess_rev_tax_dist;
11187: EXIT WHEN c_rev_self_assess_tax_dist%NOTFOUND;
11188:
11189: INSERT INTO ap_self_assessed_tax_dist_all (
11190: accounting_date,
11191: accrual_posted_flag,
11192: assets_addition_flag,
11193: assets_tracking_flag,

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

11835:
11836:
11837: IF l_self_assess_tax_dist_exist THEN -- Marker 8
11838:
11839: l_debug_info := 'Inserting reverse entries into ap_self_assessed_tax_dist_all';
11840: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
11841: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
11842: END IF;
11843:

Line 11850: INSERT INTO ap_self_assessed_tax_dist_all (

11846: FETCH c_rev_self_assess_tax_dist_1
11847: INTO l_self_assess_rev_tax_dist_1;
11848: EXIT WHEN c_rev_self_assess_tax_dist_1%NOTFOUND;
11849:
11850: INSERT INTO ap_self_assessed_tax_dist_all (
11851: accounting_date,
11852: accrual_posted_flag,
11853: assets_addition_flag,
11854: assets_tracking_flag,

Line 12267: UPDATE ap_self_assessed_tax_dist_all aid

12263: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
12264: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
12265: END IF;
12266:
12267: UPDATE ap_self_assessed_tax_dist_all aid
12268: SET reversal_flag = (select reverse_flag
12269: from zx_rec_nrec_dist zx
12270: where zx.rec_nrec_tax_dist_id = aid.detail_tax_dist_id)
12271: WHERE aid.invoice_id = p_invoice_id

Line 12281: UPDATE ap_self_assessed_tax_dist_all aid

12277: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
12278: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
12279: END IF;
12280:
12281: UPDATE ap_self_assessed_tax_dist_all aid
12282: SET aid.related_id =
12283: (SELECT invoice_distribution_id
12284: FROM ap_self_assessed_tax_dist_all aid1
12285: WHERE aid1.invoice_id = aid.invoice_id

Line 12284: FROM ap_self_assessed_tax_dist_all aid1

12280:
12281: UPDATE ap_self_assessed_tax_dist_all aid
12282: SET aid.related_id =
12283: (SELECT invoice_distribution_id
12284: FROM ap_self_assessed_tax_dist_all aid1
12285: WHERE aid1.invoice_id = aid.invoice_id
12286: AND aid1.invoice_line_number = aid.invoice_line_number
12287: AND aid1.parent_reversal_id =
12288: (SELECT related_id

Line 12289: FROM ap_self_assessed_tax_dist_all aid2

12285: WHERE aid1.invoice_id = aid.invoice_id
12286: AND aid1.invoice_line_number = aid.invoice_line_number
12287: AND aid1.parent_reversal_id =
12288: (SELECT related_id
12289: FROM ap_self_assessed_tax_dist_all aid2
12290: WHERE aid2.invoice_id = aid.invoice_id
12291: AND aid2.invoice_line_number = aid.invoice_line_number
12292: AND aid2.invoice_distribution_id = aid.parent_reversal_id)
12293: )

Line 12738: DELETE FROM ap_self_assessed_tax_dist_all

12734: IF l_return_status_service <> FND_API.G_RET_STS_SUCCESS THEN
12735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
12736: END IF;
12737:
12738: DELETE FROM ap_self_assessed_tax_dist_all
12739: WHERE invoice_id = l_preview_dists.invoice_id
12740: AND invoice_line_number = l_preview_dists.invoice_line_number;
12741:
12742: End Loop;

Line 12846: FROM ap_self_assessed_tax_dist_all asat,

12842:
12843: BEGIN
12844: SELECT 'Tax Distributions Exist'
12845: INTO l_dummy
12846: FROM ap_self_assessed_tax_dist_all asat,
12847: zx_rec_nrec_dist zx_dist
12848: WHERE invoice_id = p_invoice_id
12849: AND asat.detail_tax_dist_id = zx_dist.rec_nrec_tax_dist_id
12850: AND zx_dist.self_assessed_flag = 'Y'

Line 13805: UPDATE ap_self_assessed_tax_dist_all aid

13801: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13802: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
13803: END IF;
13804:
13805: UPDATE ap_self_assessed_tax_dist_all aid
13806: SET related_id = (SELECT DECODE(MIN(nrtax.invoice_distribution_id),
13807: NULL, MIN(other.invoice_distribution_id),
13808: MIN(nrtax.invoice_distribution_id))
13809: FROM ap_self_assessed_tax_dist_all nrtax,

Line 13809: FROM ap_self_assessed_tax_dist_all nrtax,

13805: UPDATE ap_self_assessed_tax_dist_all aid
13806: SET related_id = (SELECT DECODE(MIN(nrtax.invoice_distribution_id),
13807: NULL, MIN(other.invoice_distribution_id),
13808: MIN(nrtax.invoice_distribution_id))
13809: FROM ap_self_assessed_tax_dist_all nrtax,
13810: ap_self_assessed_tax_dist_all other
13811: WHERE nrtax.invoice_id = aid.invoice_id
13812: AND other.invoice_id = aid.invoice_id
13813: AND nrtax.detail_tax_dist_id = aid.detail_tax_dist_id

Line 13810: ap_self_assessed_tax_dist_all other

13806: SET related_id = (SELECT DECODE(MIN(nrtax.invoice_distribution_id),
13807: NULL, MIN(other.invoice_distribution_id),
13808: MIN(nrtax.invoice_distribution_id))
13809: FROM ap_self_assessed_tax_dist_all nrtax,
13810: ap_self_assessed_tax_dist_all other
13811: WHERE nrtax.invoice_id = aid.invoice_id
13812: AND other.invoice_id = aid.invoice_id
13813: AND nrtax.detail_tax_dist_id = aid.detail_tax_dist_id
13814: AND other.detail_tax_dist_id = aid.detail_tax_dist_id

Line 13821: FROM ap_self_assessed_tax_dist_all aid1

13817: GROUP BY 1)
13818: WHERE aid.invoice_id = P_Invoice_Header_Rec.invoice_id
13819: AND aid.line_type_lookup_code in ('NONREC_TAX', 'TIPV', 'TRV', 'TERV')
13820: AND EXISTS (SELECT aid1.detail_tax_dist_id
13821: FROM ap_self_assessed_tax_dist_all aid1
13822: WHERE aid1.invoice_id = aid.invoice_id
13823: AND aid1.detail_tax_dist_id = aid.detail_tax_dist_id
13824: HAVING count(*) > 1
13825: GROUP BY aid1.detail_tax_dist_id);

Line 13853: UPDATE ap_self_assessed_tax_dist_all aid

13849: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13850: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
13851: END IF;
13852:
13853: UPDATE ap_self_assessed_tax_dist_all aid
13854: SET rounding_amt =
13855: (SELECT zd.func_curr_rounding_adjustment
13856: FROM zx_rec_nrec_dist zd
13857: WHERE zd.rec_nrec_tax_dist_id = aid.detail_tax_dist_id)