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

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

551: DD_BONUS.PERIOD_COUNTER,
552: NVL(TH.DATE_EFFECTIVE, ucd),
553: ''
554: FROM
555: FA_DEPRN_DETAIL DD_BONUS,
556: FA_ASSET_HISTORY AH,
557: FA_TRANSACTION_HEADERS TH,
558: FA_TRANSACTION_HEADERS TH_RT,
559: FA_BOOKS BOOKS,

Line 576: FROM FA_DEPRN_DETAIL DD_SUB

572: DD_BONUS.BOOK_TYPE_CODE = book AND
573: DD_BONUS.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
574: DD_BONUS.PERIOD_COUNTER =
575: (SELECT max (DD_SUB.PERIOD_COUNTER)
576: FROM FA_DEPRN_DETAIL DD_SUB
577: WHERE DD_SUB.BOOK_TYPE_CODE = book
578: AND DD_SUB.ASSET_ID = DH.ASSET_ID
579: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
580: AND DD_SUB.PERIOD_COUNTER <= upc)

Line 620: FA_DEPRN_DETAIL DD,

616: DD.PERIOD_COUNTER,
617: NVL(TH.DATE_EFFECTIVE, ucd),
618: CB.BONUS_DEPRN_EXPENSE_ACCT
619: FROM
620: FA_DEPRN_DETAIL DD,
621: FA_ASSET_HISTORY AH,
622: FA_TRANSACTION_HEADERS TH,
623: FA_TRANSACTION_HEADERS TH_RT,
624: FA_BOOKS BOOKS,

Line 641: FROM FA_DEPRN_DETAIL DD_SUB

637: DD.BOOK_TYPE_CODE = book AND
638: DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
639: DD.PERIOD_COUNTER =
640: (SELECT max (DD_SUB.PERIOD_COUNTER)
641: FROM FA_DEPRN_DETAIL DD_SUB
642: WHERE DD_SUB.BOOK_TYPE_CODE = book
643: AND DD_SUB.ASSET_ID = DH.ASSET_ID
644: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
645: 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 809: FA_DEPRN_DETAIL DD,

805: 'RECLASS', 'R') T_TYPE,
806: DD.PERIOD_COUNTER,
807: NVL(TH.DATE_EFFECTIVE, ucd)
808: FROM
809: FA_DEPRN_DETAIL DD,
810: FA_ASSET_HISTORY AH,
811: FA_TRANSACTION_HEADERS TH,
812: FA_TRANSACTION_HEADERS TH_RT,
813: FA_BOOKS BOOKS,

Line 833: FROM FA_DEPRN_DETAIL DD_SUB

829: DD.BOOK_TYPE_CODE = book AND
830: DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
831: DD.PERIOD_COUNTER =
832: (SELECT max (DD_SUB.PERIOD_COUNTER)
833: FROM FA_DEPRN_DETAIL DD_SUB
834: WHERE DD_SUB.BOOK_TYPE_CODE = book
835: AND DD_SUB.ASSET_ID = DH.ASSET_ID
836: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
837: 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 996: FROM FA_DEPRN_DETAIL DD_SUB

992: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
993: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
994: AND DD.PERIOD_COUNTER =
995: (SELECT max (DD_SUB.PERIOD_COUNTER)
996: FROM FA_DEPRN_DETAIL DD_SUB
997: WHERE DD_SUB.BOOK_TYPE_CODE = book
998: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
999: AND DD_SUB.PERIOD_COUNTER <= upc
1000: )

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

Line 1122: FROM FA_DEPRN_DETAIL 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 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