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

Line 398: FA_DEPRN_DETAIL_MRC_V DD_BONUS,

394: DD_BONUS.PERIOD_COUNTER,
395: NVL(TH.DATE_EFFECTIVE, ucd),
396: ''
397: FROM
398: FA_DEPRN_DETAIL_MRC_V DD_BONUS,
399: FA_ASSET_HISTORY AH,
400: FA_TRANSACTION_HEADERS TH,
401: FA_TRANSACTION_HEADERS TH_RT,
402: FA_BOOKS_MRC_V BOOKS,

Line 419: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

415: DD_BONUS.BOOK_TYPE_CODE = book AND
416: DD_BONUS.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
417: DD_BONUS.PERIOD_COUNTER =
418: (SELECT max (DD_SUB.PERIOD_COUNTER)
419: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
420: WHERE DD_SUB.BOOK_TYPE_CODE = book
421: AND DD_SUB.ASSET_ID = DH.ASSET_ID
422: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
423: AND DD_SUB.PERIOD_COUNTER <= upc)

Line 463: FA_DEPRN_DETAIL_MRC_V DD,

459: DD.PERIOD_COUNTER,
460: NVL(TH.DATE_EFFECTIVE, ucd),
461: CB.BONUS_DEPRN_EXPENSE_ACCT
462: FROM
463: FA_DEPRN_DETAIL_MRC_V DD,
464: FA_ASSET_HISTORY AH,
465: FA_TRANSACTION_HEADERS TH,
466: FA_TRANSACTION_HEADERS TH_RT,
467: FA_BOOKS_MRC_V BOOKS,

Line 484: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

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

Line 715: FA_DEPRN_DETAIL_MRC_V DD,

711: 'RECLASS', 'R') T_TYPE,
712: DD.PERIOD_COUNTER,
713: NVL(TH.DATE_EFFECTIVE, ucd)
714: FROM
715: FA_DEPRN_DETAIL_MRC_V DD,
716: FA_ASSET_HISTORY AH,
717: FA_TRANSACTION_HEADERS TH,
718: FA_TRANSACTION_HEADERS TH_RT,
719: FA_BOOKS_MRC_V BOOKS,

Line 739: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

735: DD.BOOK_TYPE_CODE = book AND
736: DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
737: DD.PERIOD_COUNTER =
738: (SELECT max (DD_SUB.PERIOD_COUNTER)
739: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
740: WHERE DD_SUB.BOOK_TYPE_CODE = book
741: AND DD_SUB.ASSET_ID = DH.ASSET_ID
742: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
743: AND DD_SUB.PERIOD_COUNTER <= upc)

Line 923: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

919: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
920: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
921: AND DD.PERIOD_COUNTER =
922: (SELECT max (DD_SUB.PERIOD_COUNTER)
923: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
924: WHERE DD_SUB.BOOK_TYPE_CODE = book
925: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
926: AND DD_SUB.PERIOD_COUNTER <= upc
927: )

Line 1059: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

1055: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
1056: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
1057: AND DD.PERIOD_COUNTER =
1058: (SELECT max (DD_SUB.PERIOD_COUNTER)
1059: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
1060: WHERE DD_SUB.BOOK_TYPE_CODE = book
1061: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1062: AND DD_SUB.PERIOD_COUNTER <= upc)
1063: AND DD.PERIOD_COUNTER = DP.PERIOD_COUNTER