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
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'",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 |
Blitz Report™