VIEW: APPS.IGS_AD_CRED_TYPES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'