[Home] [Help]
168: ASSET_COST_ACCT
169: )
170: SELECT /*+ ORDERED
171: Index(DD_BONUS FA_DEPRN_DETAIL_U1)
172: index(DH FA_DISTRIBUTION_HISTORY_U1)
173: Index(AH FA_ASSET_HISTORY_N2)
174: */
175: DH.ASSET_ID ASSET_ID ,
176: DH.CODE_COMBINATION_ID DH_CCID ,
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,
210: FA_CATEGORY_BOOKS CB,
244: AND NVL(DH.DATE_INEFFECTIVE, sysdate) > tod
245: UNION ALL
246: SELECT /*+ ORDERED
247: Index(DD FA_DEPRN_DETAIL_U1)
248: index(DH FA_DISTRIBUTION_HISTORY_U1)
249: Index(AH FA_ASSET_HISTORY_N2)
250: */
251: DH.ASSET_ID ASSET_ID ,
252: DH.CODE_COMBINATION_ID DH_CCID ,
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,
286: FA_CATEGORY_BOOKS CB,
344: ASSET_COST_ACCT
345: )
346: SELECT /*+ ORDERED
347: Index(DD_BONUS FA_DEPRN_DETAIL_U1)
348: index(DH FA_DISTRIBUTION_HISTORY_U1)
349: Index(AH FA_ASSET_HISTORY_N2)
350: */
351: DH.ASSET_ID ASSET_ID ,
352: DH.CODE_COMBINATION_ID DH_CCID ,
378: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
379: GROUP BY DISTRIBUTION_ID
380: ) DD1 ,
381: FA_DEPRN_DETAIL DD_BONUS ,
382: FA_DISTRIBUTION_HISTORY DH ,
383: FA_ASSET_HISTORY AH ,
384: FA_BOOKS BOOKS ,
385: FA_TRANSACTION_HEADERS TH_RT,
386: FA_CATEGORY_BOOKS CB ,
420: NVL(BR.END_YEAR, DP.FISCAL_YEAR))
421: UNION ALL
422: SELECT /*+ ORDERED
423: Index(DD FA_DEPRN_DETAIL_U1)
424: index(DH FA_DISTRIBUTION_HISTORY_U1)
425: Index(AH FA_ASSET_HISTORY_N2)
426: */
427: DH.ASSET_ID ASSET_ID ,
428: DH.CODE_COMBINATION_ID DH_CCID ,
454: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
455: GROUP BY DISTRIBUTION_ID
456: ) DD1,
457: FA_DEPRN_DETAIL DD ,
458: FA_DISTRIBUTION_HISTORY DH ,
459: FA_ASSET_HISTORY AH ,
460: FA_BOOKS BOOKS ,
461: FA_TRANSACTION_HEADERS TH_RT,
462: FA_CATEGORY_BOOKS CB ,
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,
561: FA_CATEGORY_BOOKS CB,
654: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
655: GROUP BY DISTRIBUTION_ID
656: ) DD1,
657: FA_DEPRN_DETAIL DD_BONUS ,
658: FA_DISTRIBUTION_HISTORY DH ,
659: FA_ASSET_HISTORY AH ,
660: FA_BOOKS BOOKS ,
661: FA_TRANSACTION_HEADERS TH_RT,
662: FA_TRANSACTION_HEADERS TH_DIST_END,
731: ASSET_COST_ACCT
732: )
733: SELECT /*+ ORDERED
734: Index(DD FA_DEPRN_DETAIL_U1)
735: index(DH FA_DISTRIBUTION_HISTORY_U1)
736: Index(AH FA_ASSET_HISTORY_N2)
737: */
738: DH.ASSET_ID ASSET_ID ,
739: DH.CODE_COMBINATION_ID DH_CCID ,
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 ,
772: FA_TRANSACTION_HEADERS TH_RT,
835: )
836: SELECT
837: /*+ ORDERED
838: Index(DD FA_DEPRN_DETAIL_U1)
839: index(DH FA_DISTRIBUTION_HISTORY_U1)
840: Index(AH FA_ASSET_HISTORY_N2)
841: */
842: DH.ASSET_ID ASSET_ID ,
843: DH.CODE_COMBINATION_ID DH_CCID ,
868: AND ASSET_ID BETWEEN REC1.START_RANGE AND REC1.END_RANGE
869: GROUP BY DISTRIBUTION_ID
870: ) DD1,
871: FA_DEPRN_DETAIL DD ,
872: FA_DISTRIBUTION_HISTORY DH ,
873: FA_ASSET_HISTORY AH ,
874: FA_BOOKS BOOKS ,
875: FA_TRANSACTION_HEADERS TH ,
876: FA_TRANSACTION_HEADERS TH_RT,