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