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

VIEW: APPS.OKL_TXL_EXTENSION_V

Object Details
Object Name: OKL_TXL_EXTENSION_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_TXL_EXTENSION_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
ROW_ID ROWID (10)
Row ID
LINE_EXTENSION_ID NUMBER
Yes Line Extension Id
TEH_ID NUMBER
Yes Foreign key to OKL_TRX_EXTENSION_B.HEADER_EXTENSION_ID
SOURCE_ID NUMBER
Yes
SOURCE_TABLE VARCHAR2 (30) Yes Transaction Table Name
OBJECT_VERSION_NUMBER NUMBER
Yes Object Version Number
LANGUAGE VARCHAR2 (12) Yes Language
CONTRACT_LINE_NUMBER VARCHAR2 (150)
Line Number in the Contract
FEE_TYPE_CODE VARCHAR2 (30)
ASSET_NUMBER VARCHAR2 (150)
Asset Number
ASSET_CATEGORY_NAME VARCHAR2 (250)
Asset Category Name
ASSET_VENDOR_NAME VARCHAR2 (240)
Asset Vendor Name
ASSET_MANUFACTURER_NAME VARCHAR2 (360)
Asset Manufacturer Name
ASSET_YEAR_MANUFACTURED VARCHAR2 (240)
Asset Year Manufactured
ASSET_MODEL_NUMBER VARCHAR2 (40)
Asset Model Number
ASSET_DELIVERED_DATE DATE

Asset Delivered Date
INSTALLED_SITE_ID NUMBER

Contract Asset Installed Site Id
FIXED_ASSET_LOCATION_NAME VARCHAR2 (250)
Contract Fixed Asset Location Name
CONTINGENCY_CODE VARCHAR2 (30)
Contingency Code
SUBSIDY_NAME VARCHAR2 (30)
Subsidy Name
SUBSIDY_PARTY_NAME VARCHAR2 (240)
Subsidy Party Name
MEMO_FLAG VARCHAR2 (3)
Accounting Template Memo Indicator
RECIEVABLES_TRX_TYPE_NAME VARCHAR2 (20)
Contract Receivables Transaction Type Name
CONTRACT_LINE_TYPE VARCHAR2 (30)
Contract Line Type. Non Accounting source used to distinguish the type of the Line.Possible values are ASSET/FEE/SERVICE.
PAY_SUPPLIER_SITE_NAME VARCHAR2 (250)
Contracts Payables Supplier Site Name
AGING_BUCKET_NAME VARCHAR2 (20)
Aging Bucket Name
CREATED_BY NUMBER
Yes Standard Who Columns
CREATION_DATE DATE
Yes Standard Who Columns
LAST_UPDATED_BY NUMBER
Yes Standard Who Columns
LAST_UPDATE_DATE DATE
Yes Standard Who Columns
LAST_UPDATE_LOGIN NUMBER
Yes Standard Who Columns
INVENTORY_ITEM_NAME VARCHAR2 (240)
Contract Inventory Item Name
INVENTORY_ORG_NAME VARCHAR2 (240)
Contract Inventory Organization Name
INVENTORY_ITEM_NAME_CODE VARCHAR2 (240)
Inventory Item Description Code
INVENTORY_ORG_CODE VARCHAR2 (240)
Inventory Organization Code
VENDOR_SITE_ID NUMBER

Reference to Vendor Site Id
SUBSIDY_VENDOR_ID NUMBER

Reference to Vendor Id for Subsidy
ASSET_VENDOR_ID NUMBER

Reference to Vendor Id for Asset
Query Text

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


SELECT ROW_ID
,      LINE_EXTENSION_ID
,      TEH_ID
,      SOURCE_ID
,      SOURCE_TABLE
,      OBJECT_VERSION_NUMBER
,      LANGUAGE
,      CONTRACT_LINE_NUMBER
,      FEE_TYPE_CODE
,      ASSET_NUMBER
,      ASSET_CATEGORY_NAME
,      ASSET_VENDOR_NAME
,      ASSET_MANUFACTURER_NAME
,      ASSET_YEAR_MANUFACTURED
,      ASSET_MODEL_NUMBER
,      ASSET_DELIVERED_DATE
,      INSTALLED_SITE_ID
,      FIXED_ASSET_LOCATION_NAME
,      CONTINGENCY_CODE
,      SUBSIDY_NAME
,      SUBSIDY_PARTY_NAME
,      MEMO_FLAG
,      RECIEVABLES_TRX_TYPE_NAME
,      CONTRACT_LINE_TYPE
,      PAY_SUPPLIER_SITE_NAME
,      AGING_BUCKET_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      INVENTORY_ITEM_NAME
,      INVENTORY_ORG_NAME
,      INVENTORY_ITEM_NAME_CODE
,      INVENTORY_ORG_CODE
,      VENDOR_SITE_ID
,      SUBSIDY_VENDOR_ID
,      ASSET_VENDOR_ID
FROM APPS.OKL_TXL_EXTENSION_V;

Dependencies

[top of page]

APPS.OKL_TXL_EXTENSION_V references the following:

SchemaAPPS
SynonymOKL_TXL_EXTENSION_B
SynonymOKL_TXL_EXTENSION_TL
APPS.OKL_TXL_EXTENSION_V is referenced by following:

SchemaAPPS
PL/SQL PackageOKL_TEL_PVT - show dependent code
Package BodyOKL_TEL_PVT - show dependent code