/* Formatted on 2007/04/05 17:16 (Formatter Plus v4.8.6) */
SELECT fa_adj.asset_id, (SELECT fab.asset_number
FROM fa_additions_b fab
WHERE fab.asset_id = fa_adj.asset_id) asset_number,
(SELECT fat.description
FROM fa_additions_b fab, fa_additions_tl fat
WHERE fab.asset_id = fa_adj.asset_id
AND fat.asset_id = fa_adj.asset_id
AND fat.LANGUAGE = 'ZHS') description,
fa_adj.adjmnt, fa_cst.COST, (fa_adj.adjmnt - fa_cst.COST) diff
FROM (SELECT fa.asset_id,
SUM (DECODE (fa.debit_credit_flag, 'DR', 1, -1)
* fa.adjustment_amount
) adjmnt
FROM fa_adjustments fa
WHERE fa.period_counter_adjusted
NVL ((SELECT fdp.period_close_date
FROM fa_deprn_periods fdp
WHERE fdp.book_type_code = fb.book_type_code
AND fdp.period_counter = 24076),
SYSDATE
)
-- AND fb.asset_id = 10378940
AND (SELECT fc.segment2
FROM fa_categories_b fc, fa_additions_b fa
WHERE fa.asset_id = fb.asset_id
AND fa.asset_category_id = fc.category_id) LIKE
'01-12-124-12401%'
AND fb.COST0) fa_cst
WHERE fa_adj.asset_id = fa_cst.asset_id
AND (fa_adj.adjmnt - fa_cst.COST)0
|