DBA Data[Home] [Help]

APPS.FA_MC_UPG3_PKG dependencies on FA_DEPRN_DETAIL

Line 578: fa_deprn_detail dd,

574: SELECT
575: sum(mdd.deprn_reserve),
576: sum(dd.deprn_reserve)
577: FROM
578: fa_deprn_detail dd,
579: fa_mc_deprn_detail mdd,
580: fa_mc_conversion_rates cr
581: WHERE
582: cr.last_period_counter = l_pc AND

Line 651: fa_deprn_detail dd,

647: l_dist_ccid,
648: l_rsv_account,
649: l_account_ccid
650: FROM
651: fa_deprn_detail dd,
652: fa_category_books cb,
653: fa_asset_history ah,
654: fa_distribution_history dh
655: WHERE

Line 832: fa_deprn_detail dd,

828: SELECT
829: nvl(sum(dd.deprn_amount),0),
830: nvl(sum(mdd.deprn_amount),0)
831: FROM
832: fa_deprn_detail dd,
833: fa_mc_deprn_detail mdd
834: WHERE
835: mdd.period_counter = l_pc AND
836: mdd.set_of_books_id = p_rsob_id AND

Line 973: fa_deprn_detail dd,

969: nvl(sum(dd.reval_reserve),0),
970: nvl(sum(mdd.reval_reserve),0)
971: FROM
972: fa_adjustments aj,
973: fa_deprn_detail dd,
974: fa_mc_deprn_detail mdd,
975: fa_mc_conversion_rates cr
976: WHERE
977: cr.set_of_books_id = p_rsob_id AND

Line 1112: fa_deprn_detail dd

1108: nvl(sum(dd.reval_amortization),0),
1109: nvl(sum(mdd.reval_amortization),0)
1110: FROM
1111: fa_mc_deprn_detail mdd,
1112: fa_deprn_detail dd
1113: WHERE
1114: mdd.book_type_code = p_book_type_code AND
1115: mdd.period_counter = l_pc AND
1116: mdd.set_of_books_id = p_rsob_id AND