DBA Data[Home] [Help]

APPS.AR_LATE_CHARGE_UPG dependencies on AR_ADJUSTMENTS_ALL

Line 956: ar_adjustments_all adj

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