VIEW: APPS.IGS_PE_SN_SERVICE_V

Source

View Text - Preformatted

SELECT AP.ROWID ROW_ID, AP.SN_SERVICE_ID, AP.DISABILITY_ID, AP.SPECIAL_SERVICE_CD, L1.MEANING SPECIAL_SERVICE, AP.DOCUMENTED_IND, AP.CREATED_BY, AP.CREATION_DATE, AP.LAST_UPDATED_BY, AP.LAST_UPDATE_DATE, AP.LAST_UPDATE_LOGIN , ap.start_dt, ap.end_dt FROM IGS_PE_SN_SERVICE AP, IGS_LOOKUP_VALUES L1 WHERE AP.SPECIAL_SERVICE_CD = L1.LOOKUP_CODE AND L1.LOOKUP_TYPE = 'PE_SN_SERVICE'

View Text - HTML Formatted

SELECT AP.ROWID ROW_ID
, AP.SN_SERVICE_ID
, AP.DISABILITY_ID
, AP.SPECIAL_SERVICE_CD
, L1.MEANING SPECIAL_SERVICE
, AP.DOCUMENTED_IND
, AP.CREATED_BY
, AP.CREATION_DATE
, AP.LAST_UPDATED_BY
, AP.LAST_UPDATE_DATE
, AP.LAST_UPDATE_LOGIN
, AP.START_DT
, AP.END_DT
FROM IGS_PE_SN_SERVICE AP
, IGS_LOOKUP_VALUES L1
WHERE AP.SPECIAL_SERVICE_CD = L1.LOOKUP_CODE
AND L1.LOOKUP_TYPE = 'PE_SN_SERVICE'