DBA Data[Home] [Help]

APPS.FARX_BL dependencies on FA_DEPRN_PERIODS

Line 585: FROM FA_DEPRN_PERIODS P1,

581: P2.Period_Counter,
582: NVL(P2.Period_Close_Date, SYSDATE),
583: BC.Distribution_Source_Book,
584: BC.Accounting_Flex_Structure
585: FROM FA_DEPRN_PERIODS P1,
586: FA_DEPRN_PERIODS P2,
587: FA_BOOK_CONTROLS BC
588: WHERE BC.Book_Type_Code = Book
589: AND P1.Book_Type_Code = Book AND

Line 586: FA_DEPRN_PERIODS P2,

582: NVL(P2.Period_Close_Date, SYSDATE),
583: BC.Distribution_Source_Book,
584: BC.Accounting_Flex_Structure
585: FROM FA_DEPRN_PERIODS P1,
586: FA_DEPRN_PERIODS P2,
587: FA_BOOK_CONTROLS BC
588: WHERE BC.Book_Type_Code = Book
589: AND P1.Book_Type_Code = Book AND
590: P1.Period_Name = Start_Period_Name

Line 946: FA_DEPRN_PERIODS DP_BROW

942: FA_DISTRIBUTION_HISTORY DH,
943: FA_ASSET_HISTORY AH,
944: FA_DEPRN_DETAIL DD,
945: FA_BOOKS BK,
946: FA_DEPRN_PERIODS DP_BROW
947: WHERE DH.Book_Type_Code = distribution_source_book
948: AND DD.Asset_ID = AH.Asset_ID AND
949: DD.Book_Type_Code = book AND
950: DD.Distribution_ID = DH.Distribution_ID AND

Line 1649: FA_DEPRN_PERIODS DP,

1645: FA_CATEGORY_BOOKS CB,
1646: FA_DISTRIBUTION_HISTORY DH,
1647: FA_ASSET_HISTORY AH,
1648: FA_DEPRN_DETAIL DD,
1649: FA_DEPRN_PERIODS DP,
1650: FA_BOOKS BK -- Added for Drill Down Report
1651: WHERE DH.Book_Type_Code = Distribution_Source_Book
1652: AND AH.Asset_ID = DH.Asset_ID
1653: AND ((AH.Asset_Type in ('CAPITALIZED', 'GROUP')) OR