eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.OKL_FA_REF_V

Object Details

Object Name:	OKL_FA_REF_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_FA_REF_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
OKL_FA_TRANSACTION_ID	NUMBER		Yes
OKL_ASSET_ID	NUMBER		Yes
OKL_KHR_ID	NUMBER		Yes
OKL_KLE_ID	NUMBER		Yes
OKL_TRY_ID	NUMBER
TEL_ASSET_NUMBER	VARCHAR2	(150)
OKL_TAS_TRX_NUMBER	NUMBER
TEH_CONTRACT_NUMBER	VARCHAR2	(120)
TEH_CUSTOMER_NAME	VARCHAR2	(360)
TEH_CUSTOMER_ACCOUNT_NUMBER	VARCHAR2	(30)
TEH_CONVERTED_NUMBER	VARCHAR2	(30)
TEH_CONTRACT_EFFECTIVE_FROM	DATE
TEH_CONTRACT_CURRENCY_CODE	VARCHAR2	(80)
TEH_SALES_REP_NAME	VARCHAR2	(240)
TEH_PO_ORDER_NUMBER	VARCHAR2	(150)
TEH_VENDOR_PROGRAM_NUMBER	VARCHAR2	(120)
TEH_ASSIGNABLE_FLAG	VARCHAR2	(3)
TEH_CONVERTED_ACCOUNT_FLAG	VARCHAR2	(3)
TEH_ACCRUAL_OVERRIDE_FLAG	VARCHAR2	(3)
TCN_ATTRIBUTE_CATEGORY	VARCHAR2	(90)
TCN_ATTRIBUTE1	VARCHAR2	(450)
TCN_ATTRIBUTE2	VARCHAR2	(450)
TCN_ATTRIBUTE3	VARCHAR2	(450)
TCN_ATTRIBUTE4	VARCHAR2	(450)
TCN_ATTRIBUTE5	VARCHAR2	(450)
TCN_ATTRIBUTE6	VARCHAR2	(450)
TCN_ATTRIBUTE7	VARCHAR2	(450)
TCN_ATTRIBUTE8	VARCHAR2	(450)
TCN_ATTRIBUTE9	VARCHAR2	(450)
TCN_ATTRIBUTE10	VARCHAR2	(450)
TCN_ATTRIBUTE11	VARCHAR2	(450)
TCN_ATTRIBUTE12	VARCHAR2	(450)
TCN_ATTRIBUTE13	VARCHAR2	(450)
TCN_ATTRIBUTE14	VARCHAR2	(450)
TCN_ATTRIBUTE15	VARCHAR2	(450)
TEH_CUST_ATTRIBUTE_CATEGORY	VARCHAR2	(90)
TEH_CUST_ATTRIBUTE1	VARCHAR2	(450)
TEH_CUST_ATTRIBUTE2	VARCHAR2	(450)
TEH_CUST_ATTRIBUTE3	VARCHAR2	(450)
TEH_CUST_ATTRIBUTE4	VARCHAR2	(450)
TEH_CUST_ATTRIBUTE5	VARCHAR2	(450)
TEH_CUST_ATTRIBUTE6	VARCHAR2	(450)
TEH_CUST_ATTRIBUTE7	VARCHAR2	(450)
TEH_CUST_ATTRIBUTE8	VARCHAR2	(450)
TEH_CUST_ATTRIBUTE9	VARCHAR2	(450)
TEH_CUST_ATTRIBUTE10	VARCHAR2	(450)
TEH_CUST_ATTRIBUTE11	VARCHAR2	(450)
TEH_CUST_ATTRIBUTE12	VARCHAR2	(450)
TEH_CUST_ATTRIBUTE13	VARCHAR2	(450)
TEH_CUST_ATTRIBUTE14	VARCHAR2	(450)
TEH_CUST_ATTRIBUTE15	VARCHAR2	(450)
TCN_CONTRACT_PRODUCT_NAME	VARCHAR2	(150)
TCN_BOOK_CLASSIFICATION_CODE	VARCHAR2	(30)
TCN_TAX_OWNER_CODE	VARCHAR2	(150)
TEH_INT_CALC_METHOD_CODE	VARCHAR2	(150)
TEH_REV_REC_METHOD_CODE	VARCHAR2	(150)
TEL_CONTRACT_LINE_NUMBER	VARCHAR2	(150)
OKL_ASSET_BOOK_TYPE_NAME	VARCHAR2	(30)
TEL_ASSET_VENDOR_NAME	VARCHAR2	(240)
TEL_INSTALLED_SITE_ID	NUMBER
TCL_ASSET_ATTRIBUTE_CATEGORY	VARCHAR2	(90)
TCL_ASSET_ATTRIBUTE1	VARCHAR2	(450)
TCL_ASSET_ATTRIBUTE2	VARCHAR2	(450)
TCL_ASSET_ATTRIBUTE3	VARCHAR2	(450)
TCL_ASSET_ATTRIBUTE4	VARCHAR2	(450)
TCL_ASSET_ATTRIBUTE5	VARCHAR2	(450)
TCL_ASSET_ATTRIBUTE6	VARCHAR2	(450)
TCL_ASSET_ATTRIBUTE7	VARCHAR2	(450)
TCL_ASSET_ATTRIBUTE8	VARCHAR2	(450)
TCL_ASSET_ATTRIBUTE9	VARCHAR2	(450)
TCL_ASSET_ATTRIBUTE10	VARCHAR2	(450)
TCL_ASSET_ATTRIBUTE11	VARCHAR2	(450)
TCL_ASSET_ATTRIBUTE12	VARCHAR2	(450)
TCL_ASSET_ATTRIBUTE13	VARCHAR2	(450)
TCL_ASSET_ATTRIBUTE14	VARCHAR2	(450)
TCL_ASSET_ATTRIBUTE15	VARCHAR2	(450)
TEH_RENT_IA_CONTRACT_NUMBER	VARCHAR2	(120)
TEH_RENT_IA_PRODUCT_NAME	VARCHAR2	(150)
TEH_RENT_IA_ACCOUNTING_CODE	VARCHAR2	(450)
TEH_RES_IA_CONTRACT_NUMBER	VARCHAR2	(120)
TEH_RES_IA_PRODUCT_NAME	VARCHAR2	(150)
TEH_RES_IA_ACCOUNTING_CODE	VARCHAR2	(450)
TEH_CONTRACT_STATUS_CODE	VARCHAR2	(90)
TEH_TRX_TYPE_CLASS_CODE	VARCHAR2	(90)
TEL_INVENTORY_ORG_CODE	VARCHAR2	(240)
TEH_TERM_QUOTE_ACCEPT_DATE	DATE
TEH_TERM_QUOTE_NUM	NUMBER
TEH_TERM_QUOTE_TYPE_CODE	VARCHAR2	(30)
OKL_REPOSSESS_FLAG	VARCHAR2	(1)
TEL_INVENTORY_ITEM_NAME_CODE	VARCHAR2	(240)

Query Text

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


SELECT OKL_FA_TRANSACTION_ID
,      OKL_ASSET_ID
,      OKL_KHR_ID
,      OKL_KLE_ID
,      OKL_TRY_ID
,      TEL_ASSET_NUMBER
,      OKL_TAS_TRX_NUMBER
,      TEH_CONTRACT_NUMBER
,      TEH_CUSTOMER_NAME
,      TEH_CUSTOMER_ACCOUNT_NUMBER
,      TEH_CONVERTED_NUMBER
,      TEH_CONTRACT_EFFECTIVE_FROM
,      TEH_CONTRACT_CURRENCY_CODE
,      TEH_SALES_REP_NAME
,      TEH_PO_ORDER_NUMBER
,      TEH_VENDOR_PROGRAM_NUMBER
,      TEH_ASSIGNABLE_FLAG
,      TEH_CONVERTED_ACCOUNT_FLAG
,      TEH_ACCRUAL_OVERRIDE_FLAG
,      TCN_ATTRIBUTE_CATEGORY
,      TCN_ATTRIBUTE1
,      TCN_ATTRIBUTE2
,      TCN_ATTRIBUTE3
,      TCN_ATTRIBUTE4
,      TCN_ATTRIBUTE5
,      TCN_ATTRIBUTE6
,      TCN_ATTRIBUTE7
,      TCN_ATTRIBUTE8
,      TCN_ATTRIBUTE9
,      TCN_ATTRIBUTE10
,      TCN_ATTRIBUTE11
,      TCN_ATTRIBUTE12
,      TCN_ATTRIBUTE13
,      TCN_ATTRIBUTE14
,      TCN_ATTRIBUTE15
,      TEH_CUST_ATTRIBUTE_CATEGORY
,      TEH_CUST_ATTRIBUTE1
,      TEH_CUST_ATTRIBUTE2
,      TEH_CUST_ATTRIBUTE3
,      TEH_CUST_ATTRIBUTE4
,      TEH_CUST_ATTRIBUTE5
,      TEH_CUST_ATTRIBUTE6
,      TEH_CUST_ATTRIBUTE7
,      TEH_CUST_ATTRIBUTE8
,      TEH_CUST_ATTRIBUTE9
,      TEH_CUST_ATTRIBUTE10
,      TEH_CUST_ATTRIBUTE11
,      TEH_CUST_ATTRIBUTE12
,      TEH_CUST_ATTRIBUTE13
,      TEH_CUST_ATTRIBUTE14
,      TEH_CUST_ATTRIBUTE15
,      TCN_CONTRACT_PRODUCT_NAME
,      TCN_BOOK_CLASSIFICATION_CODE
,      TCN_TAX_OWNER_CODE
,      TEH_INT_CALC_METHOD_CODE
,      TEH_REV_REC_METHOD_CODE
,      TEL_CONTRACT_LINE_NUMBER
,      OKL_ASSET_BOOK_TYPE_NAME
,      TEL_ASSET_VENDOR_NAME
,      TEL_INSTALLED_SITE_ID
,      TCL_ASSET_ATTRIBUTE_CATEGORY
,      TCL_ASSET_ATTRIBUTE1
,      TCL_ASSET_ATTRIBUTE2
,      TCL_ASSET_ATTRIBUTE3
,      TCL_ASSET_ATTRIBUTE4
,      TCL_ASSET_ATTRIBUTE5
,      TCL_ASSET_ATTRIBUTE6
,      TCL_ASSET_ATTRIBUTE7
,      TCL_ASSET_ATTRIBUTE8
,      TCL_ASSET_ATTRIBUTE9
,      TCL_ASSET_ATTRIBUTE10
,      TCL_ASSET_ATTRIBUTE11
,      TCL_ASSET_ATTRIBUTE12
,      TCL_ASSET_ATTRIBUTE13
,      TCL_ASSET_ATTRIBUTE14
,      TCL_ASSET_ATTRIBUTE15
,      TEH_RENT_IA_CONTRACT_NUMBER
,      TEH_RENT_IA_PRODUCT_NAME
,      TEH_RENT_IA_ACCOUNTING_CODE
,      TEH_RES_IA_CONTRACT_NUMBER
,      TEH_RES_IA_PRODUCT_NAME
,      TEH_RES_IA_ACCOUNTING_CODE
,      TEH_CONTRACT_STATUS_CODE
,      TEH_TRX_TYPE_CLASS_CODE
,      TEL_INVENTORY_ORG_CODE
,      TEH_TERM_QUOTE_ACCEPT_DATE
,      TEH_TERM_QUOTE_NUM
,      TEH_TERM_QUOTE_TYPE_CODE
,      OKL_REPOSSESS_FLAG
,      TEL_INVENTORY_ITEM_NAME_CODE
FROM APPS.OKL_FA_REF_V;

Dependencies

[top of page]

APPS.OKL_FA_REF_V references the following:

APPS: OKL_EXT_FA_HEADER_SOURCES_B; OKL_EXT_FA_LINE_SOURCES_B

APPS.OKL_FA_REF_V is not referenced by any database object