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_ACCTG_DATA_FIX_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 2354: UPDATE ap_Invoice_Payments_All aip

2350: WHERE Accounting_Event_Id = Events_to_Process_tab(i).Event_Id
2351: AND Check_Id = p_Source_Id;
2352:
2353:
2354: UPDATE ap_Invoice_Payments_All aip
2355: SET Accounting_Date = l_gl_Date,
2356: Posted_Flag = 'N',
2357: Accrual_Posted_Flag = 'N',
2358: Last_Updated_By = fnd_Global.User_Id,

Line 3292: FROM Ap_Invoice_Payments_All AIP

3288: AIP.Exchange_Date,
3289: AIP.Exchange_Rate,
3290: NVL(AIP.Reversal_Flag,'N'),
3291: AIP.Reversal_Inv_Pmt_ID
3292: FROM Ap_Invoice_Payments_All AIP
3293: WHERE AIP.invoice_id = P_Invoice_id
3294: AND AIP.accounting_event_id = nvl(P_Event_id, AIP.accounting_event_id)
3295: AND AIP.check_id = nvl(P_Check_id, AIP.check_id)
3296: AND nvl(AIP.reversal_flag, 'N') <> 'Y';

Line 3554: FROM ap_invoice_payments_all aip,

3550:
3551:
3552: SELECT count(*)
3553: INTO l_count_hist_pay
3554: FROM ap_invoice_payments_all aip,
3555: xla_ae_headers xah,
3556: xla_transaction_entities_upg xte,
3557: xla_ae_lines xal
3558: WHERE xah.application_id = 200

Line 3620: ap_invoice_payments_all aip

3616: SELECT count(*)
3617: INTO l_cnt_unacc_pay_evnts
3618: FROM xla_events xe,
3619: xla_transaction_entities_upg xte,
3620: ap_invoice_payments_all aip
3621: WHERE xe.application_id = 200
3622: AND xte.application_id = 200
3623: AND xte.entity_code = 'AP_PAYMENTS'
3624: AND xe.entity_id = xte.entity_id

Line 3686: ap_invoice_payments_all aip

3682: INTO l_cnt_untrx_pay_evnts
3683: FROM xla_events xe,
3684: xla_ae_headers xah,
3685: xla_transaction_entities_upg xte,
3686: ap_invoice_payments_all aip
3687: WHERE xe.application_id = 200
3688: AND xte.application_id = 200
3689: AND xte.entity_code = 'AP_PAYMENTS'
3690: AND xe.entity_id = xte.entity_id

Line 3725: ap_invoice_payments_all aip

3721: AND xe.event_status_code = 'P'
3722: AND xe.event_id IN
3723: (SELECT aph.accounting_event_id
3724: FROM ap_payment_history_all aph,
3725: ap_invoice_payments_all aip
3726: WHERE aip.check_id = aph.check_id
3727: AND aip.invoice_id = l_invoice_id
3728: AND aph.rev_pmt_hist_id IS NULL
3729: AND aph.transaction_type IN ('PAYMENT CREATED',