Product: | IGI - Public Sector Financials International |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IGI_IMP_IAC_INTERFACE_DTL_V |
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
WHERE II.ASSET_ID = DH.ASSET_ID
AND II.BOOK_TYPE_CODE = DH.BOOK_TYPE_CODE
AND DH.DATE_INEFFECTIVE IS NULL
AND II.ASSET_ID = AD.ASSET_ID