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_UTILITY_PKG dependencies on ZX_LINES

Line 115: tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE,

111: org_id ap_invoice_distributions_all.org_id%TYPE,
112: tax_regime_id zx_rec_nrec_dist.tax_regime_id%TYPE,
113: tax_id zx_rec_nrec_dist.tax_id%TYPE,
114: tax_status_id zx_rec_nrec_dist.tax_status_id%TYPE,
115: tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE,
116: parent_dist_cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
117: parent_dist_reversal_flag ap_invoice_distributions_all.reversal_flag%TYPE,
118: parent_dist_parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE,
119: reversed_tax_dist_id zx_rec_nrec_dist.reversed_tax_dist_id%TYPE,

Line 1007: FROM zx_lines_summary ls

1003: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id
1004: AND ail.line_type_lookup_code = 'TAX'
1005: AND NOT EXISTS
1006: (SELECT ls.summary_tax_line_id
1007: FROM zx_lines_summary ls
1008: WHERE ls.summary_tax_line_id = ail.summary_tax_line_id
1009: AND ls.trx_id = ail.invoice_id
1010: AND NVL(ls.tax_amt_included_flag, 'N') = 'N'
1011: AND NVL(ls.self_assessed_flag, 'N') = 'N'

Line 1027: FROM zx_lines_summary zl

1023: ) --This is done for Mexicana Bug7623255 to avoid such Data Fix Condition
1024: )
1025: AND EXISTS
1026: (SELECT zl.summary_tax_line_id
1027: FROM zx_lines_summary zl
1028: WHERE zl.application_id = 200
1029: AND zl.entity_code = 'AP_INVOICES'
1030: AND zl.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
1031: AND zl.trx_id = ail.invoice_id

Line 1155: FROM zx_lines_summary zls

1151: zls.tax_rate_id, -- tax_rate_id
1152: zls.tax_rate_code, -- tax_rate_code
1153: zls.tax_rate, -- tax_rate
1154: DECODE(ail.generate_dists,'D','D','Y') -- generate_dists bug 5460342
1155: FROM zx_lines_summary zls
1156: WHERE zls.summary_tax_line_id = ail.summary_tax_line_id
1157: AND nvl(zls.reporting_only_flag, 'N') = 'N'
1158: )
1159: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id

Line 1163: FROM zx_lines_summary ls

1159: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id
1160: AND ail.line_type_lookup_code = 'TAX'
1161: AND EXISTS
1162: (SELECT ls.summary_tax_line_id
1163: FROM zx_lines_summary ls
1164: WHERE ls.summary_tax_line_id = ail.summary_tax_line_id
1165: AND ls.trx_id = ail.invoice_id
1166: AND NVL(ls.tax_amt_included_flag, 'N') = 'N'
1167: AND NVL(ls.self_assessed_flag, 'N') = 'N'

Line 1189: /* Start for bug 5943074-- updating summary_tax_line_id of ap_invoice_lines_all based on zx_lines

1185:
1186: APP_EXCEPTION.RAISE_EXCEPTION;
1187: END;
1188:
1189: /* Start for bug 5943074-- updating summary_tax_line_id of ap_invoice_lines_all based on zx_lines
1190: for manual tax lines and tax only lines so that we do not delete and regenerate the tax lines . */
1191: -------------------------------------------------------------------
1192: l_debug_info := 'Update summary tax line id for manual tax lines';
1193: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1201: FROM zx_lines zl

1197: BEGIN
1198:
1199: UPDATE ap_invoice_lines_all ail
1200: SET ail.summary_tax_line_id = (SELECT zl.summary_tax_line_id
1201: FROM zx_lines zl
1202: WHERE zl.application_id = 200
1203: AND zl.entity_code = 'AP_INVOICES'
1204: AND zl.event_class_code IN
1205: ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')

Line 1267: FROM zx_lines_summary ls

1263: DELETE ap_invoice_lines_all ail
1264: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id
1265: AND ail.line_type_lookup_code = 'TAX'
1266: AND NOT EXISTS (SELECT ls.summary_tax_line_id
1267: FROM zx_lines_summary ls
1268: WHERE ls.summary_tax_line_id = ail.summary_tax_line_id
1269: AND ls.trx_id = ail.invoice_id
1270: AND NVL(ls.tax_amt_included_flag, 'N') = 'N'
1271: AND NVL(ls.self_assessed_flag, 'N') = 'N'

Line 1701: zx_lines_summary zls,

1697: null -- tax_code_id
1698: FROM ap_invoices_all ai,
1699: ap_suppliers ap,
1700: ap_supplier_sites_all aps,
1701: zx_lines_summary zls,
1702: ap_invoice_lines_all prepay
1703: WHERE ai.invoice_id = p_invoice_header_rec.invoice_id
1704: AND ai.vendor_id = ap.vendor_id
1705: AND ai.vendor_site_id = aps.vendor_site_id

Line 1721: FROM ZX_LINES ZL

1717: WHERE il.invoice_id = ai.invoice_id
1718: AND il.summary_tax_line_id = zls.summary_tax_line_id)
1719: AND EXISTS
1720: (SELECT 'Recoupment Exists'
1721: FROM ZX_LINES ZL
1722: WHERE ZL.application_id = ZLS.application_id
1723: AND ZL.entity_code = ZLS.entity_code
1724: AND ZL.event_class_code = ZLS.event_class_code
1725: AND ZL.trx_id = ZLS.trx_id

Line 1760: (SELECT /+ index(ZL ZX_LINES_U1) /SUM(NVL(zl.tax_amt, 0))

1756: BEGIN
1757: --bug 6931461
1758: UPDATE ap_invoice_lines_all ail
1759: SET ail.included_tax_amount =
1760: (SELECT /*+ index(ZL ZX_LINES_U1) */SUM(NVL(zl.tax_amt, 0))
1761: FROM zx_lines zl
1762: WHERE zl.application_id = 200
1763: AND zl.entity_code = 'AP_INVOICES'
1764: AND zl.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')

Line 1761: FROM zx_lines zl

1757: --bug 6931461
1758: UPDATE ap_invoice_lines_all ail
1759: SET ail.included_tax_amount =
1760: (SELECT /*+ index(ZL ZX_LINES_U1) */SUM(NVL(zl.tax_amt, 0))
1761: FROM zx_lines zl
1762: WHERE zl.application_id = 200
1763: AND zl.entity_code = 'AP_INVOICES'
1764: AND zl.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
1765: AND zl.trx_id = ail.invoice_id

Line 1853: FROM zx_lines_summary zls

1849: 0)),
1850: SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
1851: 'Y', NVL(zls.tax_amt, 0),
1852: 0))
1853: FROM zx_lines_summary zls
1854: WHERE zls.application_id = 200
1855: AND zls.entity_code = 'AP_INVOICES'
1856: AND zls.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
1857: AND zls.trx_id = ai.invoice_id

Line 1901: FROM zx_lines zl

1897: on the invoice invoice line and resubmit tax calculation. In this case
1898: we would need to pass event_type as UPDATED.
1899: AND EXISTS
1900: ( SELECT zl.tax_line_id
1901: FROM zx_lines zl
1902: WHERE zl.trx_id = ail.invoice_id
1903: AND zl.trx_line_id = ail.line_number
1904: AND zl.application_id = 200
1905: AND zl.entity_code = 'AP_INVOICES'

Line 2309: zx_lines zl,

2305: ai.set_of_books_id set_of_books_id,
2306: zd.account_source_tax_rate_id account_source_tax_rate_id
2307: FROM zx_trx_headers_gt gt,
2308: zx_rec_nrec_dist zd,
2309: zx_lines zl,
2310: ap_invoices_all ai,
2311: ap_supplier_sites_all pvs,
2312: ap_system_parameters_all asp,
2313: financials_system_params_all fsp,

Line 2622: zx_lines zl,

2618: ai.set_of_books_id set_of_books_id,
2619: zd.account_source_tax_rate_id account_source_tax_rate_id
2620: FROM zx_trx_headers_gt gt,
2621: zx_rec_nrec_dist zd,
2622: zx_lines zl,
2623: ap_invoices_all ai,
2624: ap_supplier_sites_all pvs,
2625: ap_system_parameters_all asp,
2626: financials_system_params_all fsp,

Line 2880: zx_lines zl,

2876: aid.invoice_distribution_id invoice_distribution_id,
2877: zd.account_source_tax_rate_id
2878: FROM zx_trx_headers_gt gt,
2879: zx_rec_nrec_dist zd,
2880: zx_lines zl,
2881: ap_invoices_all ai,
2882: ap_invoice_distributions_all aid,
2883: ap_supplier_sites_all pvs,
2884: ap_system_parameters_all asp,

Line 3110: zx_lines zl,

3106: aid.invoice_distribution_id invoice_distribution_id,
3107: zd.account_source_tax_rate_id account_source_tax_rate_id
3108: FROM zx_trx_headers_gt gt,
3109: zx_rec_nrec_dist zd,
3110: zx_lines zl,
3111: ap_invoices_all ai,
3112: ap_invoice_distributions_all aid,
3113: ap_supplier_sites_all pvs,
3114: ap_system_parameters_all asp,

Line 3313: zx_lines zl,

3309: ai.set_of_books_id set_of_books_id,
3310: zd.account_source_tax_rate_id account_source_tax_rate_id
3311: FROM zx_trx_headers_gt gt,
3312: zx_rec_nrec_dist zd,
3313: zx_lines zl,
3314: ap_invoices_all ai,
3315: ap_supplier_sites_all pvs,
3316: ap_system_parameters_all asp,
3317: financials_system_params_all fsp,

Line 3508: zx_lines zl,

3504: aid.invoice_distribution_id invoice_distribution_id,
3505: zd.account_source_tax_rate_id
3506: FROM zx_trx_headers_gt gt,
3507: zx_rec_nrec_dist zd,
3508: zx_lines zl,
3509: ap_invoices_all ai,
3510: ap_self_assessed_tax_dist_all aid,
3511: ap_supplier_sites_all pvs,
3512: ap_system_parameters_all asp,

Line 5313: FROM zx_lines_det_factors

5309: -- Modified this select to include the TAX only case
5310: CURSOR tax_already_calculated IS
5311: SELECT 'Y'
5312: --- Start for bug 6485124
5313: FROM zx_lines_det_factors
5314: WHERE trx_id = p_invoice_id
5315: AND application_id = 200
5316: AND entity_code = 'AP_INVOICES'
5317: AND event_class_code IN

Line 5711: --discard_flag is not available on zx_lines?

5707:
5708: --SMYADAM: Need to validate if this below query is right ?
5709: --Basically we need to figure out if the Tax line has been discarded in ETAX
5710: --for the inclusive case. can we use cancel_flag , since
5711: --discard_flag is not available on zx_lines?
5712:
5713: /*
5714: SELECT zl.discarded_flag
5715: INTO l_discarded_flag

Line 5716: FROM zx_lines zl,

5712:
5713: /*
5714: SELECT zl.discarded_flag
5715: INTO l_discarded_flag
5716: FROM zx_lines zl,
5717: zx_rec_nrec_dist zd,
5718: ap_invoice_distributions aid
5719: WHERE zl.tax_line_id = zd.tax_line_id
5720: AND nvl(zl.reporting_only_flag, 'N') = 'N'