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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.CSR_RULES_TRANSLATED_V

Object Details

Object Name:	CSR_RULES_TRANSLATED_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSR.CSR_RULES_TRANSLATED_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
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

Query Text

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;

Dependencies

[top of page]

APPS.CSR_RULES_TRANSLATED_V references the following:

APPS: CSF_DC_QUERIES_VL; CSR_RULES_EXPLODED_V; CSR_RULES_TL; FND_APPLICATION_TL; FND_GLOBAL - show dependent code; FND_LOOKUPS; FND_RESPONSIBILITY_TL; FND_USER; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; JTF_OBJECTS_VL; JTF_RS_ALL_RESOURCES_VL; JTF_TASK_STATUSES_VL; JTF_TERR_ALL
APPS_NE: window1532_COLL

APPS.CSR_RULES_TRANSLATED_V is not referenced by any database object