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_MC_DEPRN_DETAIL

Line 1014: FA_MC_DEPRN_DETAIL DD,

1010: FROM
1011: FA_CATEGORY_BOOKS CB,
1012: FA_DISTRIBUTION_HISTORY DH,
1013: FA_ASSET_HISTORY AH,
1014: FA_MC_DEPRN_DETAIL DD,
1015: FA_MC_BOOKS BK, -- Added for Member Track
1016: FA_MC_ADJUSTMENTS AJ
1017: WHERE DH.Book_Type_Code = Distribution_Source_Book
1018: AND DD.Asset_ID = AH.Asset_ID AND

Line 1024: FROM FA_MC_DEPRN_DETAIL SUB_DD

1020: DD.Distribution_ID = DH.Distribution_ID AND
1021: DD.Period_Counter <= Period1_Pc - 1 AND
1022: DD.Period_Counter =
1023: (SELECT MAX (SUB_DD.Period_Counter)
1024: FROM FA_MC_DEPRN_DETAIL SUB_DD
1025: WHERE SUB_DD.Asset_ID = DH.Asset_ID AND
1026: SUB_DD.Book_Type_Code = Book AND
1027: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1028: SUB_DD.Period_Counter <= Period1_Pc - 1 AND

Line 1039: from fa_mc_deprn_detail dd1

1035: AJ.Period_Counter_Created(+) BETWEEN
1036: (DD.Period_Counter+1) AND (Period1_Pc - 1)
1037: AND (( DD.Deprn_Source_Code <> 'T' AND Report_Type = 'RESERVE' ) OR Report_Type <> 'RESERVE' OR nvl(Report_Style,'S') = 'D') /*Bug# 9284473 */
1038: AND (( 0 = (select count(1)
1039: from fa_mc_deprn_detail dd1
1040: where dd1.asset_id = DD.Asset_ID
1041: AND dd1.Deprn_Source_Code = 'T'
1042: AND dd1.book_type_code = Book
1043: AND dd1.Period_Counter = DD.Period_Counter

Line 1134: FA_MC_DEPRN_DETAIL DD,

1130: FROM
1131: FA_CATEGORY_BOOKS CB,
1132: FA_DISTRIBUTION_HISTORY DH,
1133: FA_ASSET_HISTORY AH,
1134: FA_MC_DEPRN_DETAIL DD,
1135: FA_MC_BOOKS BK,
1136: FA_MC_DEPRN_PERIODS DP_BROW
1137: WHERE DH.Book_Type_Code = distribution_source_book
1138: AND DD.Asset_ID = AH.Asset_ID AND

Line 1329: FA_MC_DEPRN_DETAIL DD,

1325: FROM
1326: FA_CATEGORY_BOOKS CB,
1327: FA_DISTRIBUTION_HISTORY DH,
1328: FA_ASSET_HISTORY AH,
1329: FA_MC_DEPRN_DETAIL DD,
1330: FA_MC_BOOKS BK,
1331: FA_MC_ADJUSTMENTS AJ
1332: WHERE DH.Book_Type_Code = Distribution_Source_Book
1333: AND DD.Asset_ID = AH.Asset_ID AND

Line 1339: FROM FA_MC_DEPRN_DETAIL SUB_DD

1335: DD.Distribution_ID = DH.Distribution_ID AND
1336: DD.Period_Counter <= period2_pc AND
1337: DD.Period_Counter =
1338: (SELECT MAX (SUB_DD.Period_Counter)
1339: FROM FA_MC_DEPRN_DETAIL SUB_DD
1340: WHERE SUB_DD.Asset_ID = DH.Asset_ID AND
1341: SUB_DD.Book_Type_Code = Book AND
1342: SUB_DD.Distribution_ID = DH.Distribution_ID AND
1343: SUB_DD.Period_Counter <= period2_pc AND

Line 1720: FA_MC_DEPRN_DETAIL DD,

1716: FROM
1717: FA_CATEGORY_BOOKS CB,
1718: FA_DISTRIBUTION_HISTORY DH,
1719: FA_ASSET_HISTORY AH,
1720: FA_MC_DEPRN_DETAIL DD,
1721: FA_MC_DEPRN_PERIODS DP,
1722: FA_MC_BOOKS BK -- Added for Drill Down Report
1723: WHERE DH.Book_Type_Code = Distribution_Source_Book
1724: AND AH.Asset_ID = DH.Asset_ID