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: CRP.CRP_DISPLAY_OPTIONS#

Source

View Text - Preformatted


select USER_ID USER_ID, DEFAULT_FLAG DEFAULT_FLAG, 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, SUMMARY_FIELD_WIDTH SUMMARY_FIELD_WIDTH, SUMMARY_DISPLAY_FACTOR SUMMARY_DISPLAY_FACTOR, SUMMARY_WINDOW_SIZE SUMMARY_WINDOW_SIZE, SUMMARY_WINDOW_WIDTH SUMMARY_WINDOW_WIDTH, SUMMARY_DECIMAL_PLACES SUMMARY_DECIMAL_PLACES, AVAILABLE_RATE AVAILABLE_RATE, REQUIRED_RATE REQUIRED_RATE, NET_AVAILABLE_RATE NET_AVAILABLE_RATE, CUM_AVAILABLE_RATE CUM_AVAILABLE_RATE, RATE_UTILIZATION RATE_UTILIZATION, CUM_RATE_UTILIZATION CUM_RATE_UTILIZATION, DAILY_REQUIRED_RATE DAILY_REQUIRED_RATE, DAILY_AVAILABLE_RATE DAILY_AVAILABLE_RATE, LINE_COST LINE_COST, HOURS_AVAILABLE HOURS_AVAILABLE, REQUIRED_HOURS REQUIRED_HOURS, NET_HOURS_AVAILABLE NET_HOURS_AVAILABLE, CUM_HOURS_AVAILABLE CUM_HOURS_AVAILABLE, ROUTING_UTILIZATION ROUTING_UTILIZATION, CUM_ROUTING_UTILIZATION CUM_ROUTING_UTILIZATION, HOURS_REQUIRED_PER_DAY HOURS_REQUIRED_PER_DAY, HOURS_AVAILABLE_PER_DAY HOURS_AVAILABLE_PER_DAY, TOTAL_RESOURCE_COST TOTAL_RESOURCE_COST, SUM_OF_CAPACITY_CHANGES SUM_OF_CAPACITY_CHANGES, CUM_SUM_OF_CHANGES CUM_SUM_OF_CHANGES, PLANNED_ORDERS PLANNED_ORDERS, NON_STANDARD_JOB_ORDERS NON_STANDARD_JOB_ORDERS, DISCRETE_JOBS DISCRETE_JOBS, REPETITIVE_SCHEDULES REPETITIVE_SCHEDULES from "CRP"."CRP_DISPLAY_OPTIONS"

View Text - HTML Formatted

SELECT USER_ID USER_ID
, DEFAULT_FLAG DEFAULT_FLAG
, 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
, SUMMARY_FIELD_WIDTH SUMMARY_FIELD_WIDTH
, SUMMARY_DISPLAY_FACTOR SUMMARY_DISPLAY_FACTOR
, SUMMARY_WINDOW_SIZE SUMMARY_WINDOW_SIZE
, SUMMARY_WINDOW_WIDTH SUMMARY_WINDOW_WIDTH
, SUMMARY_DECIMAL_PLACES SUMMARY_DECIMAL_PLACES
, AVAILABLE_RATE AVAILABLE_RATE
, REQUIRED_RATE REQUIRED_RATE
, NET_AVAILABLE_RATE NET_AVAILABLE_RATE
, CUM_AVAILABLE_RATE CUM_AVAILABLE_RATE
, RATE_UTILIZATION RATE_UTILIZATION
, CUM_RATE_UTILIZATION CUM_RATE_UTILIZATION
, DAILY_REQUIRED_RATE DAILY_REQUIRED_RATE
, DAILY_AVAILABLE_RATE DAILY_AVAILABLE_RATE
, LINE_COST LINE_COST
, HOURS_AVAILABLE HOURS_AVAILABLE
, REQUIRED_HOURS REQUIRED_HOURS
, NET_HOURS_AVAILABLE NET_HOURS_AVAILABLE
, CUM_HOURS_AVAILABLE CUM_HOURS_AVAILABLE
, ROUTING_UTILIZATION ROUTING_UTILIZATION
, CUM_ROUTING_UTILIZATION CUM_ROUTING_UTILIZATION
, HOURS_REQUIRED_PER_DAY HOURS_REQUIRED_PER_DAY
, HOURS_AVAILABLE_PER_DAY HOURS_AVAILABLE_PER_DAY
, TOTAL_RESOURCE_COST TOTAL_RESOURCE_COST
, SUM_OF_CAPACITY_CHANGES SUM_OF_CAPACITY_CHANGES
, CUM_SUM_OF_CHANGES CUM_SUM_OF_CHANGES
, PLANNED_ORDERS PLANNED_ORDERS
, NON_STANDARD_JOB_ORDERS NON_STANDARD_JOB_ORDERS
, DISCRETE_JOBS DISCRETE_JOBS
, REPETITIVE_SCHEDULES REPETITIVE_SCHEDULES
FROM "CRP"."CRP_DISPLAY_OPTIONS"