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.

[Home] [Help]

APPS.AP_ACCOUNTING_PAY_PKG dependencies on XLA_EVENT_TYPES_B

Line 1819: , xla_event_types_b xet

1815: WHERE EXISTS(
1816: SELECT 'unreversed, unaccounted payment not selected for accounting'
1817: FROM ap_payment_history_all aph
1818: , ap_invoice_payments_all aip
1819: , xla_event_types_b xet
1820: , xla_event_types_b xet_rel
1821: , xla_events xe
1822: WHERE aip.invoice_id = p_inv_rec.invoice_id
1823: AND aph.check_id = aip.check_id

Line 1820: , xla_event_types_b xet_rel

1816: SELECT 'unreversed, unaccounted payment not selected for accounting'
1817: FROM ap_payment_history_all aph
1818: , ap_invoice_payments_all aip
1819: , xla_event_types_b xet
1820: , xla_event_types_b xet_rel
1821: , xla_events xe
1822: WHERE aip.invoice_id = p_inv_rec.invoice_id
1823: AND aph.check_id = aip.check_id
1824: AND xe.event_id = aph.accounting_event_id

Line 1893: , xla_event_types_b xet

1889: -- payment
1890: SELECT MAX(aph.accounting_event_id) accounting_event_id
1891: FROM ap_payment_history_all aph
1892: , ap_invoice_payments_all aip
1893: , xla_event_types_b xet
1894: , xla_event_types_b xet_rel
1895: , xla_events xe
1896: , xla_events_gt xgt
1897: WHERE aip.invoice_id = p_inv_rec.invoice_id

Line 1894: , xla_event_types_b xet_rel

1890: SELECT MAX(aph.accounting_event_id) accounting_event_id
1891: FROM ap_payment_history_all aph
1892: , ap_invoice_payments_all aip
1893: , xla_event_types_b xet
1894: , xla_event_types_b xet_rel
1895: , xla_events xe
1896: , xla_events_gt xgt
1897: WHERE aip.invoice_id = p_inv_rec.invoice_id
1898: AND aph.check_id = aip.check_id