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.

VIEW: APPS.CSR_RULES_EXPLODED_V

Source

View Text - Preformatted


SELECT rb.rule_id
       , rb.object_version_number
       , rt.rule_name
       , rt.description
       , rb.base_rule_id
       , rb.appl_id
       , rb.resp_id
       , rb.user_id
       , rb.terr_id
       , rb.resource_type
       , rb.resource_id
       , rb.enabled_flag
       , rb.rule_rank
       , rb.created_by
       , rb.creation_date
       , rb.last_updated_by
       , rb.last_update_date
       , rb.last_update_login
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spPlanScope')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spMaxPlanOptions')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spMaxResources')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spMaxCalcTime')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spMaxOvertime')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spWtpThreshold')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spEnforcePlanWindow')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spConsiderStandbyShifts')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spSparesMandatory')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spSparesSource')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spMinTaskLength')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spDefaultShiftDuration')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spDistLastChildEffort')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spPickContractResources')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spPickIbResources')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spPickTerritoryResources')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spPickSkilledResources')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spAutoSchDefaultQuery')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spAutoRejectStsIdSpares')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spAutoRejectStsIdOthers')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spForceOptimizerToGroup')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spOptimizerSuccessPerc')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spCommutesPosition')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spCommuteExcludedTime')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spCommuteHomeEmptyTrip')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spRouterMode')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spTravelTimeExtra')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spDefaultRouterEnabled')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spDefaultTravelDistance')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spDefaultTravelDuration')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spMaxDistanceInGroup')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spMaxDistToSkipActual')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/schedulerParameters/spResourcePreference')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/routerConfig/rcRouterCalcType')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/routerConfig/rcConsiderTollRoads')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/routerConfig/rcRouteFuncDelay0')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/routerConfig/rcRouteFuncDelay1')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/routerConfig/rcRouteFuncDelay2')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/routerConfig/rcRouteFuncDelay3')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/routerConfig/rcRouteFuncDelay4')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/routerConfig/rcEstimateFirstBoundary')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/routerConfig/rcEstimateSecondBoundary')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/routerConfig/rcEstimateFirstAvgSpeed')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/routerConfig/rcEstimateSecondAvgSpeed')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/routerConfig/rcEstimateThirdAvgSpeed')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/costParameters/cpTaskPerDayDelayed')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/costParameters/cpTaskPerMinEarly')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/costParameters/cpTaskPerMinLate')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/costParameters/cpTlsPerDayExtra')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/costParameters/cpTlsPerChildExtra')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/costParameters/cpPartsViolation')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/costParameters/cpResPerMinOvertime')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/costParameters/cpResAssignedNotPref')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/costParameters/cpResSkillLevel')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/costParameters/cpStandbyShiftUsage')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/costParameters/cpTravelPerUnitDistance')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/costParameters/cpTravelPerUnitDuration')
       , EXTRACTVALUE(rb.rule_doc, 'schedulerRule/costParameters/cpDeferSameSite')
       , rb.rule_doc
    FROM csr_rules_b rb, csr_rules_tl rt
   WHERE rb.rule_id = rt.rule_id AND rt.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT RB.RULE_ID
, RB.OBJECT_VERSION_NUMBER
, RT.RULE_NAME
, RT.DESCRIPTION
, RB.BASE_RULE_ID
, RB.APPL_ID
, RB.RESP_ID
, RB.USER_ID
, RB.TERR_ID
, RB.RESOURCE_TYPE
, RB.RESOURCE_ID
, RB.ENABLED_FLAG
, RB.RULE_RANK
, RB.CREATED_BY
, RB.CREATION_DATE
, RB.LAST_UPDATED_BY
, RB.LAST_UPDATE_DATE
, RB.LAST_UPDATE_LOGIN
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPPLANSCOPE')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPMAXPLANOPTIONS')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPMAXRESOURCES')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPMAXCALCTIME')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPMAXOVERTIME')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPWTPTHRESHOLD')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPENFORCEPLANWINDOW')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPCONSIDERSTANDBYSHIFTS')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPSPARESMANDATORY')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPSPARESSOURCE')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPMINTASKLENGTH')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPDEFAULTSHIFTDURATION')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPDISTLASTCHILDEFFORT')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPPICKCONTRACTRESOURCES')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPPICKIBRESOURCES')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPPICKTERRITORYRESOURCES')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPPICKSKILLEDRESOURCES')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPAUTOSCHDEFAULTQUERY')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPAUTOREJECTSTSIDSPARES')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPAUTOREJECTSTSIDOTHERS')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPFORCEOPTIMIZERTOGROUP')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPOPTIMIZERSUCCESSPERC')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPCOMMUTESPOSITION')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPCOMMUTEEXCLUDEDTIME')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPCOMMUTEHOMEEMPTYTRIP')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPROUTERMODE')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPTRAVELTIMEEXTRA')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPDEFAULTROUTERENABLED')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPDEFAULTTRAVELDISTANCE')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPDEFAULTTRAVELDURATION')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPMAXDISTANCEINGROUP')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPMAXDISTTOSKIPACTUAL')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/SCHEDULERPARAMETERS/SPRESOURCEPREFERENCE')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/ROUTERCONFIG/RCROUTERCALCTYPE')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/ROUTERCONFIG/RCCONSIDERTOLLROADS')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/ROUTERCONFIG/RCROUTEFUNCDELAY0')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/ROUTERCONFIG/RCROUTEFUNCDELAY1')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/ROUTERCONFIG/RCROUTEFUNCDELAY2')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/ROUTERCONFIG/RCROUTEFUNCDELAY3')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/ROUTERCONFIG/RCROUTEFUNCDELAY4')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/ROUTERCONFIG/RCESTIMATEFIRSTBOUNDARY')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/ROUTERCONFIG/RCESTIMATESECONDBOUNDARY')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/ROUTERCONFIG/RCESTIMATEFIRSTAVGSPEED')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/ROUTERCONFIG/RCESTIMATESECONDAVGSPEED')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/ROUTERCONFIG/RCESTIMATETHIRDAVGSPEED')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/COSTPARAMETERS/CPTASKPERDAYDELAYED')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/COSTPARAMETERS/CPTASKPERMINEARLY')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/COSTPARAMETERS/CPTASKPERMINLATE')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/COSTPARAMETERS/CPTLSPERDAYEXTRA')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/COSTPARAMETERS/CPTLSPERCHILDEXTRA')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/COSTPARAMETERS/CPPARTSVIOLATION')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/COSTPARAMETERS/CPRESPERMINOVERTIME')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/COSTPARAMETERS/CPRESASSIGNEDNOTPREF')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/COSTPARAMETERS/CPRESSKILLLEVEL')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/COSTPARAMETERS/CPSTANDBYSHIFTUSAGE')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/COSTPARAMETERS/CPTRAVELPERUNITDISTANCE')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/COSTPARAMETERS/CPTRAVELPERUNITDURATION')
, EXTRACTVALUE(RB.RULE_DOC
, 'SCHEDULERRULE/COSTPARAMETERS/CPDEFERSAMESITE')
, RB.RULE_DOC
FROM CSR_RULES_B RB
, CSR_RULES_TL RT
WHERE RB.RULE_ID = RT.RULE_ID
AND RT.LANGUAGE = USERENV('LANG')