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

Line 196: --FA_DEPRN_DETAIL_MRC_V DD_BONUS,

192: AD.ASSET_NUMBER || ' - ' || AD.DESCRIPTION ,
193: BR.BONUS_RATE ,
194: CB.ASSET_COST_ACCT
195: FROM
196: --FA_DEPRN_DETAIL_MRC_V DD_BONUS,
197: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,
198: MAX(PERIOD_COUNTER) PERIOD_COUNTER
199: FROM FA_DEPRN_DETAIL_MRC_V
200: WHERE BOOK_TYPE_CODE = book

Line 199: FROM FA_DEPRN_DETAIL_MRC_V

195: FROM
196: --FA_DEPRN_DETAIL_MRC_V DD_BONUS,
197: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,
198: MAX(PERIOD_COUNTER) PERIOD_COUNTER
199: FROM FA_DEPRN_DETAIL_MRC_V
200: WHERE BOOK_TYPE_CODE = book
201: AND PERIOD_COUNTER <= upc
202: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
203: GROUP BY DISTRIBUTION_ID

Line 205: FA_DEPRN_DETAIL_MRC_V DD_BONUS,

201: AND PERIOD_COUNTER <= upc
202: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
203: GROUP BY DISTRIBUTION_ID
204: ) dd1,
205: FA_DEPRN_DETAIL_MRC_V DD_BONUS,
206: FA_DISTRIBUTION_HISTORY DH ,
207: FA_ASSET_HISTORY AH ,
208: FA_BOOKS_MRC_V BOOKS ,
209: FA_TRANSACTION_HEADERS TH_RT,

Line 272: --FA_DEPRN_DETAIL_MRC_V DD,

268: AD.ASSET_NUMBER || ' - ' || AD.DESCRIPTION ,
269: BR.BONUS_RATE ,
270: CB.ASSET_COST_ACCT
271: FROM
272: --FA_DEPRN_DETAIL_MRC_V DD,
273: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,
274: MAX(PERIOD_COUNTER) PERIOD_COUNTER
275: FROM FA_DEPRN_DETAIL_MRC_V
276: WHERE BOOK_TYPE_CODE = book

Line 275: FROM FA_DEPRN_DETAIL_MRC_V

271: FROM
272: --FA_DEPRN_DETAIL_MRC_V DD,
273: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,
274: MAX(PERIOD_COUNTER) PERIOD_COUNTER
275: FROM FA_DEPRN_DETAIL_MRC_V
276: WHERE BOOK_TYPE_CODE = book
277: AND PERIOD_COUNTER <= upc
278: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
279: GROUP BY DISTRIBUTION_ID

Line 281: FA_DEPRN_DETAIL_MRC_V DD,

277: AND PERIOD_COUNTER <= upc
278: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
279: GROUP BY DISTRIBUTION_ID
280: ) dd1,
281: FA_DEPRN_DETAIL_MRC_V DD,
282: FA_DISTRIBUTION_HISTORY DH ,
283: FA_ASSET_HISTORY AH ,
284: FA_BOOKS_MRC_V BOOKS ,
285: FA_TRANSACTION_HEADERS TH_RT,

Line 546: --FA_DEPRN_DETAIL_MRC_V DD_BONUS,

542: AD.ASSET_NUMBER || ' - ' || AD.DESCRIPTION ,
543: BR.BONUS_RATE ,
544: CB.ASSET_COST_ACCT
545: FROM
546: --FA_DEPRN_DETAIL_MRC_V DD_BONUS,
547: ( SELECT
548: DISTRIBUTION_ID ,
549: MAX(PERIOD_COUNTER) PERIOD_COUNTER
550: FROM FA_DEPRN_DETAIL_MRC_V

Line 550: FROM FA_DEPRN_DETAIL_MRC_V

546: --FA_DEPRN_DETAIL_MRC_V DD_BONUS,
547: ( SELECT
548: DISTRIBUTION_ID ,
549: MAX(PERIOD_COUNTER) PERIOD_COUNTER
550: FROM FA_DEPRN_DETAIL_MRC_V
551: WHERE BOOK_TYPE_CODE = book
552: AND PERIOD_COUNTER <= upc
553: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
554: GROUP BY DISTRIBUTION_ID

Line 556: FA_DEPRN_DETAIL_MRC_V DD_BONUS,

552: AND PERIOD_COUNTER <= upc
553: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
554: GROUP BY DISTRIBUTION_ID
555: ) dd1,
556: FA_DEPRN_DETAIL_MRC_V DD_BONUS,
557: FA_DISTRIBUTION_HISTORY DH ,
558: FA_ASSET_HISTORY AH ,
559: FA_BOOKS_MRC_V BOOKS ,
560: FA_TRANSACTION_HEADERS TH_RT,

Line 758: --FA_DEPRN_DETAIL_MRC_V DD,

754: AD.ASSET_NUMBER || ' - ' || AD.DESCRIPTION ,
755: BR.BONUS_RATE ,
756: CB.ASSET_COST_ACCT
757: FROM
758: --FA_DEPRN_DETAIL_MRC_V DD,
759: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,
760: MAX(PERIOD_COUNTER) PERIOD_COUNTER
761: FROM FA_DEPRN_DETAIL_MRC_V
762: WHERE BOOK_TYPE_CODE = book

Line 761: FROM FA_DEPRN_DETAIL_MRC_V

757: FROM
758: --FA_DEPRN_DETAIL_MRC_V DD,
759: ( SELECT /*+ Index (FA_DEPRN_DETAIL FA_DEPRN_DETAIL_N1 ) */ DISTRIBUTION_ID ,
760: MAX(PERIOD_COUNTER) PERIOD_COUNTER
761: FROM FA_DEPRN_DETAIL_MRC_V
762: WHERE BOOK_TYPE_CODE = book
763: AND PERIOD_COUNTER <= upc
764: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
765: GROUP BY DISTRIBUTION_ID

Line 767: FA_DEPRN_DETAIL_MRC_V DD ,

763: AND PERIOD_COUNTER <= upc
764: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
765: GROUP BY DISTRIBUTION_ID
766: ) dd1,
767: FA_DEPRN_DETAIL_MRC_V DD ,
768: FA_DISTRIBUTION_HISTORY DH ,
769: FA_ASSET_HISTORY AH ,
770: FA_BOOKS_MRC_V BOOKS ,
771: FA_TRANSACTION_HEADERS TH ,

Line 991: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

987: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
988: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
989: AND DD.PERIOD_COUNTER =
990: (SELECT MAX (DD_SUB.PERIOD_COUNTER)
991: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
992: WHERE DD_SUB.BOOK_TYPE_CODE = book
993: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
994: AND DD_SUB.PERIOD_COUNTER <= upc
995: )

Line 1157: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

1153: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
1154: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
1155: AND DD.PERIOD_COUNTER =
1156: (SELECT MAX (DD_SUB.PERIOD_COUNTER)
1157: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
1158: WHERE DD_SUB.BOOK_TYPE_CODE = book
1159: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1160: AND DD_SUB.PERIOD_COUNTER <= upc
1161: )