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 664: zx_rates_b tax,

660: NULL,
661: decode(dis.parent_reversal_id, NULL,' ','C'),
662: 'JEFRTXDC'
663: FROM zx_rec_nrec_dist zl,
664: zx_rates_b tax,
665: ap_invoices inv,
666: ap_invoice_distributions dis,
667: po_vendors ven,
668: ap_invoice_distributions acctinfo

Line 761: zx_rates_b tax,

757: NULL,
758: 'P',
759: 'JEFRTXDC'
760: FROM zx_rec_nrec_dist zl,
761: zx_rates_b tax,
762: ap_invoices inv,
763: ap_invoice_distributions dis,
764: po_vendors ven,
765: ap_invoice_distributions acctinfo

Line 857: zx_rates_b tax,

853: NULL,
854: decode(aip.reversal_inv_pmt_id,NULL,' ','V'),
855: 'JEFRTXDC'
856: FROM zx_rec_nrec_dist zl,
857: zx_rates_b tax,
858: ap_invoices inv,
859: ap_invoice_distributions dis,
860: po_vendors ven,
861: ap_invoice_payments aip,

Line 966: zx_rates_b tax,

962: NULL,
963: 'P',
964: 'JEFRTXDC'
965: FROM zx_rec_nrec_dist zl,
966: zx_rates_b tax,
967: ap_invoices inv,
968: ap_invoice_distributions dis,
969: po_vendors ven,
970: zx_rec_nrec_dist nrec,

Line 1047: zx_rates_b tax,

1043: NULL,
1044: 'P',
1045: 'JEFRTXDC'
1046: FROM zx_rec_nrec_dist zl,
1047: zx_rates_b tax,
1048: ap_invoices inv,
1049: ap_invoice_distributions dis,
1050: po_vendors ven,
1051: zx_rec_nrec_dist nrec,

Line 1143: zx_rates_b tax,

1139: NULL,
1140: 'PP',
1141: 'JEFRTXDC'
1142: FROM zx_rec_nrec_dist zl,
1143: zx_rates_b tax,
1144: ap_invoices inv,
1145: ap_invoice_distributions dis,
1146: po_vendors ven,
1147: ap_invoice_distributions pre,

Line 1679: ,zx_rates_b tax

1675: ,p_end_date DATE)
1676: IS
1677: SELECT SUM(nvl(dis.base_amount, dis.amount)) amount
1678: FROM ap_invoice_distributions dis
1679: ,zx_rates_b tax
1680: WHERE dis.line_type_lookup_code NOT IN ('TAX', 'PREPAY')
1681: AND tax.tax_rate_id = dis.tax_code_id
1682: AND dis.invoice_id = p_invoice_id
1683: AND tax.offset_tax_rate_code = p_offset_tax_rate_code

Line 1693: ,zx_rates_b tax

1689: ,p_end_date DATE)
1690: IS
1691: SELECT SUM(nvl(dis.base_amount, dis.amount)) amount
1692: FROM ap_invoice_distributions dis
1693: ,zx_rates_b tax
1694: WHERE tax.tax_rate_id = dis.tax_code_id
1695: AND dis.invoice_id = p_invoice_id
1696: AND tax.tax_rate_id = p_tax_id
1697: AND dis.line_type_lookup_code = 'PREPAY'

Line 1707: ,zx_rates_b tax

1703: ,p_end_date DATE)
1704: IS
1705: SELECT SUM(nvl(dis.base_amount, dis.amount) * aip.discount_lost / p_real_inv_amt) amount
1706: FROM ap_invoice_distributions dis
1707: ,zx_rates_b tax
1708: ,ap_invoice_payments aip
1709: ,ap_invoices inv
1710: WHERE dis.line_type_lookup_code NOT IN ('TAX', 'PREPAY')
1711: AND inv.invoice_id = dis.invoice_id

Line 1725: ,zx_rates_b tax

1721: ,p_end_date DATE)
1722: IS
1723: SELECT SUM(nvl(dis.base_amount, dis.amount) * aip.discount_lost / p_real_inv_amt) amount
1724: FROM ap_invoice_distributions dis
1725: ,zx_rates_b tax
1726: ,ap_invoice_payments aip
1727: ,ap_invoices inv
1728: WHERE dis.line_type_lookup_code NOT IN ('TAX', 'PREPAY')
1729: AND inv.invoice_id = dis.invoice_id

Line 1741: ,zx_rates_b tax

1737: ,p_tax_id NUMBER)
1738: IS
1739: SELECT (-1) * SUM(nvl(dis.base_amount, dis.amount)) amount
1740: FROM ap_invoice_distributions dis
1741: ,zx_rates_b tax
1742: WHERE dis.line_type_lookup_code NOT IN ('TAX', 'PREPAY')
1743: AND dis.invoice_id = p_invoice_id
1744: AND tax.tax_rate_id = p_tax_id
1745: AND dis.tax_code_id = tax.tax_rate_id

Line 1753: ,zx_rates_b tax

1749: ,p_tax_id NUMBER)
1750: IS
1751: SELECT SUM(nvl(dis.base_amount, dis.amount)) amount
1752: FROM ap_invoice_distributions dis
1753: ,zx_rates_b tax
1754: WHERE dis.line_type_lookup_code NOT IN ('TAX', 'PREPAY')
1755: AND dis.invoice_id = p_invoice_id
1756: AND tax.tax_rate_id = p_tax_id
1757: AND dis.tax_code_id = tax.tax_rate_id;

Line 1764: ,zx_rates_b tax

1760: ,p_offset_tax_rate_code VARCHAR2)
1761: IS
1762: SELECT SUM(nvl(dis.base_amount, dis.amount)) amount
1763: FROM ap_invoice_distributions dis
1764: ,zx_rates_b tax
1765: WHERE dis.line_type_lookup_code NOT IN ('TAX', 'PREPAY')
1766: AND dis.invoice_id = p_invoice_id
1767: AND tax.offset_tax_rate_code = p_offset_tax_rate_code
1768: AND dis.tax_code_id = tax.tax_rate_id;

Line 1775: ,zx_rates_b tax

1771: ,p_tax_id NUMBER)
1772: IS
1773: SELECT SUM(nvl(dis.base_amount, dis.amount)) * (p_payment_amt / p_real_inv_amt) amount
1774: FROM ap_invoice_distributions dis
1775: ,zx_rates_b tax
1776: WHERE dis.line_type_lookup_code NOT IN ('TAX', 'PREPAY')
1777: AND dis.invoice_id = p_invoice_id
1778: AND tax.tax_rate_id = p_tax_id
1779: AND dis.tax_code_id = tax.tax_rate_id;