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

Line 438: FA_DEPRN_DETAIL_MRC_V DD_BONUS,

434: DD_BONUS.PERIOD_COUNTER,
435: NVL(TH.DATE_EFFECTIVE, ucd),
436: ''
437: FROM
438: FA_DEPRN_DETAIL_MRC_V DD_BONUS,
439: FA_ASSET_HISTORY AH,
440: FA_TRANSACTION_HEADERS TH,
441: FA_TRANSACTION_HEADERS TH_RT,
442: FA_BOOKS_MRC_V BOOKS,

Line 459: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

455: DD_BONUS.BOOK_TYPE_CODE = book AND
456: DD_BONUS.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
457: DD_BONUS.PERIOD_COUNTER =
458: (SELECT max (DD_SUB.PERIOD_COUNTER)
459: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
460: WHERE DD_SUB.BOOK_TYPE_CODE = book
461: AND DD_SUB.ASSET_ID = DH.ASSET_ID
462: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
463: AND DD_SUB.PERIOD_COUNTER <= upc)

Line 503: FA_DEPRN_DETAIL_MRC_V DD,

499: DD.PERIOD_COUNTER,
500: NVL(TH.DATE_EFFECTIVE, ucd),
501: CB.BONUS_DEPRN_EXPENSE_ACCT
502: FROM
503: FA_DEPRN_DETAIL_MRC_V DD,
504: FA_ASSET_HISTORY AH,
505: FA_TRANSACTION_HEADERS TH,
506: FA_TRANSACTION_HEADERS TH_RT,
507: FA_BOOKS_MRC_V BOOKS,

Line 524: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

520: DD.BOOK_TYPE_CODE = book AND
521: DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
522: DD.PERIOD_COUNTER =
523: (SELECT max (DD_SUB.PERIOD_COUNTER)
524: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
525: WHERE DD_SUB.BOOK_TYPE_CODE = book
526: AND DD_SUB.ASSET_ID = DH.ASSET_ID
527: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
528: AND DD_SUB.PERIOD_COUNTER <= upc)

Line 755: FA_DEPRN_DETAIL_MRC_V DD,

751: 'RECLASS', 'R') T_TYPE,
752: DD.PERIOD_COUNTER,
753: NVL(TH.DATE_EFFECTIVE, ucd)
754: FROM
755: FA_DEPRN_DETAIL_MRC_V DD,
756: FA_ASSET_HISTORY AH,
757: FA_TRANSACTION_HEADERS TH,
758: FA_TRANSACTION_HEADERS TH_RT,
759: FA_BOOKS_MRC_V BOOKS,

Line 779: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

775: DD.BOOK_TYPE_CODE = book AND
776: DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
777: DD.PERIOD_COUNTER =
778: (SELECT max (DD_SUB.PERIOD_COUNTER)
779: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
780: WHERE DD_SUB.BOOK_TYPE_CODE = book
781: AND DD_SUB.ASSET_ID = DH.ASSET_ID
782: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
783: AND DD_SUB.PERIOD_COUNTER <= upc)

Line 963: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

959: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
960: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
961: AND DD.PERIOD_COUNTER =
962: (SELECT max (DD_SUB.PERIOD_COUNTER)
963: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
964: WHERE DD_SUB.BOOK_TYPE_CODE = book
965: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
966: AND DD_SUB.PERIOD_COUNTER <= upc
967: )

Line 1099: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

1095: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
1096: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
1097: AND DD.PERIOD_COUNTER =
1098: (SELECT max (DD_SUB.PERIOD_COUNTER)
1099: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
1100: WHERE DD_SUB.BOOK_TYPE_CODE = book
1101: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1102: AND DD_SUB.PERIOD_COUNTER <= upc)
1103: AND DD.PERIOD_COUNTER = DP.PERIOD_COUNTER