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

Line 461: FA_DEPRN_DETAIL_MRC_V DD_BONUS,

457: DD_BONUS.PERIOD_COUNTER,
458: NVL(TH.DATE_EFFECTIVE, ucd),
459: ''
460: FROM
461: FA_DEPRN_DETAIL_MRC_V DD_BONUS,
462: FA_ASSET_HISTORY AH,
463: FA_TRANSACTION_HEADERS TH,
464: FA_TRANSACTION_HEADERS TH_RT,
465: FA_BOOKS_MRC_V BOOKS,

Line 482: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

478: DD_BONUS.BOOK_TYPE_CODE = book AND
479: DD_BONUS.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
480: DD_BONUS.PERIOD_COUNTER =
481: (SELECT max (DD_SUB.PERIOD_COUNTER)
482: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
483: WHERE DD_SUB.BOOK_TYPE_CODE = book
484: AND DD_SUB.ASSET_ID = DH.ASSET_ID
485: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
486: AND DD_SUB.PERIOD_COUNTER <= upc)

Line 526: FA_DEPRN_DETAIL_MRC_V DD,

522: DD.PERIOD_COUNTER,
523: NVL(TH.DATE_EFFECTIVE, ucd),
524: CB.BONUS_DEPRN_EXPENSE_ACCT
525: FROM
526: FA_DEPRN_DETAIL_MRC_V DD,
527: FA_ASSET_HISTORY AH,
528: FA_TRANSACTION_HEADERS TH,
529: FA_TRANSACTION_HEADERS TH_RT,
530: FA_BOOKS_MRC_V BOOKS,

Line 547: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

543: DD.BOOK_TYPE_CODE = book AND
544: DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
545: DD.PERIOD_COUNTER =
546: (SELECT max (DD_SUB.PERIOD_COUNTER)
547: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
548: WHERE DD_SUB.BOOK_TYPE_CODE = book
549: AND DD_SUB.ASSET_ID = DH.ASSET_ID
550: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
551: AND DD_SUB.PERIOD_COUNTER <= upc)

Line 778: FA_DEPRN_DETAIL_MRC_V DD,

774: 'RECLASS', 'R') T_TYPE,
775: DD.PERIOD_COUNTER,
776: NVL(TH.DATE_EFFECTIVE, ucd)
777: FROM
778: FA_DEPRN_DETAIL_MRC_V DD,
779: FA_ASSET_HISTORY AH,
780: FA_TRANSACTION_HEADERS TH,
781: FA_TRANSACTION_HEADERS TH_RT,
782: FA_BOOKS_MRC_V BOOKS,

Line 802: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

798: DD.BOOK_TYPE_CODE = book AND
799: DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
800: DD.PERIOD_COUNTER =
801: (SELECT max (DD_SUB.PERIOD_COUNTER)
802: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
803: WHERE DD_SUB.BOOK_TYPE_CODE = book
804: AND DD_SUB.ASSET_ID = DH.ASSET_ID
805: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
806: AND DD_SUB.PERIOD_COUNTER <= upc)

Line 986: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

982: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
983: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
984: AND DD.PERIOD_COUNTER =
985: (SELECT max (DD_SUB.PERIOD_COUNTER)
986: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
987: WHERE DD_SUB.BOOK_TYPE_CODE = book
988: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
989: AND DD_SUB.PERIOD_COUNTER <= upc
990: )

Line 1122: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

1118: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
1119: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
1120: AND DD.PERIOD_COUNTER =
1121: (SELECT max (DD_SUB.PERIOD_COUNTER)
1122: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
1123: WHERE DD_SUB.BOOK_TYPE_CODE = book
1124: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1125: AND DD_SUB.PERIOD_COUNTER <= upc)
1126: AND DD.PERIOD_COUNTER = DP.PERIOD_COUNTER