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_ALL

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 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 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 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: