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.

[Home] [Help]

View: CSR_RULES_EXPLODED_V

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

View Text

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')