[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AZ_REQUESTS |
|---|---|
| Object Type: | TABLE |
| Owner: | AZ |
| FND Design Data: |  AZ.AZ_REQUESTS
|
| Subobject Name: | |
| Status: | VALID |
iSetup Requests
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| AZ_REQUESTS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 JOB_NAME
REQUEST_TYPE
USER_ID
|
| SYS_IL0000239517C00012$$ | LOB | UNIQUE |
APPS_TS_TX_DATA
|
|
| SYS_IL0000239517C00031$$ | LOB | UNIQUE |
APPS_TS_TX_DATA
|
|
| SYS_IL0000239517C00033$$ | LOB | UNIQUE |
APPS_TS_TX_DATA
|
| 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) |
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;
SYS
STANDARD
- show dependent code
XMLTYPE
XDB
XDJijXQJjMyTzgQBSQycRVhw==
APPS
AZ_REQUESTS
|
|
|
|