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 566: FROM fa_mc_deprn_detail

562: book_type_code = p_book_type_code;
563:
564: CURSOR reserve_line_num IS
565: SELECT distinct deprn_reserve_je_line_num, je_header_id
566: FROM fa_mc_deprn_detail
567: where period_counter = l_pc AND
568: book_type_code = p_book_type_code AND
569: set_of_books_id = p_rsob_id AND
570: deprn_reserve_je_line_num is not null AND

Line 588: fa_mc_deprn_detail mdd,

584: sum(mdd.deprn_reserve),
585: sum(dd.deprn_reserve)
586: FROM
587: fa_deprn_detail dd,
588: fa_mc_deprn_detail mdd,
589: fa_mc_conversion_rates cr
590: WHERE
591: cr.last_period_counter = l_pc AND
592: cr.set_of_books_id = p_rsob_id AND

Line 820: FROM fa_mc_deprn_detail

816: l_index NUMBER;
817:
818: CURSOR exp_line_num IS
819: SELECT distinct deprn_expense_je_line_num, je_header_id
820: FROM fa_mc_deprn_detail
821: where period_counter = l_pc AND
822: book_type_code = p_book_type_code AND
823: set_of_books_id = p_rsob_id and
824: deprn_expense_je_line_num is not null and

Line 842: fa_mc_deprn_detail mdd

838: nvl(sum(dd.deprn_amount),0),
839: nvl(sum(mdd.deprn_amount),0)
840: FROM
841: fa_deprn_detail dd,
842: fa_mc_deprn_detail mdd
843: WHERE
844: mdd.period_counter = l_pc AND
845: mdd.set_of_books_id = p_rsob_id AND
846: mdd.book_type_code = p_book_type_code AND

Line 983: fa_mc_deprn_detail mdd,

979: nvl(sum(mdd.reval_reserve),0)
980: FROM
981: fa_adjustments aj,
982: fa_deprn_detail dd,
983: fa_mc_deprn_detail mdd,
984: fa_mc_conversion_rates cr
985: WHERE
986: cr.set_of_books_id = p_rsob_id AND
987: cr.book_type_code = p_book_type_code AND

Line 1093: FROM fa_mc_deprn_detail

1089:
1090:
1091: CURSOR amort_line_num IS
1092: SELECT distinct reval_amort_je_line_num
1093: FROM fa_mc_deprn_detail
1094: where period_counter = l_pc AND
1095: book_type_code = p_book_type_code AND
1096: set_of_books_id = p_rsob_id AND
1097: reval_amort_je_line_num is not null;

Line 1120: fa_mc_deprn_detail mdd,

1116: SELECT
1117: nvl(sum(dd.reval_amortization),0),
1118: nvl(sum(mdd.reval_amortization),0)
1119: FROM
1120: fa_mc_deprn_detail mdd,
1121: fa_deprn_detail dd
1122: WHERE
1123: mdd.book_type_code = p_book_type_code AND
1124: mdd.period_counter = l_pc AND