DBA Data[Home] [Help]

APPS.GMF_AR_GET_PAYMENT_DETAILS dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 95: AR_RECEIVABLE_APPLICATIONS_ALL arr

91: arr.REVERSAL_GL_DATE,
92: ' ',
93: arr.CASH_RECEIPT_HISTORY_ID
94: from AR_CASH_RECEIPTS_ALL arc,
95: AR_RECEIVABLE_APPLICATIONS_ALL arr
96: where (arr.APPLIED_CUSTOMER_TRX_ID = invoice_id)
97: AND (arr.last_update_date between nvl(start_date, arr.last_update_date)
98: AND nvl(end_date, arr.last_update_date))
99: AND (arc.CASH_RECEIPT_ID = arr.CASH_RECEIPT_ID);