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 169: --FA_DEPRN_DETAIL_MRC_V DD_BONUS,

165: DD_BONUS.PERIOD_COUNTER,
166: ucd,
167: ''
168: FROM
169: --FA_DEPRN_DETAIL_MRC_V DD_BONUS,
170: FA_ASSET_HISTORY AH,
171: FA_TRANSACTION_HEADERS TH_RT,
172: FA_BOOKS_MRC_V BOOKS,
173: FA_DISTRIBUTION_HISTORY DH,

Line 187: FROM FA_DEPRN_DETAIL_MRC_V DD_BONUS1

183: BONUS_DEPRN_RESERVE,
184: ASSET_ID,
185: BOOK_TYPE_CODE,
186: DISTRIBUTION_ID
187: FROM FA_DEPRN_DETAIL_MRC_V DD_BONUS1
188: WHERE (DISTRIBUTION_ID, BOOK_TYPE_CODE, PERIOD_COUNTER)
189: IN
190: (
191: SELECT distinct DD_BONUS2.DISTRIBUTION_ID,

Line 196: FROM FA_DEPRN_DETAIL_MRC_V DD_BONUS2

192: DD_BONUS2.BOOK_TYPE_CODE,
193: first_value(PERIOD_COUNTER)
194: over (partition by DISTRIBUTION_ID, BOOK_TYPE_CODE, ASSET_ID
195: order by Period_counter desc nulls last) as max_period_counter
196: FROM FA_DEPRN_DETAIL_MRC_V DD_BONUS2
197: WHERE DD_BONUS2.BOOK_TYPE_CODE = book
198: AND DD_BONUS2.PERIOD_COUNTER <= upc
199: )
200: ) DD_BONUS

Line 248: --FA_DEPRN_DETAIL_MRC_V DD,

244: DD.PERIOD_COUNTER,
245: ucd,
246: CB.BONUS_DEPRN_EXPENSE_ACCT
247: FROM
248: --FA_DEPRN_DETAIL_MRC_V DD,
249: FA_ASSET_HISTORY AH,
250: FA_TRANSACTION_HEADERS TH_RT,
251: FA_BOOKS_MRC_V BOOKS,
252: FA_DISTRIBUTION_HISTORY DH,

Line 266: FROM FA_DEPRN_DETAIL_MRC_V DD_BONUS1

262: BONUS_DEPRN_RESERVE,
263: ASSET_ID,
264: BOOK_TYPE_CODE,
265: DISTRIBUTION_ID
266: FROM FA_DEPRN_DETAIL_MRC_V DD_BONUS1
267: WHERE (DISTRIBUTION_ID, BOOK_TYPE_CODE, PERIOD_COUNTER)
268: IN
269: (
270: SELECT distinct DD_BONUS2.DISTRIBUTION_ID,

Line 275: FROM FA_DEPRN_DETAIL_MRC_V DD_BONUS2

271: DD_BONUS2.BOOK_TYPE_CODE,
272: first_value(PERIOD_COUNTER)
273: over (partition by DISTRIBUTION_ID, BOOK_TYPE_CODE, ASSET_ID
274: order by Period_counter desc nulls last) as max_period_counter
275: FROM FA_DEPRN_DETAIL_MRC_V DD_BONUS2
276: WHERE DD_BONUS2.BOOK_TYPE_CODE = book
277: AND DD_BONUS2.PERIOD_COUNTER <= upc
278: )
279: ) DD

Line 549: --FA_DEPRN_DETAIL_MRC_V DD_BONUS,

545: DD_BONUS.PERIOD_COUNTER,
546: ucd,
547: ''
548: FROM
549: --FA_DEPRN_DETAIL_MRC_V DD_BONUS,
550: FA_ASSET_HISTORY AH,
551: FA_TRANSACTION_HEADERS TH_RT,
552: FA_BOOKS_MRC_V BOOKS,
553: FA_DISTRIBUTION_HISTORY DH,

Line 567: FROM FA_DEPRN_DETAIL_MRC_V DD_BONUS1

563: BONUS_DEPRN_RESERVE,
564: ASSET_ID,
565: BOOK_TYPE_CODE,
566: DISTRIBUTION_ID
567: FROM FA_DEPRN_DETAIL_MRC_V DD_BONUS1
568: WHERE (DISTRIBUTION_ID, BOOK_TYPE_CODE, PERIOD_COUNTER)
569: IN
570: (
571: SELECT distinct DD_BONUS2.DISTRIBUTION_ID,

Line 576: FROM FA_DEPRN_DETAIL_MRC_V DD_BONUS2

572: DD_BONUS2.BOOK_TYPE_CODE,
573: first_value(PERIOD_COUNTER)
574: over (partition by DISTRIBUTION_ID, BOOK_TYPE_CODE, ASSET_ID
575: order by Period_counter desc nulls last) as max_period_counter
576: FROM FA_DEPRN_DETAIL_MRC_V DD_BONUS2
577: WHERE DD_BONUS2.BOOK_TYPE_CODE = book
578: AND DD_BONUS2.PERIOD_COUNTER <= upc
579: )
580: ) DD_BONUS

Line 769: --FA_DEPRN_DETAIL_MRC_V DD,

765: 'RECLASS', 'R') T_TYPE,
766: DD.PERIOD_COUNTER,
767: NVL(TH.DATE_EFFECTIVE, ucd)
768: FROM
769: --FA_DEPRN_DETAIL_MRC_V DD,
770: FA_ASSET_HISTORY AH,
771: FA_TRANSACTION_HEADERS TH,
772: FA_TRANSACTION_HEADERS TH_RT,
773: FA_BOOKS_MRC_V BOOKS,

Line 788: FROM FA_DEPRN_DETAIL_MRC_V DD_BONUS1

784: BONUS_DEPRN_RESERVE,
785: ASSET_ID,
786: BOOK_TYPE_CODE,
787: DISTRIBUTION_ID
788: FROM FA_DEPRN_DETAIL_MRC_V DD_BONUS1
789: WHERE (DISTRIBUTION_ID, BOOK_TYPE_CODE, PERIOD_COUNTER)
790: IN
791: (
792: SELECT distinct DD_BONUS2.DISTRIBUTION_ID,

Line 797: FROM FA_DEPRN_DETAIL_MRC_V DD_BONUS2

793: DD_BONUS2.BOOK_TYPE_CODE,
794: first_value(PERIOD_COUNTER)
795: over (partition by DISTRIBUTION_ID, BOOK_TYPE_CODE, ASSET_ID
796: order by Period_counter desc nulls last) as max_period_counter
797: FROM FA_DEPRN_DETAIL_MRC_V DD_BONUS2
798: WHERE DD_BONUS2.BOOK_TYPE_CODE = book
799: AND DD_BONUS2.PERIOD_COUNTER <= upc
800: )
801: ) DD

Line 1019: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

1015: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
1016: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
1017: AND DD.PERIOD_COUNTER =
1018: (SELECT max (DD_SUB.PERIOD_COUNTER)
1019: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB
1020: WHERE DD_SUB.BOOK_TYPE_CODE = book
1021: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1022: AND DD_SUB.PERIOD_COUNTER <= upc
1023: )

Line 1158: FROM FA_DEPRN_DETAIL_MRC_V DD_SUB

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