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 2132: FROM ap_checks_all ac,

2128: IF (p_event_type IN (PAYMENT_MATURTY_TRX_TYPE, PAYMENT_MATURTY_RVRSL_TRX_TYPE)) THEN
2129: BEGIN
2130: SELECT 1
2131: INTO l_dummy
2132: FROM ap_checks_all ac,
2133: ap_system_parameters_all asp
2134: WHERE ac.check_id =l_event_source_info.source_id_int_1
2135: AND ac.org_id = asp.org_id
2136: AND exists (

Line 2161: FROM ap_checks_all ac,

2157: ELSE
2158: BEGIN
2159: SELECT 1
2160: INTO l_dummy
2161: FROM ap_checks_all ac,
2162: ap_system_parameters_all asp
2163: WHERE ac.check_id =l_event_source_info.source_id_int_1
2164: AND ac.org_id = asp.org_id
2165: /*AND not exists (

Line 2189: FROM ap_checks_all ac,

2185: /*
2186: BEGIN
2187: SELECT 1
2188: INTO l_dummy
2189: FROM ap_checks_all ac,
2190: ap_system_parameters_all asp
2191: WHERE ac.check_id =l_event_source_info.source_id_int_1
2192: AND ac.org_id = asp.org_id
2193: AND exists (

Line 2215: FROM ap_checks_all ac,

2211: WHEN NO_DATA_FOUND THEN
2212: BEGIN
2213: SELECT 1
2214: INTO l_dummy
2215: FROM ap_checks_all ac,
2216: ap_system_parameters_all asp
2217: WHERE ac.check_id =l_event_source_info.source_id_int_1
2218: AND ac.org_id = asp.org_id
2219: AND not exists (

Line 2700: ap_checks_all ac

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

Line 2716: FROM ap_checks_all ac,

2712: --bug 8358552 starts
2713: BEGIN
2714: SELECT 1
2715: INTO l_dummy
2716: FROM ap_checks_all ac,
2717: ap_system_parameters_all asp
2718: WHERE ac.check_id =l_event_source_info.source_id_int_1
2719: AND ac.org_id = asp.org_id
2720: AND( (ac.currency_code <> asp.base_currency_code

Line 3322: ap_checks_all ac

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

Line 3772: FROM AP_CHECKS_ALL AC

3768: SET event_status_code = XLA_EVENTS_PUB_PKG.C_EVENT_NOACTION
3769: WHERE XEG.application_id = 200
3770: AND XEG.source_id_int_1 IN
3771: ( SELECT AC.check_id
3772: FROM AP_CHECKS_ALL AC
3773: WHERE AC.checkrun_name = p_checkrun_name
3774: and AC.completed_pmts_group_id = p_completed_pmts_group_id
3775: and AC.org_id = p_org_id );
3776:

Line 3962: FROM ap_checks_all ac

3958: decode(ac.exchange_rate_type, NULL, XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE,
3959: decode(ac.exchange_rate, NULL, XLA_EVENTS_PUB_PKG.C_EVENT_INCOMPLETE,
3960: XLA_EVENTS_PUB_PKG.C_EVENT_UNPROCESSED))))
3961: --bug 8358552 ends
3962: FROM ap_checks_all ac
3963: , ap_system_parameters_all asp
3964: WHERE ac.checkrun_name = p_checkrun_name
3965: AND ac.completed_pmts_group_id = p_completed_pmts_group_id
3966: AND ac.org_id = p_org_id

Line 4100: from ap_checks_all ac,

4096: XEG.event_id, -- accounting_event_id
4097: NULL, -- request_id
4098: ac.org_id, -- org_id
4099: XEG.event_id -- related_event_id
4100: from ap_checks_all ac,
4101: xla_events_int_gt xeg
4102: where ac.completed_pmts_group_id = p_completed_pmts_group_id
4103: and ac.org_id = p_org_id
4104: and xeg.source_id_int_1 = ac.check_id);

Line 4111: ap_checks_all ac

4107:
4108: SELECT COUNT(*)
4109: INTO l_count
4110: FROM ap_payment_history_all aph,
4111: ap_checks_all ac
4112: WHERE aph.check_id = ac.check_id
4113: AND ac.completed_pmts_group_id = p_completed_pmts_group_id
4114: AND ac.org_id = p_org_id;
4115:

Line 4127: ap_checks_all ac

4123:
4124: SELECT accounting_event_id
4125: INTO l_count
4126: FROM ap_payment_history_all aph,
4127: ap_checks_all ac
4128: WHERE aph.check_id = ac.check_id
4129: AND ac.completed_pmts_group_id = p_completed_pmts_group_id
4130: AND ac.org_id = p_org_id
4131: AND rownum = 1;

Line 5216: FROM ap_checks_all ac,

5212: ac.last_updated_by,
5213: ac.org_id,
5214: ac.payment_type_flag,
5215: asp.automatic_offsets_flag
5216: FROM ap_checks_all ac,
5217: ap_system_parameters_all asp ---7209263 added automatic offsets flag
5218: WHERE ac.check_id = p_check_id
5219: AND ac.org_id=asp.org_id;
5220:

Line 5254: l_pay_type ap_checks_all.payment_type_flag%TYPE;

5250: l_procedure_name CONSTANT VARCHAR2(30) := 'DERIVE_CASCADE_EVENTS';
5251: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5252:
5253: l_event_type xla_events.event_type_code%TYPE;
5254: l_pay_type ap_checks_all.payment_type_flag%TYPE;
5255: l_automatic_offsets_flag ap_system_parameters_all.automatic_offsets_flag%TYPE; ---7209263
5256: l_bank_curr_code ap_payment_history_all.bank_currency_code%TYPE; ---7337949
5257:
5258: -- Bug 8276852 Start

Line 6538: ap_checks_all AC

6534: AND ROWNUM = 1
6535: ) ledger_id
6536: FROM
6537: ap_payment_history_all APH,
6538: ap_checks_all AC
6539: WHERE
6540: APH.check_id = AC.check_id
6541: AND AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(TRUNC(APH.accounting_date), aph.org_id) --bug5956469
6542: = p_period_name

Line 6577: ap_checks_all AC

6573: AND ROWNUM = 1
6574: ) ledger_id
6575: FROM
6576: ap_payment_history_all APH,
6577: ap_checks_all AC
6578: WHERE
6579: APH.check_id = AC.check_id
6580: AND APH.accounting_date BETWEEN p_from_date AND p_to_date
6581: AND aph.posted_flag IN ('N', 'S') -- Bug 6869699

Line 6987: ap_checks_all AC

6983: WHERE AIP.check_id = APH.check_id
6984: AND ROWNUM = 1
6985: ) ledger_id
6986: FROM ap_payment_history_all APH,
6987: ap_checks_all AC
6988: WHERE APH.check_id = AC.check_id
6989: AND APH.org_id = AC.org_id
6990: AND AP_UTILITIES_PKG.GET_CURRENT_GL_DATE(TRUNC(APH.accounting_date), aph.org_id) --bug5956469
6991: = p_period_name

Line 7006: ap_checks_all AC

7002: WHERE AIP.check_id = APH.check_id
7003: AND ROWNUM = 1
7004: ) ledger_id
7005: FROM ap_payment_history_all APH,
7006: ap_checks_all AC
7007: WHERE APH.check_id = AC.check_id
7008: AND APH.org_id = AC.org_id
7009: AND APH.accounting_date BETWEEN p_from_date AND p_to_date
7010: AND aph.posted_flag IN ('N', 'S') -- Bug 6869699

Line 7575: from ap_checks_all --bug6705052

7571: END IF;
7572:
7573: select check_number
7574: into l_check_number
7575: from ap_checks_all --bug6705052
7576: where check_id = p_check_id;
7577:
7578: l_event_source_info.application_id := 200;
7579: l_event_source_info.legal_entity_id := p_legal_entity_id;

Line 7739: FROM ap_checks_all AC, --bug6705052

7735: ASP.set_of_books_id
7736: INTO p_org_id,
7737: p_legal_entity_id,
7738: p_ledger_id
7739: FROM ap_checks_all AC, --bug6705052
7740: ap_system_parameters_all ASP --bug6705052
7741: WHERE AC.check_id = p_check_id
7742: AND nvl(AC.org_id,-99) = nvl(ASP.org_id,-99);
7743: