DBA Data[Home] [Help] [Dependency Information]

TABLE: OKE.OKE_FLOWDOWNS

Object Details
Object Name: OKE_FLOWDOWNS
Object Type: TABLE
Owner: OKE
Subobject Name:
Status: VALID


OKE_FLOWDOWNS holds flowdown setting for flow down types by the attribute groups. It is used to display related attributes in contract flow down viewer


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OKE_FLOWDOWNS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnBUSINESS_AREA_CODE
ColumnFLOWDOWN_TYPE
ColumnFLOWDOWN_CODE
ColumnATTRIBUTE_GROUP_TYPE
OKE_FLOWDOWNS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnFLOWDOWN_TYPE
ColumnFLOWDOWN_CODE
Columns
Name Datatype Length Mandatory Comments
BUSINESS_AREA_CODE VARCHAR2 (30) Yes Flow down business area code. Example SHIPPING, PROCUREMENT, APPROVAL
FLOWDOWN_TYPE VARCHAR2 (30) Yes Logical area of Project Contract, which are available in flow down. Example: ARTICLE, STD_NOTE, PRINT_FORM etc
FLOWDOWN_CODE VARCHAR2 (30) Yes Attribute group code. Example: If flow down type is PRINT_FORM then flowdown code could be BILLING or SHIPPING
ATTRIBUTE_GROUP_TYPE VARCHAR2 (30) Yes Denotes if attribute group is of type system or user
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER
Yes Standard Who column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BUSINESS_AREA_CODE
,      FLOWDOWN_TYPE
,      FLOWDOWN_CODE
,      ATTRIBUTE_GROUP_TYPE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM OKE.OKE_FLOWDOWNS;

Dependencies

[top of page]

OKE.OKE_FLOWDOWNS does not reference any database object

OKE.OKE_FLOWDOWNS is referenced by following:

SchemaAPPS
SynonymOKE_FLOWDOWNS