Skip to content

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

VIEW: MSC.MSC_SELECTION_CRITERIA#

Object Details
Object Name: MSC_SELECTION_CRITERIA#
Object Type: VIEW
Owner: MSC
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SEQUENCE NUMBER
Yes
FOLDER_ID NUMBER
Yes
FIELD_NAME VARCHAR2 (30) Yes
FIELD_TYPE VARCHAR2 (10) Yes
HIDDEN_FROM_FIELD VARCHAR2 (250)
CONDITION NUMBER

FROM_FIELD VARCHAR2 (250)
TO_FIELD VARCHAR2 (250)
FOLDER_OBJECT VARCHAR2 (30) Yes
TREE_NODE NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

AND_OR NUMBER

COUNT_BY NUMBER

SEARCH_QUERY_ID NUMBER (38)
SEARCH_QUERY_NAME VARCHAR2 (30)
DEFAULT_FLAG NUMBER (38)
PUBLIC_FLAG NUMBER (38)
FROM_FIELD_VALUE VARCHAR2 (250)
TO_FIELD_VALUE VARCHAR2 (250)
OBJECT_TYPE NUMBER

SOURCE_TYPE NUMBER

ACTIVE_FLAG NUMBER

OBJECT_SEQUENCE_ID NUMBER

Query Text

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


SELECT SEQUENCE
,      FOLDER_ID
,      FIELD_NAME
,      FIELD_TYPE
,      HIDDEN_FROM_FIELD
,      CONDITION
,      FROM_FIELD
,      TO_FIELD
,      FOLDER_OBJECT
,      TREE_NODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      AND_OR
,      COUNT_BY
,      SEARCH_QUERY_ID
,      SEARCH_QUERY_NAME
,      DEFAULT_FLAG
,      PUBLIC_FLAG
,      FROM_FIELD_VALUE
,      TO_FIELD_VALUE
,      OBJECT_TYPE
,      SOURCE_TYPE
,      ACTIVE_FLAG
,      OBJECT_SEQUENCE_ID
FROM MSC.MSC_SELECTION_CRITERIA#;

Dependencies

[top of page]

MSC.MSC_SELECTION_CRITERIA# references the following:

SchemaMSC
TableMSC_SELECTION_CRITERIA
MSC.MSC_SELECTION_CRITERIA# is referenced by following:

SchemaAPPS
SynonymMSC_SELECTION_CRITERIA