[Home] [Help] [Dependency Information]
Object Name: | OKL_STRM_TMPT_PRIMARY_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_STRM_TMPT_PRIMARY_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 | |
STY_ID | NUMBER | Yes | Stream Type Id | |
STY_NAME | VARCHAR2 | (150) | Yes | A unique name given for a type |
STY_PURPOSE | VARCHAR2 | (30) | Stream type purpose | |
STY_PURPOSE_MEANING | VARCHAR2 | (4000) | Stream Type purpose meaning | |
BILLABLE_YN | VARCHAR2 | (30) | Yes | Billable YN |
CAPITALIZE_YN | VARCHAR2 | (30) | Capitalize YN | |
PRICING_NAME | VARCHAR2 | (150) | Pricing Name | |
GTT_ID | NUMBER | Yes | Stream Template Id | |
VERSION | VARCHAR2 | (24) | Yes | Stream Template version |
START_DATE | DATE | Yes | Stream Template start date | |
END_DATE | DATE | Stream Template end date | ||
TMPT_STATUS | VARCHAR2 | (30) | Yes | Stream Template status |
GTS_ID | NUMBER | Yes | Stream Template set Id | |
ST_GEN_TMPT_SET_NAME | VARCHAR2 | (150) | Yes | Stream Template set name |
DESCRIPTION | VARCHAR2 | (1995) | Stream Template description | |
PRODUCT_TYPE | VARCHAR2 | (30) | Yes | Product Type |
TAX_OWNER | VARCHAR2 | (30) | Yes | Tax owner |
DEAL_TYPE | VARCHAR2 | (30) | Yes | Book classification |
PRICING_ENGINE | VARCHAR2 | (30) | Pricing Engine | |
AES_ID | NUMBER | Yes | Accounting Template set Id | |
AE_TMPT_SET_NAME | VARCHAR2 | (150) | Yes | Accounting Template set Name |
PDT_ID | NUMBER | Yes | Product Id | |
PRODUCT_NAME | VARCHAR2 | (150) | Yes | Product Name |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, PRIMARY_YN
, STY_ID
, STY_NAME
, STY_PURPOSE
, STY_PURPOSE_MEANING
, BILLABLE_YN
, CAPITALIZE_YN
, 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_PRIMARY_UV;
|
|
|