ECC Assets, Assets

Description
Categories: Enterprise Command Center
Columns: 'Fa Row Id', 'Fa Context Value', 'Fa Insurance Company', 'Fa Insurance Renewal Date', 'Fa Building Size', 'Fa Area', 'Fa License Plate', 'Fa License Renewal Date', 'Fa Number Of Axles', 'Fa Cargo Size' ...
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
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'",INSURANCE_COMPANY "'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'" 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