[Home] [Help]
View: OKE_APPROVAL_STEPS_V
View Text
SELECT B.ROWID
, B.APPROVAL_PATH_ID
, B.APPROVAL_SEQUENCE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.RECORD_VERSION_NUMBER
, B.APPROVER_ROLE_ID
, R.MEANING
, B.REQUIRED_FLAG
FROM OKE_APPROVAL_STEPS B
, PA_PROJECT_ROLE_TYPES R
WHERE R.PROJECT_ROLE_ID = B.APPROVER_ROLE_ID
Columns
Name |
ROW_ID |
APPROVAL_PATH_ID |
APPROVAL_SEQUENCE |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
RECORD_VERSION_NUMBER |
APPROVER_ROLE_ID |
APPROVER_ROLE |
REQUIRED_FLAG |