[Home] [Help] [Dependency Information]
Object Name: | OKL_STRM_TMPT_FULL_UV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_STRM_TMPT_FULL_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 | Primary key column | ||
PRIMARY_YN | VARCHAR2 | (3) | Primary Stream Type YN | |
STY_ID | NUMBER | Stream Type Identifier | ||
STY_NAME | VARCHAR2 | (150) | 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) | Billable YN | |
CAPITALIZE_YN | VARCHAR2 | (30) | Capitalize YN | |
PRICING_NAME | VARCHAR2 | (150) | Pricing Name | |
GTT_ID | NUMBER | Stream template identifier | ||
VERSION | VARCHAR2 | (24) | Stream template version | |
START_DATE | DATE | Start date | ||
END_DATE | DATE | End Date | ||
TMPT_STATUS | VARCHAR2 | (30) | Template status | |
GTS_ID | NUMBER | Template set identifier | ||
ST_GEN_TMPT_SET_NAME | VARCHAR2 | (150) | Stream template set name | |
DESCRIPTION | VARCHAR2 | (1995) | Description | |
PRODUCT_TYPE | VARCHAR2 | (30) | Product Type | |
TAX_OWNER | VARCHAR2 | (30) | Tax owner | |
DEAL_TYPE | VARCHAR2 | (30) | Book classification | |
PRICING_ENGINE | VARCHAR2 | (30) | Pricing engine | |
AES_ID | NUMBER | Accounting Template set Id | ||
AE_TMPT_SET_NAME | VARCHAR2 | (150) | Accounting Template set name | |
PDT_ID | NUMBER | Product Id | ||
PRODUCT_NAME | VARCHAR2 | (150) | Product Name | |
PRIMARY_STY_ID | NUMBER | This field will have the primary stream id corresponding to the depdendent stream defined by sty_id |
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
, PRIMARY_STY_ID
FROM APPS.OKL_STRM_TMPT_FULL_UV;
|
|
|