View: CSR_RULES_TRANSLATED_V

Product:	CSR - Scheduler
Description:
Implementation/DBA Data:	APPS.CSR_RULES_TRANSLATED_V

View Text

SELECT R.RULE_ID
, R.OBJECT_VERSION_NUMBER
, R.RULE_NAME
, R.DESCRIPTION
, R.BASE_RULE_ID
, BASE.RULE_NAME BASE_RULE_NAME
, APPL.APPLICATION_NAME
, RESP.RESPONSIBILITY_NAME
, U.USER_NAME
, TERR.NAME TERRITORY_NAME
, (SELECT O.NAME
FROM JTF_OBJECTS_VL O
WHERE O.OBJECT_CODE = R.RESOURCE_TYPE) RESOURCE_TYPE_NAME
, RES.RESOURCE_NAME
, (SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO'
AND LOOKUP_CODE = DECODE(R.ENABLED_FLAG
, 'Y'
, 'Y'
, 'N')) ENABLED_FLAG
, R.RULE_RANK
, R.CREATED_BY
, R.CREATION_DATE
, R.LAST_UPDATED_BY
, R.LAST_UPDATE_DATE
, R.LAST_UPDATE_LOGIN
, R.SP_PLAN_SCOPE
, R.SP_MAX_PLAN_OPTIONS
, R.SP_MAX_RESOURCES
, R.SP_MAX_CALC_TIME
, R.SP_MAX_OVERTIME
, R.SP_WTP_THRESHOLD
, (SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'CSR_ENFORCE_PLAN_WINDOW'
AND LOOKUP_CODE = R.SP_ENFORCE_PLAN_WINDOW) SP_ENFORCE_PLAN_WINDOW
, (SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'CSR_CONSIDER_STANDBY_SHIFTS'
AND LOOKUP_CODE = R.SP_CONSIDER_STANDBY_SHIFTS) SP_CONSIDER_STANDBY_SHIFTS
, (SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO'
AND LOOKUP_CODE = R.SP_SPARES_MANDATORY) SP_SPARES_MANDATORY
, (SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'CSR_SPARES_SOURCE'
AND LOOKUP_CODE = R.SP_SPARES_SOURCE) SP_SPARES_SOURCE
, R.SP_MIN_TASK_LENGTH
, R.SP_DEFAULT_SHIFT_DURATION
, (SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO'
AND LOOKUP_CODE = R.SP_DIST_LAST_CHILD_EFFORT) SP_DIST_LAST_CHILD_EFFORT
, (SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO'
AND LOOKUP_CODE = R.SP_PICK_CONTRACT_RESOURCES) SP_PICK_CONTRACT_RESOURCES
, (SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO'
AND LOOKUP_CODE = R.SP_PICK_IB_RESOURCES) SP_PICK_IB_RESOURCES
, (SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO'
AND LOOKUP_CODE = R.SP_PICK_TERRITORY_RESOURCES) SP_PICK_TERRITORY_RESOURCES
, (SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO'
AND LOOKUP_CODE = R.SP_PICK_SKILLED_RESOURCES) SP_PICK_SKILLED_RESOURCES
, (SELECT NAME
FROM CSF_DC_QUERIES_VL
WHERE QUERY_ID = R.SP_AUTO_SCH_DEFAULT_QUERY) SP_AUTO_SCH_DEFAULT_QUERY
, (SELECT NAME
FROM JTF_TASK_STATUSES_VL
WHERE TASK_STATUS_ID = R.SP_AUTO_REJECT_STS_ID_SPARES) SP_AUTO_REJECT_STS_ID_SPARES
, (SELECT NAME
FROM JTF_TASK_STATUSES_VL
WHERE TASK_STATUS_ID = R.SP_AUTO_REJECT_STS_ID_OTHERS) SP_AUTO_REJECT_STS_ID_OTHERS
, (SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO'
AND LOOKUP_CODE = R.SP_FORCE_OPTIMIZER_TO_GROUP) SP_FORCE_OPTIMIZER_TO_GROUP
, R.SP_OPTIMIZER_SUCCESS_PERC
, (SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'CSR_COMMUTES_POSITION_TYPE'
AND LOOKUP_CODE = R.SP_COMMUTES_POSITION) SP_COMMUTES_POSITION
, R.SP_COMMUTE_EXCLUDED_TIME
, (SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO'
AND LOOKUP_CODE = R.SP_COMMUTE_HOME_EMPTY_TRIP) SP_COMMUTE_HOME_EMPTY_TRIP
, (SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'CSR_ROUTER_MODES'
AND LOOKUP_CODE = R.SP_ROUTER_MODE) SP_ROUTER_MODE
, R.SP_TRAVEL_TIME_EXTRA
, (SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO'
AND LOOKUP_CODE = R.SP_DEFAULT_ROUTER_ENABLED) SP_DEFAULT_ROUTER_ENABLED
, R.SP_DEFAULT_TRAVEL_DISTANCE
, R.SP_DEFAULT_TRAVEL_DURATION
, R.SP_MAX_DISTANCE_IN_GROUP
, R.SP_MAX_DIST_TO_SKIP_ACTUAL
, (SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'CSR_ROUTER_CALC_TYPES'
AND LOOKUP_CODE = R.RC_ROUTER_CALC_TYPE) RC_ROUTER_CALC_TYPE
, (SELECT MEANING
FROM FND_LOOKUPS
WHERE LOOKUP_TYPE = 'YES_NO'
AND LOOKUP_CODE = R.RC_CONSIDER_TOLL_ROADS) RC_CONSIDER_TOLL_ROADS
, R.RC_ROUTE_FUNC_DELAY_0
, R.RC_ROUTE_FUNC_DELAY_1
, R.RC_ROUTE_FUNC_DELAY_2
, R.RC_ROUTE_FUNC_DELAY_3
, R.RC_ROUTE_FUNC_DELAY_4
, R.RC_ESTIMATE_FIRST_BOUNDARY
, R.RC_ESTIMATE_SECOND_BOUNDARY
, R.RC_ESTIMATE_FIRST_AVG_SPEED
, R.RC_ESTIMATE_SECOND_AVG_SPEED
, R.RC_ESTIMATE_THIRD_AVG_SPEED
, R.CP_TASK_PER_DAY_DELAYED
, R.CP_TASK_PER_MIN_EARLY
, R.CP_TASK_PER_MIN_LATE
, R.CP_TLS_PER_DAY_EXTRA
, R.CP_TLS_PER_CHILD_EXTRA
, R.CP_PARTS_VIOLATION
, R.CP_RES_PER_MIN_OVERTIME
, R.CP_RES_ASSIGNED_NOT_PREF
, R.CP_RES_SKILL_LEVEL
, R.CP_STANDBY_SHIFT_USAGE
, R.CP_TRAVEL_PER_UNIT_DISTANCE
, R.CP_TRAVEL_PER_UNIT_DURATION
, R.CP_DEFER_SAME_SITE
FROM CSR_RULES_EXPLODED_V R
, FND_APPLICATION_TL APPL
, FND_RESPONSIBILITY_TL RESP
, FND_USER U
, JTF_TERR_ALL TERR
, JTF_RS_ALL_RESOURCES_VL RES
, CSR_RULES_TL BASE
WHERE APPL.APPLICATION_ID(+) = R.APPL_ID
AND APPL.LANGUAGE(+) = USERENV( 'LANG' )
AND RESP.RESPONSIBILITY_ID(+) = R.RESP_ID
AND RESP.LANGUAGE(+) = USERENV( 'LANG' )
AND U.USER_ID(+) = R.USER_ID
AND TERR.TERR_ID(+) = R.TERR_ID
AND RES.RESOURCE_ID(+) = R.RESOURCE_ID
AND RES.RESOURCE_TYPE(+) = R.RESOURCE_TYPE
AND BASE.RULE_ID(+) = R.BASE_RULE_ID
AND BASE.LANGUAGE(+) = USERENV( 'LANG' )