DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKL_TXL_ASSETS_V

Object Details
Object Name: OKL_TXL_ASSETS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_TXL_ASSETS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


A contract line level transaction table to record various asset attributes needed by Fixed Asset module before activating the contract.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Auto-generated by Headstart Utilities
ID NUMBER
Yes Primary key column
OBJECT_VERSION_NUMBER NUMBER (9) Yes Column used for locking records during updates
SFWT_FLAG VARCHAR2 (3) Yes Column used by the translation batch program
TAS_ID NUMBER
Yes Foreign key to table OKL_TRX_ASSETS
ILO_ID NUMBER

Foreign Key to view OKX_AST_LOCS_V.ID1( first part of the Primary key)
ILO_ID_OLD NUMBER

Foreign Key to view OKX_AST_LOCS_V.ID1( first part of the Primary key)
IAY_ID NUMBER

Foreign Key to view OKX_ASST_CATGRS_V.ID1( first part of the Primary key)
IAY_ID_NEW NUMBER

Foreign Key to view OKX_ASST_CATGRS_V.ID1( first part of the Primary key)
KLE_ID NUMBER

Foreign key to table OKL_K_LINES
DNZ_KHR_ID NUMBER

Foreign Key to table OKC_K_LINES_V.DNZ_CHR_ID for Fixed asset line style.
LINE_NUMBER NUMBER
Yes Line number
ORG_ID NUMBER

Operating unit identifier
TAL_TYPE VARCHAR2 (10) Yes Foreign Key to table FND_LOOKUPS.LOOKUP_CODE for Lookup Type 'OKL_TRANS_LINE_TYPE
ASSET_NUMBER VARCHAR2 (15) Yes Asset number
DESCRIPTION VARCHAR2 (1995)
User entered description
FA_LOCATION_ID NUMBER

Fixed asset Location id
ORIGINAL_COST NUMBER
Yes Original cost of the asset
CURRENT_UNITS NUMBER
Yes Current number of units for the asset
MANUFACTURER_NAME VARCHAR2 (360)
Manufacture Name
YEAR_MANUFACTURED NUMBER

Year Manufactured
SUPPLIER_ID NUMBER

Foreign Key to view OKX_VENDORS_V.ID1( first part of the Primary key) and will be populated for equipment exchange tal_type(typically OAS and NAS)
USED_ASSET_YN VARCHAR2 (3)
Indicates whether asset is new or used, typical values are null for new and 'Y' for used
TAG_NUMBER VARCHAR2 (40)
Tag number of the asset
MODEL_NUMBER VARCHAR2 (40)
Model number of the asset
CORPORATE_BOOK VARCHAR2 (70)
Corporate Book
DATE_PURCHASED DATE

Not used
DATE_DELIVERY DATE

Not used
IN_SERVICE_DATE DATE

Date the asset was placed in service
LIFE_IN_MONTHS NUMBER (15)
Life of asset in total months
DEPRECIATION_ID NUMBER (15)
Foreign Key to view OKX_ASST_CATGRS_V .ID1( first part of the Primary key)
DEPRECIATION_COST NUMBER

Depreciation cost of the asset and at the transaction at line level will be equal to Original cost of the asset
DEPRN_METHOD VARCHAR2 (12)
Name of the depreciation method for the asset
DEPRN_RATE NUMBER

Effective depreciation rate for Flate rate methods
SALVAGE_VALUE NUMBER (14)
Asset salvage value
PERCENT_SALVAGE_VALUE NUMBER

Salvage value percentage amount
ATTRIBUTE_CATEGORY VARCHAR2 (90)
Descriptive flexfield category column
ATTRIBUTE1 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE2 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE3 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE4 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE5 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE6 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE7 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE8 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE9 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE10 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE11 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE12 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE13 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE14 VARCHAR2 (450)
Descriptive flexfield column
ATTRIBUTE15 VARCHAR2 (450)
Descriptive flexfield column
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
DEPRECIATE_YN VARCHAR2 (3)
Flag to indicate whether depreciation will be started/stopped in Fixed Asset
HOLD_PERIOD_DAYS NUMBER

The number of days the transaction will be held.
OLD_SALVAGE_VALUE NUMBER (14)
The old salvage value in a salvage value writedown transaction.
NEW_RESIDUAL_VALUE NUMBER (14)
The new residual value in a residual value writedown transaction.
OLD_RESIDUAL_VALUE NUMBER (14)
The old residual value in a residual value writedown transaction.
UNITS_RETIRED NUMBER

The number of units posted to Fixed Assets for retirement.
COST_RETIRED NUMBER (14)
The cost posted to Fixed Assets for retirement.
SALE_PROCEEDS NUMBER (14)
The sale proceeds posted to Fixed Assets for retirement.
REMOVAL_COST NUMBER (14)
The costs incurred while scrapping an Asset and retiring in Fixed Assets
DNZ_ASSET_ID NUMBER (15)
A denormalized key to the Fixed Asset ID.
DATE_DUE DATE

Cut off date when the equipment exchange is due
REP_ASSET_ID NUMBER

Like Kind Exchange Replacement Asset Id
LKE_ASSET_ID NUMBER

Like kind Exchange Asset Id
MATCH_AMOUNT NUMBER

Like Kind exchange Match Amount
SPLIT_INTO_SINGLES_FLAG VARCHAR2 (3)
Split Assets Will be 'Y' if asset has to be split into single units of qty 1 each.
SPLIT_INTO_UNITS NUMBER

Split Asset - Number of units to be split into
CURRENCY_CODE VARCHAR2 (15)
Currency code
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency conversion type
CURRENCY_CONVERSION_RATE NUMBER

Currency conversion rate
CURRENCY_CONVERSION_DATE DATE

Currency conversion date
ASSET_KEY_ID NUMBER

Asset key code combination identifier
FA_TRX_DATE DATE

Oracle Fixed Asset transaction date corresponding to this Lease management transactions
RESIDUAL_SHR_PARTY_ID NUMBER

Residual Share Party ID
RESIDUAL_SHR_AMOUNT NUMBER

Residual Share Amount
RETIREMENT_ID NUMBER

Retirement ID
FA_COST NUMBER

Fixed asset depreciable cost
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      ID
,      OBJECT_VERSION_NUMBER
,      SFWT_FLAG
,      TAS_ID
,      ILO_ID
,      ILO_ID_OLD
,      IAY_ID
,      IAY_ID_NEW
,      KLE_ID
,      DNZ_KHR_ID
,      LINE_NUMBER
,      ORG_ID
,      TAL_TYPE
,      ASSET_NUMBER
,      DESCRIPTION
,      FA_LOCATION_ID
,      ORIGINAL_COST
,      CURRENT_UNITS
,      MANUFACTURER_NAME
,      YEAR_MANUFACTURED
,      SUPPLIER_ID
,      USED_ASSET_YN
,      TAG_NUMBER
,      MODEL_NUMBER
,      CORPORATE_BOOK
,      DATE_PURCHASED
,      DATE_DELIVERY
,      IN_SERVICE_DATE
,      LIFE_IN_MONTHS
,      DEPRECIATION_ID
,      DEPRECIATION_COST
,      DEPRN_METHOD
,      DEPRN_RATE
,      SALVAGE_VALUE
,      PERCENT_SALVAGE_VALUE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DEPRECIATE_YN
,      HOLD_PERIOD_DAYS
,      OLD_SALVAGE_VALUE
,      NEW_RESIDUAL_VALUE
,      OLD_RESIDUAL_VALUE
,      UNITS_RETIRED
,      COST_RETIRED
,      SALE_PROCEEDS
,      REMOVAL_COST
,      DNZ_ASSET_ID
,      DATE_DUE
,      REP_ASSET_ID
,      LKE_ASSET_ID
,      MATCH_AMOUNT
,      SPLIT_INTO_SINGLES_FLAG
,      SPLIT_INTO_UNITS
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      ASSET_KEY_ID
,      FA_TRX_DATE
,      RESIDUAL_SHR_PARTY_ID
,      RESIDUAL_SHR_AMOUNT
,      RETIREMENT_ID
,      FA_COST
FROM APPS.OKL_TXL_ASSETS_V;

Dependencies

[top of page]

APPS.OKL_TXL_ASSETS_V references the following:

SchemaAPPS
SynonymOKL_TXL_ASSETS_B
SynonymOKL_TXL_ASSETS_TL
APPS.OKL_TXL_ASSETS_V is referenced by following:

SchemaAPPS
Package BodyOKL_ACTIVATE_ASSET_PVT - show dependent code
Package BodyOKL_AM_AMORTIZE_PVT - show dependent code
PL/SQL PackageOKL_AM_AMORTIZE_PVT - show dependent code
Package BodyOKL_AM_ASSET_DISPOSE_PVT - show dependent code
Package BodyOKL_AM_ASSET_RELOCATION_PVT - show dependent code
Package BodyOKL_AM_PROCESS_RV_TRX_PVT - show dependent code
Package BodyOKL_AM_RV_WRITEDOWN_PVT - show dependent code
Package BodyOKL_AM_SV_WRITEDOWN_PVT - show dependent code
Package BodyOKL_AM_TERMNT_QUOTE_PVT - show dependent code
Package BodyOKL_ASD_PVT - show dependent code
PL/SQL PackageOKL_ASD_PVT - show dependent code
Package BodyOKL_CONTRACT_PVT - show dependent code
Package BodyOKL_COPY_ASSET_PVT - show dependent code
Package BodyOKL_COPY_CONTRACT_PVT - show dependent code
PL/SQL PackageOKL_CREATE_KLE_PUB - show dependent code
Package BodyOKL_CREATE_KLE_PUB - show dependent code
PL/SQL PackageOKL_CREATE_KLE_PVT - show dependent code
Package BodyOKL_CREATE_KLE_PVT - show dependent code
Package BodyOKL_EQUIPMENT_EXCHANGE_PVT - show dependent code
Package BodyOKL_ITI_PVT - show dependent code
Package BodyOKL_LIKE_KIND_EXCHANGE_PVT - show dependent code
Package BodyOKL_MAINTAIN_CONTRACT_PVT - show dependent code
Package BodyOKL_OPEN_INTERFACE_PVT - show dependent code
Package BodyOKL_RELEASE_PVT - show dependent code
Package BodyOKL_SPLIT_ASSET_PVT - show dependent code
Package BodyOKL_SSC_WF - show dependent code
Package BodyOKL_TAL_PVT - show dependent code
PL/SQL PackageOKL_TAL_PVT - show dependent code
Package BodyOKL_TXD_ASSETS_PVT - show dependent code
Package BodyOKL_TXL_ASSETS_PVT - show dependent code