[Home] [Help] [Dependency Information]
Object Name: | CRP_DISPLAY_OPTIONS |
---|---|
Object Type: | TABLE |
Owner: | CRP |
FND Design Data: | CRP.CRP_DISPLAY_OPTIONS |
Subobject Name: | |
Status: | VALID |
CRP_DISPLAY_OPTIONS stores the user interface configuration of the
Horizontal window in the RCCP and CRP Inquiry form. A row is stored
for each user which specifies display details such as field width,
window size, and display factors for the Horizontal window.
Columns AVAILABLE_RATE to REPETITIVE_SCHEDULES are attribute display
indicators that indicates whether the corresponding attribute will be
displayed in the form. For example, if REQUIRED_RATE is set to 'Y',
then the required rate for assembly lines will be displayed in the
form.
User can change the configuration through the Preferences window in
CRPFCVCP form.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CRP_DISPLAY_OPTIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | USER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
USER_ID | NUMBER | Yes | User Identifier | |
DEFAULT_FLAG | NUMBER | Default setup indicator | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
SUMMARY_FIELD_WIDTH | NUMBER | Field width | ||
SUMMARY_DISPLAY_FACTOR | NUMBER | Display factor | ||
SUMMARY_WINDOW_SIZE | NUMBER | Window size | ||
SUMMARY_WINDOW_WIDTH | NUMBER | Window width | ||
SUMMARY_DECIMAL_PLACES | NUMBER | Number of decimal places | ||
AVAILABLE_RATE | VARCHAR2 | (1) | Attribute display indicator | |
REQUIRED_RATE | VARCHAR2 | (1) | Attribute display indicator | |
NET_AVAILABLE_RATE | VARCHAR2 | (1) | Attribute display indicator | |
CUM_AVAILABLE_RATE | VARCHAR2 | (1) | Attribute display indicator | |
RATE_UTILIZATION | VARCHAR2 | (1) | Attribute display indicator | |
CUM_RATE_UTILIZATION | VARCHAR2 | (1) | Attribute display indicator | |
DAILY_REQUIRED_RATE | VARCHAR2 | (1) | Attribute display indicator | |
DAILY_AVAILABLE_RATE | VARCHAR2 | (1) | Attribute display indicator | |
LINE_COST | VARCHAR2 | (1) | Attribute display indicator | |
HOURS_AVAILABLE | VARCHAR2 | (1) | Attribute display indicator | |
REQUIRED_HOURS | VARCHAR2 | (1) | Attribute display indicator | |
NET_HOURS_AVAILABLE | VARCHAR2 | (1) | Attribute display indicator | |
CUM_HOURS_AVAILABLE | VARCHAR2 | (1) | Attribute display indicator | |
ROUTING_UTILIZATION | VARCHAR2 | (1) | Attribute display indicator | |
CUM_ROUTING_UTILIZATION | VARCHAR2 | (1) | Attribute display indicator | |
HOURS_REQUIRED_PER_DAY | VARCHAR2 | (1) | Attribute display indicator | |
HOURS_AVAILABLE_PER_DAY | VARCHAR2 | (1) | Attribute display indicator | |
TOTAL_RESOURCE_COST | VARCHAR2 | (1) | Attribute display indicator | |
SUM_OF_CAPACITY_CHANGES | VARCHAR2 | (1) | Attribute display indicator | |
CUM_SUM_OF_CHANGES | VARCHAR2 | (1) | Attribute display indicator | |
PLANNED_ORDERS | VARCHAR2 | (1) | Attribute display indicator | |
NON_STANDARD_JOB_ORDERS | VARCHAR2 | (1) | Attribute display indicator | |
DISCRETE_JOBS | VARCHAR2 | (1) | Attribute display indicator | |
REPETITIVE_SCHEDULES | VARCHAR2 | (1) | Attribute display indicator |
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;
CRP.CRP_DISPLAY_OPTIONS does not reference any database object
CRP.CRP_DISPLAY_OPTIONS is referenced by following:
|
|
|