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

VIEW: APPS.OKL_ASSET_EXTRACT_LINE_V

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

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
TCL_ID NUMBER
Yes Primary key column
TEL_ASSET_CATEGORY_NAME VARCHAR2 (250)
Asset Category Name
TEL_ASSET_DELIVERED_DATE DATE

Asset Delivered Date
TEL_ASSET_MANUFACTURER_NAME VARCHAR2 (360)
Asset Manufacturer Name
TEL_ASSET_MODEL_NUMBER VARCHAR2 (40)
Asset Model Number
TEL_ASSET_NUMBER VARCHAR2 (150)
Asset Number
TEL_ASSET_VENDOR_NAME VARCHAR2 (240)
Asset Vendor Name
TEL_ASSET_YEAR_MANUFACTURED VARCHAR2 (240)
Asset Year Manufactured
TEL_FIXED_ASSET_LOCATION_NAME VARCHAR2 (250)
Contract Fixed Asset Location Name
TEL_INSTALLED_SITE_ID NUMBER

Contract Asset Installed Site Id
TEL_INVENTORY_ITEM_NAME_CODE VARCHAR2 (240)
Inventory Item Description Code
Query Text

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


SELECT TCL_ID
,      TEL_ASSET_CATEGORY_NAME
,      TEL_ASSET_DELIVERED_DATE
,      TEL_ASSET_MANUFACTURER_NAME
,      TEL_ASSET_MODEL_NUMBER
,      TEL_ASSET_NUMBER
,      TEL_ASSET_VENDOR_NAME
,      TEL_ASSET_YEAR_MANUFACTURED
,      TEL_FIXED_ASSET_LOCATION_NAME
,      TEL_INSTALLED_SITE_ID
,      TEL_INVENTORY_ITEM_NAME_CODE
FROM APPS.OKL_ASSET_EXTRACT_LINE_V;

Dependencies

[top of page]

APPS.OKL_ASSET_EXTRACT_LINE_V references the following:

SchemaAPPS
SynonymOKL_TXL_CNTRCT_LNS_ALL
SynonymOKL_TXL_EXTENSION_B

APPS.OKL_ASSET_EXTRACT_LINE_V is not referenced by any database object