ECC Assets, Assets

Description
Categories: Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: fa-asset
Query Procedure: FA_ECC_UTIL_PVT.GET_ECC_DATA_LOAD_INFO
Security Procedure: FA_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues
Run ECC Assets, Assets and other Oracle EBS reports with Blitz Report™ on our demo environment
select
x.*
from
(
select * from ((SELECT dfv.*, trx_v.* FROM FA_ECC_F_ASSET_V trx_v  , (select ROW_ID "'FA_ROW_ID'",CONTEXT_VALUE "'FA_CONTEXT_VALUE'",FND_ECC_DFF_UTIL.get_vset_values('FA_ADDITIONS','INSURANCE_COMPANY',INSURANCE_COMPANY, NULL ,NULL,140) "'FA_INSURANCE_COMPANY'",to_char(INSURANCE_RENEWAL_DATE, 'yyyy-mm-dd')  "'FA_INSURANCE_RENEWAL_DATE'",to_char(BUILDING_SIZE) "'FA_BUILDING_SIZE'",to_char(AREA) "'FA_AREA'",LICENSE_PLATE "'FA_LICENSE_PLATE'",to_char(LICENSE_RENEWAL_DATE, 'yyyy-mm-dd')  "'FA_LICENSE_RENEWAL_DATE'",NUMBER_OF_AXLES "'FA_NUMBER_OF_AXLES'",to_char(CARGO_SIZE) "'FA_CARGO_SIZE'",CONCATENATED_SEGMENTS "'FA_CONCATENATED_SEGMENTS'",INSURANCE_COMPANY "'FA_INSURANCE_COMPANY_EDOC'" from FA_ADDITIONS_B_DFV) dfv WHERE trx_v.language in ('US')  AND trx_v.fa_rowid = dfv."'FA_ROW_ID'"(+) )
                                       PIVOT (max(CURRENCY) as CURRENCY,
                                              max(ASSET_DESCRIPTION) as ASSET_DESCRIPTION,
                                              max(PARENT_DESCRIPTION) as PARENT_DESCRIPTION,
                                              max(PROPERTY_TYPE) as PROPERTY_TYPE,
                                              max(TRANSACTION_TYPE) as TRANSACTION_TYPE,
                                              max(ASSET_TYPE) as ASSET_TYPE,
                                              MAX(YEAR_AGING_BUCKET) AS YEAR_AGING_BUCKET,
                                              MAX(MONTH_AGING_BUCKET) AS MONTH_AGING_BUCKET
                                       for LANGUAGE in ('US' "US")))
) x
where
2=2