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.JE_ZZ_AUDIT_AP_PKG dependencies on ZX_RATES_B

Line 121: ,zx_rates_b tax

117: ,zl.entity_code
118: FROM po_vendors ven
119: ,ap_invoices inv
120: ,ap_invoice_distributions dis
121: ,zx_rates_b tax
122: ,ap_invoice_distributions item
123: ,ap_invoices pp
124: ,ap_invoice_distributions ppdis
125: ,ap_checks chk

Line 670: zx_rates_b tax,

666: NULL,
667: decode(dis.parent_reversal_id, NULL,' ','C'),
668: 'JEFRTXDC'
669: FROM zx_rec_nrec_dist zl,
670: zx_rates_b tax,
671: ap_invoices inv,
672: ap_invoice_distributions dis,
673: po_vendors ven,
674: ap_invoice_distributions acctinfo

Line 785: zx_rates_b tax,

781: NULL,
782: 'P',
783: 'JEFRTXDC'
784: FROM zx_rec_nrec_dist zl,
785: zx_rates_b tax,
786: ap_invoices inv,
787: ap_invoice_distributions dis,
788: po_vendors ven,
789: ap_invoice_distributions acctinfo

Line 889: FROM zx_rates_b tax,

885: decode(inv.cancelled_date,NULL,nvl(inv.exchange_rate,1)*inv.invoice_amount, nvl(inv.exchange_rate,1)*inv.cancelled_amount) prt_inv_amt,
886: NULL,
887: decode(aip.reversal_inv_pmt_id,NULL,' ','V'),
888: 'JEFRTXDC'
889: FROM zx_rates_b tax,
890: ap_invoices inv,
891: ap_invoice_distributions dis,
892: po_vendors ven,
893: ap_invoice_payments aip,

Line 1022: FROM zx_rates_b tax,

1018: decode(inv.cancelled_date,NULL,nvl(inv.exchange_rate,1)*inv.invoice_amount, nvl(inv.exchange_rate,1)*inv.cancelled_amount) prt_inv_amt,
1019: NULL,
1020: 'P',
1021: 'JEFRTXDC'
1022: FROM zx_rates_b tax,
1023: ap_invoices inv,
1024: ap_invoice_distributions dis,
1025: po_vendors ven,
1026: zx_rec_nrec_dist nrec,

Line 1120: FROM zx_rates_b tax,

1116: decode(inv.cancelled_date,NULL,nvl(inv.exchange_rate,1)*inv.invoice_amount, nvl(inv.exchange_rate,1)*inv.cancelled_amount) prt_inv_amt,
1117: NULL,
1118: 'P',
1119: 'JEFRTXDC'
1120: FROM zx_rates_b tax,
1121: ap_invoices inv,
1122: ap_invoice_distributions dis,
1123: po_vendors ven,
1124: zx_rec_nrec_dist nrec,

Line 1230: FROM zx_rates_b tax,

1226: decode(inv.cancelled_date,NULL,nvl(inv.exchange_rate,1)*inv.invoice_amount, nvl(inv.exchange_rate,1)*inv.cancelled_amount) prt_inv_amt,
1227: NULL,
1228: 'PP',
1229: 'JEFRTXDC'
1230: FROM zx_rates_b tax,
1231: ap_invoices inv,
1232: ap_invoice_distributions dis,
1233: po_vendors ven,
1234: ap_invoice_distributions pre,

Line 1782: ,zx_rates_b tax

1778: ,p_end_date DATE)
1779: IS
1780: SELECT SUM(nvl(dis.base_amount, dis.amount)) amount
1781: FROM ap_invoice_distributions dis
1782: ,zx_rates_b tax
1783: WHERE dis.line_type_lookup_code NOT IN ('TAX', 'PREPAY')
1784: AND tax.tax_rate_id = dis.tax_code_id
1785: AND dis.invoice_id = p_invoice_id
1786: AND tax.offset_tax_rate_code = p_offset_tax_rate_code

Line 1796: ,zx_rates_b tax

1792: ,p_end_date DATE)
1793: IS
1794: SELECT SUM(nvl(dis.base_amount, dis.amount)) amount
1795: FROM ap_invoice_distributions dis
1796: ,zx_rates_b tax
1797: WHERE tax.tax_rate_id = dis.tax_code_id
1798: AND dis.invoice_id = p_invoice_id
1799: AND tax.tax_rate_id = p_tax_id
1800: AND dis.line_type_lookup_code = 'PREPAY'

Line 1810: ,zx_rates_b tax

1806: ,p_end_date DATE)
1807: IS
1808: SELECT SUM(nvl(dis.base_amount, dis.amount) * aip.discount_lost / p_real_inv_amt) amount
1809: FROM ap_invoice_distributions dis
1810: ,zx_rates_b tax
1811: ,ap_invoice_payments aip
1812: ,ap_invoices inv
1813: WHERE dis.line_type_lookup_code NOT IN ('TAX', 'PREPAY')
1814: AND inv.invoice_id = dis.invoice_id

Line 1828: ,zx_rates_b tax

1824: ,p_end_date DATE)
1825: IS
1826: SELECT SUM(nvl(dis.base_amount, dis.amount) * aip.discount_lost / p_real_inv_amt) amount
1827: FROM ap_invoice_distributions dis
1828: ,zx_rates_b tax
1829: ,ap_invoice_payments aip
1830: ,ap_invoices inv
1831: WHERE dis.line_type_lookup_code NOT IN ('TAX', 'PREPAY')
1832: AND inv.invoice_id = dis.invoice_id

Line 1844: ,zx_rates_b tax

1840: ,p_tax_id NUMBER)
1841: IS
1842: SELECT (-1) * SUM(nvl(dis.base_amount, dis.amount)) amount
1843: FROM ap_invoice_distributions dis
1844: ,zx_rates_b tax
1845: WHERE dis.line_type_lookup_code NOT IN ('TAX', 'PREPAY')
1846: AND dis.invoice_id = p_invoice_id
1847: AND tax.tax_rate_id = p_tax_id
1848: AND dis.tax_code_id = tax.tax_rate_id

Line 1856: ,zx_rates_b tax

1852: ,p_tax_id NUMBER)
1853: IS
1854: SELECT SUM(nvl(dis.base_amount, dis.amount)) amount
1855: FROM ap_invoice_distributions dis
1856: ,zx_rates_b tax
1857: WHERE dis.line_type_lookup_code NOT IN ('TAX', 'PREPAY')
1858: AND dis.invoice_id = p_invoice_id
1859: AND tax.tax_rate_id = p_tax_id
1860: AND dis.tax_code_id = tax.tax_rate_id;

Line 1867: ,zx_rates_b tax

1863: ,p_offset_tax_rate_code VARCHAR2)
1864: IS
1865: SELECT SUM(nvl(dis.base_amount, dis.amount)) amount
1866: FROM ap_invoice_distributions dis
1867: ,zx_rates_b tax
1868: WHERE dis.line_type_lookup_code NOT IN ('TAX', 'PREPAY')
1869: AND dis.invoice_id = p_invoice_id
1870: AND tax.offset_tax_rate_code = p_offset_tax_rate_code
1871: AND dis.tax_code_id = tax.tax_rate_id;

Line 1878: ,zx_rates_b tax

1874: ,p_tax_id NUMBER)
1875: IS
1876: SELECT SUM(nvl(dis.base_amount, dis.amount)) * (p_payment_amt / p_real_inv_amt) amount
1877: FROM ap_invoice_distributions dis
1878: ,zx_rates_b tax
1879: WHERE dis.line_type_lookup_code NOT IN ('TAX', 'PREPAY')
1880: AND dis.invoice_id = p_invoice_id
1881: AND tax.tax_rate_id = p_tax_id
1882: AND dis.tax_code_id = tax.tax_rate_id;