[Home] [Help] [Dependency Information]
Object Name: | CSR_RULES_TRANSLATED_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSR.CSR_RULES_TRANSLATED_V |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_ID | NUMBER | Yes | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
RULE_NAME | VARCHAR2 | (240) | Yes | |
DESCRIPTION | VARCHAR2 | (1000) | ||
BASE_RULE_ID | NUMBER | |||
BASE_RULE_NAME | VARCHAR2 | (240) | ||
APPLICATION_NAME | VARCHAR2 | (240) | ||
RESPONSIBILITY_NAME | VARCHAR2 | (100) | ||
USER_NAME | VARCHAR2 | (100) | ||
TERRITORY_NAME | VARCHAR2 | (2000) | ||
RESOURCE_TYPE_NAME | VARCHAR2 | (30) | ||
RESOURCE_NAME | VARCHAR2 | (360) | ||
ENABLED_FLAG | VARCHAR2 | (80) | ||
RULE_RANK | NUMBER | Yes | ||
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) | Yes | |
SP_PLAN_SCOPE | NUMBER | (10) | ||
SP_MAX_PLAN_OPTIONS | NUMBER | (10) | ||
SP_MAX_RESOURCES | NUMBER | (10) | ||
SP_MAX_CALC_TIME | NUMBER | (10) | ||
SP_MAX_OVERTIME | NUMBER | (10) | ||
SP_WTP_THRESHOLD | NUMBER | (10) | ||
SP_ENFORCE_PLAN_WINDOW | VARCHAR2 | (80) | ||
SP_CONSIDER_STANDBY_SHIFTS | VARCHAR2 | (80) | ||
SP_SPARES_MANDATORY | VARCHAR2 | (80) | ||
SP_SPARES_SOURCE | VARCHAR2 | (80) | ||
SP_MIN_TASK_LENGTH | NUMBER | (10) | ||
SP_DEFAULT_SHIFT_DURATION | NUMBER | (10) | ||
SP_DIST_LAST_CHILD_EFFORT | VARCHAR2 | (80) | ||
SP_PICK_CONTRACT_RESOURCES | VARCHAR2 | (80) | ||
SP_PICK_IB_RESOURCES | VARCHAR2 | (80) | ||
SP_PICK_TERRITORY_RESOURCES | VARCHAR2 | (80) | ||
SP_PICK_SKILLED_RESOURCES | VARCHAR2 | (80) | ||
SP_AUTO_SCH_DEFAULT_QUERY | VARCHAR2 | (30) | ||
SP_AUTO_REJECT_STS_ID_SPARES | VARCHAR2 | (30) | ||
SP_AUTO_REJECT_STS_ID_OTHERS | VARCHAR2 | (30) | ||
SP_FORCE_OPTIMIZER_TO_GROUP | VARCHAR2 | (80) | ||
SP_OPTIMIZER_SUCCESS_PERC | NUMBER | (10) | ||
SP_COMMUTES_POSITION | VARCHAR2 | (80) | ||
SP_COMMUTE_EXCLUDED_TIME | NUMBER | (10) | ||
SP_COMMUTE_HOME_EMPTY_TRIP | VARCHAR2 | (80) | ||
SP_ROUTER_MODE | VARCHAR2 | (80) | ||
SP_TRAVEL_TIME_EXTRA | NUMBER | (10) | ||
SP_DEFAULT_ROUTER_ENABLED | VARCHAR2 | (80) | ||
SP_DEFAULT_TRAVEL_DISTANCE | NUMBER | |||
SP_DEFAULT_TRAVEL_DURATION | NUMBER | |||
SP_MAX_DISTANCE_IN_GROUP | NUMBER | |||
SP_MAX_DIST_TO_SKIP_ACTUAL | NUMBER | |||
RC_ROUTER_CALC_TYPE | VARCHAR2 | (80) | ||
RC_CONSIDER_TOLL_ROADS | VARCHAR2 | (80) | ||
RC_ROUTE_FUNC_DELAY_0 | NUMBER | |||
RC_ROUTE_FUNC_DELAY_1 | NUMBER | |||
RC_ROUTE_FUNC_DELAY_2 | NUMBER | |||
RC_ROUTE_FUNC_DELAY_3 | NUMBER | |||
RC_ROUTE_FUNC_DELAY_4 | NUMBER | |||
RC_ESTIMATE_FIRST_BOUNDARY | NUMBER | |||
RC_ESTIMATE_SECOND_BOUNDARY | NUMBER | |||
RC_ESTIMATE_FIRST_AVG_SPEED | NUMBER | |||
RC_ESTIMATE_SECOND_AVG_SPEED | NUMBER | |||
RC_ESTIMATE_THIRD_AVG_SPEED | NUMBER | |||
CP_TASK_PER_DAY_DELAYED | NUMBER | |||
CP_TASK_PER_MIN_EARLY | NUMBER | |||
CP_TASK_PER_MIN_LATE | NUMBER | |||
CP_TLS_PER_DAY_EXTRA | NUMBER | |||
CP_TLS_PER_CHILD_EXTRA | NUMBER | |||
CP_PARTS_VIOLATION | NUMBER | |||
CP_RES_PER_MIN_OVERTIME | NUMBER | |||
CP_RES_ASSIGNED_NOT_PREF | NUMBER | |||
CP_RES_SKILL_LEVEL | NUMBER | |||
CP_STANDBY_SHIFT_USAGE | NUMBER | |||
CP_TRAVEL_PER_UNIT_DISTANCE | NUMBER | |||
CP_TRAVEL_PER_UNIT_DURATION | NUMBER | |||
CP_DEFER_SAME_SITE | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT RULE_ID
, OBJECT_VERSION_NUMBER
, RULE_NAME
, DESCRIPTION
, BASE_RULE_ID
, BASE_RULE_NAME
, APPLICATION_NAME
, RESPONSIBILITY_NAME
, USER_NAME
, TERRITORY_NAME
, RESOURCE_TYPE_NAME
, RESOURCE_NAME
, ENABLED_FLAG
, RULE_RANK
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, SP_PLAN_SCOPE
, SP_MAX_PLAN_OPTIONS
, SP_MAX_RESOURCES
, SP_MAX_CALC_TIME
, SP_MAX_OVERTIME
, SP_WTP_THRESHOLD
, SP_ENFORCE_PLAN_WINDOW
, SP_CONSIDER_STANDBY_SHIFTS
, SP_SPARES_MANDATORY
, SP_SPARES_SOURCE
, SP_MIN_TASK_LENGTH
, SP_DEFAULT_SHIFT_DURATION
, SP_DIST_LAST_CHILD_EFFORT
, SP_PICK_CONTRACT_RESOURCES
, SP_PICK_IB_RESOURCES
, SP_PICK_TERRITORY_RESOURCES
, SP_PICK_SKILLED_RESOURCES
, SP_AUTO_SCH_DEFAULT_QUERY
, SP_AUTO_REJECT_STS_ID_SPARES
, SP_AUTO_REJECT_STS_ID_OTHERS
, SP_FORCE_OPTIMIZER_TO_GROUP
, SP_OPTIMIZER_SUCCESS_PERC
, SP_COMMUTES_POSITION
, SP_COMMUTE_EXCLUDED_TIME
, SP_COMMUTE_HOME_EMPTY_TRIP
, SP_ROUTER_MODE
, SP_TRAVEL_TIME_EXTRA
, SP_DEFAULT_ROUTER_ENABLED
, SP_DEFAULT_TRAVEL_DISTANCE
, SP_DEFAULT_TRAVEL_DURATION
, SP_MAX_DISTANCE_IN_GROUP
, SP_MAX_DIST_TO_SKIP_ACTUAL
, RC_ROUTER_CALC_TYPE
, RC_CONSIDER_TOLL_ROADS
, RC_ROUTE_FUNC_DELAY_0
, RC_ROUTE_FUNC_DELAY_1
, RC_ROUTE_FUNC_DELAY_2
, RC_ROUTE_FUNC_DELAY_3
, RC_ROUTE_FUNC_DELAY_4
, RC_ESTIMATE_FIRST_BOUNDARY
, RC_ESTIMATE_SECOND_BOUNDARY
, RC_ESTIMATE_FIRST_AVG_SPEED
, RC_ESTIMATE_SECOND_AVG_SPEED
, RC_ESTIMATE_THIRD_AVG_SPEED
, CP_TASK_PER_DAY_DELAYED
, CP_TASK_PER_MIN_EARLY
, CP_TASK_PER_MIN_LATE
, CP_TLS_PER_DAY_EXTRA
, CP_TLS_PER_CHILD_EXTRA
, CP_PARTS_VIOLATION
, CP_RES_PER_MIN_OVERTIME
, CP_RES_ASSIGNED_NOT_PREF
, CP_RES_SKILL_LEVEL
, CP_STANDBY_SHIFT_USAGE
, CP_TRAVEL_PER_UNIT_DISTANCE
, CP_TRAVEL_PER_UNIT_DURATION
, CP_DEFER_SAME_SITE
FROM APPS.CSR_RULES_TRANSLATED_V;
APPS.CSR_RULES_TRANSLATED_V is not referenced by any database object
|
|
|