View: IGS_CA_DA_OVD_RULES_V

Product:	IGS - Student System
Description:	View to pickup overriding rules for system date types
Implementation/DBA Data:	APPS.IGS_CA_DA_OVD_RULES_V

View Text

SELECT CDR.ROWID
, CDR.SYS_DATE_TYPE
, ELEMENT_CODE
, LKUP.MEANING
, CDR.SQL_VAL
, CDR.SQL_VAL_OVRD_FLAG
, CDR.CREATED_BY
, CDR.CREATION_DATE
, CDR.LAST_UPDATED_BY
, CDR.LAST_UPDATE_DATE
, CDR.LAST_UPDATE_LOGIN
, CDR.CLOSED_IND
FROM IGS_CA_DA_OVD_RULES CDR
, FND_LOOKUP_VALUES LKUP
WHERE CDR.ELEMENT_CODE=LKUP.LOOKUP_CODE
AND LKUP.LOOKUP_TYPE='IGS_DA_OVRD_ELT_LEVEL'
AND LKUP.VIEW_APPLICATION_ID = 8405
AND LKUP.SECURITY_GROUP_ID = 0
AND LKUP.LANGUAGE = USERENV('LANG')

Columns