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_PAYMENT_HISTORY_ALL

Line 2004: FROM ap_payment_history_all aphp,

2000: PAYMENT_MATURITY_ADJUSTED_TYPE, PAYMENT_CLEARED_TRX_TYPE,
2001: PAYMENT_UNCLEARED_TRX_TYPE, PAYMENT_CLEARING_ADJUSTED_TYPE)
2002: AND NOT EXISTS
2003: (SELECT 1
2004: FROM ap_payment_history_all aphp,
2005: xla_events xe,
2006: ap_system_parameters_all asp
2007: WHERE aph.check_id = aphp.check_id
2008: AND aphp.payment_history_id = aph.rev_pmt_hist_id

Line 2029: FROM ap_payment_history_all aphp,

2025: AND transaction_type IN (PAYMENT_MATURTY_RVRSL_TRX_TYPE, PAYMENT_MATURTY_TRX_TYPE,
2026: PAYMENT_CLEARED_TRX_TYPE, PAYMENT_UNCLEARED_TRX_TYPE)
2027: AND NOT EXISTS
2028: (SELECT 1
2029: FROM ap_payment_history_all aphp,
2030: xla_events xe
2031: WHERE aph.check_id = aphp.check_id
2032: AND aphp.payment_history_id = aph.rev_pmt_hist_id
2033: AND aphp.posted_flag = 'Y'

Line 2138: FROM ap_payment_history_all aph

2134: WHERE ac.check_id =l_event_source_info.source_id_int_1
2135: AND ac.org_id = asp.org_id
2136: AND exists (
2137: SELECT 1
2138: FROM ap_payment_history_all aph
2139: WHERE ac.check_id = aph.check_id
2140: AND aph.transaction_type = PAYMENT_MATURTY_TRX_TYPE
2141: )
2142: AND(

Line 2167: FROM ap_payment_history_all aph

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 (
2166: SELECT 1
2167: FROM ap_payment_history_all aph
2168: WHERE ac.check_id = aph.check_id
2169: AND aph.transaction_type = PAYMENT_MATURTY_TRX_TYPE
2170: )*/ /* bug 13616704 */
2171: AND(

Line 2195: FROM ap_payment_history_all aph

2191: WHERE ac.check_id =l_event_source_info.source_id_int_1
2192: AND ac.org_id = asp.org_id
2193: AND exists (
2194: SELECT 1
2195: FROM ap_payment_history_all aph
2196: WHERE ac.check_id = aph.check_id
2197: AND aph.transaction_type = PAYMENT_MATURTY_TRX_TYPE
2198: )
2199: AND(

Line 2221: FROM ap_payment_history_all aph

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 (
2220: SELECT 1
2221: FROM ap_payment_history_all aph
2222: WHERE ac.check_id = aph.check_id
2223: AND aph.transaction_type = PAYMENT_MATURTY_TRX_TYPE
2224: )
2225: AND(

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 4026: INSERT INTO ap_payment_history_all

4022: END IF;
4023:
4024: BEGIN
4025:
4026: INSERT INTO ap_payment_history_all
4027: ( payment_history_id,
4028: check_id,
4029: accounting_date,
4030: transaction_type,

Line 4110: FROM ap_payment_history_all aph,

4106: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
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;

Line 4126: FROM ap_payment_history_all aph,

4122: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
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

Line 5256: l_bank_curr_code ap_payment_history_all.bank_currency_code%TYPE; ---7337949

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
5259: l_bank_to_base_xrate_type ap_payment_history_all.bank_to_base_xrate_type%TYPE;
5260: l_bank_to_base_xrate_date ap_payment_history_all.bank_to_base_xrate_date%TYPE;

Line 5259: l_bank_to_base_xrate_type ap_payment_history_all.bank_to_base_xrate_type%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
5259: l_bank_to_base_xrate_type ap_payment_history_all.bank_to_base_xrate_type%TYPE;
5260: l_bank_to_base_xrate_date ap_payment_history_all.bank_to_base_xrate_date%TYPE;
5261: l_bank_to_base_xrate ap_payment_history_all.bank_to_base_xrate%TYPE;
5262: l_charges_bank_amount ap_payment_history_all.charges_bank_amount%TYPE; /*Bug13385106 */
5263: -- Bug 8276852 End

Line 5260: l_bank_to_base_xrate_date ap_payment_history_all.bank_to_base_xrate_date%TYPE;

5256: l_bank_curr_code ap_payment_history_all.bank_currency_code%TYPE; ---7337949
5257:
5258: -- Bug 8276852 Start
5259: l_bank_to_base_xrate_type ap_payment_history_all.bank_to_base_xrate_type%TYPE;
5260: l_bank_to_base_xrate_date ap_payment_history_all.bank_to_base_xrate_date%TYPE;
5261: l_bank_to_base_xrate ap_payment_history_all.bank_to_base_xrate%TYPE;
5262: l_charges_bank_amount ap_payment_history_all.charges_bank_amount%TYPE; /*Bug13385106 */
5263: -- Bug 8276852 End
5264:

Line 5261: l_bank_to_base_xrate ap_payment_history_all.bank_to_base_xrate%TYPE;

5257:
5258: -- Bug 8276852 Start
5259: l_bank_to_base_xrate_type ap_payment_history_all.bank_to_base_xrate_type%TYPE;
5260: l_bank_to_base_xrate_date ap_payment_history_all.bank_to_base_xrate_date%TYPE;
5261: l_bank_to_base_xrate ap_payment_history_all.bank_to_base_xrate%TYPE;
5262: l_charges_bank_amount ap_payment_history_all.charges_bank_amount%TYPE; /*Bug13385106 */
5263: -- Bug 8276852 End
5264:
5265: /* bug12363669 start */

Line 5262: l_charges_bank_amount ap_payment_history_all.charges_bank_amount%TYPE; /Bug13385106 /

5258: -- Bug 8276852 Start
5259: l_bank_to_base_xrate_type ap_payment_history_all.bank_to_base_xrate_type%TYPE;
5260: l_bank_to_base_xrate_date ap_payment_history_all.bank_to_base_xrate_date%TYPE;
5261: l_bank_to_base_xrate ap_payment_history_all.bank_to_base_xrate%TYPE;
5262: l_charges_bank_amount ap_payment_history_all.charges_bank_amount%TYPE; /*Bug13385106 */
5263: -- Bug 8276852 End
5264:
5265: /* bug12363669 start */
5266: l_pmt_to_base_xrate_type ap_payment_history_all.pmt_to_base_xrate_type%type;

Line 5266: l_pmt_to_base_xrate_type ap_payment_history_all.pmt_to_base_xrate_type%type;

5262: l_charges_bank_amount ap_payment_history_all.charges_bank_amount%TYPE; /*Bug13385106 */
5263: -- Bug 8276852 End
5264:
5265: /* bug12363669 start */
5266: l_pmt_to_base_xrate_type ap_payment_history_all.pmt_to_base_xrate_type%type;
5267: l_pmt_to_base_xrate_date ap_payment_history_all.pmt_to_base_xrate_date%type;
5268: l_pmt_to_base_xrate ap_payment_history_all.pmt_to_base_xrate%type;
5269: /* bug12363669 end*/
5270:

Line 5267: l_pmt_to_base_xrate_date ap_payment_history_all.pmt_to_base_xrate_date%type;

5263: -- Bug 8276852 End
5264:
5265: /* bug12363669 start */
5266: l_pmt_to_base_xrate_type ap_payment_history_all.pmt_to_base_xrate_type%type;
5267: l_pmt_to_base_xrate_date ap_payment_history_all.pmt_to_base_xrate_date%type;
5268: l_pmt_to_base_xrate ap_payment_history_all.pmt_to_base_xrate%type;
5269: /* bug12363669 end*/
5270:
5271: l_accounting_date DATE := p_accounting_date; -- bug 10126192

Line 5268: l_pmt_to_base_xrate ap_payment_history_all.pmt_to_base_xrate%type;

5264:
5265: /* bug12363669 start */
5266: l_pmt_to_base_xrate_type ap_payment_history_all.pmt_to_base_xrate_type%type;
5267: l_pmt_to_base_xrate_date ap_payment_history_all.pmt_to_base_xrate_date%type;
5268: l_pmt_to_base_xrate ap_payment_history_all.pmt_to_base_xrate%type;
5269: /* bug12363669 end*/
5270:
5271: l_accounting_date DATE := p_accounting_date; -- bug 10126192
5272: l_count NUMBER; --bug12569594

Line 5600: FROM ap_payment_history_all APH

5596: ,l_pmt_to_base_xrate_type
5597: ,l_pmt_to_base_xrate_date
5598: ,l_pmt_to_base_xrate
5599: /* bug12363669 end*/
5600: FROM ap_payment_history_all APH
5601: WHERE APH.check_id = l_pay_clear_check_ids(i)
5602: AND APH.transaction_type = 'PAYMENT CLEARING'
5603: --added for bug 7614505
5604: AND NOT EXISTS( SELECT 'PAYMENT UNCLEARING EXISTS'

Line 5605: FROM ap_payment_history_all APH1

5601: WHERE APH.check_id = l_pay_clear_check_ids(i)
5602: AND APH.transaction_type = 'PAYMENT CLEARING'
5603: --added for bug 7614505
5604: AND NOT EXISTS( SELECT 'PAYMENT UNCLEARING EXISTS'
5605: FROM ap_payment_history_all APH1
5606: WHERE APH1.rev_pmt_hist_id = APH.payment_history_id
5607: AND APH1.transaction_type = 'PAYMENT UNCLEARING'
5608: AND APH1.check_id = APH.check_id);
5609:

Line 6537: ap_payment_history_all APH,

6533: WHERE AIP.check_id = APH.check_id
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

Line 6576: ap_payment_history_all APH,

6572: WHERE AIP.check_id = APH.check_id
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

Line 6986: FROM ap_payment_history_all APH,

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

Line 7005: FROM ap_payment_history_all APH,

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