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 ZX_REC_NREC_DIST

Line 1827: FROM zx_rec_nrec_dist zd

1823: WHERE aid2.invoice_id = aid1.invoice_id
1824: AND aid2.charge_applicable_to_dist_id = aid1.invoice_distribution_id
1825: AND aid2.line_type_lookup_code IN ( 'REC_TAX', 'NONREC_TAX', 'TRV', 'TIPV', 'TERV' )
1826: AND EXISTS (SELECT /*+ NO_UNNEST */ 1
1827: FROM zx_rec_nrec_dist zd
1828: WHERE zd.application_id = 200
1829: AND zd.entity_code = 'AP_INVOICES'
1830: AND zd.event_class_code IN ( 'STANDARD INVOICES', 'EXPENSE REPORTS', 'PREPAYMENT INVOICES' )
1831: AND zd.trx_id = aid2.invoice_id

Line 1912: FROM zx_rec_nrec_dist zd

1908: AND aid2.invoice_line_number = p_line_number
1909: AND aid2.charge_applicable_to_dist_id = aid1.invoice_distribution_id
1910: AND aid2.line_type_lookup_code IN ( 'REC_TAX', 'NONREC_TAX', 'TRV', 'TIPV', 'TERV' )
1911: AND EXISTS (SELECT /*+ NO_UNNEST */ 1
1912: FROM zx_rec_nrec_dist zd
1913: WHERE zd.application_id = 200
1914: AND zd.entity_code = 'AP_INVOICES'
1915: AND zd.event_class_code IN ( 'STANDARD INVOICES', 'EXPENSE REPORTS', 'PREPAYMENT INVOICES' )
1916: AND zd.trx_id = aid2.invoice_id

Line 12677: zx_rec_nrec_dist zx_dist

12673: (-1)*tax_dist.prepay_tax_diff_amount prepay_tax_diff_amount, -- BUG 7338249 bug 9040333 added (-1)* as this is reversal
12674: tax_dist.pay_awt_group_id pay_awt_group_id /*BUG 10261626*/
12675: from ap_invoice_distributions_all tax_dist,
12676: ap_invoice_distributions_all item_dist,
12677: zx_rec_nrec_dist zx_dist
12678: where tax_dist.invoice_id = p_invoice_id
12679: /* -- Bug8575619 start */
12680: and tax_dist.invoice_id = zx_dist.trx_id
12681: and zx_dist.application_id = 200

Line 12706: select /+ INDEX (ZX_DIST, ZX_REC_NREC_DIST_N2) / --8576175

12702: Else c_reverse_tax_dist_1 would be opened.
12703: */
12704:
12705: cursor c_reverse_tax_dist_1 is
12706: select /*+ INDEX (ZX_DIST, ZX_REC_NREC_DIST_N2) */ --8576175
12707: nvl(item_dist.accounting_date,
12708: zx_dist.gl_date) accounting_date, --bug 13101979
12709: 'N' accrual_posted_flag,
12710: 'U' assets_addition_flag,

Line 12896: zx_rec_nrec_dist zx_dist

12892: (-1)*tax_dist.prepay_tax_diff_amount prepay_tax_diff_amount, -- BUG 7338249 bug 9040333 added (-1)* as this is reversal
12893: tax_dist.pay_awt_group_id pay_awt_group_id /*BUG 10261626*/
12894: from ap_invoice_distributions_all tax_dist,
12895: ap_invoice_distributions_all item_dist,
12896: zx_rec_nrec_dist zx_dist
12897: where tax_dist.invoice_id = p_invoice_id
12898: /* -- Bug8575619 start */
12899: and tax_dist.invoice_id = zx_dist.trx_id
12900: and zx_dist.application_id = 200

Line 13118: zx_rec_nrec_dist zx_dist

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 */
13121: and tax_dist.invoice_id = zx_dist.trx_id
13122: and zx_dist.application_id = 200

Line 13347: zx_rec_nrec_dist zx_dist

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 */
13350: and tax_dist.invoice_id = zx_dist.trx_id
13351: and zx_dist.application_id = 200

Line 13705: zx_rec_nrec_dist zx_dist

13701: zx_dist.tax_line_id reversed_tax_line_id
13702: from ap_invoice_distributions_all item_dist,
13703: ap_invoice_distributions_all tax_dist,
13704: ap_invoice_distributions_all reverse_dist,
13705: zx_rec_nrec_dist zx_dist
13706: where tax_dist.invoice_id = p_invoice_id
13707: and tax_dist.invoice_id = item_dist.invoice_id
13708: and tax_dist.charge_applicable_to_dist_id = item_dist.invoice_distribution_id
13709: and item_dist.invoice_distribution_id = reverse_dist.parent_reversal_id

Line 13833: zx_rec_nrec_dist zx_dist

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
13836: and tax_dist.charge_applicable_to_dist_id = item_dist.invoice_distribution_id
13837: and item_dist.invoice_distribution_id = reverse_dist.parent_reversal_id

Line 15778: from zx_rec_nrec_dist zx

15774: END IF;
15775:
15776: UPDATE ap_invoice_distributions_all aid
15777: SET reversal_flag = (select reverse_flag
15778: from zx_rec_nrec_dist zx
15779: where zx.rec_nrec_tax_dist_id = aid.detail_tax_dist_id)
15780: WHERE aid.invoice_id = p_invoice_id
15781: AND aid.detail_tax_dist_id IS NOT NULL;
15782:

Line 15824: from zx_rec_nrec_dist zx

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
15827: AND aid.detail_tax_dist_id IS NOT NULL;
15828:

Line 16272: FROM zx_rec_nrec_dist zd

16268: AND aid2.charge_applicable_to_dist_id = aid1.invoice_distribution_id
16269: AND aid2.line_type_lookup_code IN ('REC_TAX','NONREC_TAX','TRV','TIPV')
16270: AND aid2.distribution_class = 'CANDIDATE'
16271: AND EXISTS (SELECT 1
16272: FROM zx_rec_nrec_dist zd
16273: WHERE zd.application_id =200
16274: AND zd.entity_code = 'AP_INVOICES'
16275: AND zd.event_class_code IN ('STANDARD INVOICES','EXPENSE REPORTS','PREPAYMENT INVOICES')
16276: AND zd.trx_id = aid2.invoice_id

Line 16287: FROM zx_rec_nrec_dist zd1

16283: AND aid3.charge_applicable_to_dist_id = aid1.invoice_distribution_id
16284: AND aid3.line_type_lookup_code IN ('REC_TAX','NONREC_TAX','TRV','TIPV')
16285: AND aid3.distribution_class = 'CANDIDATE'
16286: AND EXISTS (SELECT 1
16287: FROM zx_rec_nrec_dist zd1
16288: WHERE zd1.application_id =200
16289: AND zd1.entity_code = 'AP_INVOICES'
16290: AND zd1.event_class_code IN ('STANDARD INVOICES','EXPENSE REPORTS','PREPAYMENT INVOICES')
16291: AND zd1.trx_id = aid3.invoice_id

Line 16443: -- associated with an invoice. Join with zx_rec_nrec_dist is required becase

16439: RETURN FALSE;
16440: END TAX_ONLY_LINE_EXIST;
16441:
16442: /* Bug 6694536. Added function to verify whether there are self assessed tax lines
16443: -- associated with an invoice. Join with zx_rec_nrec_dist is required becase
16444: -- self_assessed_flag of zx_rec_nrec_dist actually indicates whether the lines
16445: -- are self assessed or not.
16446: */
16447:

Line 16444: -- self_assessed_flag of zx_rec_nrec_dist actually indicates whether the lines

16440: END TAX_ONLY_LINE_EXIST;
16441:
16442: /* Bug 6694536. Added function to verify whether there are self assessed tax lines
16443: -- associated with an invoice. Join with zx_rec_nrec_dist is required becase
16444: -- self_assessed_flag of zx_rec_nrec_dist actually indicates whether the lines
16445: -- are self assessed or not.
16446: */
16447:
16448: FUNCTION SELF_ASSESS_TAX_DIST_EXIST

Line 16462: zx_rec_nrec_dist zx_dist

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'
16466: AND nvl(zx_dist.reverse_flag, 'N') <> 'Y'

Line 17387: zx_rec_nrec_dist zx

17383: aid_parent.invoice_distribution_id parent_reversal_id,
17384: aid_parent.dist_code_combination_id parent_ccid
17385: FROM ap_invoice_distributions_all aid_reverse,
17386: ap_invoice_distributions_all aid_parent,
17387: zx_rec_nrec_dist zx
17388: WHERE aid_reverse.invoice_id = c_invoice_id
17389: AND aid_reverse.detail_tax_dist_id = zx.rec_nrec_tax_dist_id
17390: AND aid_parent.detail_tax_dist_id = zx.reversed_tax_dist_id
17391: AND aid_parent.line_type_lookup_code = aid_reverse.line_type_lookup_code;

Line 17400: zx_rec_nrec_dist zx

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
17404: AND aid_parent.line_type_lookup_code = aid_reverse.line_type_lookup_code;

Line 17542: FROM zx_rec_nrec_dist zd

17538:
17539: UPDATE ap_invoice_distributions_all aid
17540: SET rounding_amt =
17541: (SELECT zd.func_curr_rounding_adjustment
17542: FROM zx_rec_nrec_dist zd
17543: WHERE zd.rec_nrec_tax_dist_id = aid.detail_tax_dist_id)
17544: WHERE aid.invoice_id = P_Invoice_Header_Rec.invoice_id
17545: AND aid.line_type_lookup_code in ('NONREC_TAX', 'TIPV', 'TRV', 'TERV')
17546: AND (aid.related_id IS NULL

Line 17560: FROM zx_rec_nrec_dist zd

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)
17562: WHERE aid.invoice_id = P_Invoice_Header_Rec.invoice_id
17563: AND aid.line_type_lookup_code in ('NONREC_TAX', 'TIPV', 'TRV', 'TERV')
17564: AND (aid.related_id IS NULL

Line 17592: FROM zx_rec_nrec_dist zd

17588: 0)),
17589: SUM(DECODE(NVL(zd.recoverable_flag, 'N'),
17590: 'N', NVL(zd.rec_nrec_tax_amt_funcl_curr, 0),
17591: 0))
17592: FROM zx_rec_nrec_dist zd
17593: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
17594: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
17595: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
17596: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,

Line 17625: zx_rec_nrec_dist zd

17621: AND NVL(aid.tax_already_distributed_flag, 'N') = 'N'
17622: AND aid.invoice_distribution_id IN
17623: ( SELECT aid1.charge_applicable_to_dist_id
17624: FROM ap_invoice_distributions_all aid1,
17625: zx_rec_nrec_dist zd
17626: WHERE zd.REC_NREC_TAX_DIST_ID = aid1.DETAIL_TAX_DIST_ID
17627: AND aid1.invoice_id = p_invoice_header_rec.invoice_id );
17628:
17629: -----------------------------------------------------------------

Line 17770: FROM zx_rec_nrec_dist zd1

17766: AND aid2.invoice_line_number = i.line_number
17767: AND aid2.charge_applicable_to_dist_id = aid1.invoice_distribution_id
17768: AND aid2.line_type_lookup_code IN ('REC_TAX','NONREC_TAX', 'TIPV', 'TRV')
17769: AND EXISTS (SELECT 1
17770: FROM zx_rec_nrec_dist zd1
17771: WHERE zd1.application_id =200
17772: AND zd1.entity_code = 'AP_INVOICES'
17773: AND zd1.event_class_code IN ('STANDARD INVOICES','EXPENSE REPORTS','PREPAYMENT INVOICES')
17774: AND zd1.trx_id = aid2.invoice_id

Line 17784: FROM zx_rec_nrec_dist zd2

17780: AND aid3.invoice_line_number = i.line_number
17781: AND aid3.charge_applicable_to_dist_id = aid1.invoice_distribution_id
17782: AND aid3.line_type_lookup_code IN ('REC_TAX','NONREC_TAX', 'TIPV', 'TRV','TERV')
17783: AND EXISTS (SELECT 1
17784: FROM zx_rec_nrec_dist zd2
17785: WHERE zd2.application_id =200
17786: AND zd2.entity_code = 'AP_INVOICES'
17787: AND zd2.event_class_code IN ('STANDARD INVOICES','EXPENSE REPORTS','PREPAYMENT INVOICES')
17788: AND zd2.trx_id = aid3.invoice_id

Line 17870: from zx_rec_nrec_dist zx

17866: END IF;
17867:
17868: UPDATE ap_invoice_distributions_all aid
17869: SET reversal_flag = (select reverse_flag
17870: from zx_rec_nrec_dist zx
17871: where zx.rec_nrec_tax_dist_id = aid.detail_tax_dist_id)
17872: WHERE aid.invoice_id = p_invoice_header_rec.invoice_id
17873: AND aid.detail_tax_dist_id IS NOT NULL;
17874:

Line 17885: from zx_rec_nrec_dist zx

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
17888: AND aid.detail_tax_dist_id IS NOT NULL;
17889: -- Bug 10140793 : End