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

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

591: DD_BONUS.PERIOD_COUNTER,
592: NVL(TH.DATE_EFFECTIVE, ucd),
593: ''
594: FROM
595: FA_DEPRN_DETAIL DD_BONUS,
596: FA_ASSET_HISTORY AH,
597: FA_TRANSACTION_HEADERS TH,
598: FA_TRANSACTION_HEADERS TH_RT,
599: FA_BOOKS BOOKS,

Line 616: FROM FA_DEPRN_DETAIL DD_SUB

612: DD_BONUS.BOOK_TYPE_CODE = book AND
613: DD_BONUS.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
614: DD_BONUS.PERIOD_COUNTER =
615: (SELECT max (DD_SUB.PERIOD_COUNTER)
616: FROM FA_DEPRN_DETAIL DD_SUB
617: WHERE DD_SUB.BOOK_TYPE_CODE = book
618: AND DD_SUB.ASSET_ID = DH.ASSET_ID
619: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
620: AND DD_SUB.PERIOD_COUNTER <= upc)

Line 660: FA_DEPRN_DETAIL DD,

656: DD.PERIOD_COUNTER,
657: NVL(TH.DATE_EFFECTIVE, ucd),
658: CB.BONUS_DEPRN_EXPENSE_ACCT
659: FROM
660: FA_DEPRN_DETAIL DD,
661: FA_ASSET_HISTORY AH,
662: FA_TRANSACTION_HEADERS TH,
663: FA_TRANSACTION_HEADERS TH_RT,
664: FA_BOOKS BOOKS,

Line 681: FROM FA_DEPRN_DETAIL DD_SUB

677: DD.BOOK_TYPE_CODE = book AND
678: DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
679: DD.PERIOD_COUNTER =
680: (SELECT max (DD_SUB.PERIOD_COUNTER)
681: FROM FA_DEPRN_DETAIL DD_SUB
682: WHERE DD_SUB.BOOK_TYPE_CODE = book
683: AND DD_SUB.ASSET_ID = DH.ASSET_ID
684: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
685: 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 849: FA_DEPRN_DETAIL DD,

845: 'RECLASS', 'R') T_TYPE,
846: DD.PERIOD_COUNTER,
847: NVL(TH.DATE_EFFECTIVE, ucd)
848: FROM
849: FA_DEPRN_DETAIL DD,
850: FA_ASSET_HISTORY AH,
851: FA_TRANSACTION_HEADERS TH,
852: FA_TRANSACTION_HEADERS TH_RT,
853: FA_BOOKS BOOKS,

Line 873: FROM FA_DEPRN_DETAIL DD_SUB

869: DD.BOOK_TYPE_CODE = book AND
870: DD.DISTRIBUTION_ID = DH.DISTRIBUTION_ID AND
871: DD.PERIOD_COUNTER =
872: (SELECT max (DD_SUB.PERIOD_COUNTER)
873: FROM FA_DEPRN_DETAIL DD_SUB
874: WHERE DD_SUB.BOOK_TYPE_CODE = book
875: AND DD_SUB.ASSET_ID = DH.ASSET_ID
876: AND DD_SUB.DISTRIBUTION_ID = DH.DISTRIBUTION_ID
877: 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 1036: FROM FA_DEPRN_DETAIL DD_SUB

1032: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
1033: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
1034: AND DD.PERIOD_COUNTER =
1035: (SELECT max (DD_SUB.PERIOD_COUNTER)
1036: FROM FA_DEPRN_DETAIL DD_SUB
1037: WHERE DD_SUB.BOOK_TYPE_CODE = book
1038: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1039: AND DD_SUB.PERIOD_COUNTER <= upc
1040: )

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

Line 1162: FROM FA_DEPRN_DETAIL DD_SUB

1158: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
1159: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
1160: AND DD.PERIOD_COUNTER =
1161: (SELECT max (DD_SUB.PERIOD_COUNTER)
1162: FROM FA_DEPRN_DETAIL DD_SUB
1163: WHERE DD_SUB.BOOK_TYPE_CODE = book
1164: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1165: AND DD_SUB.PERIOD_COUNTER <= upc)
1166: AND DD.PERIOD_COUNTER = DP.PERIOD_COUNTER