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 672: ap_invoice_distributions dis,

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

Line 674: ap_invoice_distributions acctinfo

670: zx_rates_b tax,
671: ap_invoices inv,
672: ap_invoice_distributions dis,
673: po_vendors ven,
674: ap_invoice_distributions acctinfo
675: WHERE ((P_LEDGER_ID IS NULL AND P_COMPANY IS NULL AND inv.legal_entity_id = G_LE_ID)
676: OR (P_LEDGER_ID IS NOT NULL AND P_COMPANY IS NULL AND inv.set_of_books_id = P_LEDGER_ID)
677: 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))
678: AND ven.vendor_id = inv.vendor_id

Line 695: from ap_invoice_distributions dis2

691: AND ((nvl(dis.reversal_flag,'N') = 'N' AND nvl(zl.reverse_flag,'N') = 'N')
692: or
693: (nvl(dis.reversal_flag,'N') = 'Y' AND nvl(zl.reverse_flag,'N') = 'Y'
694: and exists (select 'x'
695: from ap_invoice_distributions dis2
696: where dis2.invoice_id = inv.invoice_id
697: and dis2.accounting_date not between l_start_date and l_end_date)))
698: --bug10422464 - end
699: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf

Line 787: ap_invoice_distributions dis,

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

Line 789: ap_invoice_distributions acctinfo

785: zx_rates_b tax,
786: ap_invoices inv,
787: ap_invoice_distributions dis,
788: po_vendors ven,
789: ap_invoice_distributions acctinfo
790: WHERE ((P_LEDGER_ID IS NULL AND P_COMPANY IS NULL AND inv.legal_entity_id = G_LE_ID)
791: OR (P_LEDGER_ID IS NOT NULL AND P_COMPANY IS NULL AND inv.set_of_books_id = P_LEDGER_ID)
792: 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))
793: AND ven.vendor_id = inv.vendor_id

Line 891: ap_invoice_distributions dis,

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,
894: ap_checks_all chk,
895: ap_invoice_distributions acctinfo,

Line 895: ap_invoice_distributions acctinfo,

891: ap_invoice_distributions dis,
892: po_vendors ven,
893: ap_invoice_payments aip,
894: ap_checks_all chk,
895: ap_invoice_distributions acctinfo,
896: zx_rec_nrec_dist zl LEFT OUTER JOIN zx_accounts ACCOUNTS
897: ON (accounts.TAX_ACCOUNT_ENTITY_ID =
898: nvl(zl.ACCOUNT_SOURCE_TAX_RATE_ID, zl.TAX_RATE_ID)
899: AND accounts.TAX_ACCOUNT_ENTITY_CODE = 'RATES'

Line 929: from ap_invoice_distributions dis2

925: AND ((nvl(dis.reversal_flag,'N') = 'N' AND nvl(zl.reverse_flag,'N') = 'N')
926: or
927: (nvl(dis.reversal_flag,'N') = 'Y' AND nvl(zl.reverse_flag,'N') = 'Y'
928: and exists (select 'x'
929: from ap_invoice_distributions dis2
930: where dis2.invoice_id = inv.invoice_id
931: and dis2.accounting_date not between l_start_date and l_end_date)))
932: --bug10422464 - end
933: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf WHERE

Line 1024: ap_invoice_distributions dis,

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,
1027: ap_invoice_distributions acctinfo,
1028: zx_rec_nrec_dist zl LEFT OUTER JOIN zx_accounts ACCOUNTS

Line 1027: ap_invoice_distributions acctinfo,

1023: ap_invoices inv,
1024: ap_invoice_distributions dis,
1025: po_vendors ven,
1026: zx_rec_nrec_dist nrec,
1027: ap_invoice_distributions acctinfo,
1028: zx_rec_nrec_dist zl LEFT OUTER JOIN zx_accounts ACCOUNTS
1029: ON (accounts.TAX_ACCOUNT_ENTITY_ID =
1030: nvl(zl.ACCOUNT_SOURCE_TAX_RATE_ID, zl.TAX_RATE_ID)
1031: AND accounts.TAX_ACCOUNT_ENTITY_CODE = 'RATES'

Line 1122: ap_invoice_distributions dis,

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,
1125: ap_invoice_distributions acctinfo,
1126: zx_rec_nrec_dist zl LEFT OUTER JOIN zx_accounts ACCOUNTS

Line 1125: ap_invoice_distributions acctinfo,

1121: ap_invoices inv,
1122: ap_invoice_distributions dis,
1123: po_vendors ven,
1124: zx_rec_nrec_dist nrec,
1125: ap_invoice_distributions acctinfo,
1126: zx_rec_nrec_dist zl LEFT OUTER JOIN zx_accounts ACCOUNTS
1127: ON (accounts.TAX_ACCOUNT_ENTITY_ID =
1128: nvl(zl.ACCOUNT_SOURCE_TAX_RATE_ID, zl.TAX_RATE_ID)
1129: AND accounts.TAX_ACCOUNT_ENTITY_CODE = 'RATES'

Line 1232: ap_invoice_distributions dis,

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,
1235: ap_invoice_distributions acctinfo,
1236: zx_rec_nrec_dist zl LEFT OUTER JOIN zx_accounts ACCOUNTS

Line 1234: ap_invoice_distributions pre,

1230: FROM zx_rates_b tax,
1231: ap_invoices inv,
1232: ap_invoice_distributions dis,
1233: po_vendors ven,
1234: ap_invoice_distributions pre,
1235: ap_invoice_distributions acctinfo,
1236: zx_rec_nrec_dist zl LEFT OUTER JOIN zx_accounts ACCOUNTS
1237: ON (accounts.TAX_ACCOUNT_ENTITY_ID =
1238: nvl(zl.ACCOUNT_SOURCE_TAX_RATE_ID, zl.TAX_RATE_ID)

Line 1235: ap_invoice_distributions acctinfo,

1231: ap_invoices inv,
1232: ap_invoice_distributions dis,
1233: po_vendors ven,
1234: ap_invoice_distributions pre,
1235: ap_invoice_distributions acctinfo,
1236: zx_rec_nrec_dist zl LEFT OUTER JOIN zx_accounts ACCOUNTS
1237: ON (accounts.TAX_ACCOUNT_ENTITY_ID =
1238: nvl(zl.ACCOUNT_SOURCE_TAX_RATE_ID, zl.TAX_RATE_ID)
1239: AND accounts.TAX_ACCOUNT_ENTITY_CODE = 'RATES'

Line 1274: from ap_invoice_distributions dis2

1270: AND ((nvl(dis.reversal_flag,'N') = 'N' AND nvl(zl.reverse_flag,'N') = 'N')
1271: or
1272: (nvl(dis.reversal_flag,'N') = 'Y' AND nvl(zl.reverse_flag,'N') = 'Y'
1273: and exists (select 'x'
1274: from ap_invoice_distributions dis2
1275: where dis2.invoice_id = inv.invoice_id
1276: and dis2.accounting_date not between l_start_date and l_end_date)))
1277: --bug10422464 - end
1278: AND EXISTS ( SELECT 1 FROM zx_lines_det_factors zldf WHERE

Line 1618: FROM ap_invoice_distributions pp

1614: ,p_start_date DATE
1615: ,p_end_date DATE)
1616: IS
1617: SELECT SUM(nvl(pp.base_amount, pp.amount) + nvl(ppt.base_amount, ppt.amount)) prepay_amount
1618: FROM ap_invoice_distributions pp
1619: ,ap_invoice_distributions ppt
1620: WHERE pp.invoice_id = p_invoice_id
1621: AND ppt.invoice_id = p_invoice_id
1622: AND pp.line_type_lookup_code = 'PREPAY'

Line 1619: ,ap_invoice_distributions ppt

1615: ,p_end_date DATE)
1616: IS
1617: SELECT SUM(nvl(pp.base_amount, pp.amount) + nvl(ppt.base_amount, ppt.amount)) prepay_amount
1618: FROM ap_invoice_distributions pp
1619: ,ap_invoice_distributions ppt
1620: WHERE pp.invoice_id = p_invoice_id
1621: AND ppt.invoice_id = p_invoice_id
1622: AND pp.line_type_lookup_code = 'PREPAY'
1623: AND pp.charge_applicable_to_dist_id = ppt.invoice_distribution_id

Line 1632: FROM ap_invoice_distributions ppp

1628: ,p_start_date DATE
1629: ,p_end_date DATE)
1630: IS
1631: SELECT (-1) * SUM(nvl(ppp.base_amount, ppp.amount)) prepay_amount
1632: FROM ap_invoice_distributions ppp
1633: WHERE ppp.invoice_id = p_invoice_id
1634: AND ppp.line_type_lookup_code = 'PREPAY'
1635: AND nvl(ppp.reversal_flag, 'N') <> 'Y'
1636: AND ppp.accounting_date BETWEEN p_start_date AND p_end_date

Line 1638: FROM ap_invoice_distributions ptax

1634: AND ppp.line_type_lookup_code = 'PREPAY'
1635: AND nvl(ppp.reversal_flag, 'N') <> 'Y'
1636: AND ppp.accounting_date BETWEEN p_start_date AND p_end_date
1637: AND NOT EXISTS (SELECT 'x'
1638: FROM ap_invoice_distributions ptax
1639: WHERE ptax.invoice_id = p_invoice_id
1640: AND ppp.charge_applicable_to_dist_id = ptax.invoice_distribution_id);
1641:
1642:

Line 1769: FROM ap_invoice_distributions dis

1765: ,p_start_date DATE
1766: ,p_end_date DATE)
1767: IS
1768: SELECT SUM(nvl(dis.base_amount, dis.amount)) amount
1769: FROM ap_invoice_distributions dis
1770: WHERE dis.invoice_id = p_invoice_id
1771: AND dis.line_type_lookup_code NOT IN ('REC_TAX','NONREC_TAX','PREPAY')
1772: AND dis.accounting_date BETWEEN p_start_date AND p_end_date;
1773:

Line 1781: FROM ap_invoice_distributions dis

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

Line 1795: FROM ap_invoice_distributions dis

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

Line 1809: FROM ap_invoice_distributions dis

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

Line 1827: FROM ap_invoice_distributions dis

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

Line 1843: FROM ap_invoice_distributions dis

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

Line 1855: FROM ap_invoice_distributions dis

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

Line 1866: FROM ap_invoice_distributions dis

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

Line 1877: FROM ap_invoice_distributions dis

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

Line 2048: FROM ap_invoice_distributions dis

2044:
2045: CURSOR c_get_inv_remain_amt (p_end_date DATE)
2046: IS
2047: SELECT round(SUM(nvl(dis.base_amount, dis.amount)), G_PRECISION) remaining_amount
2048: FROM ap_invoice_distributions dis
2049: WHERE dis.invoice_id = p_invoice_id
2050: AND dis.accounting_date <= p_end_date;
2051:
2052: BEGIN

Line 2215: FROM ap_invoice_distributions

2211:
2212: CURSOR c_get_inv_prepay_amt (p_invoice_id NUMBER)
2213: IS
2214: SELECT SUM(decode(invoice_includes_prepay_flag, 'Y', nvl(base_amount, amount), 0)) iipp_amt
2215: FROM ap_invoice_distributions
2216: WHERE invoice_id = p_invoice_id;
2217:
2218: BEGIN
2219: