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: PA.PA_RBS_VERSIONS_B#

Source

View Text - Preformatted


select RBS_VERSION_ID RBS_VERSION_ID, VERSION_NUMBER VERSION_NUMBER, RBS_HEADER_ID RBS_HEADER_ID, VERSION_START_DATE VERSION_START_DATE, VERSION_END_DATE VERSION_END_DATE, JOB_GROUP_ID JOB_GROUP_ID, RULE_BASED_FLAG RULE_BASED_FLAG, VALIDATED_FLAG VALIDATED_FLAG, STATUS_CODE STATUS_CODE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, CURRENT_REPORTING_FLAG CURRENT_REPORTING_FLAG, RESOURCE_CLASS_FLAG RESOURCE_CLASS_FLAG, OLAP_ELEMENT_ID OLAP_ELEMENT_ID from "PA"."PA_RBS_VERSIONS_B"

View Text - HTML Formatted

SELECT RBS_VERSION_ID RBS_VERSION_ID
, VERSION_NUMBER VERSION_NUMBER
, RBS_HEADER_ID RBS_HEADER_ID
, VERSION_START_DATE VERSION_START_DATE
, VERSION_END_DATE VERSION_END_DATE
, JOB_GROUP_ID JOB_GROUP_ID
, RULE_BASED_FLAG RULE_BASED_FLAG
, VALIDATED_FLAG VALIDATED_FLAG
, STATUS_CODE STATUS_CODE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER
, CURRENT_REPORTING_FLAG CURRENT_REPORTING_FLAG
, RESOURCE_CLASS_FLAG RESOURCE_CLASS_FLAG
, OLAP_ELEMENT_ID OLAP_ELEMENT_ID
FROM "PA"."PA_RBS_VERSIONS_B"