[Home] [Help] [Dependency Information]
Object Name: | OKL_STRM_TMPT_LINES_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_STRM_TMPT_LINES_UV |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | Primary key column | |
PRIMARY_YN | VARCHAR2 | (3) | Primary Stream Type YN | |
PRIMARY_STY_ID | NUMBER | Yes | ||
PRIMARY_STY_NAME | VARCHAR2 | (150) | Yes | A unique name given for a type |
PRIMARY_STY_PURPOSE | VARCHAR2 | (30) | Stream type purpose | |
DEPENDENT_STY_ID | NUMBER | |||
DEPENDENT_STY_NAME | VARCHAR2 | (150) | A unique name given for a type | |
DEPENDENT_STY_PURPOSE | VARCHAR2 | (30) | Stream type purpose | |
PRICING_NAME | VARCHAR2 | (150) | ||
GTT_ID | NUMBER | Yes | Primary key column | |
VERSION | VARCHAR2 | (24) | Yes | Version |
START_DATE | DATE | Yes | Start Date | |
END_DATE | DATE | End Date | ||
TMPT_STATUS | VARCHAR2 | (30) | Yes | Status of Template |
GTS_ID | NUMBER | Yes | Primary key column | |
ST_GEN_TMPT_SET_NAME | VARCHAR2 | (150) | Yes | Name of the Stream template set |
DESCRIPTION | VARCHAR2 | (1995) | User entered description for the stream template set | |
PRODUCT_TYPE | VARCHAR2 | (30) | Yes | Product Type. To indiacate if it is FINANCIAL or INVESTOR product. |
TAX_OWNER | VARCHAR2 | (30) | Yes | Tax Ownership |
DEAL_TYPE | VARCHAR2 | (30) | Yes | Book Classification |
PRICING_ENGINE | VARCHAR2 | (30) | Pricing Engine to indicate if it is an internal or external | |
AES_ID | NUMBER | Yes | Primary key column | |
AE_TMPT_SET_NAME | VARCHAR2 | (150) | Yes | Primary key column |
PDT_ID | NUMBER | Yes | Primary key column | |
PRODUCT_NAME | VARCHAR2 | (150) | Yes | Primary key column |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, PRIMARY_YN
, PRIMARY_STY_ID
, PRIMARY_STY_NAME
, PRIMARY_STY_PURPOSE
, DEPENDENT_STY_ID
, DEPENDENT_STY_NAME
, DEPENDENT_STY_PURPOSE
, PRICING_NAME
, GTT_ID
, VERSION
, START_DATE
, END_DATE
, TMPT_STATUS
, GTS_ID
, ST_GEN_TMPT_SET_NAME
, DESCRIPTION
, PRODUCT_TYPE
, TAX_OWNER
, DEAL_TYPE
, PRICING_ENGINE
, AES_ID
, AE_TMPT_SET_NAME
, PDT_ID
, PRODUCT_NAME
FROM APPS.OKL_STRM_TMPT_LINES_UV;
|
|
|