eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_CA_DA_CONFIGS_V

Product:	IGS - Student System
Description:	View to pickup seeded system date types
Implementation/DBA Data:	APPS.IGS_CA_DA_CONFIGS_V

View Text

SELECT CAC.ROWID
, CAC.SYS_DATE_TYPE
, CAC.DESCRIPTION
, CAC. OWNER_MODULE_CODE
, L1.MEANING
, CAC.VALIDATION_PROC
, CAC.ONE_PER_CAL_FLAG
, CAC.RES_CAL_CAT1
, LK2.MEANING
, CAC.RES_CAL_CAT2
, LK3.MEANING
, CAC.DATE_ALIAS
, CAC.CREATED_BY
, CAC.CREATION_DATE
, CAC.LAST_UPDATED_BY
, CAC.LAST_UPDATE_DATE
, CAC.LAST_UPDATE_LOGIN
FROM IGS_CA_DA_CONFIGS CAC
, FND_LOOKUP_VALUES L1
, IGS_LOOKUP_VALUES LK2
, IGS_LOOKUP_VALUES LK3
WHERE CAC.OWNER_MODULE_CODE=L1.LOOKUP_CODE
AND L1.LOOKUP_TYPE='IGS_MODULES'
AND L1.VIEW_APPLICATION_ID = 8405
AND L1.SECURITY_GROUP_ID = 0
AND L1.LANGUAGE= USERENV('LANG')
AND LK2.LOOKUP_CODE = RES_CAL_CAT1
AND LK2.LOOKUP_TYPE = 'CAL_CAT'
AND LK3.LOOKUP_CODE (+)= RES_CAL_CAT2
AND LK3.LOOKUP_TYPE (+) = 'CAL_CAT'

Columns

Name
ROW_ID
SYS_DATE_TYPE
DESCRIPTION
OWNER_MODULE_CODE
OWNER_MODULE_DESC
VALIDATION_PROC
ONE_PER_CAL_FLAG
RES_CAL_CAT1
CAL_CAT1_DESC
RES_CAL_CAT2
CAL_CAT2_DESC
DATE_ALIAS
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN