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.EGO_RESULTS_FORMAT_V

Source

View Text - Preformatted


SELECT NAME_QUERY.CUSTOMIZATION_APPLICATION_ID AS CUSTOMIZATION_APPLICATION_ID , NAME_QUERY.CUSTOMIZATION_CODE AS CUSTOMIZATION_CODE , NAME_QUERY.REGION_APPLICATION_ID AS REGION_APPLICATION_ID , NAME_QUERY.REGION_CODE AS REGION_CODE , NAME_QUERY.PROPERTY_VARCHAR2_VALUE AS NAME , DESC_QUERY.PROPERTY_VARCHAR2_VALUE AS DESCRIPTION , ROWS_QUERY.PROPERTY_NUMBER_VALUE AS NUM_ROWS_DISPLAYED , DEFAULT_QUERY.PROPERTY_VARCHAR2_VALUE AS DEFAULT_RESULT_FLAG , L1.MEANING AS DEFAULT_RESULT_FLAG_MEANING , ECT.CLASSIFICATION1 AS CLASSIFICATION1 , ECT.CLASSIFICATION2 AS CLASSIFICATION2 , ECT.CLASSIFICATION3 AS CLASSIFICATION3 , SITE_ID_QUERY.PROPERTY_NUMBER_VALUE AS SITE_ID , USER_ID_QUERY.PROPERTY_NUMBER_VALUE AS WEB_USER_ID , LEVEL_ID_QUERY.PROPERTY_NUMBER_VALUE AS CUSTOMIZATION_LEVEL_ID , IMPORT_QUERY.PROPERTY_VARCHAR2_VALUE AS IMPORT_FLAG , DATA_LEVEL_QUERY.PROPERTY_VARCHAR2_VALUE AS DATA_LEVEL FROM AK_CUSTOM_REGIONS_TL NAME_QUERY , AK_CUSTOM_REGIONS_TL DESC_QUERY , AK_CUSTOM_REGIONS ROWS_QUERY , AK_CUSTOM_REGIONS DEFAULT_QUERY , AK_CUSTOM_REGIONS SITE_ID_QUERY , AK_CUSTOM_REGIONS USER_ID_QUERY , AK_CUSTOM_REGIONS LEVEL_ID_QUERY , AK_CUSTOM_REGIONS IMPORT_QUERY , AK_CUSTOM_REGIONS DATA_LEVEL_QUERY , EGO_CUSTOMIZATION_EXT ECT , FND_LOOKUP_VALUES L1 WHERE NAME_QUERY.PROPERTY_NAME = 'RESULT_NAME' AND NAME_QUERY.LANGUAGE = USERENV('LANG') AND DESC_QUERY.PROPERTY_NAME = 'RESULT_DESCRIPTION' AND DESC_QUERY.LANGUAGE = USERENV('LANG') AND ROWS_QUERY.PROPERTY_NAME = 'NUM_ROWS_DISPLAY' AND DEFAULT_QUERY.PROPERTY_NAME = 'DEFAULT_RESULT_FLAG' AND SITE_ID_QUERY.PROPERTY_NAME = 'SITE_ID' AND USER_ID_QUERY.PROPERTY_NAME = 'WEB_USER_ID' AND IMPORT_QUERY.PROPERTY_NAME (+) = 'IMPORT_FLAG' AND DATA_LEVEL_QUERY.PROPERTY_NAME (+) = 'DATA_LEVEL' AND NAME_QUERY.CUSTOMIZATION_APPLICATION_ID = DESC_QUERY.CUSTOMIZATION_APPLICATION_ID AND NAME_QUERY.CUSTOMIZATION_CODE = DESC_QUERY.CUSTOMIZATION_CODE AND NAME_QUERY.REGION_APPLICATION_ID = DESC_QUERY.REGION_APPLICATION_ID AND NAME_QUERY.REGION_CODE = DESC_QUERY.REGION_CODE AND NAME_QUERY.CUSTOMIZATION_APPLICATION_ID = ROWS_QUERY.CUSTOMIZATION_APPLICATION_ID AND NAME_QUERY.CUSTOMIZATION_CODE = ROWS_QUERY.CUSTOMIZATION_CODE AND NAME_QUERY.REGION_APPLICATION_ID = ROWS_QUERY.REGION_APPLICATION_ID AND NAME_QUERY.REGION_CODE = ROWS_QUERY.REGION_CODE AND NAME_QUERY.CUSTOMIZATION_APPLICATION_ID = DEFAULT_QUERY.CUSTOMIZATION_APPLICATION_ID AND NAME_QUERY.CUSTOMIZATION_CODE = DEFAULT_QUERY.CUSTOMIZATION_CODE AND NAME_QUERY.REGION_APPLICATION_ID = DEFAULT_QUERY.REGION_APPLICATION_ID AND NAME_QUERY.REGION_CODE = DEFAULT_QUERY.REGION_CODE AND NAME_QUERY.CUSTOMIZATION_APPLICATION_ID = ECT.CUSTOMIZATION_APPLICATION_ID AND NAME_QUERY.CUSTOMIZATION_CODE = ECT.CUSTOMIZATION_CODE AND NAME_QUERY.REGION_APPLICATION_ID = ECT.REGION_APPLICATION_ID AND NAME_QUERY.REGION_CODE = ECT.REGION_CODE AND NAME_QUERY.CUSTOMIZATION_APPLICATION_ID = SITE_ID_QUERY.CUSTOMIZATION_APPLICATION_ID AND NAME_QUERY.CUSTOMIZATION_CODE = SITE_ID_QUERY.CUSTOMIZATION_CODE AND NAME_QUERY.REGION_APPLICATION_ID = SITE_ID_QUERY.REGION_APPLICATION_ID AND NAME_QUERY.REGION_CODE = SITE_ID_QUERY.REGION_CODE AND NAME_QUERY.CUSTOMIZATION_APPLICATION_ID = USER_ID_QUERY.CUSTOMIZATION_APPLICATION_ID AND NAME_QUERY.CUSTOMIZATION_CODE = USER_ID_QUERY.CUSTOMIZATION_CODE AND NAME_QUERY.REGION_APPLICATION_ID = USER_ID_QUERY.REGION_APPLICATION_ID AND NAME_QUERY.REGION_CODE = USER_ID_QUERY.REGION_CODE AND NAME_QUERY.CUSTOMIZATION_APPLICATION_ID = LEVEL_ID_QUERY.CUSTOMIZATION_APPLICATION_ID AND NAME_QUERY.CUSTOMIZATION_CODE = LEVEL_ID_QUERY.CUSTOMIZATION_CODE AND NAME_QUERY.REGION_APPLICATION_ID = LEVEL_ID_QUERY.REGION_APPLICATION_ID AND NAME_QUERY.REGION_CODE = LEVEL_ID_QUERY.REGION_CODE AND NAME_QUERY.CUSTOMIZATION_APPLICATION_ID = IMPORT_QUERY.CUSTOMIZATION_APPLICATION_ID(+) AND NAME_QUERY.CUSTOMIZATION_CODE = IMPORT_QUERY.CUSTOMIZATION_CODE (+) AND NAME_QUERY.REGION_APPLICATION_ID = IMPORT_QUERY.REGION_APPLICATION_ID(+) AND NAME_QUERY.REGION_CODE = IMPORT_QUERY.REGION_CODE(+) AND NAME_QUERY.CUSTOMIZATION_APPLICATION_ID = DATA_LEVEL_QUERY.CUSTOMIZATION_APPLICATION_ID(+) AND NAME_QUERY.CUSTOMIZATION_CODE = DATA_LEVEL_QUERY.CUSTOMIZATION_CODE (+) AND NAME_QUERY.REGION_APPLICATION_ID = DATA_LEVEL_QUERY.REGION_APPLICATION_ID(+) AND NAME_QUERY.REGION_CODE = DATA_LEVEL_QUERY.REGION_CODE(+) AND LEVEL_ID_QUERY.PROPERTY_NAME = 'CUSTOMIZATION_LEVEL_ID' AND L1.LOOKUP_TYPE = 'YES_NO' AND L1.LOOKUP_CODE = DEFAULT_QUERY.PROPERTY_VARCHAR2_VALUE AND L1.VIEW_APPLICATION_ID = 0 AND L1.LANGUAGE = USERENV('LANG') AND L1.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP('YES_NO', 0)

View Text - HTML Formatted

SELECT NAME_QUERY.CUSTOMIZATION_APPLICATION_ID AS CUSTOMIZATION_APPLICATION_ID
, NAME_QUERY.CUSTOMIZATION_CODE AS CUSTOMIZATION_CODE
, NAME_QUERY.REGION_APPLICATION_ID AS REGION_APPLICATION_ID
, NAME_QUERY.REGION_CODE AS REGION_CODE
, NAME_QUERY.PROPERTY_VARCHAR2_VALUE AS NAME
, DESC_QUERY.PROPERTY_VARCHAR2_VALUE AS DESCRIPTION
, ROWS_QUERY.PROPERTY_NUMBER_VALUE AS NUM_ROWS_DISPLAYED
, DEFAULT_QUERY.PROPERTY_VARCHAR2_VALUE AS DEFAULT_RESULT_FLAG
, L1.MEANING AS DEFAULT_RESULT_FLAG_MEANING
, ECT.CLASSIFICATION1 AS CLASSIFICATION1
, ECT.CLASSIFICATION2 AS CLASSIFICATION2
, ECT.CLASSIFICATION3 AS CLASSIFICATION3
, SITE_ID_QUERY.PROPERTY_NUMBER_VALUE AS SITE_ID
, USER_ID_QUERY.PROPERTY_NUMBER_VALUE AS WEB_USER_ID
, LEVEL_ID_QUERY.PROPERTY_NUMBER_VALUE AS CUSTOMIZATION_LEVEL_ID
, IMPORT_QUERY.PROPERTY_VARCHAR2_VALUE AS IMPORT_FLAG
, DATA_LEVEL_QUERY.PROPERTY_VARCHAR2_VALUE AS DATA_LEVEL
FROM AK_CUSTOM_REGIONS_TL NAME_QUERY
, AK_CUSTOM_REGIONS_TL DESC_QUERY
, AK_CUSTOM_REGIONS ROWS_QUERY
, AK_CUSTOM_REGIONS DEFAULT_QUERY
, AK_CUSTOM_REGIONS SITE_ID_QUERY
, AK_CUSTOM_REGIONS USER_ID_QUERY
, AK_CUSTOM_REGIONS LEVEL_ID_QUERY
, AK_CUSTOM_REGIONS IMPORT_QUERY
, AK_CUSTOM_REGIONS DATA_LEVEL_QUERY
, EGO_CUSTOMIZATION_EXT ECT
, FND_LOOKUP_VALUES L1
WHERE NAME_QUERY.PROPERTY_NAME = 'RESULT_NAME'
AND NAME_QUERY.LANGUAGE = USERENV('LANG')
AND DESC_QUERY.PROPERTY_NAME = 'RESULT_DESCRIPTION'
AND DESC_QUERY.LANGUAGE = USERENV('LANG')
AND ROWS_QUERY.PROPERTY_NAME = 'NUM_ROWS_DISPLAY'
AND DEFAULT_QUERY.PROPERTY_NAME = 'DEFAULT_RESULT_FLAG'
AND SITE_ID_QUERY.PROPERTY_NAME = 'SITE_ID'
AND USER_ID_QUERY.PROPERTY_NAME = 'WEB_USER_ID'
AND IMPORT_QUERY.PROPERTY_NAME (+) = 'IMPORT_FLAG'
AND DATA_LEVEL_QUERY.PROPERTY_NAME (+) = 'DATA_LEVEL'
AND NAME_QUERY.CUSTOMIZATION_APPLICATION_ID = DESC_QUERY.CUSTOMIZATION_APPLICATION_ID
AND NAME_QUERY.CUSTOMIZATION_CODE = DESC_QUERY.CUSTOMIZATION_CODE
AND NAME_QUERY.REGION_APPLICATION_ID = DESC_QUERY.REGION_APPLICATION_ID
AND NAME_QUERY.REGION_CODE = DESC_QUERY.REGION_CODE
AND NAME_QUERY.CUSTOMIZATION_APPLICATION_ID = ROWS_QUERY.CUSTOMIZATION_APPLICATION_ID
AND NAME_QUERY.CUSTOMIZATION_CODE = ROWS_QUERY.CUSTOMIZATION_CODE
AND NAME_QUERY.REGION_APPLICATION_ID = ROWS_QUERY.REGION_APPLICATION_ID
AND NAME_QUERY.REGION_CODE = ROWS_QUERY.REGION_CODE
AND NAME_QUERY.CUSTOMIZATION_APPLICATION_ID = DEFAULT_QUERY.CUSTOMIZATION_APPLICATION_ID
AND NAME_QUERY.CUSTOMIZATION_CODE = DEFAULT_QUERY.CUSTOMIZATION_CODE
AND NAME_QUERY.REGION_APPLICATION_ID = DEFAULT_QUERY.REGION_APPLICATION_ID
AND NAME_QUERY.REGION_CODE = DEFAULT_QUERY.REGION_CODE
AND NAME_QUERY.CUSTOMIZATION_APPLICATION_ID = ECT.CUSTOMIZATION_APPLICATION_ID
AND NAME_QUERY.CUSTOMIZATION_CODE = ECT.CUSTOMIZATION_CODE
AND NAME_QUERY.REGION_APPLICATION_ID = ECT.REGION_APPLICATION_ID
AND NAME_QUERY.REGION_CODE = ECT.REGION_CODE
AND NAME_QUERY.CUSTOMIZATION_APPLICATION_ID = SITE_ID_QUERY.CUSTOMIZATION_APPLICATION_ID
AND NAME_QUERY.CUSTOMIZATION_CODE = SITE_ID_QUERY.CUSTOMIZATION_CODE
AND NAME_QUERY.REGION_APPLICATION_ID = SITE_ID_QUERY.REGION_APPLICATION_ID
AND NAME_QUERY.REGION_CODE = SITE_ID_QUERY.REGION_CODE
AND NAME_QUERY.CUSTOMIZATION_APPLICATION_ID = USER_ID_QUERY.CUSTOMIZATION_APPLICATION_ID
AND NAME_QUERY.CUSTOMIZATION_CODE = USER_ID_QUERY.CUSTOMIZATION_CODE
AND NAME_QUERY.REGION_APPLICATION_ID = USER_ID_QUERY.REGION_APPLICATION_ID
AND NAME_QUERY.REGION_CODE = USER_ID_QUERY.REGION_CODE
AND NAME_QUERY.CUSTOMIZATION_APPLICATION_ID = LEVEL_ID_QUERY.CUSTOMIZATION_APPLICATION_ID
AND NAME_QUERY.CUSTOMIZATION_CODE = LEVEL_ID_QUERY.CUSTOMIZATION_CODE
AND NAME_QUERY.REGION_APPLICATION_ID = LEVEL_ID_QUERY.REGION_APPLICATION_ID
AND NAME_QUERY.REGION_CODE = LEVEL_ID_QUERY.REGION_CODE
AND NAME_QUERY.CUSTOMIZATION_APPLICATION_ID = IMPORT_QUERY.CUSTOMIZATION_APPLICATION_ID(+)
AND NAME_QUERY.CUSTOMIZATION_CODE = IMPORT_QUERY.CUSTOMIZATION_CODE (+)
AND NAME_QUERY.REGION_APPLICATION_ID = IMPORT_QUERY.REGION_APPLICATION_ID(+)
AND NAME_QUERY.REGION_CODE = IMPORT_QUERY.REGION_CODE(+)
AND NAME_QUERY.CUSTOMIZATION_APPLICATION_ID = DATA_LEVEL_QUERY.CUSTOMIZATION_APPLICATION_ID(+)
AND NAME_QUERY.CUSTOMIZATION_CODE = DATA_LEVEL_QUERY.CUSTOMIZATION_CODE (+)
AND NAME_QUERY.REGION_APPLICATION_ID = DATA_LEVEL_QUERY.REGION_APPLICATION_ID(+)
AND NAME_QUERY.REGION_CODE = DATA_LEVEL_QUERY.REGION_CODE(+)
AND LEVEL_ID_QUERY.PROPERTY_NAME = 'CUSTOMIZATION_LEVEL_ID'
AND L1.LOOKUP_TYPE = 'YES_NO'
AND L1.LOOKUP_CODE = DEFAULT_QUERY.PROPERTY_VARCHAR2_VALUE
AND L1.VIEW_APPLICATION_ID = 0
AND L1.LANGUAGE = USERENV('LANG')
AND L1.SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP('YES_NO'
, 0)