[Home] [Help]
476: AND DD.BOOK_TYPE_CODE = :h_book AND
477: DD.ASSET_ID = TH.ASSET_ID AND
478: DD.PERIOD_COUNTER =
479: ( select max(DD1.PERIOD_COUNTER)
480: from FA_DEPRN_DETAIL DD1
481: where dd1.period_counter <= dp1.period_counter
482: and DD1.ASSET_ID = DD.ASSET_ID
483: and DD1.BOOK_TYPE_CODE = DD.BOOK_TYPE_CODE)
484: AND DP1.BOOK_TYPE_CODE = :h_book AND
574: AND DD.BOOK_TYPE_CODE = :h_book AND
575: DD.ASSET_ID = TH.ASSET_ID AND
576: DD.PERIOD_COUNTER =
577: ( select max(DD1.PERIOD_COUNTER)
578: from FA_DEPRN_DETAIL DD1, FA_DEPRN_PERIODS DP2
579: where dd1.period_counter <= dp2.period_counter
580: and DD1.ASSET_ID = DD.ASSET_ID
581: and DD1.BOOK_TYPE_CODE = DD.BOOK_TYPE_CODE
582: and DP2.BOOK_TYPE_CODE = DD1.BOOK_TYPE_CODE
681: FA_BOOKS BK,
682: FA_TRANSACTION_HEADERS TH,
683: FA_DEPRN_PERIODS DP1,
684: FA_DEPRN_PERIODS DP,
685: FA_DEPRN_DETAIL DD,
686: FA_CATEGORIES CAT,
687: FA_ADDITIONS_B GAD
688: WHERE ' || where_clause1 || '
689: UNION ALL
741: FA_DEPRN_PERIODS DP2,
742: FA_DEPRN_PERIODS DP1,
743: FA_DEPRN_PERIODS DP,
744: FA_TRANSACTION_HEADERS TH,
745: fa_deprn_detail dd,
746: fa_categories cat,
747: fa_additions_b GAD
748: WHERE ' || where_clause2 || '
749: UNION ALL
791: FA_ASSET_HISTORY AH,
792: FA_BOOKS BK,
793: FA_TRANSACTION_HEADERS TH,
794: FA_DEPRN_PERIODS DP,
795: FA_DEPRN_DETAIL DD,
796: fa_categories cat,
797: fa_additions_b GAD
798: WHERE ' || where_clause3 || '
799: UNION ALL
842: FA_LOOKUPS FALU,
843: FA_ASSET_HISTORY AH,
844: FA_DEPRN_PERIODS DP,
845: FA_TRANSACTION_HEADERS TH,
846: fa_deprn_detail dd,
847: fa_categories cat,
848: FA_ADDITIONS_B GAD
849: WHERE ' || where_clause4 ;
850:
1372: --GL_CODE_COMBINATIONS DHCC,
1373: FA_BOOKS BK,
1374: FA_DEPRN_SUMMARY DS,
1375: FA_TRANSACTION_HEADERS TH,
1376: FA_DEPRN_DETAIL DD,
1377: fa_adjustments adj
1378:
1379: WHERE
1380: bk.book_type_code = th.book_type_code AND
1583: FA_LOOKUPS FALU,
1584: PO_VENDORS PO_VEND,
1585: FA_ADDITIONS AD,
1586: --GL_CODE_COMBINATIONS DHCC,
1587: FA_DEPRN_DETAIL DD
1588: WHERE
1589: bk.book_type_code = th.book_type_code AND
1590: bk.asset_id = th.asset_id AND
1591: bk.date_placed_in_service >= begin_dpis AND
2072: FA_ASSET_HISTORY AH,
2073: FA_DISTRIBUTION_HISTORY DH,
2074: FA_BOOKS BOOKS,
2075: FA_DEPRN_SUMMARY DS,
2076: FA_DEPRN_DETAIL DD
2077: --FA_DEPRN_PERIODS DP
2078: WHERE
2079: TH.DATE_EFFECTIVE >= h_period1_pod AND
2080: TH.DATE_EFFECTIVE <= nvl(h_period2_pcd ,sysdate) AND