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

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 618: FA_DEPRN_DETAIL DD_BONUS,

614: DD_BONUS.PERIOD_COUNTER,
615: NVL(TH.DATE_EFFECTIVE, ucd),
616: ''
617: FROM
618: FA_DEPRN_DETAIL DD_BONUS,
619: FA_ASSET_HISTORY AH,
620: FA_TRANSACTION_HEADERS TH,
621: FA_TRANSACTION_HEADERS TH_RT,
622: FA_BOOKS BOOKS,

Line 639: FROM FA_DEPRN_DETAIL DD_SUB

635: DD_BONUS.BOOK_TYPE_CODE = book AND
636: DD_BONUS.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
637: DD_BONUS.PERIOD_COUNTER =
638: (SELECT max (DD_SUB.PERIOD_COUNTER)
639: FROM FA_DEPRN_DETAIL DD_SUB
640: WHERE DD_SUB.BOOK_TYPE_CODE = book
641: AND DD_SUB.ASSET_ID = DH.ASSET_ID
642: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
643: AND DD_SUB.PERIOD_COUNTER <= upc)

Line 683: FA_DEPRN_DETAIL DD,

679: DD.PERIOD_COUNTER,
680: NVL(TH.DATE_EFFECTIVE, ucd),
681: CB.BONUS_DEPRN_EXPENSE_ACCT
682: FROM
683: FA_DEPRN_DETAIL DD,
684: FA_ASSET_HISTORY AH,
685: FA_TRANSACTION_HEADERS TH,
686: FA_TRANSACTION_HEADERS TH_RT,
687: FA_BOOKS BOOKS,

Line 704: FROM FA_DEPRN_DETAIL DD_SUB

700: DD.BOOK_TYPE_CODE = book AND
701: DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
702: DD.PERIOD_COUNTER =
703: (SELECT max (DD_SUB.PERIOD_COUNTER)
704: FROM FA_DEPRN_DETAIL DD_SUB
705: WHERE DD_SUB.BOOK_TYPE_CODE = book
706: AND DD_SUB.ASSET_ID = DH.ASSET_ID
707: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
708: 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 872: FA_DEPRN_DETAIL DD,

868: 'RECLASS', 'R') T_TYPE,
869: DD.PERIOD_COUNTER,
870: NVL(TH.DATE_EFFECTIVE, ucd)
871: FROM
872: FA_DEPRN_DETAIL DD,
873: FA_ASSET_HISTORY AH,
874: FA_TRANSACTION_HEADERS TH,
875: FA_TRANSACTION_HEADERS TH_RT,
876: FA_BOOKS BOOKS,

Line 896: FROM FA_DEPRN_DETAIL DD_SUB

892: DD.BOOK_TYPE_CODE = book AND
893: DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
894: DD.PERIOD_COUNTER =
895: (SELECT max (DD_SUB.PERIOD_COUNTER)
896: FROM FA_DEPRN_DETAIL DD_SUB
897: WHERE DD_SUB.BOOK_TYPE_CODE = book
898: AND DD_SUB.ASSET_ID = DH.ASSET_ID
899: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
900: 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 1059: FROM FA_DEPRN_DETAIL 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 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: )

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

Line 1185: FROM FA_DEPRN_DETAIL DD_SUB

1181: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
1182: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
1183: AND DD.PERIOD_COUNTER =
1184: (SELECT max (DD_SUB.PERIOD_COUNTER)
1185: FROM FA_DEPRN_DETAIL DD_SUB
1186: WHERE DD_SUB.BOOK_TYPE_CODE = book
1187: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1188: AND DD_SUB.PERIOD_COUNTER <= upc)
1189: AND DD.PERIOD_COUNTER = DP.PERIOD_COUNTER