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

TABLE: CSR.CSR_RULES_B

Object Details
Object Name: CSR_RULES_B
Object Type: TABLE
Owner: CSR
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Unique Key: SYS_C00251201
  1. ColumnSYS_NC0031800319$
Indexes
Index Type Uniqueness Tablespace Column
CSR_RULES_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_DATA ColumnRULE_ID
CSR_RULES_B_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_DATA ColumnAPPL_ID
ColumnRESP_ID
ColumnUSER_ID
ColumnTERR_ID
ColumnRESOURCE_TYPE
ColumnRESOURCE_ID
ColumnENABLED_FLAG
SYS_C00251201 NORMAL UNIQUE TablespaceAPPS_TS_TX_DATA Column"SYS_NC00022$"."wtpParameters"."window"
SYS_IL0000509171C00019$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00020$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00022$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00023$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00026$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00031$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00036$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00041$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00046$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00051$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00056$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00061$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00066$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00071$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00076$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00081$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00086$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00091$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00096$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00101$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00106$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00111$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00116$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00121$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00126$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00131$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00136$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00141$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00146$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00151$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00156$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00161$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00166$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00171$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00176$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00181$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00186$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00189$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00192$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00197$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00202$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00207$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00212$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00217$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00222$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00227$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00232$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00237$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00242$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00247$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00250$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00253$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00258$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00263$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00268$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00273$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00278$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00283$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00288$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00293$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00298$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00303$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00308$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00313$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000509171C00316$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
CSR_RULES_B_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_DATA ColumnBASE_RULE_ID
Columns
Name Datatype Length Mandatory Comments
RULE_ID NUMBER
Yes
OBJECT_VERSION_NUMBER NUMBER
Yes
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
RULE_DOC XMLTYPE (2000)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RULE_ID
,      OBJECT_VERSION_NUMBER
,      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
,      RULE_DOC
FROM CSR.CSR_RULES_B;

Dependencies

[top of page]

CSR.CSR_RULES_B references the following:

SchemaAPPS_NE
TYPECommutesPositionType1456_T
TYPEConsiderStandbyShiftsTy1457_T
TYPEEnforcePlanWindowType1458_T
TYPEFloatExtType1462_T
TYPEIntExtType1463_T
TYPEPercentageType1459_T
TYPEResourcePrefType1451_T
TYPERouterCalcTypesType1454_T
TYPERouterModesType1455_T
TYPESparesMandatoryType1452_T
TYPESparesSourceType1453_T
TYPEYesNoType1460_T
TYPEschedulerRule1464_T
TYPEwindow1532_COLL
SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
TYPEXMLTYPE
TYPEXMLTYPEEXTRA
TYPEXMLTYPEPI
SchemaXDB
TYPEXDB$RAW_LIST_T
XML SCHEMAXDz3mhLe7ZYPHgQ5MVuYtJ8w==
CSR.CSR_RULES_B is referenced by following:

SchemaCSR
ViewCSR_RULES_B#