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

TABLE: CE.CE_UK_VAL_MODULUS_WEIGHTS

Object Details
Object Name: CE_UK_VAL_MODULUS_WEIGHTS
Object Type: TABLE
Owner: CE
FND Design Data: TableCE.CE_UK_VAL_MODULUS_WEIGHTS
Subobject Name:
Status: VALID

The CE_UK_VAL_MODULUS_WEIGHTS table stores the modulus weights used for UK Domestic Account Number validations.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CE_UK_VAL_MODULUS_WEIGHTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMODULUS_CHECK_ID
CE_UK_VAL_MODULUS_WEIGHTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFROM_SORT_CODE
ColumnTO_SORT_CODE
Columns
Name Datatype Length Mandatory Comments
MODULUS_CHECK_ID NUMBER (15) Yes Modulus Check Identifier.
FROM_SORT_CODE VARCHAR2 (6) Yes Start of range for sort code.
TO_SORT_CODE VARCHAR2 (6) Yes End of range for sort code.
CHECK_TYPE VARCHAR2 (5) Yes The modulus algorithm which has to be applied.
WEIGHT_U NUMBER
Yes Modulus weight for digit 1 of sort code.
WEIGHT_V NUMBER
Yes Modulus weight for digit 2 of sort code.
WEIGHT_W NUMBER
Yes Modulus weight for digit 3 of sort code.
WEIGHT_X NUMBER
Yes Modulus weight for digit 4 of sort code.
WEIGHT_Y NUMBER
Yes Modulus weight for digit 5 of sort code.
WEIGHT_Z NUMBER
Yes Modulus weight for digit 6 of sort code.
WEIGHT_A NUMBER
Yes Modulus weight for digit 1 of account number.
WEIGHT_B NUMBER
Yes Modulus weight for digit 2 of account number.
WEIGHT_C NUMBER
Yes Modulus weight for digit 3 of account number.
WEIGHT_D NUMBER
Yes Modulus weight for digit 4 of account number.
WEIGHT_E NUMBER
Yes Modulus weight for digit 5 of account number.
WEIGHT_F NUMBER
Yes Modulus weight for digit 6 of account number.
WEIGHT_G NUMBER
Yes Modulus weight for digit 7 of account number.
WEIGHT_H NUMBER
Yes Modulus weight for digit 8 of account number.
EXCEPTION_CODE NUMBER

Exception to be applied.
REQUEST_ID NUMBER (15) Yes ID of Concurrent request which created the data.
CREATED_BY NUMBER (15) Yes Standard WHO Column.
CREATION_DATE DATE
Yes Standard WHO Column.
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO Column.
LAST_UPDATE_DATE DATE
Yes Standard WHO Column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO Column.
Query Text

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


SELECT MODULUS_CHECK_ID
,      FROM_SORT_CODE
,      TO_SORT_CODE
,      CHECK_TYPE
,      WEIGHT_U
,      WEIGHT_V
,      WEIGHT_W
,      WEIGHT_X
,      WEIGHT_Y
,      WEIGHT_Z
,      WEIGHT_A
,      WEIGHT_B
,      WEIGHT_C
,      WEIGHT_D
,      WEIGHT_E
,      WEIGHT_F
,      WEIGHT_G
,      WEIGHT_H
,      EXCEPTION_CODE
,      REQUEST_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM CE.CE_UK_VAL_MODULUS_WEIGHTS;

Dependencies

[top of page]

CE.CE_UK_VAL_MODULUS_WEIGHTS does not reference any database object

CE.CE_UK_VAL_MODULUS_WEIGHTS is referenced by following:

SchemaCE
ViewCE_UK_VAL_MODULUS_WEIGHTS#