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 AP_INVOICE_DISTRIBUTIONS

Line 120: ,ap_invoice_distributions dis

116: ,zl.trx_line_id
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

Line 122: ,ap_invoice_distributions item

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
126: ,ap_invoice_payments aip

Line 124: ,ap_invoice_distributions ppdis

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
126: ,ap_invoice_payments aip
127: ,ap_invoice_lines apl
128: ,zx_lines zl

Line 291: AND xla_dist.source_distribution_type = 'AP_INVOICE_DISTRIBUTIONS'

287: AND asd.assignment_code = acs.assignment_code
288: AND asd.enabled_flag = 'Y'
289: AND acs.accounting_class_code = xla_line.accounting_class_code -- Accounting Joins Enda
290: AND xla_dist.source_distribution_id_num_1 = zx_dist.trx_line_dist_id
291: AND xla_dist.source_distribution_type = 'AP_INVOICE_DISTRIBUTIONS'
292: AND zx_line.tax_line_id = zx_dist.tax_line_id
293: AND zx_det.tax_reporting_flag = 'Y'
294: AND zx_line.tax_id = zx_tax.tax_id
295: AND zx_line.tax_rate_id = nvl(zx_rate.source_id, zx_rate.tax_rate_id)

Line 345: AND xla_dist.source_distribution_type = 'AP_INVOICE_DISTRIBUTIONS'

341: AND asd.assignment_code = acs.assignment_code
342: AND asd.enabled_flag = 'Y'
343: AND acs.accounting_class_code = xla_line.accounting_class_code -- Accounting Joins Enda
344: AND xla_dist.tax_rec_nrec_dist_ref_id = zx_dist.rec_nrec_tax_dist_id
345: AND xla_dist.source_distribution_type = 'AP_INVOICE_DISTRIBUTIONS'
346: AND zx_line.tax_line_id = zx_dist.tax_line_id
347: AND zx_det.tax_reporting_flag = 'Y'
348: AND zx_line.tax_id = zx_tax.tax_id
349: AND zx_line.tax_rate_id = nvl(zx_rate.source_id, zx_rate.tax_rate_id)

Line 666: ap_invoice_distributions dis,

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
669: WHERE ((P_LEDGER_ID IS NULL AND P_COMPANY IS NULL AND inv.legal_entity_id = G_LE_ID)
670: OR (P_LEDGER_ID IS NOT NULL AND P_COMPANY IS NULL AND inv.set_of_books_id = P_LEDGER_ID)

Line 668: ap_invoice_distributions acctinfo

664: zx_rates_b tax,
665: ap_invoices inv,
666: ap_invoice_distributions dis,
667: po_vendors ven,
668: ap_invoice_distributions acctinfo
669: WHERE ((P_LEDGER_ID IS NULL AND P_COMPANY IS NULL AND inv.legal_entity_id = G_LE_ID)
670: OR (P_LEDGER_ID IS NOT NULL AND P_COMPANY IS NULL AND inv.set_of_books_id = P_LEDGER_ID)
671: OR (P_COMPANY IS NOT NULL AND inv.set_of_books_id = P_LEDGER_ID AND get_balancing_segment(dis.dist_code_combination_id) = P_COMPANY))
672: AND ven.vendor_id = inv.vendor_id

Line 763: ap_invoice_distributions dis,

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
766: WHERE ((P_LEDGER_ID IS NULL AND P_COMPANY IS NULL AND inv.legal_entity_id = G_LE_ID)
767: OR (P_LEDGER_ID IS NOT NULL AND P_COMPANY IS NULL AND inv.set_of_books_id = P_LEDGER_ID)

Line 765: ap_invoice_distributions acctinfo

761: zx_rates_b tax,
762: ap_invoices inv,
763: ap_invoice_distributions dis,
764: po_vendors ven,
765: ap_invoice_distributions acctinfo
766: WHERE ((P_LEDGER_ID IS NULL AND P_COMPANY IS NULL AND inv.legal_entity_id = G_LE_ID)
767: OR (P_LEDGER_ID IS NOT NULL AND P_COMPANY IS NULL AND inv.set_of_books_id = P_LEDGER_ID)
768: OR (P_COMPANY IS NOT NULL AND inv.set_of_books_id = P_LEDGER_ID AND get_balancing_segment(dis.dist_code_combination_id) = P_COMPANY))
769: AND ven.vendor_id = inv.vendor_id

Line 859: ap_invoice_distributions dis,

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,
862: ap_checks_all chk,
863: ap_invoice_distributions acctinfo

Line 863: ap_invoice_distributions acctinfo

859: ap_invoice_distributions dis,
860: po_vendors ven,
861: ap_invoice_payments aip,
862: ap_checks_all chk,
863: ap_invoice_distributions acctinfo
864: WHERE ((p_ledger_id IS NULL
865: AND p_company IS NULL
866: AND inv.legal_entity_id = g_le_id) OR(p_ledger_id IS NOT NULL
867: AND p_company IS NULL

Line 968: ap_invoice_distributions dis,

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,
971: ap_invoice_distributions acctinfo
972: WHERE ((P_LEDGER_ID IS NULL AND P_COMPANY IS NULL AND inv.legal_entity_id = G_LE_ID)

Line 971: ap_invoice_distributions acctinfo

967: ap_invoices inv,
968: ap_invoice_distributions dis,
969: po_vendors ven,
970: zx_rec_nrec_dist nrec,
971: ap_invoice_distributions acctinfo
972: WHERE ((P_LEDGER_ID IS NULL AND P_COMPANY IS NULL AND inv.legal_entity_id = G_LE_ID)
973: OR (P_LEDGER_ID IS NOT NULL AND P_COMPANY IS NULL AND inv.set_of_books_id = P_LEDGER_ID)
974: OR (P_COMPANY IS NOT NULL AND inv.set_of_books_id = P_LEDGER_ID AND get_balancing_segment(dis.dist_code_combination_id) = P_COMPANY))
975: AND ven.vendor_id = inv.vendor_id

Line 1049: ap_invoice_distributions dis,

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,
1052: ap_invoice_distributions acctinfo
1053: WHERE ((P_LEDGER_ID IS NULL AND P_COMPANY IS NULL AND inv.legal_entity_id = G_LE_ID)

Line 1052: ap_invoice_distributions acctinfo

1048: ap_invoices inv,
1049: ap_invoice_distributions dis,
1050: po_vendors ven,
1051: zx_rec_nrec_dist nrec,
1052: ap_invoice_distributions acctinfo
1053: WHERE ((P_LEDGER_ID IS NULL AND P_COMPANY IS NULL AND inv.legal_entity_id = G_LE_ID)
1054: OR (P_LEDGER_ID IS NOT NULL AND P_COMPANY IS NULL AND inv.set_of_books_id = P_LEDGER_ID)
1055: OR (P_COMPANY IS NOT NULL AND inv.set_of_books_id = P_LEDGER_ID AND get_balancing_segment(dis.dist_code_combination_id) = P_COMPANY))
1056: AND ven.vendor_id = inv.vendor_id

Line 1145: ap_invoice_distributions dis,

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,
1148: ap_invoice_distributions acctinfo
1149: WHERE ((p_ledger_id IS NULL

Line 1147: ap_invoice_distributions pre,

1143: zx_rates_b tax,
1144: ap_invoices inv,
1145: ap_invoice_distributions dis,
1146: po_vendors ven,
1147: ap_invoice_distributions pre,
1148: ap_invoice_distributions acctinfo
1149: WHERE ((p_ledger_id IS NULL
1150: AND p_company IS NULL
1151: AND inv.legal_entity_id = g_le_id) OR(p_ledger_id IS NOT NULL

Line 1148: ap_invoice_distributions acctinfo

1144: ap_invoices inv,
1145: ap_invoice_distributions dis,
1146: po_vendors ven,
1147: ap_invoice_distributions pre,
1148: ap_invoice_distributions acctinfo
1149: WHERE ((p_ledger_id IS NULL
1150: AND p_company IS NULL
1151: AND inv.legal_entity_id = g_le_id) OR(p_ledger_id IS NOT NULL
1152: AND p_company IS NULL

Line 1515: FROM ap_invoice_distributions pp

1511: ,p_start_date DATE
1512: ,p_end_date DATE)
1513: IS
1514: SELECT SUM(nvl(pp.base_amount, pp.amount) + nvl(ppt.base_amount, ppt.amount)) prepay_amount
1515: FROM ap_invoice_distributions pp
1516: ,ap_invoice_distributions ppt
1517: WHERE pp.invoice_id = p_invoice_id
1518: AND ppt.invoice_id = p_invoice_id
1519: AND pp.line_type_lookup_code = 'PREPAY'

Line 1516: ,ap_invoice_distributions ppt

1512: ,p_end_date DATE)
1513: IS
1514: SELECT SUM(nvl(pp.base_amount, pp.amount) + nvl(ppt.base_amount, ppt.amount)) prepay_amount
1515: FROM ap_invoice_distributions pp
1516: ,ap_invoice_distributions ppt
1517: WHERE pp.invoice_id = p_invoice_id
1518: AND ppt.invoice_id = p_invoice_id
1519: AND pp.line_type_lookup_code = 'PREPAY'
1520: AND pp.charge_applicable_to_dist_id = ppt.invoice_distribution_id

Line 1529: FROM ap_invoice_distributions ppp

1525: ,p_start_date DATE
1526: ,p_end_date DATE)
1527: IS
1528: SELECT (-1) * SUM(nvl(ppp.base_amount, ppp.amount)) prepay_amount
1529: FROM ap_invoice_distributions ppp
1530: WHERE ppp.invoice_id = p_invoice_id
1531: AND ppp.line_type_lookup_code = 'PREPAY'
1532: AND nvl(ppp.reversal_flag, 'N') <> 'Y'
1533: AND ppp.accounting_date BETWEEN p_start_date AND p_end_date

Line 1535: FROM ap_invoice_distributions ptax

1531: AND ppp.line_type_lookup_code = 'PREPAY'
1532: AND nvl(ppp.reversal_flag, 'N') <> 'Y'
1533: AND ppp.accounting_date BETWEEN p_start_date AND p_end_date
1534: AND NOT EXISTS (SELECT 'x'
1535: FROM ap_invoice_distributions ptax
1536: WHERE ptax.invoice_id = p_invoice_id
1537: AND ppp.charge_applicable_to_dist_id = ptax.invoice_distribution_id);
1538:
1539:

Line 1666: FROM ap_invoice_distributions dis

1662: ,p_start_date DATE
1663: ,p_end_date DATE)
1664: IS
1665: SELECT SUM(nvl(dis.base_amount, dis.amount)) amount
1666: FROM ap_invoice_distributions dis
1667: WHERE dis.invoice_id = p_invoice_id
1668: AND dis.line_type_lookup_code NOT IN ('REC_TAX','NONREC_TAX','PREPAY')
1669: AND dis.accounting_date BETWEEN p_start_date AND p_end_date;
1670:

Line 1678: FROM ap_invoice_distributions dis

1674: ,p_start_date DATE
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

Line 1692: FROM ap_invoice_distributions dis

1688: ,p_start_date DATE
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

Line 1706: FROM ap_invoice_distributions dis

1702: ,p_start_date DATE
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')

Line 1724: FROM ap_invoice_distributions dis

1720: ,p_start_date DATE
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')

Line 1740: FROM ap_invoice_distributions dis

1736: CURSOR c_get_amount_cre_rev ( p_invoice_id NUMBER
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

Line 1752: FROM ap_invoice_distributions dis

1748: CURSOR c_get_amount_cre ( p_invoice_id NUMBER
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

Line 1763: FROM ap_invoice_distributions dis

1759: CURSOR c_get_off_amount_cre ( p_invoice_id NUMBER
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

Line 1774: FROM ap_invoice_distributions dis

1770: CURSOR c_get_amount_cre_calc ( p_invoice_id NUMBER
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

Line 1945: FROM ap_invoice_distributions dis

1941:
1942: CURSOR c_get_inv_remain_amt (p_end_date DATE)
1943: IS
1944: SELECT round(SUM(nvl(dis.base_amount, dis.amount)), G_PRECISION) remaining_amount
1945: FROM ap_invoice_distributions dis
1946: WHERE dis.invoice_id = p_invoice_id
1947: AND dis.accounting_date <= p_end_date;
1948:
1949: BEGIN

Line 2112: FROM ap_invoice_distributions

2108:
2109: CURSOR c_get_inv_prepay_amt (p_invoice_id NUMBER)
2110: IS
2111: SELECT SUM(decode(invoice_includes_prepay_flag, 'Y', nvl(base_amount, amount), 0)) iipp_amt
2112: FROM ap_invoice_distributions
2113: WHERE invoice_id = p_invoice_id;
2114:
2115: BEGIN
2116: