92: fa_asset_history ah,
93: FA_LOCATIONS TLOC, FA_LOCATIONS FLOC,
94: PER_ALL_PEOPLE_F Temp,
95: PER_ALL_PEOPLE_F FEMP,
96: FA_ADDITIONS AD,
97: GL_CODE_COMBINATIONS TASCC, GL_CODE_COMBINATIONS FASCC,
98: -- fa_deprn_detail dd,
99: FA_DISTRIBUTION_HISTORY TDH, FA_DISTRIBUTION_HISTORY FDH,
100: FA_TRANSACTION_HEADERS TH,
166: SUM(NVL(RADJ.ADJUSTMENT_AMOUNT,0) *
167: DECODE(NVL(RADJ.DEBIT_CREDIT_FLAG,'CR'),'CR',1,'DR',-1) )
168: FROM
169: fa_category_books cb,
170: FA_ADDITIONS AD,
171: FA_ASSET_HISTORY AH,
172: FA_TRANSACTION_HEADERS TH,
173: FA_ADJUSTMENTS RADJ
174: WHERE