DBA Data[Home] [Help]

APPS.OKL_AM_BAL_WRITEOFF_PVT dependencies on AR_PAYMENT_SCHEDULES_ALL

Line 816: AR_PAYMENT_SCHEDULES_ALL APS

812: RACTRL.CUSTOMER_TRX_ID AR_INVOICE_NUMBER,
813: RACTRL.til_id_details TIL_ID,
814: RACTRL.TLD_ID TLD_ID
815: FROM OKL_BPD_TLD_AR_LINES_V RACTRL,
816: AR_PAYMENT_SCHEDULES_ALL APS
817: WHERE RACTRL.khr_id = p_khr_id
818: AND RACTRL.amount_due_remaining > 0
819: AND RACTRL.CUSTOMER_TRX_ID = APS.CUSTOMER_TRX_ID
820: AND RACTRL.invoice_date <= p_trn_date;