DBA Data[Home] [Help]

APPS.AR_LATE_CHARGE_UPG dependencies on AR_ADJUSTMENTS_ALL

Line 954: ar_adjustments_all adj

950: csu.last_accrue_charge_date as csu_last_charge_date,
951: rank () over (partition by adj.payment_schedule_id order by adjustment_id desc) as rk
952: FROM hz_cust_site_uses_all csu,
953: ar_payment_schedules_all psch,
954: ar_adjustments_all adj
955: WHERE csu.rowid >= p_start_rowid
956: AND csu.rowid <= p_end_rowid
957: AND csu.last_accrue_charge_date IS NOT NULL
958: AND csu.SITE_USE_ID = psch.CUSTOMER_SITE_USE_ID