VIEW: APPS.IGI_IMP_IAC_INTERFACE_DTL_V

Source

View Text - Preformatted

SELECT ii.Asset_ID , ii.asset_number, ii.Book_type_code , dh.distribution_id , dh.code_combination_id , dh.units_Assigned , ii.Category_ID , ii.Hist_Salvage_Value , ii.Life_in_Months , round( ii.Cost_Hist * (dh.units_Assigned/ad.current_units), 2) Cost_Hist , round( ii.Cost_MHCA * (dh.units_Assigned/ad.current_units), 2) Cost_MHCA , round( ii.Deprn_Exp_Hist * (dh.units_Assigned/ad.current_units), 2) Deprn_Exp_Hist , round( ii.Deprn_Exp_MHCA * (dh.units_Assigned/ad.current_units), 2) Deprn_Exp_MHCA , round( ii.YTD_Hist * (dh.units_Assigned/ad.current_units), 2) YTD_Hist , round( ii.YTD_MHCA * (dh.units_Assigned/ad.current_units), 2) YTD_MHCA , round( ii.Accum_Deprn_Hist * (dh.units_Assigned/ad.current_units), 2) Accum_Deprn_Hist , round( ii.Accum_Deprn_MHCA * (dh.units_Assigned/ad.current_units), 2) Accum_deprn_MHCA , round( ii.Reval_Reserve_Hist * (dh.units_Assigned/ad.current_units), 2) Reval_Reserve_Hist , round( ii.Reval_Reserve_MHCA * (dh.units_Assigned/ad.current_units), 2) Reval_Reserve_MHCA , round( ii.Backlog_Hist * (dh.units_Assigned/ad.current_units), 2) Backlog_Hist , round( ii.Backlog_MHCA * (dh.units_Assigned/ad.current_units), 2) Backlog_MHCA , round( ii.General_Fund_Hist * (dh.units_Assigned/ad.current_units), 2) General_Fund_Hist , round( ii.General_Fund_MHCA * (dh.units_Assigned/ad.current_units), 2) General_Fund_MHCA , round( ii.General_Fund_Per_Hist * (dh.units_Assigned/ad.current_units), 2) General_Fund_Per_Hist , round( ii.General_Fund_Per_Mhca * (dh.units_Assigned/ad.current_units), 2) General_Fund_Per_MHCA , round( ii.Operating_Account_Hist * (dh.units_Assigned/ad.current_units), 2) Operating_Account_Hist , round( ii.Operating_Account_MHCA * (dh.units_Assigned/ad.current_units), 2) Operating_Account_MHCA , round( ii.Operating_Account_YTD_Hist * (dh.units_Assigned/ad.current_units), 2) Operating_Account_YTD_Hist , round( ii.Operating_Account_YTD_MHCA * (dh.units_Assigned/ad.current_units), 2) Operating_Account_YTD_MHCA , round( ii.Operating_Account_Cost * (dh.units_Assigned/ad.current_units), 2) Operating_Account_Cost , round( ii.Operating_Account_Backlog * (dh.units_Assigned/ad.current_units), 2) Operating_Account_Backlog , round( ii.NBV_Hist * (dh.units_Assigned/ad.current_units), 2) NBV_Hist , round( ii.NBV_MHCA * (dh.units_Assigned/ad.current_units), 2) NBV_MHCA , ii.Transferred_Flag , ii.Selected_Flag , ii.Exception_Flag , ii.Exception_Code , ii.Created_By , ii.Creation_date , ii.Last_Update_login , ii.Last_updated_by , ii.Last_Update_date FROM Igi_Imp_Iac_Interface ii , Fa_Distribution_History dh , Fa_Additions ad, igi_imp_iac_controls ct WHERE ct.book_type_code = ii.book_type_code AND dh.book_type_Code = ct.corp_book AND dh.asset_id = ii.asset_id AND dh.date_ineffective IS NULL AND ad.asset_id = ii.asset_id

View Text - HTML Formatted

SELECT II.ASSET_ID
, II.ASSET_NUMBER
, II.BOOK_TYPE_CODE
, DH.DISTRIBUTION_ID
, DH.CODE_COMBINATION_ID
, DH.UNITS_ASSIGNED
, II.CATEGORY_ID
, II.HIST_SALVAGE_VALUE
, II.LIFE_IN_MONTHS
, ROUND( II.COST_HIST * (DH.UNITS_ASSIGNED/AD.CURRENT_UNITS)
, 2) COST_HIST
, ROUND( II.COST_MHCA * (DH.UNITS_ASSIGNED/AD.CURRENT_UNITS)
, 2) COST_MHCA
, ROUND( II.DEPRN_EXP_HIST * (DH.UNITS_ASSIGNED/AD.CURRENT_UNITS)
, 2) DEPRN_EXP_HIST
, ROUND( II.DEPRN_EXP_MHCA * (DH.UNITS_ASSIGNED/AD.CURRENT_UNITS)
, 2) DEPRN_EXP_MHCA
, ROUND( II.YTD_HIST * (DH.UNITS_ASSIGNED/AD.CURRENT_UNITS)
, 2) YTD_HIST
, ROUND( II.YTD_MHCA * (DH.UNITS_ASSIGNED/AD.CURRENT_UNITS)
, 2) YTD_MHCA
, ROUND( II.ACCUM_DEPRN_HIST * (DH.UNITS_ASSIGNED/AD.CURRENT_UNITS)
, 2) ACCUM_DEPRN_HIST
, ROUND( II.ACCUM_DEPRN_MHCA * (DH.UNITS_ASSIGNED/AD.CURRENT_UNITS)
, 2) ACCUM_DEPRN_MHCA
, ROUND( II.REVAL_RESERVE_HIST * (DH.UNITS_ASSIGNED/AD.CURRENT_UNITS)
, 2) REVAL_RESERVE_HIST
, ROUND( II.REVAL_RESERVE_MHCA * (DH.UNITS_ASSIGNED/AD.CURRENT_UNITS)
, 2) REVAL_RESERVE_MHCA
, ROUND( II.BACKLOG_HIST * (DH.UNITS_ASSIGNED/AD.CURRENT_UNITS)
, 2) BACKLOG_HIST
, ROUND( II.BACKLOG_MHCA * (DH.UNITS_ASSIGNED/AD.CURRENT_UNITS)
, 2) BACKLOG_MHCA
, ROUND( II.GENERAL_FUND_HIST * (DH.UNITS_ASSIGNED/AD.CURRENT_UNITS)
, 2) GENERAL_FUND_HIST
, ROUND( II.GENERAL_FUND_MHCA * (DH.UNITS_ASSIGNED/AD.CURRENT_UNITS)
, 2) GENERAL_FUND_MHCA
, ROUND( II.GENERAL_FUND_PER_HIST * (DH.UNITS_ASSIGNED/AD.CURRENT_UNITS)
, 2) GENERAL_FUND_PER_HIST
, ROUND( II.GENERAL_FUND_PER_MHCA * (DH.UNITS_ASSIGNED/AD.CURRENT_UNITS)
, 2) GENERAL_FUND_PER_MHCA
, ROUND( II.OPERATING_ACCOUNT_HIST * (DH.UNITS_ASSIGNED/AD.CURRENT_UNITS)
, 2) OPERATING_ACCOUNT_HIST
, ROUND( II.OPERATING_ACCOUNT_MHCA * (DH.UNITS_ASSIGNED/AD.CURRENT_UNITS)
, 2) OPERATING_ACCOUNT_MHCA
, ROUND( II.OPERATING_ACCOUNT_YTD_HIST * (DH.UNITS_ASSIGNED/AD.CURRENT_UNITS)
, 2) OPERATING_ACCOUNT_YTD_HIST
, ROUND( II.OPERATING_ACCOUNT_YTD_MHCA * (DH.UNITS_ASSIGNED/AD.CURRENT_UNITS)
, 2) OPERATING_ACCOUNT_YTD_MHCA
, ROUND( II.OPERATING_ACCOUNT_COST * (DH.UNITS_ASSIGNED/AD.CURRENT_UNITS)
, 2) OPERATING_ACCOUNT_COST
, ROUND( II.OPERATING_ACCOUNT_BACKLOG * (DH.UNITS_ASSIGNED/AD.CURRENT_UNITS)
, 2) OPERATING_ACCOUNT_BACKLOG
, ROUND( II.NBV_HIST * (DH.UNITS_ASSIGNED/AD.CURRENT_UNITS)
, 2) NBV_HIST
, ROUND( II.NBV_MHCA * (DH.UNITS_ASSIGNED/AD.CURRENT_UNITS)
, 2) NBV_MHCA
, II.TRANSFERRED_FLAG
, II.SELECTED_FLAG
, II.EXCEPTION_FLAG
, II.EXCEPTION_CODE
, II.CREATED_BY
, II.CREATION_DATE
, II.LAST_UPDATE_LOGIN
, II.LAST_UPDATED_BY
, II.LAST_UPDATE_DATE
FROM IGI_IMP_IAC_INTERFACE II
, FA_DISTRIBUTION_HISTORY DH
, FA_ADDITIONS AD
, IGI_IMP_IAC_CONTROLS CT
WHERE CT.BOOK_TYPE_CODE = II.BOOK_TYPE_CODE
AND DH.BOOK_TYPE_CODE = CT.CORP_BOOK
AND DH.ASSET_ID = II.ASSET_ID
AND DH.DATE_INEFFECTIVE IS NULL
AND AD.ASSET_ID = II.ASSET_ID