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_CHECKS

Line 1866: from ap_Checks

1862: l_currency_code,
1863: l_maturity_exchange_rate_type,
1864: l_maturity_exchange_date,
1865: l_maturity_exchange_Rate
1866: from ap_Checks
1867: where check_id = P_check_id;
1868:
1869: l_log_msg := 'Before ap_reconciliation_pkg.recon_payment_history';
1870: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 2199: ap_checks_all ac

2195: BEGIN
2196: select ac.check_id
2197: into l_check_id
2198: from ap_invoice_payments_all aip,
2199: ap_checks_all ac
2200: where aip.check_id=ac.check_id
2201: and aip.accounting_event_id = l_accounting_event_ids(i)
2202: and aip.invoice_id=l_event_source_info.source_id_int_1;
2203:

Line 2802: ap_checks_all ac

2798: BEGIN
2799: select ac.check_id
2800: into l_check_id
2801: from ap_invoice_payments_all aip,
2802: ap_checks_all ac
2803: where aip.check_id=ac.check_id
2804: and aip.accounting_event_id = l_accounting_event_ids(i)
2805: and aip.invoice_id=l_event_source_info.source_id_int_1;
2806:

Line 3252: FROM AP_CHECKS_ALL AC

3248: SET event_status_code = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION
3249: WHERE XEG.application_id = 200
3250: AND XEG.source_id_int_1 IN
3251: ( SELECT AC.check_id
3252: FROM AP_CHECKS_ALL AC
3253: WHERE AC.checkrun_name = p_checkrun_name
3254: and AC.completed_pmts_group_id = p_completed_pmts_group_id
3255: and AC.org_id = p_org_id );
3256:

Line 3429: FROM ap_checks_all ac

3425: ac.org_id,
3426: l_event_type,
3427: p_accounting_date,
3428: l_event_status
3429: FROM ap_checks_all ac
3430: WHERE ac.checkrun_name = p_checkrun_name
3431: AND ac.completed_pmts_group_id = p_completed_pmts_group_id
3432: AND ac.org_id = p_org_id);
3433:

Line 3526: ( select /+ Leading(xeg) index(ac ap_checks_u1) /

3522: accounting_event_id,
3523: request_id,
3524: org_id,
3525: related_event_id ) -- Bug 5015973 -- Bug 5658623: Adding hint
3526: ( select /*+ Leading(xeg) index(ac ap_checks_u1) */
3527: ap_payment_history_s.NEXTVAL, -- payment_history_id
3528: ac.check_id, -- check_id
3529: trunc(p_accounting_date), -- accounting_date bug6602676
3530: l_event_type, -- transaction_type

Line 3563: from ap_checks_all ac,

3559: XEG.event_id, -- accounting_event_id
3560: NULL, -- request_id
3561: ac.org_id, -- org_id
3562: XEG.event_id -- related_event_id
3563: from ap_checks_all ac,
3564: xla_events_int_gt xeg
3565: where ac.completed_pmts_group_id = p_completed_pmts_group_id
3566: and ac.org_id = p_org_id
3567: and xeg.source_id_int_1 = ac.check_id);

Line 3574: ap_checks_all ac

3570:
3571: SELECT COUNT(*)
3572: INTO l_count
3573: FROM ap_payment_history_all aph,
3574: ap_checks_all ac
3575: WHERE aph.check_id = ac.check_id
3576: AND ac.completed_pmts_group_id = p_completed_pmts_group_id
3577: AND ac.org_id = p_org_id;
3578:

Line 3590: ap_checks_all ac

3586:
3587: SELECT accounting_event_id
3588: INTO l_count
3589: FROM ap_payment_history_all aph,
3590: ap_checks_all ac
3591: WHERE aph.check_id = ac.check_id
3592: AND ac.completed_pmts_group_id = p_completed_pmts_group_id
3593: AND ac.org_id = p_org_id
3594: AND rownum = 1;

Line 3795: FROM ap_checks AC,

3791:
3792: CURSOR get_payment_info IS
3793: SELECT AC.check_id,
3794: AIP.accounting_event_id -- Bug3343314
3795: FROM ap_checks AC,
3796: ap_invoice_payments AIP -- Bug3343314
3797: WHERE AC.check_id = AIP.check_id -- Bug3343314
3798: AND AC.checkrun_name = p_checkrun_name
3799: AND AC.status_lookup_code NOT IN ('OVERFLOW', 'SET UP')

Line 4016: AP_CHECKS AC

4012:
4013: SELECT nvl(purch_encumbrance_flag,'N')
4014: INTO l_purch_enc_flag
4015: FROM financials_system_parameters FSP,
4016: AP_CHECKS AC
4017: WHERE AC.org_id = FSP.org_id
4018: AND AC.check_id = p_source_id;
4019: EXCEPTION
4020: WHEN NO_DATA_FOUND THEN

Line 4171: ap_checks AC

4167:
4168: CURSOR l_event_cur IS
4169: SELECT distinct(AIP.accounting_event_id)
4170: FROM ap_invoice_payments AIP,
4171: ap_checks AC
4172: WHERE AIP.check_id = p_check_id
4173: AND AIP.check_id = AC.check_id
4174: AND nvl(AIP.posted_flag, 'N') = 'N'
4175: AND AC.void_date IS NULL;

Line 4333: FROM AP_CHECKS AC

4329: l_exchange_rate,
4330: l_currency_code,
4331: l_creation_date,
4332: l_last_updated_by
4333: FROM AP_CHECKS AC
4334: WHERE AC.check_id = P_check_id;
4335:
4336: l_log_msg := 'Before AP_RECONCILIATION_PKG.INSERT_PAYMENT_HISTORY';
4337: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 4529: FROM ap_checks_all ac,

4525: ac.last_updated_by,
4526: ac.org_id,
4527: ac.payment_type_flag,
4528: asp.automatic_offsets_flag
4529: FROM ap_checks_all ac,
4530: ap_system_parameters_all asp ---7209263 added automatic offsets flag
4531: WHERE ac.check_id = p_check_id
4532: AND ac.org_id=asp.org_id;
4533:

Line 4567: l_pay_type ap_checks_all.payment_type_flag%TYPE;

4563: l_procedure_name CONSTANT VARCHAR2(30) := 'DERIVE_CASCADE_EVENTS';
4564: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4565:
4566: l_event_type xla_events.event_type_code%TYPE;
4567: l_pay_type ap_checks_all.payment_type_flag%TYPE;
4568: l_automatic_offsets_flag ap_system_parameters_all.automatic_offsets_flag%TYPE; ---7209263
4569: l_bank_curr_code ap_payment_history_all.bank_currency_code%TYPE; ---7337949
4570:
4571:

Line 4822: FROM AP_CHECKS AC, ap_system_parameters_all asp

4818: l_creation_date,
4819: l_last_updated_by,
4820: l_org_id,
4821: l_automatic_offsets_flag --7209263
4822: FROM AP_CHECKS AC, ap_system_parameters_all asp
4823: WHERE AC.check_id = l_pay_clear_check_ids(i) --bug 7278341 l_pay_check_ids(i)
4824: AND AC.org_id=asp.org_id;
4825: */
4826: --bug 7607184

Line 4885: FROM AP_CHECKS AC

4881: l_exchange_rate,
4882: l_creation_date,
4883: l_last_updated_by,
4884: l_org_id
4885: FROM AP_CHECKS AC
4886: WHERE AC.check_id = l_pay_check_ids(i);
4887: */
4888:
4889:

Line 4984: FROM AP_CHECKS AC, ap_system_parameters_all asp

4980: l_creation_date,
4981: l_last_updated_by,
4982: l_org_id,
4983: l_automatic_offsets_flag --7209263
4984: FROM AP_CHECKS AC, ap_system_parameters_all asp
4985: WHERE AC.check_id = l_pay_mat_check_ids(i)--bug 7278341 l_pay_check_ids(i)
4986: AND AC.org_id=asp.org_id;
4987:
4988:

Line 5023: FROM AP_CHECKS AC

5019: l_exchange_rate,
5020: l_creation_date,
5021: l_last_updated_by,
5022: l_org_id
5023: FROM AP_CHECKS AC
5024: WHERE AC.check_id = l_pay_check_ids(i);
5025: */
5026:
5027: l_log_msg := 'Before AP_RECONCILIATION_PKG.INSERT_PAYMENT_HISTORY';

Line 5521: FROM ap_checks

5517: IF (l_event_id_list.count <= 1) THEN
5518:
5519: SELECT check_date
5520: INTO l_accounting_date
5521: FROM ap_checks
5522: WHERE check_id = p_check_id;
5523:
5524: IF (l_accounting_date = p_accounting_date) THEN
5525: -- p_event_type_code is left NULL so that 'PAYMENT CREATED' and

Line 5794: ap_checks_all AC

5790: AND ROWNUM = 1
5791: ) ledger_id
5792: FROM
5793: ap_payment_history_all APH,
5794: ap_checks_all AC
5795: WHERE
5796: APH.check_id = AC.check_id
5797: AND AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(TRUNC(APH.accounting_date), aph.org_id) --bug5956469
5798: = p_period_name

Line 5833: ap_checks_all AC

5829: AND ROWNUM = 1
5830: ) ledger_id
5831: FROM
5832: ap_payment_history_all APH,
5833: ap_checks_all AC
5834: WHERE
5835: APH.check_id = AC.check_id
5836: AND APH.accounting_date BETWEEN p_from_date AND p_to_date
5837: AND aph.posted_flag IN ('N', 'S') -- Bug 6869699

Line 6243: ap_checks_all AC

6239: WHERE AIP.check_id = APH.check_id
6240: AND ROWNUM = 1
6241: ) ledger_id
6242: FROM ap_payment_history_all APH,
6243: ap_checks_all AC
6244: WHERE APH.check_id = AC.check_id
6245: AND APH.org_id = AC.org_id
6246: AND AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(TRUNC(APH.accounting_date), aph.org_id) --bug5956469
6247: = p_period_name

Line 6262: ap_checks_all AC

6258: WHERE AIP.check_id = APH.check_id
6259: AND ROWNUM = 1
6260: ) ledger_id
6261: FROM ap_payment_history_all APH,
6262: ap_checks_all AC
6263: WHERE APH.check_id = AC.check_id
6264: AND APH.org_id = AC.org_id
6265: AND APH.accounting_date BETWEEN p_from_date AND p_to_date
6266: AND aph.posted_flag IN ('N', 'S') -- Bug 6869699

Line 6830: from ap_checks_all --bug6705052

6826: END IF;
6827:
6828: select check_number
6829: into l_check_number
6830: from ap_checks_all --bug6705052
6831: where check_id = p_check_id;
6832:
6833: l_event_source_info.application_id := 200;
6834: l_event_source_info.legal_entity_id := p_legal_entity_id;

Line 6994: FROM ap_checks_all AC, --bug6705052

6990: ASP.set_of_books_id
6991: INTO p_org_id,
6992: p_legal_entity_id,
6993: p_ledger_id
6994: FROM ap_checks_all AC, --bug6705052
6995: ap_system_parameters_all ASP --bug6705052
6996: WHERE AC.check_id = p_check_id
6997: AND nvl(AC.org_id,-99) = nvl(ASP.org_id,-99);
6998: