VIEW: APPS.IGS_AD_CODE_CLASSES_V

Source

View Text - Preformatted

SELECT CC.ROWID ROW_ID, L1.MEANING MEANING, CC.CLASS CLASS, CC.CODE_ID CODE_ID, CC.NAME NAME, CC.DESCRIPTION DESCRIPTION, CC.CLOSED_IND CLOSED_IND, CC.CREATED_BY, CC.CREATION_DATE, CC.LAST_UPDATED_BY, CC.LAST_UPDATE_DATE, CC.LAST_UPDATE_LOGIN, CC.SYSTEM_STATUS, DECODE(CC.SYSTEM_STATUS,NULL,NULL, (SELECT L2.MEANING FROM IGS_LOOKUP_VALUES L2 WHERE L2.LOOKUP_TYPE = CC.CLASS AND L2.LOOKUP_CODE = CC.SYSTEM_STATUS)), CC.SYSTEM_DEFAULT, CC.CLASS_TYPE_CODE FROM IGS_AD_CODE_CLASSES CC, IGS_LOOKUP_VALUES L1 WHERE L1.LOOKUP_TYPE IN ('ADM_CODE_CLASSES','IGS_AD_QUAL_TYPE') AND L1.LOOKUP_CODE = CC.CLASS

View Text - HTML Formatted

SELECT CC.ROWID ROW_ID
, L1.MEANING MEANING
, CC.CLASS CLASS
, CC.CODE_ID CODE_ID
, CC.NAME NAME
, CC.DESCRIPTION DESCRIPTION
, CC.CLOSED_IND CLOSED_IND
, CC.CREATED_BY
, CC.CREATION_DATE
, CC.LAST_UPDATED_BY
, CC.LAST_UPDATE_DATE
, CC.LAST_UPDATE_LOGIN
, CC.SYSTEM_STATUS
, DECODE(CC.SYSTEM_STATUS
, NULL
, NULL
, (SELECT L2.MEANING
FROM IGS_LOOKUP_VALUES L2
WHERE L2.LOOKUP_TYPE = CC.CLASS
AND L2.LOOKUP_CODE = CC.SYSTEM_STATUS))
, CC.SYSTEM_DEFAULT
, CC.CLASS_TYPE_CODE
FROM IGS_AD_CODE_CLASSES CC
, IGS_LOOKUP_VALUES L1
WHERE L1.LOOKUP_TYPE IN ('ADM_CODE_CLASSES'
, 'IGS_AD_QUAL_TYPE')
AND L1.LOOKUP_CODE = CC.CLASS