[Home] [Help] [Dependency Information]
Object Name: | CRP_DISPLAY_OPTIONS# |
---|---|
Object Type: | VIEW |
Owner: | CRP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USER_ID | NUMBER | Yes | ||
DEFAULT_FLAG | NUMBER | |||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
SUMMARY_FIELD_WIDTH | NUMBER | |||
SUMMARY_DISPLAY_FACTOR | NUMBER | |||
SUMMARY_WINDOW_SIZE | NUMBER | |||
SUMMARY_WINDOW_WIDTH | NUMBER | |||
SUMMARY_DECIMAL_PLACES | NUMBER | |||
AVAILABLE_RATE | VARCHAR2 | (1) | ||
REQUIRED_RATE | VARCHAR2 | (1) | ||
NET_AVAILABLE_RATE | VARCHAR2 | (1) | ||
CUM_AVAILABLE_RATE | VARCHAR2 | (1) | ||
RATE_UTILIZATION | VARCHAR2 | (1) | ||
CUM_RATE_UTILIZATION | VARCHAR2 | (1) | ||
DAILY_REQUIRED_RATE | VARCHAR2 | (1) | ||
DAILY_AVAILABLE_RATE | VARCHAR2 | (1) | ||
LINE_COST | VARCHAR2 | (1) | ||
HOURS_AVAILABLE | VARCHAR2 | (1) | ||
REQUIRED_HOURS | VARCHAR2 | (1) | ||
NET_HOURS_AVAILABLE | VARCHAR2 | (1) | ||
CUM_HOURS_AVAILABLE | VARCHAR2 | (1) | ||
ROUTING_UTILIZATION | VARCHAR2 | (1) | ||
CUM_ROUTING_UTILIZATION | VARCHAR2 | (1) | ||
HOURS_REQUIRED_PER_DAY | VARCHAR2 | (1) | ||
HOURS_AVAILABLE_PER_DAY | VARCHAR2 | (1) | ||
TOTAL_RESOURCE_COST | VARCHAR2 | (1) | ||
SUM_OF_CAPACITY_CHANGES | VARCHAR2 | (1) | ||
CUM_SUM_OF_CHANGES | VARCHAR2 | (1) | ||
PLANNED_ORDERS | VARCHAR2 | (1) | ||
NON_STANDARD_JOB_ORDERS | VARCHAR2 | (1) | ||
DISCRETE_JOBS | VARCHAR2 | (1) | ||
REPETITIVE_SCHEDULES | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT USER_ID
, DEFAULT_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, SUMMARY_FIELD_WIDTH
, SUMMARY_DISPLAY_FACTOR
, SUMMARY_WINDOW_SIZE
, SUMMARY_WINDOW_WIDTH
, SUMMARY_DECIMAL_PLACES
, AVAILABLE_RATE
, REQUIRED_RATE
, NET_AVAILABLE_RATE
, CUM_AVAILABLE_RATE
, RATE_UTILIZATION
, CUM_RATE_UTILIZATION
, DAILY_REQUIRED_RATE
, DAILY_AVAILABLE_RATE
, LINE_COST
, HOURS_AVAILABLE
, REQUIRED_HOURS
, NET_HOURS_AVAILABLE
, CUM_HOURS_AVAILABLE
, ROUTING_UTILIZATION
, CUM_ROUTING_UTILIZATION
, HOURS_REQUIRED_PER_DAY
, HOURS_AVAILABLE_PER_DAY
, TOTAL_RESOURCE_COST
, SUM_OF_CAPACITY_CHANGES
, CUM_SUM_OF_CHANGES
, PLANNED_ORDERS
, NON_STANDARD_JOB_ORDERS
, DISCRETE_JOBS
, REPETITIVE_SCHEDULES
FROM CRP.CRP_DISPLAY_OPTIONS#;
|
|
|