eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: CS.CS_CF_FLOW_PAGES_B

Object Details

Object Name:	CS_CF_FLOW_PAGES_B
Object Type:	TABLE
Owner:	CS
FND Design Data:	CS.CS_CF_FLOW_PAGES_B
Subobject Name:
Status:	VALID

CS_CF_FLOW_PAGES_B stores the activation status of pages for particular flow type instances.
FLOW_ID references the primary key in CS_CF_FLOWS_B for a specific instance of a flow type.
PAGE_FLOW_TYPE_ID references the primary key in CS_CF_FLOW_TYPE_PAGES for the page of a flow type.
The ENABLED_FLAG specifies the activation status of this page in this instance of the flow type.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CS_CF_FLOW_PAGES_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FLOW_ID FLOW_TYPE_PAGE_ID ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
FLOW_ID	NUMBER	(15)	Yes	This stores the particular instance of a flow type.
FLOW_TYPE_PAGE_ID	NUMBER	(15)	Yes	This stores the primary key PAGE_FLOW_TYPE_ID from CS_CF_FLOW_TYPE_PAGES to reference a particular page of a flow type.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Sequential number used for database locking control.
ENABLED_FLAG	VARCHAR2	(1)	Yes	This column indicates whether the page will be activated in the corresponding instance of the flow type.
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment for attribute 1
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment for attribute 2
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment for attribute 3
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment for attribute 4
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment for attribute 5
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment for attribute 6
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment for attribute 7
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment for attribute 8
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment for attribute 9
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment for attribute 10
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment for attribute 11
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment for attribute 12
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment for attribute 13
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment for attribute 14
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment for attribute 15
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT FLOW_ID
,      FLOW_TYPE_PAGE_ID
,      OBJECT_VERSION_NUMBER
,      ENABLED_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ZD_EDITION_NAME
FROM CS.CS_CF_FLOW_PAGES_B;

Dependencies

[top of page]

CS.CS_CF_FLOW_PAGES_B does not reference any database object

CS.CS_CF_FLOW_PAGES_B is referenced by following:

CS: CS_CF_FLOW_PAGES_B#