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.AP_ACCOUNTING_EVENTS_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 2699: from ap_invoice_payments_all aip,

2695: if (l_count > 0) then
2696: BEGIN
2697: select DISTINCT ac.check_id --bug10024752
2698: into l_check_id
2699: from ap_invoice_payments_all aip,
2700: ap_checks_all ac
2701: where aip.check_id=ac.check_id
2702: and aip.accounting_event_id = l_accounting_event_ids(i)
2703: and aip.invoice_id=l_event_source_info.source_id_int_1;

Line 3321: from ap_invoice_payments_all aip,

3317: if (l_count > 0) then
3318: BEGIN
3319: select ac.check_id
3320: into l_check_id
3321: from ap_invoice_payments_all aip,
3322: ap_checks_all ac
3323: where aip.check_id=ac.check_id
3324: and aip.accounting_event_id = l_accounting_event_ids(i)
3325: and aip.invoice_id=l_event_source_info.source_id_int_1;

Line 4273: FROM ap_invoice_payments_all AIP2,

4269: SET D.accounting_event_id = p_event_id
4270: WHERE D.accounting_event_id IS NULL
4271: AND D.invoice_id IN
4272: (SELECT AI.invoice_id
4273: FROM ap_invoice_payments_all AIP2,
4274: ap_invoices_all AI
4275: WHERE AI.invoice_id = AIP2.invoice_id
4276: AND AIP2.check_id = p_check_id
4277: AND AIP2.accounting_event_id = p_event_id

Line 4446: FROM ap_invoice_payments_all AIP,

4442: SET AID.accounting_event_id = l_accounting_event_ids(i)
4443: WHERE AID.accounting_event_id IS NULL
4444: AND AID.invoice_id IN
4445: ( SELECT AI.invoice_id
4446: FROM ap_invoice_payments_all AIP,
4447: ap_invoices_all AI
4448: WHERE AIP.invoice_id = AI.invoice_id
4449: AND AIP.accounting_event_id = l_accounting_event_ids(i)
4450: AND AIP.check_id = l_check_ids(i)

Line 6532: FROM ap_invoice_payments_all AIP

6528: APH.check_id check_id,
6529: APH.org_id,
6530: AC.legal_entity_id,
6531: ( SELECT AIP.set_of_books_id
6532: FROM ap_invoice_payments_all AIP
6533: WHERE AIP.check_id = APH.check_id
6534: AND ROWNUM = 1
6535: ) ledger_id
6536: FROM

Line 6571: FROM ap_invoice_payments_all AIP

6567: APH.check_id check_id,
6568: APH.org_id,
6569: AC.legal_entity_id,
6570: ( SELECT AIP.set_of_books_id
6571: FROM ap_invoice_payments_all AIP
6572: WHERE AIP.check_id = APH.check_id
6573: AND ROWNUM = 1
6574: ) ledger_id
6575: FROM

Line 6982: FROM ap_invoice_payments_all AIP

6978: APH.check_id,
6979: APH.org_id,
6980: AC.legal_entity_id,
6981: ( SELECT AIP.set_of_books_id
6982: FROM ap_invoice_payments_all AIP
6983: WHERE AIP.check_id = APH.check_id
6984: AND ROWNUM = 1
6985: ) ledger_id
6986: FROM ap_payment_history_all APH,

Line 7001: FROM ap_invoice_payments_all AIP

6997: APH.check_id,
6998: APH.org_id,
6999: AC.legal_entity_id,
7000: ( SELECT AIP.set_of_books_id
7001: FROM ap_invoice_payments_all AIP
7002: WHERE AIP.check_id = APH.check_id
7003: AND ROWNUM = 1
7004: ) ledger_id
7005: FROM ap_payment_history_all APH,

Line 8210: FROM ap_invoice_payments_all aip,

8206: )
8207: ) OR --bug9441420 added OR clause
8208: (NOT EXISTS
8209: (SELECT 1
8210: FROM ap_invoice_payments_all aip,
8211: ap_invoice_distributions_all aid_prepay
8212: WHERE aip.invoice_id = aid_prepay.invoice_id
8213: AND aid_prepay.invoice_distribution_id = aid.prepay_distribution_id
8214: AND nvl(aip.reversal_flag, 'N') = 'N'