[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKL_AR_CM_APP_KHR_REF_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| OKL_TXD_ID | NUMBER | Yes | ||
| OKL_KHR_ID | NUMBER | Yes | ||
| OKL_KLE_ID | NUMBER | |||
| OKL_TRY_ID | NUMBER | |||
| TCL_STY_ID | NUMBER | |||
| CM_TCN_TRX_NUMBER | VARCHAR2 | (240) | ||
| CM_TEH_CONTRACT_NUMBER | VARCHAR2 | (120) | ||
| CM_CONTRACT_PRODUCT_NAME | VARCHAR2 | (150) | ||
| CM_BOOK_CLASSIFICATION_CODE | VARCHAR2 | (30) | ||
| CM_TCN_TAX_OWNER_CODE | VARCHAR2 | (150) | ||
| CM_RENT_IA_CONTRACT_NUMBER | VARCHAR2 | (120) | ||
| CM_RES_IA_CONTRACT_NUMBER | VARCHAR2 | (120) | ||
| CM_TEH_CONVERTED_NUMBER | VARCHAR2 | (30) | ||
| CM_TEH_CONTRACT_EFFECTIVE_FROM | DATE | |||
| CM_TEH_CONTRACT_CURRENCY_CODE | VARCHAR2 | (80) | ||
| CM_TEH_SALES_REP_NAME | VARCHAR2 | (240) | ||
| CM_TEH_RENT_IA_PRODUCT_NAME | VARCHAR2 | (150) | ||
| CM_TEH_RES_IA_PRODUCT_NAME | VARCHAR2 | (150) | ||
| CM_TEH_PO_ORDER_NUMBER | VARCHAR2 | (150) | ||
| CM_TEH_VENDOR_PROGRAM_NUMBER | VARCHAR2 | (120) | ||
| CM_TEH_RENT_IA_ACCOUNTING_CODE | VARCHAR2 | (450) | ||
| CM_TEH_RES_IA_ACCOUNTING_CODE | VARCHAR2 | (450) | ||
| CM_TEH_ASSIGNABLE_FLAG | VARCHAR2 | (3) | ||
| CM_TEH_CONVERTED_ACCOUNT_FLAG | VARCHAR2 | (3) | ||
| CM_TEH_ACCRUAL_OVERRIDE_FLAG | VARCHAR2 | (3) | ||
| CM_TEH_TERM_QUOTE_ACCEPT_DATE | DATE | |||
| CM_TEH_TERM_QUOTE_NUM | NUMBER | |||
| CM_TEH_TERM_QUOTE_TYPE_CODE | VARCHAR2 | (30) | ||
| CM_TCN_ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | ||
| CM_TCN_ATTRIBUTE1 | VARCHAR2 | (450) | ||
| CM_TCN_ATTRIBUTE2 | VARCHAR2 | (450) | ||
| CM_TCN_ATTRIBUTE3 | VARCHAR2 | (450) | ||
| CM_TCN_ATTRIBUTE4 | VARCHAR2 | (450) | ||
| CM_TCN_ATTRIBUTE5 | VARCHAR2 | (450) | ||
| CM_TCN_ATTRIBUTE6 | VARCHAR2 | (450) | ||
| CM_TCN_ATTRIBUTE7 | VARCHAR2 | (450) | ||
| CM_TCN_ATTRIBUTE8 | VARCHAR2 | (450) | ||
| CM_TCN_ATTRIBUTE9 | VARCHAR2 | (450) | ||
| CM_TCN_ATTRIBUTE10 | VARCHAR2 | (450) | ||
| CM_TCN_ATTRIBUTE11 | VARCHAR2 | (450) | ||
| CM_TCN_ATTRIBUTE12 | VARCHAR2 | (450) | ||
| CM_TCN_ATTRIBUTE13 | VARCHAR2 | (450) | ||
| CM_TCN_ATTRIBUTE14 | VARCHAR2 | (450) | ||
| CM_TCN_ATTRIBUTE15 | VARCHAR2 | (450) | ||
| CM_CUST_ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | ||
| CM_TEH_CUST_ATTRIBUTE1 | VARCHAR2 | (450) | ||
| CM_TEH_CUST_ATTRIBUTE2 | VARCHAR2 | (450) | ||
| CM_TEH_CUST_ATTRIBUTE3 | VARCHAR2 | (450) | ||
| CM_TEH_CUST_ATTRIBUTE4 | VARCHAR2 | (450) | ||
| CM_TEH_CUST_ATTRIBUTE5 | VARCHAR2 | (450) | ||
| CM_TEH_CUST_ATTRIBUTE6 | VARCHAR2 | (450) | ||
| CM_TEH_CUST_ATTRIBUTE7 | VARCHAR2 | (450) | ||
| CM_TEH_CUST_ATTRIBUTE8 | VARCHAR2 | (450) | ||
| CM_TEH_CUST_ATTRIBUTE9 | VARCHAR2 | (450) | ||
| CM_TEH_CUST_ATTRIBUTE10 | VARCHAR2 | (450) | ||
| CM_TEH_CUST_ATTRIBUTE11 | VARCHAR2 | (450) | ||
| CM_TEH_CUST_ATTRIBUTE12 | VARCHAR2 | (450) | ||
| CM_TEH_CUST_ATTRIBUTE13 | VARCHAR2 | (450) | ||
| CM_TEH_CUST_ATTRIBUTE14 | VARCHAR2 | (450) | ||
| CM_TEH_CUST_ATTRIBUTE15 | VARCHAR2 | (450) | ||
| CM_TEH_REV_REC_METHOD_CODE | VARCHAR2 | (150) | ||
| CM_TEH_INT_CALC_METHOD_CODE | VARCHAR2 | (150) | ||
| CM_TEL_ASSET_NUMBER | VARCHAR2 | (150) | ||
| CM_TEL_CONTRACT_LINE_NUMBER | VARCHAR2 | (150) | ||
| CM_TEL_ASSET_VENDOR_NAME | VARCHAR2 | (240) | ||
| CM_TEL_INSTALLED_SITE_ID | NUMBER | |||
| CM_FIXED_ASSET_LOCATION_NAME | VARCHAR2 | (250) | ||
| CM_TEL_MEMO_FLAG | VARCHAR2 | (3) | ||
| CM_OKL_SUBSIDY_NAME | VARCHAR2 | (30) | ||
| CM_OKL_SUBSIDY_PARTY_NAME | VARCHAR2 | (240) | ||
| CM_DIST_ACC_TEMPLATE_NAME | VARCHAR2 | (150) | ||
| CM_OKL_CONTINGENCY_CODE | VARCHAR2 | (80) | ||
| CM_TEL_FEE_TYPE_CODE | VARCHAR2 | (30) | ||
| CM_OKL_KHR_LINE_TYPE | VARCHAR2 | (30) | ||
| CM_ASSET_ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | ||
| CM_TCL_ASSET_ATTRIBUTE1 | VARCHAR2 | (450) | ||
| CM_TCL_ASSET_ATTRIBUTE2 | VARCHAR2 | (450) | ||
| CM_TCL_ASSET_ATTRIBUTE3 | VARCHAR2 | (450) | ||
| CM_TCL_ASSET_ATTRIBUTE4 | VARCHAR2 | (450) | ||
| CM_TCL_ASSET_ATTRIBUTE5 | VARCHAR2 | (450) | ||
| CM_TCL_ASSET_ATTRIBUTE6 | VARCHAR2 | (450) | ||
| CM_TCL_ASSET_ATTRIBUTE7 | VARCHAR2 | (450) | ||
| CM_TCL_ASSET_ATTRIBUTE8 | VARCHAR2 | (450) | ||
| CM_TCL_ASSET_ATTRIBUTE9 | VARCHAR2 | (450) | ||
| CM_TCL_ASSET_ATTRIBUTE10 | VARCHAR2 | (450) | ||
| CM_TCL_ASSET_ATTRIBUTE11 | VARCHAR2 | (450) | ||
| CM_TCL_ASSET_ATTRIBUTE12 | VARCHAR2 | (450) | ||
| CM_TCL_ASSET_ATTRIBUTE13 | VARCHAR2 | (450) | ||
| CM_TCL_ASSET_ATTRIBUTE14 | VARCHAR2 | (450) | ||
| CM_TCL_ASSET_ATTRIBUTE15 | VARCHAR2 | (450) | ||
| CM_TCL_FEE_ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | ||
| CM_TCL_FEE_ATTRIBUTE1 | VARCHAR2 | (450) | ||
| CM_TCL_FEE_ATTRIBUTE2 | VARCHAR2 | (450) | ||
| CM_TCL_FEE_ATTRIBUTE3 | VARCHAR2 | (450) | ||
| CM_TCL_FEE_ATTRIBUTE4 | VARCHAR2 | (450) | ||
| CM_TCL_FEE_ATTRIBUTE5 | VARCHAR2 | (450) | ||
| CM_TCL_FEE_ATTRIBUTE6 | VARCHAR2 | (450) | ||
| CM_TCL_FEE_ATTRIBUTE7 | VARCHAR2 | (450) | ||
| CM_TCL_FEE_ATTRIBUTE8 | VARCHAR2 | (450) | ||
| CM_TCL_FEE_ATTRIBUTE9 | VARCHAR2 | (450) | ||
| CM_TCL_FEE_ATTRIBUTE10 | VARCHAR2 | (450) | ||
| CM_TCL_FEE_ATTRIBUTE11 | VARCHAR2 | (450) | ||
| CM_TCL_FEE_ATTRIBUTE12 | VARCHAR2 | (450) | ||
| CM_TCL_FEE_ATTRIBUTE13 | VARCHAR2 | (450) | ||
| CM_TCL_FEE_ATTRIBUTE14 | VARCHAR2 | (450) | ||
| CM_TCL_FEE_ATTRIBUTE15 | VARCHAR2 | (450) | ||
| CM_SERVICE_ATTRIBUTE_CATEGORY | VARCHAR2 | (90) | ||
| CM_TCL_SERVICE_ATTRIBUTE1 | VARCHAR2 | (450) | ||
| CM_TCL_SERVICE_ATTRIBUTE2 | VARCHAR2 | (450) | ||
| CM_TCL_SERVICE_ATTRIBUTE3 | VARCHAR2 | (450) | ||
| CM_TCL_SERVICE_ATTRIBUTE4 | VARCHAR2 | (450) | ||
| CM_TCL_SERVICE_ATTRIBUTE5 | VARCHAR2 | (450) | ||
| CM_TCL_SERVICE_ATTRIBUTE6 | VARCHAR2 | (450) | ||
| CM_TCL_SERVICE_ATTRIBUTE7 | VARCHAR2 | (450) | ||
| CM_TCL_SERVICE_ATTRIBUTE8 | VARCHAR2 | (450) | ||
| CM_TCL_SERVICE_ATTRIBUTE9 | VARCHAR2 | (450) | ||
| CM_TCL_SERVICE_ATTRIBUTE10 | VARCHAR2 | (450) | ||
| CM_TCL_SERVICE_ATTRIBUTE11 | VARCHAR2 | (450) | ||
| CM_TCL_SERVICE_ATTRIBUTE12 | VARCHAR2 | (450) | ||
| CM_TCL_SERVICE_ATTRIBUTE13 | VARCHAR2 | (450) | ||
| CM_TCL_SERVICE_ATTRIBUTE14 | VARCHAR2 | (450) | ||
| CM_TCL_SERVICE_ATTRIBUTE15 | VARCHAR2 | (450) | ||
| CM_TEH_CONTRACT_STATUS_CODE | VARCHAR2 | (30) | ||
| CM_TEH_TRX_TYPE_CLASS_CODE | VARCHAR2 | (30) | ||
| CM_TCL_STREAM_TYPE_CODE | VARCHAR2 | (150) | ||
| CM_TCL_STREAM_TYPE_PURPOSE | VARCHAR2 | (30) | ||
| CM_TEL_INVENTORY_ORG_CODE | VARCHAR2 | (240) |
Cut, paste (and edit) the following text to query this object:
SELECT OKL_TXD_ID
, OKL_KHR_ID
, OKL_KLE_ID
, OKL_TRY_ID
, TCL_STY_ID
, CM_TCN_TRX_NUMBER
, CM_TEH_CONTRACT_NUMBER
, CM_CONTRACT_PRODUCT_NAME
, CM_BOOK_CLASSIFICATION_CODE
, CM_TCN_TAX_OWNER_CODE
, CM_RENT_IA_CONTRACT_NUMBER
, CM_RES_IA_CONTRACT_NUMBER
, CM_TEH_CONVERTED_NUMBER
, CM_TEH_CONTRACT_EFFECTIVE_FROM
, CM_TEH_CONTRACT_CURRENCY_CODE
, CM_TEH_SALES_REP_NAME
, CM_TEH_RENT_IA_PRODUCT_NAME
, CM_TEH_RES_IA_PRODUCT_NAME
, CM_TEH_PO_ORDER_NUMBER
, CM_TEH_VENDOR_PROGRAM_NUMBER
, CM_TEH_RENT_IA_ACCOUNTING_CODE
, CM_TEH_RES_IA_ACCOUNTING_CODE
, CM_TEH_ASSIGNABLE_FLAG
, CM_TEH_CONVERTED_ACCOUNT_FLAG
, CM_TEH_ACCRUAL_OVERRIDE_FLAG
, CM_TEH_TERM_QUOTE_ACCEPT_DATE
, CM_TEH_TERM_QUOTE_NUM
, CM_TEH_TERM_QUOTE_TYPE_CODE
, CM_TCN_ATTRIBUTE_CATEGORY
, CM_TCN_ATTRIBUTE1
, CM_TCN_ATTRIBUTE2
, CM_TCN_ATTRIBUTE3
, CM_TCN_ATTRIBUTE4
, CM_TCN_ATTRIBUTE5
, CM_TCN_ATTRIBUTE6
, CM_TCN_ATTRIBUTE7
, CM_TCN_ATTRIBUTE8
, CM_TCN_ATTRIBUTE9
, CM_TCN_ATTRIBUTE10
, CM_TCN_ATTRIBUTE11
, CM_TCN_ATTRIBUTE12
, CM_TCN_ATTRIBUTE13
, CM_TCN_ATTRIBUTE14
, CM_TCN_ATTRIBUTE15
, CM_CUST_ATTRIBUTE_CATEGORY
, CM_TEH_CUST_ATTRIBUTE1
, CM_TEH_CUST_ATTRIBUTE2
, CM_TEH_CUST_ATTRIBUTE3
, CM_TEH_CUST_ATTRIBUTE4
, CM_TEH_CUST_ATTRIBUTE5
, CM_TEH_CUST_ATTRIBUTE6
, CM_TEH_CUST_ATTRIBUTE7
, CM_TEH_CUST_ATTRIBUTE8
, CM_TEH_CUST_ATTRIBUTE9
, CM_TEH_CUST_ATTRIBUTE10
, CM_TEH_CUST_ATTRIBUTE11
, CM_TEH_CUST_ATTRIBUTE12
, CM_TEH_CUST_ATTRIBUTE13
, CM_TEH_CUST_ATTRIBUTE14
, CM_TEH_CUST_ATTRIBUTE15
, CM_TEH_REV_REC_METHOD_CODE
, CM_TEH_INT_CALC_METHOD_CODE
, CM_TEL_ASSET_NUMBER
, CM_TEL_CONTRACT_LINE_NUMBER
, CM_TEL_ASSET_VENDOR_NAME
, CM_TEL_INSTALLED_SITE_ID
, CM_FIXED_ASSET_LOCATION_NAME
, CM_TEL_MEMO_FLAG
, CM_OKL_SUBSIDY_NAME
, CM_OKL_SUBSIDY_PARTY_NAME
, CM_DIST_ACC_TEMPLATE_NAME
, CM_OKL_CONTINGENCY_CODE
, CM_TEL_FEE_TYPE_CODE
, CM_OKL_KHR_LINE_TYPE
, CM_ASSET_ATTRIBUTE_CATEGORY
, CM_TCL_ASSET_ATTRIBUTE1
, CM_TCL_ASSET_ATTRIBUTE2
, CM_TCL_ASSET_ATTRIBUTE3
, CM_TCL_ASSET_ATTRIBUTE4
, CM_TCL_ASSET_ATTRIBUTE5
, CM_TCL_ASSET_ATTRIBUTE6
, CM_TCL_ASSET_ATTRIBUTE7
, CM_TCL_ASSET_ATTRIBUTE8
, CM_TCL_ASSET_ATTRIBUTE9
, CM_TCL_ASSET_ATTRIBUTE10
, CM_TCL_ASSET_ATTRIBUTE11
, CM_TCL_ASSET_ATTRIBUTE12
, CM_TCL_ASSET_ATTRIBUTE13
, CM_TCL_ASSET_ATTRIBUTE14
, CM_TCL_ASSET_ATTRIBUTE15
, CM_TCL_FEE_ATTRIBUTE_CATEGORY
, CM_TCL_FEE_ATTRIBUTE1
, CM_TCL_FEE_ATTRIBUTE2
, CM_TCL_FEE_ATTRIBUTE3
, CM_TCL_FEE_ATTRIBUTE4
, CM_TCL_FEE_ATTRIBUTE5
, CM_TCL_FEE_ATTRIBUTE6
, CM_TCL_FEE_ATTRIBUTE7
, CM_TCL_FEE_ATTRIBUTE8
, CM_TCL_FEE_ATTRIBUTE9
, CM_TCL_FEE_ATTRIBUTE10
, CM_TCL_FEE_ATTRIBUTE11
, CM_TCL_FEE_ATTRIBUTE12
, CM_TCL_FEE_ATTRIBUTE13
, CM_TCL_FEE_ATTRIBUTE14
, CM_TCL_FEE_ATTRIBUTE15
, CM_SERVICE_ATTRIBUTE_CATEGORY
, CM_TCL_SERVICE_ATTRIBUTE1
, CM_TCL_SERVICE_ATTRIBUTE2
, CM_TCL_SERVICE_ATTRIBUTE3
, CM_TCL_SERVICE_ATTRIBUTE4
, CM_TCL_SERVICE_ATTRIBUTE5
, CM_TCL_SERVICE_ATTRIBUTE6
, CM_TCL_SERVICE_ATTRIBUTE7
, CM_TCL_SERVICE_ATTRIBUTE8
, CM_TCL_SERVICE_ATTRIBUTE9
, CM_TCL_SERVICE_ATTRIBUTE10
, CM_TCL_SERVICE_ATTRIBUTE11
, CM_TCL_SERVICE_ATTRIBUTE12
, CM_TCL_SERVICE_ATTRIBUTE13
, CM_TCL_SERVICE_ATTRIBUTE14
, CM_TCL_SERVICE_ATTRIBUTE15
, CM_TEH_CONTRACT_STATUS_CODE
, CM_TEH_TRX_TYPE_CLASS_CODE
, CM_TCL_STREAM_TYPE_CODE
, CM_TCL_STREAM_TYPE_PURPOSE
, CM_TEL_INVENTORY_ORG_CODE
FROM APPS.OKL_AR_CM_APP_KHR_REF_V;
APPS
OKL_EXT_AR_HEADER_SOURCES_B
OKL_EXT_AR_LINE_SOURCES_B
OKL_TXD_AR_LN_DTLS_B
APPS.OKL_AR_CM_APP_KHR_REF_V is not referenced by any database object
|
|
|
|