ECC Assets, Fixed Assets (1)

➜ 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

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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 ECC Oracle Asset Tracking, Oracle Asset Tracking: Assets ECC Lease Contracts, Lease Meter Errors FA Asset Book Details GL Account Analysis (Distributions) ECC Lease Contracts, Contracts FA Tax Reserve Ledger FA Asset Additions Responsibility Report- Not Supported: Reserved For Future Use FA Asset Inventory Report
Blitz Report™

Blitz Report™ provides multiple benefits: