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

VIEW: APPS.AZ_SELECTION_SETS_VL

Object Details
Object Name: AZ_SELECTION_SETS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAZ.AZ_SELECTION_SETS_VL
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


AZ_SELECTION_SETS_VL


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ROW_ID
CREATION_DATE DATE
Yes CREATION_DATE
LAST_UPDATED_BY NUMBER (15) Yes LAST_UPDATED_BY
LAST_UPDATE_DATE DATE
Yes LAST_UPDATE_DATE
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_LOGIN
SELECTION_SET_CODE VARCHAR2 (45) Yes SELECTION_SET_CODE
USER_ID NUMBER (15) Yes USER_ID
STRUCTURE_CODE VARCHAR2 (30) Yes STRUCTURE_CODE
REF_SELECTION_SET_CODE VARCHAR2 (45)
Reference Selection Set Code
ACTIVE VARCHAR2 (1)
Active
HIERARCHICAL_FLAG VARCHAR2 (1)
Hierarchical Flag
PARTIAL_SELECTION VARCHAR2 (1)
Partial Selection
CREATED_BY NUMBER (15) Yes CREATED_BY
SOURCE_INSTANCE VARCHAR2 (45)
SOURCE_INSTANCE
PREDEFINED_FLAG VARCHAR2 (1) Yes PREDEFINED_FLAG
SELECTION_SET_NAME VARCHAR2 (45) Yes SELECTION_SET_NAME
SELECTION_SET_DESC VARCHAR2 (1800)
SELECTION_SET_DESC
Query Text

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


SELECT ROW_ID
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SELECTION_SET_CODE
,      USER_ID
,      STRUCTURE_CODE
,      REF_SELECTION_SET_CODE
,      ACTIVE
,      HIERARCHICAL_FLAG
,      PARTIAL_SELECTION
,      CREATED_BY
,      SOURCE_INSTANCE
,      PREDEFINED_FLAG
,      SELECTION_SET_NAME
,      SELECTION_SET_DESC
FROM APPS.AZ_SELECTION_SETS_VL;

Dependencies

[top of page]

APPS.AZ_SELECTION_SETS_VL references the following:

SchemaAPPS
SynonymAZ_SELECTION_SETS_B
SynonymAZ_SELECTION_SETS_TL

APPS.AZ_SELECTION_SETS_VL is not referenced by any database object