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_EXPLODED_V

Object Details

Object Name:	CSR_RULES_EXPLODED_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSR.CSR_RULES_EXPLODED_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
APPL_ID	NUMBER
RESP_ID	NUMBER
USER_ID	NUMBER
TERR_ID	NUMBER
RESOURCE_TYPE	VARCHAR2	(30)
RESOURCE_ID	NUMBER
ENABLED_FLAG	VARCHAR2	(1)	Yes
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	(4000)
SP_CONSIDER_STANDBY_SHIFTS	VARCHAR2	(4000)
SP_SPARES_MANDATORY	VARCHAR2	(4000)
SP_SPARES_SOURCE	VARCHAR2	(4000)
SP_MIN_TASK_LENGTH	NUMBER	(10)
SP_DEFAULT_SHIFT_DURATION	NUMBER	(10)
SP_DIST_LAST_CHILD_EFFORT	VARCHAR2	(4000)
SP_PICK_CONTRACT_RESOURCES	VARCHAR2	(4000)
SP_PICK_IB_RESOURCES	VARCHAR2	(4000)
SP_PICK_TERRITORY_RESOURCES	VARCHAR2	(4000)
SP_PICK_SKILLED_RESOURCES	VARCHAR2	(4000)
SP_AUTO_SCH_DEFAULT_QUERY	NUMBER	(10)
SP_AUTO_REJECT_STS_ID_SPARES	NUMBER	(10)
SP_AUTO_REJECT_STS_ID_OTHERS	NUMBER	(10)
SP_FORCE_OPTIMIZER_TO_GROUP	VARCHAR2	(4000)
SP_OPTIMIZER_SUCCESS_PERC	NUMBER	(10)
SP_COMMUTES_POSITION	VARCHAR2	(4000)
SP_COMMUTE_EXCLUDED_TIME	NUMBER	(10)
SP_COMMUTE_HOME_EMPTY_TRIP	VARCHAR2	(4000)
SP_ROUTER_MODE	VARCHAR2	(4000)
SP_TRAVEL_TIME_EXTRA	NUMBER	(10)
SP_DEFAULT_ROUTER_ENABLED	VARCHAR2	(4000)
SP_DEFAULT_TRAVEL_DISTANCE	NUMBER
SP_DEFAULT_TRAVEL_DURATION	NUMBER
SP_MAX_DISTANCE_IN_GROUP	NUMBER
SP_MAX_DIST_TO_SKIP_ACTUAL	NUMBER
SP_RESOURCE_PREFERENCE	VARCHAR2	(4000)
RC_ROUTER_CALC_TYPE	VARCHAR2	(4000)
RC_CONSIDER_TOLL_ROADS	VARCHAR2	(4000)
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
RULE_DOC	XMLTYPE	(64)

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
,      APPL_ID
,      RESP_ID
,      USER_ID
,      TERR_ID
,      RESOURCE_TYPE
,      RESOURCE_ID
,      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
,      SP_RESOURCE_PREFERENCE
,      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
,      RULE_DOC
FROM APPS.CSR_RULES_EXPLODED_V;

Dependencies

[top of page]

APPS.CSR_RULES_EXPLODED_V references the following:

APPS: CSR_RULES_B; CSR_RULES_TL
APPS_NE: window1532_COLL
SYS: STANDARD - show dependent code; XMLTYPE

APPS.CSR_RULES_EXPLODED_V is referenced by following:

APPS: CSR_RULES_TRANSLATED_V