DBA Data[Home] [Help]

VIEW: APPS.IGS_AD_SS_APPL_PGS_V

Source

View Text - Preformatted

SELECT SSA.ROWID, SSA.ADMISSION_APPLICATION_TYPE, SSA.PAGE_NAME, ILV.MEANING, SSA.INCLUDE_IND, SSA.CREATED_BY, SSA.CREATION_DATE, SSA.LAST_UPDATED_BY, SSA.LAST_UPDATE_DATE, SSA.LAST_UPDATE_LOGIN, SSA.REQUIRED_IND, SSA.DISP_ORDER, SSA.PAGE_DISP_NAME FROM IGS_AD_SS_APPL_PGS SSA, IGS_LOOKUP_VALUES ILV WHERE SSA.PAGE_NAME=ILV.LOOKUP_CODE AND ILV.LOOKUP_TYPE = 'SS_APPL_SELFSERVICE_PAGES'
View Text - HTML Formatted

SELECT SSA.ROWID
, SSA.ADMISSION_APPLICATION_TYPE
, SSA.PAGE_NAME
, ILV.MEANING
, SSA.INCLUDE_IND
, SSA.CREATED_BY
, SSA.CREATION_DATE
, SSA.LAST_UPDATED_BY
, SSA.LAST_UPDATE_DATE
, SSA.LAST_UPDATE_LOGIN
, SSA.REQUIRED_IND
, SSA.DISP_ORDER
, SSA.PAGE_DISP_NAME
FROM IGS_AD_SS_APPL_PGS SSA
, IGS_LOOKUP_VALUES ILV
WHERE SSA.PAGE_NAME=ILV.LOOKUP_CODE
AND ILV.LOOKUP_TYPE = 'SS_APPL_SELFSERVICE_PAGES'