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

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 481: fa_deprn_detail DD_BONUS

477: ,DD_BONUS.period_counter
478: ,NVL(TH.date_effective, ucd)
479: ,''
480: FROM
481: fa_deprn_detail DD_BONUS
482: ,fa_asset_history AH
483: ,fa_transaction_headers TH
484: ,fa_transaction_headers TH_RT
485: ,fa_books BOOKS

Line 498: FROM fa_deprn_detail DD_SUB

494: AND AH.asset_type = 'CAPITALIZED'
495: AND DD_BONUS.book_type_code = book
496: AND DD_BONUS.distribution_id = DH.distribution_id
497: AND DD_BONUS.period_counter = (SELECT MAX (DD_SUB.period_counter)
498: FROM fa_deprn_detail DD_SUB
499: WHERE DD_SUB.book_type_code = book
500: AND DD_SUB.asset_id = DH.asset_id
501: AND DD_SUB.distribution_id = DH.distribution_id
502: AND DD_SUB.period_counter <= upc)

Line 536: fa_deprn_detail DD

532: ,DD.period_counter
533: ,NVL(TH.date_effective, ucd)
534: ,CB.bonus_deprn_expense_acct
535: FROM
536: fa_deprn_detail DD
537: ,fa_asset_history AH
538: ,fa_transaction_headers TH
539: ,fa_transaction_headers TH_RT
540: ,fa_books BOOKS

Line 553: FROM fa_deprn_detail DD_SUB

549: AND AH.asset_type = 'CAPITALIZED'
550: AND DD.book_type_code = book
551: AND DD.distribution_id = DH.distribution_id
552: AND DD.period_counter = (SELECT MAX (DD_SUB.period_counter)
553: FROM fa_deprn_detail DD_SUB
554: WHERE DD_SUB.book_type_code = book
555: AND DD_SUB.asset_id = DH.asset_id
556: AND DD_SUB.distribution_id = DH.distribution_id
557: 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 694: fa_deprn_detail DD

690: 'RECLASS', 'R') t_type
691: ,DD.period_counter
692: ,NVL(TH.date_effective, ucd)
693: FROM
694: fa_deprn_detail DD
695: ,fa_asset_history AH
696: ,fa_transaction_headers TH
697: ,fa_transaction_headers TH_RT
698: ,fa_books BOOKS

Line 711: FROM fa_deprn_detail DD_SUB

707: AND AH.asset_type = 'CAPITALIZED'
708: AND DD.book_type_code = book
709: AND DD.distribution_id = DH.distribution_id
710: AND DD.period_counter =(SELECT MAX (DD_SUB.period_counter)
711: FROM fa_deprn_detail DD_SUB
712: WHERE DD_SUB.book_type_code = book
713: AND DD_SUB.asset_id = DH.asset_id
714: AND DD_SUB.distribution_id = DH.distribution_id
715: 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 836: FROM fa_deprn_detail DD_SUB

832: AND GAR.book_type_code = DD.book_type_code
833: AND GAD.book_type_code = GAR.book_type_code
834: AND GAD.group_asset_id = GAR.group_asset_id
835: AND DD.period_counter = (SELECT MAX (DD_SUB.period_counter)
836: FROM fa_deprn_detail DD_SUB
837: WHERE DD_SUB.book_type_code = book
838: AND DD_SUB.asset_id = GAR.group_asset_id
839: AND DD_SUB.period_counter <= upc
840: )

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

Line 958: FROM fa_deprn_detail DD_SUB

954: AND GAD.book_type_code = SGR.book_type_code -- MPOWELL
955: AND GAD.book_type_code = GAR.book_type_code
956: AND GAD.group_asset_id = GAR.group_asset_id
957: AND DD.period_counter = (SELECT max (DD_SUB.period_counter)
958: FROM fa_deprn_detail DD_SUB
959: WHERE DD_SUB.book_type_code = book
960: AND DD_SUB.asset_id = GAR.group_asset_id
961: AND DD_SUB.period_counter <= upc)
962: AND DD.period_counter = DP.period_counter