DBA Data[Home] [Help]

APPS.FA_ASSET_CALC_PVT dependencies on FA_ADJUSTMENTS_MRC_V

Line 1278: FROM fa_adjustments_mrc_v adj,

1274: SELECT sum(decode(adj.debit_credit_flag,'DR',
1275: -1 * adj.adjustment_amount,
1276: adj.adjustment_amount))
1277: INTO l_deprn_exp
1278: FROM fa_adjustments_mrc_v adj,
1279: fa_transaction_headers th
1280: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
1281: and th.asset_id = p_asset_hdr_rec.asset_id
1282: and th.transaction_type_code in ('ADDITION', 'ADJUSTMENT') ----Bug7409454

Line 1332: FROM fa_adjustments_mrc_v adj,

1328: SELECT sum(decode(adj.debit_credit_flag,'DR',
1329: -1 * adj.adjustment_amount,
1330: adj.adjustment_amount))
1331: INTO l_deprn_exp
1332: FROM fa_adjustments_mrc_v adj,
1333: fa_transaction_headers th
1334: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
1335: and th.asset_id = p_asset_hdr_rec.asset_id
1336: and th.transaction_type_code in ('ADDITION', 'ADJUSTMENT')

Line 1676: from fa_adjustments_mrc_v

1672: select nvl(sum(decode(debit_credit_flag,
1673: 'CR', adjustment_amount,
1674: adjustment_amount * -1)), 0)
1675: into l_clearing
1676: from fa_adjustments_mrc_v
1677: where asset_id = p_asset_hdr_rec.asset_id
1678: and book_type_code = p_asset_hdr_rec.book_type_code
1679: and period_counter_created = p_period_rec.period_counter
1680: and transaction_header_id = px_trans_rec.transaction_header_id