DBA Data[Home] [Help]

APPS.FA_BALREP_PKG dependencies on FA_DEPRN_SUMMARY_MRC_V

Line 1964: FROM fa_deprn_summary_mrc_v dd,

1960: */
1961: 'BEGIN',
1962: dd.deprn_reserve,
1963: h_request_id
1964: FROM fa_deprn_summary_mrc_v dd,
1965: fa_group_asset_rules gar,
1966: fa_group_asset_default gad
1967: WHERE dd.book_type_code = book
1968: AND dd.asset_id = gar.group_asset_id

Line 2314: FROM fa_deprn_summary_mrc_v dd,

2310: Begin_or_End),*/
2311: 'END',
2312: dd.deprn_reserve,
2313: h_request_id
2314: FROM fa_deprn_summary_mrc_v dd,
2315: fa_group_asset_rules gar,
2316: fa_group_asset_default gad
2317: WHERE dd.book_type_code = book
2318: AND dd.asset_id = gar.group_asset_id

Line 2591: FROM fa_deprn_summary_mrc_v dd,

2587: NULL,
2588: 'DEPRECIATION',
2589: SUM(dd.deprn_amount),
2590: h_request_id
2591: FROM fa_deprn_summary_mrc_v dd,
2592: fa_group_asset_rules gar,
2593: fa_group_asset_default gad
2594: WHERE dd.book_type_code = book
2595: AND dd.asset_id = gar.group_asset_id