[Home] [Help] [Dependency Information]
Object Name: | OKL_AR_RECEIPT_KHR_REF_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_AR_RECEIPT_KHR_REF_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
APPS.OKL_AR_RECEIPT_KHR_REF_V is not referenced by any database object
|
|
|