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' ... 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', 'Fa Concatenated Segments', Ecc Spec Id, Fa Rowid, Book Type Code, Book Type Name, Book Class, Org Id, Ledger Name, Currency Code, Last Deprn Run Date, Current Fiscal Year, Current Period, Calendar Period Open Date, Period Open Date, Ledger Id, Asset Id, Asset Number, Asset Type Code, Manufacturer Name, Serial Number, Model Number, Tag Number, In Use Flag, Owned Leased, New Used, Inventorial, Property Type Code, Unit Adjustment Flag, Add Cost Je Flag, Lease Id, Lessor, Lease Number, Lease Desc, Parent Asset, Category Type, Capitalize Flag, Asset Key Seg, Asset Category Seg, Major Category, Minor Category, Date Placed In Service, Month Placed In Service, Year Placed In Service, Prorate Date, Prorate Convention Code, Life In Years, Life In Month, Age In Years, Age In Months, Remaining In Year, Remaining In Months, Eofy Reserve, Prior Eofy Reserve, Employee Name, Employee Termination Date, Distribution Id, Loc Segment1, Loc Segment2, Loc Segment3, Loc Segment4, Loc Segment5, Loc Segment6, Loc Segment7, Asset Location Seg, Current Units, Transaction Type Code, Units Assigned, Original Cost, Asset Cost, Accumulated Deprn, Net Book Value, Deprn Amount, Adjustment Amount, Bonus Deprn Amount, Bonus Adjustment Amount, Reval Amortization, Total Deprn Amount, Cost Change Flag, Salvage Type, Salvage Value, Deprn Method Code, Expense Acc Ccid, Exp Acc Code, Exp Account Desc, Exp Costcenter Code, Exp Costcenter Desc, Feeder System Name, Source Line Id, Vendor Name, PO Number, Invoice Id, Invoice Number, Invoice Date, Invoice Line Number, Inv Line Desc, Payables Cost, Payables Units, Project Id, Project Name, Project Type, Project Number, Warranty Number, Warranty Desc, Warranty Cost, Warranty Start Date, Warranty End Date, Warranty Renew Flag, Warranty Vendor, Warranty Currency, Ecc Last Update Date, Context, Attribute Category Code, Attribute1, Attribute2, Attribute3, Attribute4, Attribute5, Attribute6, Attribute7, Attribute8, Attribute9, Attribute10, Attribute11, Attribute12, Attribute13, Attribute14, Attribute15, Attribute16, Attribute17, Attribute18, Attribute19, Attribute20, Attribute21, Attribute22, Attribute23, Attribute24, Attribute25, Attribute26, Attribute27, Attribute28, Attribute29, Attribute30, Us Currency, Us Asset Description, Us Parent Description, Us Property Type, Us Transaction Type, Us Asset Type, Us Year Aging Bucket, Us Month Aging Bucket

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

Copy

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

Download

Related Blitz Reports

ECC Lease Contracts, Lease Meter Errors ECC Oracle Asset Tracking, Oracle Asset Tracking: Instances IGI Inflation Accounting : Asset Revaluation Preview Detail - draft FA Journal Entry Reserve Ledger FA Asset Inventory FA Asset Additions Responsibility - draft IGI Inflation Accounting : Asset Revaluation Preview Summary - draft JL Colombian Fixed Assets Technical Appraisal Additions - draft FA Implementation Exception Report for UK Local Authority Accounting Implementation

Blitz Report In Action

Blitz Report™

Blitz Report™ provides multiple benefits:

Perfectly formatted Excel reports
Create new or ad-hoc reports in minutes
User configurable reports
Includes seeded reports for all core areas
Toolkits for tuning, management and support
Data governance and audit tracking
Central report repository & version control
Imports BI-Publisher and Discoverer reports
EBS forms interface for user adoption

Find out more

Features

Download

FAQ