[Home] [Help] [Dependency Information]
Object Name: | OKL_AR_REC_APP_IA_REF_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_AR_REC_APP_IA_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_REC_APP_ID | NUMBER | (15) | Yes | Identifies the receivable application |
OKL_TXD_ID | NUMBER | Yes | Source Table Identifier | |
OKL_KHR_ID | NUMBER | Yes | Contract Identifier | |
OKL_KLE_ID | NUMBER | Contract Line Identifier | ||
OKL_TRY_ID | NUMBER | Transaction Type Identifier | ||
TCL_STY_ID | NUMBER | Stream Type Identifier | ||
TEH_INV_AGRMNT_NUMBER | VARCHAR2 | (120) | Investor Agreement Number | |
TEH_INV_AGRMNT_EFFECTIVE_FROM | DATE | Investor Agreement Effective From Date | ||
TCN_INV_AGRMNT_PRODUCT_NAME | VARCHAR2 | (150) | Investor Agreement Product Name | |
TEH_INV_AGRMNT_CURRENCY_CODE | VARCHAR2 | (80) | Investor Agreement Currency Code | |
TEH_INV_AGRMNT_SYND_CODE | VARCHAR2 | (30) | Investor Agreement Type | |
TEH_INV_AGRMNT_POOL_NUMBER | VARCHAR2 | (120) | Investor Agrreement Pool Number | |
TEH_INV_AGRMNT_STATUS_CODE | VARCHAR2 | (30) | Investor Agreement Status Code | |
TEH_TRX_TYPE_CLASS_CODE | VARCHAR2 | (30) | Transaction Type Class Code | |
DIST_ACCOUNTING_TEMPLATE_NAME | VARCHAR2 | (150) | Accounting Template Name | |
OKL_CONTINGENCY_CODE | VARCHAR2 | (80) | Stream Type Collectibility Contingency | |
TEL_MEMO_FLAG | VARCHAR2 | (3) | Accounting Template Memo Indicator | |
TCL_INV_STREAM_TYPE_CODE | VARCHAR2 | (150) | Stream Type Code | |
TCL_INV_STREAM_TYPE_PURPOSE | VARCHAR2 | (30) | Stream Type Purpose Code |
Cut, paste (and edit) the following text to query this object:
SELECT OKL_REC_APP_ID
, OKL_TXD_ID
, OKL_KHR_ID
, OKL_KLE_ID
, OKL_TRY_ID
, TCL_STY_ID
, TEH_INV_AGRMNT_NUMBER
, TEH_INV_AGRMNT_EFFECTIVE_FROM
, TCN_INV_AGRMNT_PRODUCT_NAME
, TEH_INV_AGRMNT_CURRENCY_CODE
, TEH_INV_AGRMNT_SYND_CODE
, TEH_INV_AGRMNT_POOL_NUMBER
, TEH_INV_AGRMNT_STATUS_CODE
, TEH_TRX_TYPE_CLASS_CODE
, DIST_ACCOUNTING_TEMPLATE_NAME
, OKL_CONTINGENCY_CODE
, TEL_MEMO_FLAG
, TCL_INV_STREAM_TYPE_CODE
, TCL_INV_STREAM_TYPE_PURPOSE
FROM APPS.OKL_AR_REC_APP_IA_REF_V;
APPS.OKL_AR_REC_APP_IA_REF_V is not referenced by any database object
|
|
|