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.FARX_BL dependencies on FA_DEPRN_DETAIL

Line 829: FA_DEPRN_DETAIL DD,

825: FROM
826: FA_CATEGORY_BOOKS CB,
827: FA_DISTRIBUTION_HISTORY DH,
828: FA_ASSET_HISTORY AH,
829: FA_DEPRN_DETAIL DD,
830: FA_BOOKS BK, -- Added for Member Track
831: FA_ADJUSTMENTS AJ
832: WHERE DH.Book_Type_Code = Distribution_Source_Book
833: AND DD.Asset_ID = AH.Asset_ID AND

Line 839: FROM FA_DEPRN_DETAIL SUB_DD

835: DD.Distribution_ID = DH.Distribution_ID AND
836: DD.Period_Counter <= Period1_Pc - 1 AND
837: DD.Period_Counter =
838: (SELECT MAX (SUB_DD.Period_Counter)
839: FROM FA_DEPRN_DETAIL SUB_DD
840: WHERE SUB_DD.Asset_ID = DH.Asset_ID AND
841: SUB_DD.Book_Type_Code = Book AND
842: SUB_DD.Distribution_ID = DH.Distribution_ID AND
843: SUB_DD.Period_Counter <= Period1_Pc - 1) AND

Line 852: from fa_deprn_detail dd1

848: AJ.Period_Counter_Created(+) BETWEEN
849: (DD.Period_Counter+1) AND (Period1_PC-1)
850: AND (( DD.Deprn_Source_Code <> 'T' AND Report_Type = 'RESERVE' ) OR Report_Type <> 'RESERVE' OR nvl(Report_Style,'S') = 'D') /*Bug# 9407401 */
851: AND (( 0 = (select count(1)
852: from fa_deprn_detail dd1
853: where dd1.asset_id = DD.Asset_ID
854: AND dd1.Deprn_Source_Code = 'T'
855: AND dd1.book_type_code = Book
856: AND dd1.Period_Counter = DD.Period_Counter

Line 944: FA_DEPRN_DETAIL DD,

940: FROM
941: FA_CATEGORY_BOOKS CB,
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

Line 1206: FA_DEPRN_DETAIL DD,

1202: FROM
1203: FA_CATEGORY_BOOKS CB,
1204: FA_DISTRIBUTION_HISTORY DH,
1205: FA_ASSET_HISTORY AH,
1206: FA_DEPRN_DETAIL DD,
1207: FA_BOOKS BK,
1208: FA_ADJUSTMENTS AJ
1209: WHERE DH.Book_Type_Code = Distribution_Source_Book
1210: AND DD.Asset_ID = AH.Asset_ID AND

Line 1216: FROM FA_DEPRN_DETAIL SUB_DD

1212: DD.Distribution_ID = DH.Distribution_ID AND
1213: DD.Period_Counter <= period2_pc AND
1214: DD.Period_Counter =
1215: (SELECT MAX (SUB_DD.Period_Counter)
1216: FROM FA_DEPRN_DETAIL SUB_DD
1217: WHERE SUB_DD.Asset_ID = DH.Asset_ID AND
1218: SUB_DD.Book_Type_Code = Book AND
1219: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1220: SUB_DD.Period_Counter <= period2_pc) AND

Line 1648: FA_DEPRN_DETAIL DD,

1644: FROM
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