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


VIEW: APPS.OKL_FA_DEP_REF_V

Object Details
Object Name: OKL_FA_DEP_REF_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_FA_DEP_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 Comments
OKL_DEPRN_RUN_ID NUMBER
Yes
OKL_ASSET_BOOK_TYPE_CODE VARCHAR2 (240)
OKL_PERIOD_COUNTER NUMBER

OKL_ASSET_ID NUMBER
Yes
OKL_KHR_ID NUMBER
Yes
OKL_KLE_ID NUMBER
Yes
TEL_ASSET_NUMBER VARCHAR2 (150)
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)
TEL_INVENTORY_ORG_CODE VARCHAR2 (240)
Query Text

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


SELECT OKL_DEPRN_RUN_ID
,      OKL_ASSET_BOOK_TYPE_CODE
,      OKL_PERIOD_COUNTER
,      OKL_ASSET_ID
,      OKL_KHR_ID
,      OKL_KLE_ID
,      TEL_ASSET_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
,      TEL_INVENTORY_ORG_CODE
FROM APPS.OKL_FA_DEP_REF_V;

Dependencies

[top of page]

APPS.OKL_FA_DEP_REF_V references the following:

SchemaAPPS
SynonymOKL_EXT_FA_HEADER_SOURCES_B
SynonymOKL_EXT_FA_LINE_SOURCES_B

APPS.OKL_FA_DEP_REF_V is not referenced by any database object