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

TABLE: CS.CS_CF_FLOW_TYPE_PAGES

Object Details
Object Name: CS_CF_FLOW_TYPE_PAGES
Object Type: TABLE
Owner: CS
FND Design Data: TableCS.CS_CF_FLOW_TYPE_PAGES
Subobject Name:
Status: VALID


CS_CF_FLOW_TYPE_PAGES lists the pages available for each flow type and their corresponding sequences in the flow.
The FUNCTION_NAME column stores the fnd_form_function which contains the physical jsp name for the corresponding PAGE_CODE.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CS_CF_FLOW_TYPE_PAGES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFLOW_TYPE_PAGE_ID
Columns
Name Datatype Length Mandatory Comments
FLOW_TYPE_PAGE_ID NUMBER (15) Yes The primary key for this table.
OBJECT_VERSION_NUMBER NUMBER
Yes Sequential number used for database locking control.
FLOW_TYPE_CODE VARCHAR2 (30) Yes This specifies the type of flow that we are defining.
PAGE_CODE VARCHAR2 (30) Yes This specifies the page available in the flow type.
SEQUENCE NUMBER (15) Yes This specifies the sequence of the page in the flow type.
FUNCTION_NAME VARCHAR2 (30) Yes This specifies the function name mapped to the corresponding page.
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
Query Text

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


SELECT FLOW_TYPE_PAGE_ID
,      OBJECT_VERSION_NUMBER
,      FLOW_TYPE_CODE
,      PAGE_CODE
,      SEQUENCE
,      FUNCTION_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM CS.CS_CF_FLOW_TYPE_PAGES;

Dependencies

[top of page]

CS.CS_CF_FLOW_TYPE_PAGES does not reference any database object

CS.CS_CF_FLOW_TYPE_PAGES is referenced by following:

SchemaAPPS
SynonymCS_CF_FLOW_TYPE_PAGES