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_RESOURCE_LISTS_ALL_BG#

Source

View Text - Preformatted


select RESOURCE_LIST_ID RESOURCE_LIST_ID, NAME NAME, DESCRIPTION DESCRIPTION, PUBLIC_FLAG PUBLIC_FLAG, GROUP_RESOURCE_TYPE_ID GROUP_RESOURCE_TYPE_ID, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, UNCATEGORIZED_FLAG UNCATEGORIZED_FLAG, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ADW_NOTIFY_FLAG ADW_NOTIFY_FLAG, JOB_GROUP_ID JOB_GROUP_ID, RESOURCE_LIST_TYPE RESOURCE_LIST_TYPE, CONTROL_FLAG CONTROL_FLAG, USE_FOR_WP_FLAG USE_FOR_WP_FLAG, MIGRATION_CODE MIGRATION_CODE, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, MIGRATED_RBS_VERSION_ID MIGRATED_RBS_VERSION_ID, RESOURCE_CLASS_FLAG RESOURCE_CLASS_FLAG, ITEM_MASTER_ID ITEM_MASTER_ID, ITEM_CATEGORY_SET_ID ITEM_CATEGORY_SET_ID, DEFAULT_EXPENDITURE_TYPE DEFAULT_EXPENDITURE_TYPE, DEFAULT_COST_TYPE_ID DEFAULT_COST_TYPE_ID, ZD_EDITION_NAME ZD_EDITION_NAME from "PA"."PA_RESOURCE_LISTS_ALL_BG"

View Text - HTML Formatted

SELECT RESOURCE_LIST_ID RESOURCE_LIST_ID
, NAME NAME
, DESCRIPTION DESCRIPTION
, PUBLIC_FLAG PUBLIC_FLAG
, GROUP_RESOURCE_TYPE_ID GROUP_RESOURCE_TYPE_ID
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, UNCATEGORIZED_FLAG UNCATEGORIZED_FLAG
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ADW_NOTIFY_FLAG ADW_NOTIFY_FLAG
, JOB_GROUP_ID JOB_GROUP_ID
, RESOURCE_LIST_TYPE RESOURCE_LIST_TYPE
, CONTROL_FLAG CONTROL_FLAG
, USE_FOR_WP_FLAG USE_FOR_WP_FLAG
, MIGRATION_CODE MIGRATION_CODE
, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER
, MIGRATED_RBS_VERSION_ID MIGRATED_RBS_VERSION_ID
, RESOURCE_CLASS_FLAG RESOURCE_CLASS_FLAG
, ITEM_MASTER_ID ITEM_MASTER_ID
, ITEM_CATEGORY_SET_ID ITEM_CATEGORY_SET_ID
, DEFAULT_EXPENDITURE_TYPE DEFAULT_EXPENDITURE_TYPE
, DEFAULT_COST_TYPE_ID DEFAULT_COST_TYPE_ID
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "PA"."PA_RESOURCE_LISTS_ALL_BG"