Skip to content

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

TABLE: AZ.AZ_REQUESTS

Object Details
Object Name: AZ_REQUESTS
Object Type: TABLE
Owner: AZ
FND Design Data: TableAZ.AZ_REQUESTS
Subobject Name:
Status: VALID

iSetup Requests

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AZ_REQUESTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnJOB_NAME
ColumnREQUEST_TYPE
ColumnUSER_ID
SYS_IL0000239517C00012$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000239517C00031$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000239517C00033$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
Columns
Name Datatype Length Mandatory Comments
JOB_NAME VARCHAR2 (45) Yes Job Name
REQUEST_TYPE VARCHAR2 (1) Yes Request Type
USER_ID NUMBER (15) Yes User ID
REQUEST_ID NUMBER (15) Yes Request ID
INSTANCE_NAME VARCHAR2 (45) Yes Instance Name
JOB_DESC VARCHAR2 (1800)
Job Description
PREVIOUS_REQ_IDS VARCHAR2 (240)
Previous request IDs
REQUEST_PHASE VARCHAR2 (1) Yes Request Phase
REQUEST_STATUS VARCHAR2 (1) Yes Request Status
SUBMISSION_DATE DATE

Submission Date
COMPLETION_DATE DATE

Completion Date
CONTENT BLOB (4000)
Content
CREATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard date column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard datecolumn
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
PARAM1 VARCHAR2 (240)
Param1
PARAM2 VARCHAR2 (240)
Param1
PARAM3 VARCHAR2 (240)
Param1
PARAM4 VARCHAR2 (240)
Param1
PARAM5 VARCHAR2 (240)
Param1
PARAM6 VARCHAR2 (240)
Param1
PARAM7 VARCHAR2 (240)
Param1
PARAM8 VARCHAR2 (240)
Param1
PARAM9 VARCHAR2 (240)
Param1
PARAM10 VARCHAR2 (240)
Param1
SCHEDULED DATE

ACTIVE VARCHAR2 (1)
SELECTION_SET XMLTYPE (2000)
DRIVER_FILE XMLTYPE (2000)
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:

SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
TYPEXMLTYPE
SchemaXDB
XML SCHEMAXDJijXQJjMyTzgQBSQycRVhw==
AZ.AZ_REQUESTS is referenced by following:

SchemaAPPS
SynonymAZ_REQUESTS