VIEW: APPS.IGS_PE_CODE_CLASSES_V

Source

View Text - Preformatted

SELECT CC.ROWID ROW_ID, CC.CODE_CLASSES_ID, CC.CLASS, LK.MEANING CLASS_DESC, CC.CODE, CC.DESCRIPTION, CC.CLOSED_IND, CC.CREATED_BY, CC.CREATION_DATE, CC.LAST_UPDATED_BY, CC.LAST_UPDATE_DATE, CC.LAST_UPDATE_LOGIN FROM IGS_PE_CODE_CLASSES CC, IGS_LOOKUPS_VIEW LK WHERE LK.LOOKUP_CODE = CC.CLASS

View Text - HTML Formatted

SELECT CC.ROWID ROW_ID
, CC.CODE_CLASSES_ID
, CC.CLASS
, LK.MEANING CLASS_DESC
, CC.CODE
, CC.DESCRIPTION
, CC.CLOSED_IND
, CC.CREATED_BY
, CC.CREATION_DATE
, CC.LAST_UPDATED_BY
, CC.LAST_UPDATE_DATE
, CC.LAST_UPDATE_LOGIN
FROM IGS_PE_CODE_CLASSES CC
, IGS_LOOKUPS_VIEW LK
WHERE LK.LOOKUP_CODE = CC.CLASS