ECC Assets, Fixed Assets

➜ Back to Library
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
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_dff('FA_ADDITIONS','INSURANCE_COMPANY',"INSURANCE_COMPANY",140,"CONTEXT_VALUE") "'FA_INSURANCE_COMPANY'",to_char("INSURANCE_RENEWAL_DATE")  "'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")  "'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
Download
Related Blitz Reports
ECC Assets, Fixed Assets (1) ECC Oracle Asset Tracking, Oracle Asset Tracking: Assets ECC Lease Contracts, Lease Meter Errors FA Asset Book Details GL Account Analysis (Distributions) ECC Assets, Reconciliation (1) ECC Lease Contracts, Contracts FA Tax Reserve Ledger FA Asset Inventory Report
Blitz Report™