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

Line 683: --FROM AP_Invoice_Payments_All AIP

679: --
680: -- commented below for bug10183934
681: --SELECT count(*)
682: --INTO l_upg_inv_pmts
683: --FROM AP_Invoice_Payments_All AIP
684: --WHERE Invoice_ID = l_inv_pay_rec.invoice_id
685: --AND EXISTS (SELECT 'Upg Payment'
686: -- FROM AP_Payment_History_All APH,
687: -- AP_System_Parameters_All ASP,

Line 776: ap_invoice_payments_all aip

772: FROM dual
773: WHERE EXISTS(
774: SELECT 'Unreversed clearing txns with different xrates'
775: FROM ap_payment_history_all aph,
776: ap_invoice_payments_all aip
777: WHERE aip.invoice_id = l_inv_pay_rec.invoice_id
778: AND aip.check_id = aph.check_id
779: AND aph.transaction_type = 'PAYMENT CLEARING'
780: AND EXISTS(

Line 783: ap_invoice_payments_all aip_sub

779: AND aph.transaction_type = 'PAYMENT CLEARING'
780: AND EXISTS(
781: SELECT 'Unreversed clearing txn with different xrate'
782: FROM ap_payment_history_all aph_sub,
783: ap_invoice_payments_all aip_sub
784: WHERE aip_sub.invoice_id = aip.invoice_id
785: AND aip_sub.check_id = aph_sub.check_id
786: AND aph_sub.check_id <> aph.check_id
787: AND aph_sub.transaction_type = 'PAYMENT CLEARING'

Line 1738: FROM AP_Invoice_Payments_All AIP

1734: AIP.Exchange_Date,
1735: AIP.Exchange_Rate,
1736: NVL(AIP.Reversal_Flag,'N'),
1737: AIP.Reversal_Inv_Pmt_ID
1738: FROM AP_Invoice_Payments_All AIP
1739: WHERE AIP.Check_ID = P_Check_ID
1740: AND AIP.Invoice_ID = P_Invoice_ID
1741: AND AIP.REVERSAL_INV_PMT_ID IS NULL; --bug 9005225
1742:

Line 4764: AP_Invoice_Payments_All AIP,

4760: NULL,
4761: SYSDATE,
4762: FND_GLOBAL.Conc_Request_ID
4763: FROM AP_Payment_Hist_Dists APHD,
4764: AP_Invoice_Payments_All AIP,
4765: AP_Invoice_Distributions_All AID
4766: WHERE AIP.Invoice_Payment_ID = p_reversal_inv_pmt_id
4767: AND AIP.Accounting_Event_ID = APHD.Accounting_Event_ID
4768: AND AIP.Invoice_ID = AID.Invoice_ID

Line 4856: AP_Invoice_Payments_All AIP,

4852: FND_GLOBAL.Conc_Request_ID,
4853: APHD.Gain_Loss_Indicator --11681786
4854: FROM AP_Payment_Hist_Dists APHD,
4855: AP_Payment_History_All APH,
4856: AP_Invoice_Payments_All AIP,
4857: AP_Invoice_Distributions_All AID -- 6804379
4858: WHERE nvl(APH.Related_Event_ID, APH.Accounting_Event_ID) = p_related_event_id
4859: AND APHD.Payment_History_ID = APH.Payment_History_ID
4860: AND NVL(APHD.Reversal_Flag,'N') <> 'Y'