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

Source

View Text - Preformatted


SELECT prc.configuration_code configuration_code, prc.configuration_type configuration_type, prc.configuration_status configuration_status, prt.configuration_name configuration_name, prt.configuration_description configuration_description, prc.object_version_number object_version_number, prc.last_update_date last_update_date, prc.last_updated_by last_updated_by, prc.last_update_login last_update_login, prc.created_by created_by, prc.creation_date createion_date from per_ri_configurations prc, per_ri_configurations_tl prt where prc.configuration_code = prt.configuration_code and prt.language = USERENV('LANG')

View Text - HTML Formatted

SELECT PRC.CONFIGURATION_CODE CONFIGURATION_CODE
, PRC.CONFIGURATION_TYPE CONFIGURATION_TYPE
, PRC.CONFIGURATION_STATUS CONFIGURATION_STATUS
, PRT.CONFIGURATION_NAME CONFIGURATION_NAME
, PRT.CONFIGURATION_DESCRIPTION CONFIGURATION_DESCRIPTION
, PRC.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PRC.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PRC.LAST_UPDATED_BY LAST_UPDATED_BY
, PRC.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PRC.CREATED_BY CREATED_BY
, PRC.CREATION_DATE CREATEION_DATE
FROM PER_RI_CONFIGURATIONS PRC
, PER_RI_CONFIGURATIONS_TL PRT
WHERE PRC.CONFIGURATION_CODE = PRT.CONFIGURATION_CODE
AND PRT.LANGUAGE = USERENV('LANG')