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

VIEW: AZ.AZ_SELECTION_SET_ENTITIES_B#

Object Details
Object Name: AZ_SELECTION_SET_ENTITIES_B#
Object Type: VIEW
Owner: AZ
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
SELECTION_SET_CODE VARCHAR2 (45) Yes
USER_ID NUMBER (15) Yes
ENTITY_OCCURANCE_CODE VARCHAR2 (45) Yes
ENTITY_CODE VARCHAR2 (45) Yes
INCLUDE_TYPE VARCHAR2 (1)
REF_ENTITY_OCCURANCE_CODE VARCHAR2 (45)
UPDATABLE_FLAG VARCHAR2 (1)
CHANGE_UPDATABLE_FLAG VARCHAR2 (1)
ALLOW_SET_TARGETVAL_FLAG VARCHAR2 (1)
ALLOW_FILTER_FLAG VARCHAR2 (1)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
FILTERING_PARAMETERS CLOB (4000)
SELECTION_FLAG VARCHAR2 (1)
SEQ_NUM NUMBER (15)
FILTER_SET_FLAG VARCHAR2 (1)
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT SELECTION_SET_CODE
,      USER_ID
,      ENTITY_OCCURANCE_CODE
,      ENTITY_CODE
,      INCLUDE_TYPE
,      REF_ENTITY_OCCURANCE_CODE
,      UPDATABLE_FLAG
,      CHANGE_UPDATABLE_FLAG
,      ALLOW_SET_TARGETVAL_FLAG
,      ALLOW_FILTER_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      FILTERING_PARAMETERS
,      SELECTION_FLAG
,      SEQ_NUM
,      FILTER_SET_FLAG
,      ZD_EDITION_NAME
FROM AZ.AZ_SELECTION_SET_ENTITIES_B#;

Dependencies

[top of page]

AZ.AZ_SELECTION_SET_ENTITIES_B# references the following:

SchemaAZ
TableAZ_SELECTION_SET_ENTITIES_B
AZ.AZ_SELECTION_SET_ENTITIES_B# is referenced by following:

SchemaAPPS
SynonymAZ_SELECTION_SET_ENTITIES_B
TriggerAZ_SELECTION_SET_ENTITIES_B+