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.

VIEW: APPS.IGS_CA_DA_CONFIGS_V

Source

View Text - Preformatted


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'

View Text - HTML Formatted

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'