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

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

352: DD_BONUS.PERIOD_COUNTER,
353: ucd,
354: ''
355: FROM
356: --FA_DEPRN_DETAIL DD_BONUS,
357: FA_ASSET_HISTORY AH,
358: FA_TRANSACTION_HEADERS TH_RT,
359: FA_DISTRIBUTION_HISTORY DH,
360: FA_CATEGORY_BOOKS CB,

Line 374: FROM FA_DEPRN_DETAIL DD_BONUS1

370: BONUS_DEPRN_RESERVE,
371: ASSET_ID,
372: BOOK_TYPE_CODE,
373: DISTRIBUTION_ID
374: FROM FA_DEPRN_DETAIL DD_BONUS1
375: WHERE (DISTRIBUTION_ID, BOOK_TYPE_CODE, PERIOD_COUNTER)
376: IN
377: (
378: SELECT distinct DD_BONUS2.DISTRIBUTION_ID,

Line 383: FROM FA_DEPRN_DETAIL DD_BONUS2

379: DD_BONUS2.BOOK_TYPE_CODE,
380: first_value(PERIOD_COUNTER)
381: over (partition by DISTRIBUTION_ID, BOOK_TYPE_CODE, ASSET_ID
382: order by Period_counter desc nulls last) as max_period_counter
383: FROM FA_DEPRN_DETAIL DD_BONUS2
384: WHERE DD_BONUS2.BOOK_TYPE_CODE = book
385: AND DD_BONUS2.PERIOD_COUNTER <= upc
386: )
387: ) DD_BONUS

Line 435: --FA_DEPRN_DETAIL DD,

431: DD.PERIOD_COUNTER,
432: ucd,
433: CB.BONUS_DEPRN_EXPENSE_ACCT
434: FROM
435: --FA_DEPRN_DETAIL DD,
436: FA_ASSET_HISTORY AH,
437: FA_TRANSACTION_HEADERS TH_RT,
438: FA_DISTRIBUTION_HISTORY DH,
439: FA_CATEGORY_BOOKS CB,

Line 453: FROM FA_DEPRN_DETAIL DD_BONUS1

449: BONUS_DEPRN_RESERVE,
450: ASSET_ID,
451: BOOK_TYPE_CODE,
452: DISTRIBUTION_ID
453: FROM FA_DEPRN_DETAIL DD_BONUS1
454: WHERE (DISTRIBUTION_ID, BOOK_TYPE_CODE, PERIOD_COUNTER)
455: IN
456: (
457: SELECT distinct DD_BONUS2.DISTRIBUTION_ID,

Line 462: FROM FA_DEPRN_DETAIL DD_BONUS2

458: DD_BONUS2.BOOK_TYPE_CODE,
459: first_value(PERIOD_COUNTER)
460: over (partition by DISTRIBUTION_ID, BOOK_TYPE_CODE, ASSET_ID
461: order by Period_counter desc nulls last) as max_period_counter
462: FROM FA_DEPRN_DETAIL DD_BONUS2
463: WHERE DD_BONUS2.BOOK_TYPE_CODE = book
464: AND DD_BONUS2.PERIOD_COUNTER <= upc
465: )
466: ) 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 657: --FA_DEPRN_DETAIL DD_BONUS,

653: DD_BONUS.PERIOD_COUNTER,
654: ucd,
655: ''
656: FROM
657: --FA_DEPRN_DETAIL DD_BONUS,
658: FA_ASSET_HISTORY AH,
659: FA_TRANSACTION_HEADERS TH_RT,
660: FA_DISTRIBUTION_HISTORY DH,
661: FA_CATEGORY_BOOKS CB,

Line 675: FROM FA_DEPRN_DETAIL DD_BONUS1

671: BONUS_DEPRN_RESERVE,
672: ASSET_ID,
673: BOOK_TYPE_CODE,
674: DISTRIBUTION_ID
675: FROM FA_DEPRN_DETAIL DD_BONUS1
676: WHERE (DISTRIBUTION_ID, BOOK_TYPE_CODE, PERIOD_COUNTER)
677: IN
678: (
679: SELECT distinct DD_BONUS2.DISTRIBUTION_ID,

Line 684: FROM FA_DEPRN_DETAIL DD_BONUS2

680: DD_BONUS2.BOOK_TYPE_CODE,
681: first_value(PERIOD_COUNTER)
682: over (partition by DISTRIBUTION_ID, BOOK_TYPE_CODE, ASSET_ID order by Period_counter desc nulls last)
683: as max_period_counter
684: FROM FA_DEPRN_DETAIL DD_BONUS2
685: WHERE DD_BONUS2.BOOK_TYPE_CODE = book
686: AND DD_BONUS2.PERIOD_COUNTER <= upc
687: )
688: ) 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 882: --FA_DEPRN_DETAIL DD,

878: 'RECLASS', 'R') T_TYPE,
879: DD.PERIOD_COUNTER,
880: NVL(TH.DATE_EFFECTIVE, ucd)
881: FROM
882: --FA_DEPRN_DETAIL DD,
883: FA_ASSET_HISTORY AH,
884: FA_TRANSACTION_HEADERS TH,
885: FA_TRANSACTION_HEADERS TH_RT,
886: FA_BOOKS BOOKS,

Line 901: FROM FA_DEPRN_DETAIL DD_BONUS1

897: BONUS_DEPRN_RESERVE,
898: ASSET_ID,
899: BOOK_TYPE_CODE,
900: DISTRIBUTION_ID
901: FROM FA_DEPRN_DETAIL DD_BONUS1
902: WHERE (DISTRIBUTION_ID, BOOK_TYPE_CODE, PERIOD_COUNTER)
903: IN
904: (
905: SELECT distinct DD_BONUS2.DISTRIBUTION_ID,

Line 910: FROM FA_DEPRN_DETAIL DD_BONUS2

906: DD_BONUS2.BOOK_TYPE_CODE,
907: first_value(PERIOD_COUNTER)
908: over (partition by DISTRIBUTION_ID, BOOK_TYPE_CODE, ASSET_ID
909: order by Period_counter desc nulls last) as max_period_counter
910: FROM FA_DEPRN_DETAIL DD_BONUS2
911: WHERE DD_BONUS2.BOOK_TYPE_CODE = book
912: AND DD_BONUS2.PERIOD_COUNTER <= upc
913: )
914: ) 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 1093: FROM FA_DEPRN_DETAIL DD_SUB

1089: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
1090: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
1091: AND DD.PERIOD_COUNTER =
1092: (SELECT max (DD_SUB.PERIOD_COUNTER)
1093: FROM FA_DEPRN_DETAIL DD_SUB
1094: WHERE DD_SUB.BOOK_TYPE_CODE = book
1095: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1096: AND DD_SUB.PERIOD_COUNTER <= upc
1097: )

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

Line 1221: FROM FA_DEPRN_DETAIL DD_SUB

1217: AND GAD.BOOK_TYPE_CODE = GAR.BOOK_TYPE_CODE
1218: AND GAD.GROUP_ASSET_ID = GAR.GROUP_ASSET_ID
1219: AND DD.PERIOD_COUNTER =
1220: (SELECT max (DD_SUB.PERIOD_COUNTER)
1221: FROM FA_DEPRN_DETAIL DD_SUB
1222: WHERE DD_SUB.BOOK_TYPE_CODE = book
1223: AND DD_SUB.ASSET_ID = GAR.GROUP_ASSET_ID
1224: AND DD_SUB.PERIOD_COUNTER <= upc)
1225: AND DD.PERIOD_COUNTER = DP.PERIOD_COUNTER