DBA Data[Home] [Help]

APPS.CSE_ASSET_UTIL_PKG dependencies on FA_DISTRIBUTION_HISTORY

Line 1259: fa_distribution_history fdh

1255: NVL(fr.cost_retired,0))) cost,
1256: SUM(DECODE(fr.status,'PENDING', NVL(fr.units,0)*(-1),
1257: NVL(fr.units,0))) units
1258: FROM fa_retirements fr ,
1259: fa_distribution_history fdh
1260: WHERE fr.status IN ('PENDING','REINSTATE')
1261: AND fr.retirement_id = fdh.retirement_id
1262: AND fdh.distribution_id = c_distribution_id ;
1263: