[Home] [Help]
[Dependency Information]
| Object Name: | OKE_APPROVAL_STEPS# |
|---|---|
| Object Type: | VIEW |
| Owner: | OKE |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| APPROVAL_PATH_ID | NUMBER | Yes | ||
| APPROVAL_SEQUENCE | NUMBER | Yes | ||
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | Yes | ||
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | Yes | ||
| LAST_UPDATE_LOGIN | NUMBER | |||
| RECORD_VERSION_NUMBER | NUMBER | Yes | ||
| APPROVER_ROLE_ID | NUMBER | Yes | ||
| REQUIRED_FLAG | VARCHAR2 | (1) | Yes | |
| ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT APPROVAL_PATH_ID
, APPROVAL_SEQUENCE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, RECORD_VERSION_NUMBER
, APPROVER_ROLE_ID
, REQUIRED_FLAG
, ZD_EDITION_NAME
FROM OKE.OKE_APPROVAL_STEPS#;
OKE
OKE_APPROVAL_STEPS
APPS
OKE_APPROVAL_STEPS
OKE_APPROVAL_STEPS+
|
|
|
|