DBA Data[Home] [Help]

APPS.FARX_BL dependencies on FA_DEPRN_PERIODS

Line 346: FROM FA_DEPRN_PERIODS P1,

342: P2.Period_Counter,
343: NVL(P2.Period_Close_Date, SYSDATE),
344: BC.Distribution_Source_Book,
345: BC.Accounting_Flex_Structure
346: FROM FA_DEPRN_PERIODS P1,
347: FA_DEPRN_PERIODS P2,
348: FA_BOOK_CONTROLS BC
349: WHERE BC.Book_Type_Code = Book
350: AND P1.Book_Type_Code = Book AND

Line 347: FA_DEPRN_PERIODS P2,

343: NVL(P2.Period_Close_Date, SYSDATE),
344: BC.Distribution_Source_Book,
345: BC.Accounting_Flex_Structure
346: FROM FA_DEPRN_PERIODS P1,
347: FA_DEPRN_PERIODS P2,
348: FA_BOOK_CONTROLS BC
349: WHERE BC.Book_Type_Code = Book
350: AND P1.Book_Type_Code = Book AND
351: P1.Period_Name = Start_Period_Name

Line 693: FA_DEPRN_PERIODS DP_BROW

689: FA_DISTRIBUTION_HISTORY DH,
690: FA_ASSET_HISTORY AH,
691: FA_DEPRN_DETAIL DD,
692: FA_BOOKS BK,
693: FA_DEPRN_PERIODS DP_BROW
694: WHERE DH.Book_Type_Code = distribution_source_book
695: AND DD.Asset_ID = AH.Asset_ID AND
696: DD.Book_Type_Code = book AND
697: DD.Distribution_ID = DH.Distribution_ID AND

Line 940: FA_DEPRN_PERIODS DP,

936: FA_CATEGORY_BOOKS CB,
937: FA_DISTRIBUTION_HISTORY DH,
938: FA_ASSET_HISTORY AH,
939: FA_DEPRN_DETAIL DD,
940: FA_DEPRN_PERIODS DP,
941: FA_BOOKS BK -- Added for Drill Down Report
942: WHERE DH.Book_Type_Code = Distribution_Source_Book
943: AND AH.Asset_ID = DH.Asset_ID
944: AND ((AH.Asset_Type in ('CAPITALIZED', 'GROUP')) OR