[Home] [Help] [Dependency Information]
Object Name: | CSF_R_SCHED_REQUESTS# |
---|---|
Object Type: | VIEW |
Owner: | CSF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SCHED_REQUEST_ID | NUMBER | Yes | ||
RESULT_FLAG | VARCHAR2 | (1) | ||
CONCURRENT_REQUEST_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
SECURITY_GROUP_ID | NUMBER | |||
OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
PLANMODE | NUMBER | Yes | ||
SPARES_LIKELIHOOD | NUMBER | |||
SCHED_REQUEST_NAME | VARCHAR2 | (300) | Yes | |
EXTENDED_EFFORT | NUMBER | |||
PARENT_REQUEST_ID | NUMBER | |||
TARGET_STATUS_ID | NUMBER | |||
ROUTE_BASED_FLAG | VARCHAR2 | (1) | ||
CHANGED_OPTION_START | DATE | |||
CHANGED_OPTION_END | DATE | |||
CHANGED_PLANNED_START | DATE | |||
CHANGED_PLANNED_END | DATE | |||
DISABLED_ACCESS_HOURS_FLAG | VARCHAR2 | (1) | ||
CUSTOMER_CONF_RCVD | VARCHAR2 | (1) | ||
SPARES_LIKLIHOOD | NUMBER | |||
CONSIDER_STANDBY_SHIFT | VARCHAR2 | (20) | ||
SPARES_SOURCE | VARCHAR2 | (30) | ||
SPARES_MANDATORY | VARCHAR2 | (1) | ||
RES_PREFERENCE | VARCHAR2 | (30) | ||
CUST_OR_DISP_INITIATED | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT SCHED_REQUEST_ID
, RESULT_FLAG
, CONCURRENT_REQUEST_ID
, PROGRAM_UPDATE_DATE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
, PLANMODE
, SPARES_LIKELIHOOD
, SCHED_REQUEST_NAME
, EXTENDED_EFFORT
, PARENT_REQUEST_ID
, TARGET_STATUS_ID
, ROUTE_BASED_FLAG
, CHANGED_OPTION_START
, CHANGED_OPTION_END
, CHANGED_PLANNED_START
, CHANGED_PLANNED_END
, DISABLED_ACCESS_HOURS_FLAG
, CUSTOMER_CONF_RCVD
, SPARES_LIKLIHOOD
, CONSIDER_STANDBY_SHIFT
, SPARES_SOURCE
, SPARES_MANDATORY
, RES_PREFERENCE
, CUST_OR_DISP_INITIATED
FROM CSF.CSF_R_SCHED_REQUESTS#;
|
|
|