[Home] [Help]
View: IGS_AD_CRED_TYPES_V
View Text
SELECT CT.ROWID ROW_ID
, CT.CREDENTIAL_TYPE_ID CREDENTIAL_TYPE_ID
, CT.CREDENTIAL_TYPE CREDENTIAL_TYPE
, CT.SYSTEM_TYPE SYSTEM_TYPE
, LK.MEANING TYPE_MEANING
, CT.DESCRIPTION DESCRIPTION
, CT.STEP_CODE STEP_CODE
, TRSC.DESCRIPTION STEP_CODE_DESC
, CT.CLOSED_IND CLOSED_IND
, CT.CREATED_BY CREATED_BY
, CT.CREATION_DATE CREATION_DATE
, CT.LAST_UPDATED_BY LAST_UPDATED_BY
, CT.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CT.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM IGS_AD_CRED_TYPES CT
, IGS_LOOKUP_VALUES LK
, IGS_TR_STEP_CTLG_ALL TRSC
WHERE CT.STEP_CODE = TRSC.STEP_CATALOG_CD(+)
AND CT.SYSTEM_TYPE = LK.LOOKUP_CODE
AND LK.LOOKUP_TYPE = 'CREDENTIAL_SYSTEM_TYPES'
Columns
Name |
ROW_ID |
CREDENTIAL_TYPE_ID |
CREDENTIAL_TYPE |
SYSTEM_TYPE |
TYPE_MEANING |
DESCRIPTION |
STEP_CODE |
STEP_CODE_DESC |
CLOSED_IND |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |