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

VIEW: APPS.OKL_AP_PAYMENTS_REF_V

Object Details
Object Name: OKL_AP_PAYMENTS_REF_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_AP_PAYMENTS_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_INVOICE_DISTRIBUTION_ID NUMBER (15) Yes
OKL_KHR_ID NUMBER
Yes
TEH_CONTRACT_NUMBER VARCHAR2 (120)
TEH_CONVERTED_NUMBER VARCHAR2 (30)
TEH_CONTRACT_EFFECTIVE_FROM DATE

TEH_CONTRACT_STATUS_CODE VARCHAR2 (30)
TEH_PO_ORDER_NUMBER VARCHAR2 (150)
TCN_CONTRACT_PRODUCT_NAME VARCHAR2 (150)
TCN_BOOK_CLASSIFICATION_CODE VARCHAR2 (30)
TEH_REV_REC_METHOD_CODE VARCHAR2 (150)
TEH_INT_CALC_METHOD_CODE VARCHAR2 (150)
TCN_TAX_OWNER_CODE VARCHAR2 (150)
TEH_ASSIGNABLE_FLAG VARCHAR2 (3)
TEH_CONVERTED_ACCOUNT_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_CUSTOMER_ACCOUNT_NUMBER VARCHAR2 (30)
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)
TEH_CUSTOMER_NAME VARCHAR2 (360)
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_SALES_REP_NAME VARCHAR2 (240)
TEH_VENDOR_PROGRAM_NUMBER VARCHAR2 (120)
TEH_TRX_TYPE_CLASS_CODE VARCHAR2 (30)
TEL_ASSET_CATEGORY_NAME VARCHAR2 (250)
Contract Asset Category Name
TEL_INVENTORY_ITEM_NAME_CODE VARCHAR2 (240)
Contract Inventory Item Name
Query Text

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


SELECT OKL_INVOICE_DISTRIBUTION_ID
,      OKL_KHR_ID
,      TEH_CONTRACT_NUMBER
,      TEH_CONVERTED_NUMBER
,      TEH_CONTRACT_EFFECTIVE_FROM
,      TEH_CONTRACT_STATUS_CODE
,      TEH_PO_ORDER_NUMBER
,      TCN_CONTRACT_PRODUCT_NAME
,      TCN_BOOK_CLASSIFICATION_CODE
,      TEH_REV_REC_METHOD_CODE
,      TEH_INT_CALC_METHOD_CODE
,      TCN_TAX_OWNER_CODE
,      TEH_ASSIGNABLE_FLAG
,      TEH_CONVERTED_ACCOUNT_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_CUSTOMER_ACCOUNT_NUMBER
,      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_CUSTOMER_NAME
,      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_SALES_REP_NAME
,      TEH_VENDOR_PROGRAM_NUMBER
,      TEH_TRX_TYPE_CLASS_CODE
,      TEL_ASSET_CATEGORY_NAME
,      TEL_INVENTORY_ITEM_NAME_CODE
FROM APPS.OKL_AP_PAYMENTS_REF_V;

Dependencies

[top of page]

APPS.OKL_AP_PAYMENTS_REF_V references the following:

SchemaAPPS
SynonymAP_INVOICE_DISTRIBUTIONS_ALL
SynonymAP_INVOICE_LINES_ALL
SynonymOKL_EXT_AP_HEADER_SOURCES_B
SynonymOKL_EXT_AP_LINE_SOURCES_B
SynonymOKL_TXL_AP_INV_LNS_ALL_B

APPS.OKL_AP_PAYMENTS_REF_V is not referenced by any database object