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

Line 1481: FROM ap_invoice_payments AIP

1477:
1478: BEGIN
1479: SELECT MAX(accounting_event_id)
1480: INTO l_pay_accounting_event_id
1481: FROM ap_invoice_payments AIP
1482: WHERE AIP.invoice_id = p_invoice_id
1483: AND AIP.posted_flag = 'Y';
1484: EXCEPTION
1485: WHEN NO_DATA_FOUND THEN

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 2825: FROM ap_invoice_payments AIP, ap_payment_history_all APH

2821: -- Payment Adjustment Events.
2822: CURSOR l_invoice_payments_cur IS --bug 7042296
2823: SELECT distinct(AIP.check_id),
2824: APH.accounting_event_id
2825: FROM ap_invoice_payments AIP, ap_payment_history_all APH
2826: WHERE AIP.invoice_id = p_invoice_id
2827: AND AIP.accounting_event_id IS NOT NULL
2828: and AIP.check_id = APH.check_id
2829: and APH.accounting_event_id is not null

Line 3127: FROM ap_invoice_payments AIP,

3123:
3124: CURSOR l_invoice_distributions_cur IS
3125: SELECT distinct(AID.invoice_id),
3126: AID.accounting_event_id
3127: FROM ap_invoice_payments AIP,
3128: ap_invoice_distributions AID
3129: WHERE AIP.invoice_id = AID.invoice_id
3130: AND AIP.check_id = p_check_id
3131: AND AID.accounting_event_id IS NOT NULL

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 3421: FROM ap_invoice_payments AIP

3417: DECLARE
3418:
3419: CURSOR l_invoice_payments_cur IS
3420: SELECT distinct(AIP.accounting_event_id)
3421: FROM ap_invoice_payments AIP
3422: WHERE AIP.check_id = p_check_id
3423: AND AIP.accounting_event_id IS NOT NULL;
3424:
3425: l_payment_event_status VARCHAR2(1);

Line 4253: FROM ap_invoice_payments AIP1

4249: SET D.accounting_event_id = p_event_id
4250: WHERE D.accounting_event_id IS NULL
4251: AND D.awt_invoice_payment_id IN
4252: (SELECT AIP1.invoice_payment_id
4253: FROM ap_invoice_payments AIP1
4254: WHERE AIP1.accounting_event_id = p_event_id
4255: AND AIP1.check_id = p_check_id);
4256:
4257: --Stamp the event_id on all invoice dists that belong to interest

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 4338: ap_invoice_payments AIP -- Bug3343314

4334: SELECT DISTINCT AC.check_id, /* Added the distinct for bug#8368922 */
4335: AIP.accounting_event_id -- Bug3343314
4336: , AIP.invoice_id /* Added the distinct for bug#8438184 */
4337: FROM ap_checks AC,
4338: ap_invoice_payments AIP -- Bug3343314
4339: WHERE AC.check_id = AIP.check_id -- Bug3343314
4340: AND AC.checkrun_name = p_checkrun_name
4341: AND AC.status_lookup_code NOT IN ('OVERFLOW', 'SET UP')
4342: AND AC.completed_pmts_group_id = p_completed_pmts_group_id

Line 4411: FROM ap_invoice_payments AIP

4407: SET AID.accounting_event_id = l_accounting_event_ids(i)
4408: WHERE AID.accounting_event_id IS NULL
4409: AND AID.awt_invoice_payment_id IN
4410: (SELECT AIP.invoice_payment_id
4411: FROM ap_invoice_payments AIP
4412: WHERE AIP.check_id = l_check_ids(i) AND
4413: AIP.accounting_event_id = l_accounting_event_ids(i)
4414: AND AIP.invoice_id = l_invoice_ids(i)); /* Added for bug#8438184 */
4415:

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 4601: FROM ap_invoice_payments

4597: SELECT count(*)
4598: INTO l_count
4599: FROM ap_invoice_distributions AID1
4600: WHERE AID1.invoice_id in (SELECT invoice_id
4601: FROM ap_invoice_payments
4602: WHERE check_id = p_source_id)
4603: AND nvl(AID1.match_status_flag,'N') NOT IN ('T','A');
4604: EXCEPTION
4605: WHEN NO_DATA_FOUND THEN

Line 4615: FROM ap_invoice_payments

4611: SELECT count(*)
4612: INTO l_count
4613: FROM ap_invoice_distributions AID
4614: WHERE AID.invoice_id in (SELECT invoice_id
4615: FROM ap_invoice_payments
4616: WHERE check_id = p_source_id)
4617: AND nvl(AID.match_status_flag,'N') <> 'A' ;
4618: EXCEPTION
4619: WHEN NO_DATA_FOUND THEN

Line 4651: FROM ap_invoice_payments

4647: SELECT count(*)
4648: INTO l_count
4649: FROM ap_holds H, ap_hold_codes C
4650: WHERE H.invoice_id in (SELECT invoice_id
4651: FROM ap_invoice_payments
4652: WHERE check_id = p_source_id)
4653: AND H.hold_lookup_code = C.hold_lookup_code
4654: AND ((H.release_lookup_code IS NULL)
4655: AND (C.postable_flag ='N'

Line 4740: FROM ap_invoice_payments AIP,

4736: l_last_updated_by NUMBER(15);
4737:
4738: CURSOR l_event_cur IS
4739: SELECT distinct(AIP.accounting_event_id)
4740: FROM ap_invoice_payments AIP,
4741: ap_checks AC
4742: WHERE AIP.check_id = p_check_id
4743: AND AIP.check_id = AC.check_id
4744: AND nvl(AIP.posted_flag, 'N') = 'N'

Line 5089: FROM ap_invoice_payments AIP,

5085:
5086: CURSOR l_payments_cur IS
5087: SELECT DISTINCT AIP.check_id,
5088: AIP.accounting_date
5089: FROM ap_invoice_payments AIP,
5090: xla_events XE
5091: WHERE AIP.invoice_id = p_invoice_id
5092: AND AIP.posted_flag = 'Y'
5093: AND NVL(AIP.reversal_flag, 'N') <> 'Y'

Line 5123: ap_invoice_payments AIP,

5119: CURSOR l_payment_clearings_cur IS
5120: SELECT DISTINCT APH.check_id,
5121: APH.accounting_date
5122: FROM ap_payment_history APH,
5123: ap_invoice_payments AIP,
5124: xla_events XE
5125: WHERE AIP.invoice_id = p_invoice_id
5126: AND AIP.check_id = APH.check_id
5127: AND APH.transaction_type = 'PAYMENT CLEARING'

Line 5168: ap_invoice_payments AIP,

5164: CURSOR l_payment_maturities_cur IS
5165: SELECT DISTINCT APH.check_id,
5166: APH.accounting_date
5167: FROM ap_payment_history APH,
5168: ap_invoice_payments AIP,
5169: xla_events XE
5170: WHERE AIP.invoice_id = p_invoice_id
5171: AND AIP.check_id = APH.check_id
5172: AND APH.transaction_type = 'PAYMENT MATURITY'

Line 6134: FROM ap_invoice_payments

6130:
6131: -- Bug 4748638
6132: CURSOR aip_event_id_count IS
6133: SELECT accounting_event_id
6134: FROM ap_invoice_payments
6135: WHERE check_id = p_check_id
6136: GROUP BY accounting_event_id;
6137:
6138: TYPE event_id_tab_Type IS TABLE OF

Line 6139: ap_invoice_payments.accounting_event_id%TYPE;

6135: WHERE check_id = p_check_id
6136: GROUP BY accounting_event_id;
6137:
6138: TYPE event_id_tab_Type IS TABLE OF
6139: ap_invoice_payments.accounting_event_id%TYPE;
6140: l_event_id_list event_id_tab_Type;
6141:
6142: l_legal_entity_id NUMBER(15);
6143: l_ledger_id NUMBER(15);

Line 6246: FROM ap_invoice_payments

6242: END IF;
6243:
6244: SELECT COUNT(*)
6245: INTO l_processed_events
6246: FROM ap_invoice_payments
6247: WHERE posted_flag = 'Y'
6248: AND check_id = p_check_id;
6249:
6250: IF (l_processed_events = 0) THEN

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'