[Home] [Help] [Dependency Information]
Object Name: | OKL_STRMTYP_SOURCE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OKL.OKL_STRMTYP_SOURCE_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Source for jtf object OKL_STRMTYP.
Stream types.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID1 | NUMBER | Yes | Primary key column. Foreign key to OKL_STRM_TYPE_B.ID | |
ID2 | CHAR | (1) | Primary key column | |
NAME | VARCHAR2 | (150) | Yes | Stream type name |
DESCRIPTION | VARCHAR2 | (1995) | Stream type description | |
VERSION | VARCHAR2 | (24) | Yes | Version |
CODE | VARCHAR2 | (150) | Yes | Unique code for stream type |
STREAM_TYPE_SCOPE | VARCHAR2 | (30) | Yes | stream type scope |
START_DATE_ACTIVE | DATE | Yes | Effective from date for stream type record | |
END_DATE_ACTIVE | DATE | Effective to date for stream type record | ||
STATUS | VARCHAR2 | (1) | Indicates whether stream type is active or inactive | |
PRIMARY_UOM_CODE | VARCHAR2 | (0) | Stream type primary unit of measure code | |
BILLABLE_YN | VARCHAR2 | (30) | Yes | Indicates whether stream type is billable or not |
TAXABLE_DEFAULT_YN | VARCHAR2 | (30) | Yes | Indicates whether stream type is taxable by default or not |
CUSTOMIZATION_LEVEL | VARCHAR2 | (30) | Yes | Customization level |
FUNDABLE_YN | VARCHAR2 | (30) | Indicates whether stream type is fundable or not | |
PERIODIC_YN | VARCHAR2 | (30) | Indicates whether stream type is periodic or not | |
STREAM_TYPE_CLASS | VARCHAR2 | (30) | Yes | Stream type class |
CAPITALIZE_YN | VARCHAR2 | (30) | Indicates whether stream type can be capitalized or not | |
ACCRUAL_YN | VARCHAR2 | (30) | Yes | Indicates whether sream type is eligible for accrual or not |
STREAM_TYPE_PURPOSE | VARCHAR2 | (30) | The purpose code of the stream type |
Cut, paste (and edit) the following text to query this object:
SELECT ID1
, ID2
, NAME
, DESCRIPTION
, VERSION
, CODE
, STREAM_TYPE_SCOPE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, STATUS
, PRIMARY_UOM_CODE
, BILLABLE_YN
, TAXABLE_DEFAULT_YN
, CUSTOMIZATION_LEVEL
, FUNDABLE_YN
, PERIODIC_YN
, STREAM_TYPE_CLASS
, CAPITALIZE_YN
, ACCRUAL_YN
, STREAM_TYPE_PURPOSE
FROM APPS.OKL_STRMTYP_SOURCE_V;
|
|
|