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_RES_LDG_PKG dependencies on FA_DEPRN_DETAIL_MRC_V

Line 342: fa_deprn_detail_mrc_v DD_BONUS

338: ,DD_BONUS.period_counter
339: ,NVL(TH.date_effective, ucd)
340: ,''
341: FROM
342: fa_deprn_detail_mrc_v DD_BONUS
343: ,fa_asset_history AH
344: ,fa_transaction_headers TH
345: ,fa_transaction_headers TH_RT
346: ,fa_books_mrc_v BOOKS

Line 359: FROM fa_deprn_detail_mrc_v DD_SUB

355: AND AH.asset_type = 'CAPITALIZED'
356: AND DD_BONUS.book_type_code = book
357: AND DD_BONUS.distribution_id = DH.distribution_id
358: AND DD_BONUS.period_counter = (SELECT MAX (DD_SUB.period_counter)
359: FROM fa_deprn_detail_mrc_v DD_SUB
360: WHERE DD_SUB.book_type_code = book
361: AND DD_SUB.asset_id = DH.asset_id
362: AND DD_SUB.distribution_id = DH.distribution_id
363: AND DD_SUB.period_counter <= upc)

Line 398: fa_deprn_detail_mrc_v DD

394: ,DD.period_counter
395: ,NVL(TH.date_effective, ucd)
396: ,CB.bonus_deprn_expense_acct
397: FROM
398: fa_deprn_detail_mrc_v DD
399: ,fa_asset_history AH
400: ,fa_transaction_headers TH
401: ,fa_transaction_headers TH_RT
402: ,fa_books_mrc_v BOOKS

Line 416: FROM fa_deprn_detail_mrc_v DD_SUB

412: AND AH.asset_type = 'CAPITALIZED'
413: AND DD.book_type_code = book
414: AND DD.distribution_id = DH.distribution_id
415: AND DD.period_counter = (SELECT max (DD_SUB.period_counter)
416: FROM fa_deprn_detail_mrc_v DD_SUB
417: WHERE DD_SUB.book_type_code = book
418: AND DD_SUB.asset_id = DH.asset_id
419: AND DD_SUB.distribution_id = DH.distribution_id
420: AND DD_SUB.period_counter <= upc)

Line 619: fa_deprn_detail_mrc_v DD

615: 'RECLASS', 'R') t_type
616: ,DD.period_counter
617: ,NVL(TH.date_effective, ucd)
618: FROM
619: fa_deprn_detail_mrc_v DD
620: ,fa_asset_history AH
621: ,fa_transaction_headers TH
622: ,fa_transaction_headers TH_RT
623: ,fa_books_mrc_v BOOKS

Line 636: FROM fa_deprn_detail_mrc_v DD_SUB

632: AND AH.asset_type = 'CAPITALIZED'
633: AND DD.book_type_code = book
634: AND DD.distribution_id = DH.distribution_id
635: AND DD.period_counter = (SELECT MAX (DD_SUB.period_counter)
636: FROM fa_deprn_detail_mrc_v DD_SUB
637: WHERE DD_SUB.book_type_code = book
638: AND DD_SUB.asset_id = DH.asset_id
639: AND DD_SUB.distribution_id = DH.distribution_id
640: AND DD_SUB.period_counter <= upc)

Line 780: FROM fa_deprn_detail_mrc_v DD_SUB

776: AND GAR.book_type_code = DD.book_type_code
777: AND GAD.book_type_code = GAR.book_type_code
778: AND GAD.group_asset_id = GAR.group_asset_id
779: AND DD.period_counter = (SELECT MAX (DD_SUB.period_counter)
780: FROM fa_deprn_detail_mrc_v DD_SUB
781: WHERE DD_SUB.book_type_code = book
782: AND DD_SUB.asset_id = GAR.group_asset_id
783: AND DD_SUB.period_counter <= upc)
784: AND DD.period_counter = DP.period_counter

Line 899: FROM fa_deprn_detail_mrc_v DD_SUB

895: AND GAD.book_type_code = SGR.book_type_code
896: AND GAD.book_type_code = GAR.book_type_code
897: AND GAD.group_asset_id = GAR.group_asset_id
898: AND DD.period_counter = (SELECT MAX (DD_SUB.period_counter)
899: FROM fa_deprn_detail_mrc_v DD_SUB
900: WHERE DD_SUB.book_type_code = book
901: AND DD_SUB.asset_id = GAR.group_asset_id
902: AND DD_SUB.period_counter <= upc)
903: AND DD.period_counter = DP.period_counter