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


VIEW: APPS.OKL_AR_RECEIPT_KHR_REF_V

Object Details
Object Name: OKL_AR_RECEIPT_KHR_REF_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_AR_RECEIPT_KHR_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_AR_RECEIPT_ID NUMBER
Yes Source Table Identifier
OKL_KHR_ID NUMBER
Yes Contract Identifier
TEH_CONTRACT_NUMBER VARCHAR2 (120)
Contract Number
TCN_CONTRACT_PRODUCT_NAME VARCHAR2 (150)
Contract Product Name
TCN_BOOK_CLASSIFICATION_CODE VARCHAR2 (30)
Contract Book Classification
TCN_TAX_OWNER_CODE VARCHAR2 (150)
Tax Owner
TEH_RENT_IA_CONTRACT_NUMBER VARCHAR2 (120)
Rent Investor Agreement Number
TEH_RES_IA_CONTRACT_NUMBER VARCHAR2 (120)
Residual Investor Agreement Number
TEH_CONVERTED_NUMBER VARCHAR2 (30)
Contract Converted Legacy Number
TEH_CONTRACT_EFFECTIVE_FROM DATE

Contract Effective From Date
TEH_CONTRACT_CURRENCY_CODE VARCHAR2 (80)
Contract Currency Code
TEH_SALES_REP_NAME VARCHAR2 (240)
Contract Sales Representative Name
TEH_RENT_IA_PRODUCT_NAME VARCHAR2 (150)
Rent Investor Agreement Product Name
TEH_RES_IA_PRODUCT_NAME VARCHAR2 (150)
Residual Investor Agreement Product Name
TEH_PO_ORDER_NUMBER VARCHAR2 (150)
Contract Purchase Order Number
TEH_VENDOR_PROGRAM_NUMBER VARCHAR2 (120)
Contract Vendor Program Number
TEH_RENT_IA_ACCOUNTING_CODE VARCHAR2 (450)
Rent Investor Agreement Accounting Code
TEH_RES_IA_ACCOUNTING_CODE VARCHAR2 (450)
Residual Investor Agreement Accounting Code
TEH_ASSIGNABLE_FLAG VARCHAR2 (3)
Contract Investor Assignable Flag
TEH_CONVERTED_ACCOUNT_FLAG VARCHAR2 (3)
Contract Converted Account
TEH_ACCRUAL_OVERRIDE_FLAG VARCHAR2 (3)
Contract Accrual Override
TCN_ATTRIBUTE_CATEGORY VARCHAR2 (90)
Contract Header Flexfield Attribute Category
TCN_ATTRIBUTE1 VARCHAR2 (450)
Contract Header Flexfield Segment 1
TCN_ATTRIBUTE2 VARCHAR2 (450)
Contract Header Flexfield Segment 2
TCN_ATTRIBUTE3 VARCHAR2 (450)
Contract Header Flexfield Segment 3
TCN_ATTRIBUTE4 VARCHAR2 (450)
Contract Header Flexfield Segment 4
TCN_ATTRIBUTE5 VARCHAR2 (450)
Contract Header Flexfield Segment 5
TCN_ATTRIBUTE6 VARCHAR2 (450)
Contract Header Flexfield Segment 6
TCN_ATTRIBUTE7 VARCHAR2 (450)
Contract Header Flexfield Segment 7
TCN_ATTRIBUTE8 VARCHAR2 (450)
Contract Header Flexfield Segment 8
TCN_ATTRIBUTE9 VARCHAR2 (450)
Contract Header Flexfield Segment 9
TCN_ATTRIBUTE10 VARCHAR2 (450)
Contract Header Flexfield Segment 10
TCN_ATTRIBUTE11 VARCHAR2 (450)
Contract Header Flexfield Segment 11
TCN_ATTRIBUTE12 VARCHAR2 (450)
Contract Header Flexfield Segment 12
TCN_ATTRIBUTE13 VARCHAR2 (450)
Contract Header Flexfield Segment 13
TCN_ATTRIBUTE14 VARCHAR2 (450)
Contract Header Flexfield Segment 14
TCN_ATTRIBUTE15 VARCHAR2 (450)
Contract Header Flexfield Segment 15
TEH_CUST_ATTRIBUTE_CATEGORY VARCHAR2 (90)
Customer Party Flexfield Attribute Category
TEH_CUST_ATTRIBUTE1 VARCHAR2 (450)
Customer Party Flexfield Segment 1
TEH_CUST_ATTRIBUTE2 VARCHAR2 (450)
Customer Party Flexfield Segment 2
TEH_CUST_ATTRIBUTE3 VARCHAR2 (450)
Customer Party Flexfield Segment 3
TEH_CUST_ATTRIBUTE4 VARCHAR2 (450)
Customer Party Flexfield Segment 4
TEH_CUST_ATTRIBUTE5 VARCHAR2 (450)
Customer Party Flexfield Segment 5
TEH_CUST_ATTRIBUTE6 VARCHAR2 (450)
Customer Party Flexfield Segment 6
TEH_CUST_ATTRIBUTE7 VARCHAR2 (450)
Customer Party Flexfield Segment 7
TEH_CUST_ATTRIBUTE8 VARCHAR2 (450)
Customer Party Flexfield Segment 8
TEH_CUST_ATTRIBUTE9 VARCHAR2 (450)
Customer Party Flexfield Segment 9
TEH_CUST_ATTRIBUTE10 VARCHAR2 (450)
Customer Party Flexfield Segment 10
TEH_CUST_ATTRIBUTE11 VARCHAR2 (450)
Customer Party Flexfield Segment 11
TEH_CUST_ATTRIBUTE12 VARCHAR2 (450)
Customer Party Flexfield Segment 12
TEH_CUST_ATTRIBUTE13 VARCHAR2 (450)
Customer Party Flexfield Segment 13
TEH_CUST_ATTRIBUTE14 VARCHAR2 (450)
Customer Party Flexfield Segment 14
TEH_CUST_ATTRIBUTE15 VARCHAR2 (450)
Customer Party Flexfield Segment 15
TEH_REV_REC_METHOD_CODE VARCHAR2 (150)
Revenue Recognition Method
TEH_INT_CALC_METHOD_CODE VARCHAR2 (150)
Interest Calculation Basis
TEH_CONTRACT_STATUS_CODE VARCHAR2 (30)
Contract Status Code
Query Text

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


SELECT OKL_AR_RECEIPT_ID
,      OKL_KHR_ID
,      TEH_CONTRACT_NUMBER
,      TCN_CONTRACT_PRODUCT_NAME
,      TCN_BOOK_CLASSIFICATION_CODE
,      TCN_TAX_OWNER_CODE
,      TEH_RENT_IA_CONTRACT_NUMBER
,      TEH_RES_IA_CONTRACT_NUMBER
,      TEH_CONVERTED_NUMBER
,      TEH_CONTRACT_EFFECTIVE_FROM
,      TEH_CONTRACT_CURRENCY_CODE
,      TEH_SALES_REP_NAME
,      TEH_RENT_IA_PRODUCT_NAME
,      TEH_RES_IA_PRODUCT_NAME
,      TEH_PO_ORDER_NUMBER
,      TEH_VENDOR_PROGRAM_NUMBER
,      TEH_RENT_IA_ACCOUNTING_CODE
,      TEH_RES_IA_ACCOUNTING_CODE
,      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
,      TEH_REV_REC_METHOD_CODE
,      TEH_INT_CALC_METHOD_CODE
,      TEH_CONTRACT_STATUS_CODE
FROM APPS.OKL_AR_RECEIPT_KHR_REF_V;

Dependencies

[top of page]

APPS.OKL_AR_RECEIPT_KHR_REF_V references the following:

SchemaAPPS
SynonymOKL_EXT_AR_HEADER_SOURCES_B

APPS.OKL_AR_RECEIPT_KHR_REF_V is not referenced by any database object