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_FAS480_XMLP_PKG dependencies on FA_DEPRN_DETAIL

Line 474: FA_DEPRN_DETAIL_MRC_V DD_BONUS,

470: DD_BONUS.PERIOD_COUNTER,
471: NVL(TH.DATE_EFFECTIVE, ucd),
472: ''
473: FROM
474: FA_DEPRN_DETAIL_MRC_V DD_BONUS,
475: FA_ASSET_HISTORY AH,
476: FA_TRANSACTION_HEADERS TH,
477: FA_TRANSACTION_HEADERS TH_RT,
478: FA_BOOKS_MRC_V BOOKS,

Line 495: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

491: DD_BONUS.BOOK_TYPE_CODE = book AND
492: DD_BONUS.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
493: DD_BONUS.PERIOD_COUNTER =
494: (SELECT max (DD_SUB.PERIOD_COUNTER)
495: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
496: WHERE DD_SUB.BOOK_TYPE_CODE = book
497: AND DD_SUB.ASSET_ID = DH.ASSET_ID
498: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
499: AND DD_SUB.PERIOD_COUNTER <= upc)

Line 539: FA_DEPRN_DETAIL_MRC_V DD,

535: DD.PERIOD_COUNTER,
536: NVL(TH.DATE_EFFECTIVE, ucd),
537: CB.BONUS_DEPRN_EXPENSE_ACCT
538: FROM
539: FA_DEPRN_DETAIL_MRC_V DD,
540: FA_ASSET_HISTORY AH,
541: FA_TRANSACTION_HEADERS TH,
542: FA_TRANSACTION_HEADERS TH_RT,
543: FA_BOOKS_MRC_V BOOKS,

Line 560: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

556: DD.BOOK_TYPE_CODE = book AND
557: DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
558: DD.PERIOD_COUNTER =
559: (SELECT max (DD_SUB.PERIOD_COUNTER)
560: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
561: WHERE DD_SUB.BOOK_TYPE_CODE = book
562: AND DD_SUB.ASSET_ID = DH.ASSET_ID
563: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
564: AND DD_SUB.PERIOD_COUNTER <= upc)

Line 631: FA_DEPRN_DETAIL DD_BONUS,

627: DD_BONUS.PERIOD_COUNTER,
628: NVL(TH.DATE_EFFECTIVE, ucd),
629: ''
630: FROM
631: FA_DEPRN_DETAIL DD_BONUS,
632: FA_ASSET_HISTORY AH,
633: FA_TRANSACTION_HEADERS TH,
634: FA_TRANSACTION_HEADERS TH_RT,
635: FA_BOOKS BOOKS,

Line 652: FROM FA_DEPRN_DETAIL DD_SUB

648: DD_BONUS.BOOK_TYPE_CODE = book AND
649: DD_BONUS.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
650: DD_BONUS.PERIOD_COUNTER =
651: (SELECT max (DD_SUB.PERIOD_COUNTER)
652: FROM FA_DEPRN_DETAIL DD_SUB
653: WHERE DD_SUB.BOOK_TYPE_CODE = book
654: AND DD_SUB.ASSET_ID = DH.ASSET_ID
655: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
656: AND DD_SUB.PERIOD_COUNTER <= upc)

Line 696: FA_DEPRN_DETAIL DD,

692: DD.PERIOD_COUNTER,
693: NVL(TH.DATE_EFFECTIVE, ucd),
694: CB.BONUS_DEPRN_EXPENSE_ACCT
695: FROM
696: FA_DEPRN_DETAIL DD,
697: FA_ASSET_HISTORY AH,
698: FA_TRANSACTION_HEADERS TH,
699: FA_TRANSACTION_HEADERS TH_RT,
700: FA_BOOKS BOOKS,

Line 717: FROM FA_DEPRN_DETAIL DD_SUB

713: DD.BOOK_TYPE_CODE = book AND
714: DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
715: DD.PERIOD_COUNTER =
716: (SELECT max (DD_SUB.PERIOD_COUNTER)
717: FROM FA_DEPRN_DETAIL DD_SUB
718: WHERE DD_SUB.BOOK_TYPE_CODE = book
719: AND DD_SUB.ASSET_ID = DH.ASSET_ID
720: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
721: AND DD_SUB.PERIOD_COUNTER <= upc)

Line 791: FA_DEPRN_DETAIL_MRC_V DD,

787: 'RECLASS', 'R') T_TYPE,
788: DD.PERIOD_COUNTER,
789: NVL(TH.DATE_EFFECTIVE, ucd)
790: FROM
791: FA_DEPRN_DETAIL_MRC_V DD,
792: FA_ASSET_HISTORY AH,
793: FA_TRANSACTION_HEADERS TH,
794: FA_TRANSACTION_HEADERS TH_RT,
795: FA_BOOKS_MRC_V BOOKS,

Line 815: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

811: DD.BOOK_TYPE_CODE = book AND
812: DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
813: DD.PERIOD_COUNTER =
814: (SELECT max (DD_SUB.PERIOD_COUNTER)
815: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
816: WHERE DD_SUB.BOOK_TYPE_CODE = book
817: AND DD_SUB.ASSET_ID = DH.ASSET_ID
818: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
819: AND DD_SUB.PERIOD_COUNTER <= upc)

Line 885: FA_DEPRN_DETAIL DD,

881: 'RECLASS', 'R') T_TYPE,
882: DD.PERIOD_COUNTER,
883: NVL(TH.DATE_EFFECTIVE, ucd)
884: FROM
885: FA_DEPRN_DETAIL DD,
886: FA_ASSET_HISTORY AH,
887: FA_TRANSACTION_HEADERS TH,
888: FA_TRANSACTION_HEADERS TH_RT,
889: FA_BOOKS BOOKS,

Line 909: FROM FA_DEPRN_DETAIL DD_SUB

905: DD.BOOK_TYPE_CODE = book AND
906: DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
907: DD.PERIOD_COUNTER =
908: (SELECT max (DD_SUB.PERIOD_COUNTER)
909: FROM FA_DEPRN_DETAIL DD_SUB
910: WHERE DD_SUB.BOOK_TYPE_CODE = book
911: AND DD_SUB.ASSET_ID = DH.ASSET_ID
912: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
913: AND DD_SUB.PERIOD_COUNTER <= upc)

Line 999: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

995: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
996: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
997: AND DD.PERIOD_COUNTER =
998: (SELECT max (DD_SUB.PERIOD_COUNTER)
999: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
1000: WHERE DD_SUB.BOOK_TYPE_CODE = book
1001: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1002: AND DD_SUB.PERIOD_COUNTER <= upc
1003: )

Line 1072: FROM FA_DEPRN_DETAIL DD_SUB

1068: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
1069: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
1070: AND DD.PERIOD_COUNTER =
1071: (SELECT max (DD_SUB.PERIOD_COUNTER)
1072: FROM FA_DEPRN_DETAIL DD_SUB
1073: WHERE DD_SUB.BOOK_TYPE_CODE = book
1074: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1075: AND DD_SUB.PERIOD_COUNTER <= upc
1076: )

Line 1135: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

1131: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
1132: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
1133: AND DD.PERIOD_COUNTER =
1134: (SELECT max (DD_SUB.PERIOD_COUNTER)
1135: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
1136: WHERE DD_SUB.BOOK_TYPE_CODE = book
1137: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1138: AND DD_SUB.PERIOD_COUNTER <= upc)
1139: AND DD.PERIOD_COUNTER = DP.PERIOD_COUNTER

Line 1198: FROM FA_DEPRN_DETAIL DD_SUB

1194: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
1195: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
1196: AND DD.PERIOD_COUNTER =
1197: (SELECT max (DD_SUB.PERIOD_COUNTER)
1198: FROM FA_DEPRN_DETAIL DD_SUB
1199: WHERE DD_SUB.BOOK_TYPE_CODE = book
1200: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1201: AND DD_SUB.PERIOD_COUNTER <= upc)
1202: AND DD.PERIOD_COUNTER = DP.PERIOD_COUNTER