Skip to content

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

TABLE: CSM.CSM_QUERY_B

Object Details
Object Name: CSM_QUERY_B
Object Type: TABLE
Owner: CSM
Subobject Name:
Status: VALID


Query Base Table


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSM_QUERY_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnQUERY_ID
Columns
Name Datatype Length Mandatory Comments
QUERY_ID NUMBER
Yes
QUERY_NAME VARCHAR2 (255)
QUERY_TYPE VARCHAR2 (255)
QUERY_TEXT1 VARCHAR2 (4000)
QUERY_TEXT2 VARCHAR2 (4000)
LEVEL_ID NUMBER

LEVEL_VALUE NUMBER

PARENT_QUERY_ID NUMBER

SAVED_QUERY VARCHAR2 (1)
QUERY_OUTPUT_FORMAT VARCHAR2 (255)
MIME_TYPE VARCHAR2 (255)
WORK_FLOW VARCHAR2 (255)
RETENTION_POLICY VARCHAR2 (30)
RETENTION_DAYS NUMBER

DELETE_FLAG VARCHAR2 (1)
TEMPLATE VARCHAR2 (30)
TEMPLATE_FILE VARCHAR2 (255)
SEEDED VARCHAR2 (1)
EXECUTION_MODE VARCHAR2 (30)
EMAIL_ENABLED VARCHAR2 (1)
RESTRICTED_FLAG VARCHAR2 (1)
DISABLED_FLAG VARCHAR2 (1)
PROCEDURE_NAME VARCHAR2 (240)
CREATION_DATE DATE

CREATED_BY NUMBER

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER

LAST_UPDATE_LOGIN NUMBER

Query Text

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


SELECT QUERY_ID
,      QUERY_NAME
,      QUERY_TYPE
,      QUERY_TEXT1
,      QUERY_TEXT2
,      LEVEL_ID
,      LEVEL_VALUE
,      PARENT_QUERY_ID
,      SAVED_QUERY
,      QUERY_OUTPUT_FORMAT
,      MIME_TYPE
,      WORK_FLOW
,      RETENTION_POLICY
,      RETENTION_DAYS
,      DELETE_FLAG
,      TEMPLATE
,      TEMPLATE_FILE
,      SEEDED
,      EXECUTION_MODE
,      EMAIL_ENABLED
,      RESTRICTED_FLAG
,      DISABLED_FLAG
,      PROCEDURE_NAME
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM CSM.CSM_QUERY_B;

Dependencies

[top of page]

CSM.CSM_QUERY_B does not reference any database object

CSM.CSM_QUERY_B is referenced by following:

SchemaCSM
ViewCSM_QUERY_B#