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

VIEW: AZ.AZ_REQUESTS#

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
JOB_NAME VARCHAR2 (45) Yes
REQUEST_TYPE VARCHAR2 (1) Yes
USER_ID NUMBER (15) Yes
REQUEST_ID NUMBER (15) Yes
INSTANCE_NAME VARCHAR2 (45) Yes
JOB_DESC VARCHAR2 (1800)
PREVIOUS_REQ_IDS VARCHAR2 (240)
REQUEST_PHASE VARCHAR2 (1) Yes
REQUEST_STATUS VARCHAR2 (1) Yes
SUBMISSION_DATE DATE

COMPLETION_DATE DATE

CONTENT BLOB (4000)
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)
PARAM1 VARCHAR2 (240)
PARAM2 VARCHAR2 (240)
PARAM3 VARCHAR2 (240)
PARAM4 VARCHAR2 (240)
PARAM5 VARCHAR2 (240)
PARAM6 VARCHAR2 (240)
PARAM7 VARCHAR2 (240)
PARAM8 VARCHAR2 (240)
PARAM9 VARCHAR2 (240)
PARAM10 VARCHAR2 (240)
SCHEDULED DATE

ACTIVE VARCHAR2 (1)
SELECTION_SET XMLTYPE (64)
DRIVER_FILE XMLTYPE (64)
Query Text

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


SELECT JOB_NAME
,      REQUEST_TYPE
,      USER_ID
,      REQUEST_ID
,      INSTANCE_NAME
,      JOB_DESC
,      PREVIOUS_REQ_IDS
,      REQUEST_PHASE
,      REQUEST_STATUS
,      SUBMISSION_DATE
,      COMPLETION_DATE
,      CONTENT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PARAM1
,      PARAM2
,      PARAM3
,      PARAM4
,      PARAM5
,      PARAM6
,      PARAM7
,      PARAM8
,      PARAM9
,      PARAM10
,      SCHEDULED
,      ACTIVE
,      SELECTION_SET
,      DRIVER_FILE
FROM AZ.AZ_REQUESTS#;

Dependencies

[top of page]

AZ.AZ_REQUESTS# references the following:

SchemaAZ
TableAZ_REQUESTS
SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
TYPEXMLTYPE
AZ.AZ_REQUESTS# is referenced by following:

SchemaAPPS
SynonymAZ_REQUESTS