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 120: tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE,

116: org_id ap_invoice_distributions_all.org_id%TYPE,
117: tax_regime_id zx_rec_nrec_dist.tax_regime_id%TYPE,
118: tax_id zx_rec_nrec_dist.tax_id%TYPE,
119: tax_status_id zx_rec_nrec_dist.tax_status_id%TYPE,
120: tax_jurisdiction_id zx_lines.tax_jurisdiction_id%TYPE,
121: par_dist_assets_tracking_flag ap_invoice_distributions_all.assets_tracking_flag%TYPE, -- Bug 13821160
122: parent_dist_cancellation_flag ap_invoice_distributions_all.cancellation_flag%TYPE,
123: parent_dist_reversal_flag ap_invoice_distributions_all.reversal_flag%TYPE,
124: parent_dist_parent_reversal_id ap_invoice_distributions_all.parent_reversal_id%TYPE,

Line 1238: FROM zx_lines_summary ls

1234: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id
1235: AND ail.line_type_lookup_code = 'TAX'
1236: AND NOT EXISTS
1237: (SELECT ls.summary_tax_line_id
1238: FROM zx_lines_summary ls
1239: WHERE ls.summary_tax_line_id = ail.summary_tax_line_id
1240: AND ls.trx_id = ail.invoice_id
1241: AND NVL(ls.tax_amt_included_flag, 'N') = 'N'
1242: AND NVL(ls.self_assessed_flag, 'N') = 'N'

Line 1262: FROM zx_lines_summary zl

1258: --summary line should not be allowed to delete if it has frozen distribution
1259: --as checked in above EXISTS hence no further checks needed. bug 10621602
1260: /* AND EXISTS
1261: (SELECT zl.summary_tax_line_id
1262: FROM zx_lines_summary zl
1263: WHERE zl.application_id = 200
1264: AND zl.entity_code = 'AP_INVOICES'
1265: AND zl.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
1266: AND zl.trx_id = ail.invoice_id

Line 1411: FROM zx_lines_summary zls

1407: zls.tax_rate_id, -- tax_rate_id
1408: zls.tax_rate_code, -- tax_rate_code
1409: zls.tax_rate, -- tax_rate
1410: DECODE(ail.generate_dists,'D','D','Y') -- generate_dists bug 5460342
1411: FROM zx_lines_summary zls
1412: WHERE zls.summary_tax_line_id = ail.summary_tax_line_id
1413: AND nvl(zls.reporting_only_flag, 'N') = 'N'
1414: )
1415: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id

Line 1419: FROM zx_lines_summary ls

1415: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id
1416: AND ail.line_type_lookup_code = 'TAX'
1417: AND EXISTS
1418: (SELECT ls.summary_tax_line_id
1419: FROM zx_lines_summary ls
1420: WHERE ls.summary_tax_line_id = ail.summary_tax_line_id
1421: AND ls.trx_id = ail.invoice_id
1422: AND NVL(ls.tax_amt_included_flag, 'N') = 'N'
1423: AND NVL(ls.self_assessed_flag, 'N') = 'N'

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

1441:
1442: APP_EXCEPTION.RAISE_EXCEPTION;
1443: END;
1444:
1445: /* Start for bug 5943074-- updating summary_tax_line_id of ap_invoice_lines_all based on zx_lines
1446: for manual tax lines and tax only lines so that we do not delete and regenerate the tax lines . */
1447: -------------------------------------------------------------------
1448: l_debug_info := 'Update summary tax line id for manual tax lines';
1449: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1457: FROM zx_lines zl

1453: BEGIN
1454:
1455: UPDATE ap_invoice_lines_all ail
1456: SET ail.summary_tax_line_id = (SELECT zl.summary_tax_line_id
1457: FROM zx_lines zl
1458: WHERE zl.application_id = 200
1459: AND zl.entity_code = 'AP_INVOICES'
1460: AND zl.event_class_code IN
1461: ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')

Line 1523: FROM zx_lines_summary ls

1519: DELETE ap_invoice_lines_all ail
1520: WHERE ail.invoice_id = P_Invoice_Header_Rec.invoice_id
1521: AND ail.line_type_lookup_code = 'TAX'
1522: AND NOT EXISTS (SELECT ls.summary_tax_line_id
1523: FROM zx_lines_summary ls
1524: WHERE ls.summary_tax_line_id = ail.summary_tax_line_id
1525: AND ls.trx_id = ail.invoice_id
1526: AND NVL(ls.tax_amt_included_flag, 'N') = 'N'
1527: AND NVL(ls.self_assessed_flag, 'N') = 'N'

Line 1965: zx_lines_summary zls,

1961: prepay.pay_awt_group_id)) -- pay_awt_group_id Bug8345264 */
1962: FROM ap_invoices_all ai,
1963: ap_suppliers ap,
1964: ap_supplier_sites_all aps,
1965: zx_lines_summary zls,
1966: ap_invoice_lines_all prepay
1967: WHERE ai.invoice_id = p_invoice_header_rec.invoice_id
1968: AND ai.vendor_id = ap.vendor_id
1969: AND ai.vendor_site_id = aps.vendor_site_id

Line 1985: FROM ZX_LINES ZL

1981: WHERE il.invoice_id = ai.invoice_id
1982: AND il.summary_tax_line_id = zls.summary_tax_line_id)
1983: AND EXISTS
1984: (SELECT 'Recoupment Exists'
1985: FROM ZX_LINES ZL
1986: WHERE ZL.application_id = ZLS.application_id
1987: AND ZL.entity_code = ZLS.entity_code
1988: AND ZL.event_class_code = ZLS.event_class_code
1989: AND ZL.trx_id = ZLS.trx_id

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

2020: BEGIN
2021: --bug 6931461
2022: UPDATE ap_invoice_lines_all ail
2023: SET ail.included_tax_amount =
2024: (SELECT /*+ index(ZL ZX_LINES_U1) */SUM(NVL(zl.tax_amt, 0))
2025: FROM zx_lines zl
2026: WHERE zl.application_id = 200
2027: AND zl.entity_code = 'AP_INVOICES'
2028: AND zl.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')

Line 2025: FROM zx_lines zl

2021: --bug 6931461
2022: UPDATE ap_invoice_lines_all ail
2023: SET ail.included_tax_amount =
2024: (SELECT /*+ index(ZL ZX_LINES_U1) */SUM(NVL(zl.tax_amt, 0))
2025: FROM zx_lines zl
2026: WHERE zl.application_id = 200
2027: AND zl.entity_code = 'AP_INVOICES'
2028: AND zl.event_class_code IN ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')
2029: AND zl.trx_id = ail.invoice_id

Line 2129: FROM zx_lines_summary zls

2125: 0)),
2126: SUM(DECODE(NVL(zls.self_assessed_flag, 'N'),
2127: 'Y', NVL(zls.tax_amt, 0),
2128: 0))
2129: FROM zx_lines_summary zls
2130: WHERE zls.application_id = 200
2131: AND zls.entity_code = 'AP_INVOICES'
2132: AND zls.event_class_code IN
2133: ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS')

Line 2192: FROM zx_lines zl

2188: on the invoice invoice line and resubmit tax calculation. In this case
2189: we would need to pass event_type as UPDATED.
2190: AND EXISTS
2191: ( SELECT zl.tax_line_id
2192: FROM zx_lines zl
2193: WHERE zl.trx_id = ail.invoice_id
2194: AND zl.trx_line_id = ail.line_number
2195: AND zl.application_id = 200
2196: AND zl.entity_code = 'AP_INVOICES'

Line 2698: zx_lines zl,

2694: NULL) pay_awt_group_id, --Bug8345264
2695: zd.account_source_tax_rate_id account_source_tax_rate_id
2696: FROM zx_trx_headers_gt gt,
2697: zx_rec_nrec_dist zd,
2698: zx_lines zl,
2699: ap_invoices_all ai,
2700: ap_supplier_sites_all pvs,
2701: ap_system_parameters_all asp,
2702: financials_system_params_all fsp,

Line 3045: zx_lines zl,

3041: NULL) pay_awt_group_id, --Bug8345264
3042: zd.account_source_tax_rate_id account_source_tax_rate_id
3043: FROM zx_trx_headers_gt gt,
3044: zx_rec_nrec_dist zd,
3045: zx_lines zl,
3046: ap_invoices_all ai,
3047: ap_supplier_sites_all pvs,
3048: ap_system_parameters_all asp,
3049: financials_system_params_all fsp,

Line 3323: zx_lines zl,

3319: aid.pay_awt_group_id pay_awt_group_id, --bug8345264
3320: zd.account_source_tax_rate_id
3321: FROM zx_trx_headers_gt gt,
3322: zx_rec_nrec_dist zd,
3323: zx_lines zl,
3324: ap_invoices_all ai,
3325: ap_invoice_distributions_all aid,
3326: ap_supplier_sites_all pvs,
3327: ap_system_parameters_all asp,

Line 3564: zx_lines zl,

3560: aid.pay_awt_group_id pay_awt_group_id, --Bug8345264
3561: zd.account_source_tax_rate_id account_source_tax_rate_id
3562: FROM zx_trx_headers_gt gt,
3563: zx_rec_nrec_dist zd,
3564: zx_lines zl,
3565: ap_invoices_all ai,
3566: ap_invoice_distributions_all aid,
3567: ap_supplier_sites_all pvs,
3568: ap_system_parameters_all asp,

Line 3784: zx_lines zl,

3780: parent_taxable_dist.pay_awt_group_id pay_awt_group_id, --Bug8345264
3781: zd.account_source_tax_rate_id account_source_tax_rate_id
3782: FROM zx_trx_headers_gt gt,
3783: zx_rec_nrec_dist zd,
3784: zx_lines zl,
3785: ap_invoices_all ai,
3786: ap_supplier_sites_all pvs,
3787: ap_system_parameters_all asp,
3788: financials_system_params_all fsp,

Line 3983: zx_lines zl,

3979: parent_taxable_dist.pay_awt_group_id pay_awt_group_id, --Bug8345264
3980: zd.account_source_tax_rate_id
3981: FROM zx_trx_headers_gt gt,
3982: zx_rec_nrec_dist zd,
3983: zx_lines zl,
3984: ap_invoices_all ai,
3985: ap_self_assessed_tax_dist_all aid,
3986: ap_supplier_sites_all pvs,
3987: ap_system_parameters_all asp,

Line 6489: FROM zx_lines_det_factors

6485: -- Modified this select to include the TAX only case
6486: CURSOR tax_already_calculated IS
6487: SELECT 'Y'
6488: --- Start for bug 6485124
6489: FROM zx_lines_det_factors
6490: WHERE trx_id = p_invoice_id
6491: AND application_id = 200
6492: AND entity_code = 'AP_INVOICES'
6493: AND event_class_code IN

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

6935:
6936: --SMYADAM: Need to validate if this below query is right ?
6937: --Basically we need to figure out if the Tax line has been discarded in ETAX
6938: --for the inclusive case. can we use cancel_flag , since
6939: --discard_flag is not available on zx_lines?
6940:
6941: /*
6942: SELECT zl.discarded_flag
6943: INTO l_discarded_flag

Line 6944: FROM zx_lines zl,

6940:
6941: /*
6942: SELECT zl.discarded_flag
6943: INTO l_discarded_flag
6944: FROM zx_lines zl,
6945: zx_rec_nrec_dist zd,
6946: ap_invoice_distributions aid
6947: WHERE zl.tax_line_id = zd.tax_line_id
6948: AND nvl(zl.reporting_only_flag, 'N') = 'N'

Line 10402: FROM zx_lines_summary zls

10398: AND rownum = 1; */
10399:
10400: SELECT 'Tax Only Line Exist'
10401: INTO l_dummy
10402: FROM zx_lines_summary zls
10403: WHERE application_id = AP_ETAX_PKG.AP_APPLICATION_ID
10404: AND entity_code = AP_ETAX_PKG.AP_ENTITY_CODE
10405: AND event_class_code IN (AP_ETAX_PKG.AP_INV_EVENT_CLASS_CODE,
10406: AP_ETAX_PKG.AP_PP_EVENT_CLASS_CODE,