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_MRC_V

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 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 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 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