eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_MC_UPG3_PKG dependencies on FA_MC_DEPRN_DETAIL

Line 557: FROM fa_mc_deprn_detail

553: book_type_code = p_book_type_code;
554:
555: CURSOR reserve_line_num IS
556: SELECT distinct deprn_reserve_je_line_num, je_header_id
557: FROM fa_mc_deprn_detail
558: where period_counter = l_pc AND
559: book_type_code = p_book_type_code AND
560: set_of_books_id = p_rsob_id AND
561: deprn_reserve_je_line_num is not null AND

Line 579: fa_mc_deprn_detail mdd,

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
583: cr.set_of_books_id = p_rsob_id AND

Line 811: FROM fa_mc_deprn_detail

807: l_index NUMBER;
808:
809: CURSOR exp_line_num IS
810: SELECT distinct deprn_expense_je_line_num, je_header_id
811: FROM fa_mc_deprn_detail
812: where period_counter = l_pc AND
813: book_type_code = p_book_type_code AND
814: set_of_books_id = p_rsob_id and
815: deprn_expense_je_line_num is not null and

Line 833: fa_mc_deprn_detail mdd

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
837: mdd.book_type_code = p_book_type_code AND

Line 974: fa_mc_deprn_detail mdd,

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
978: cr.book_type_code = p_book_type_code AND

Line 1084: FROM fa_mc_deprn_detail

1080:
1081:
1082: CURSOR amort_line_num IS
1083: SELECT distinct reval_amort_je_line_num
1084: FROM fa_mc_deprn_detail
1085: where period_counter = l_pc AND
1086: book_type_code = p_book_type_code AND
1087: set_of_books_id = p_rsob_id AND
1088: reval_amort_je_line_num is not null;

Line 1111: fa_mc_deprn_detail mdd,

1107: SELECT
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