[Home] [Help] [Dependency Information]
Object Name: | CN_RATE_DIM_TIERS_ALL |
---|---|
Object Type: | TABLE |
Owner: | CN |
FND Design Data: | CN.CN_RATE_DIM_TIERS_ALL |
Subobject Name: | |
Status: | VALID |
CN_RATE_DIM_TIERS contains information about tiers for each rate dimension.
You need one row for each rate tier of a rate dimension.
RATE_DIM_TIER_ID is the system generated primary key and is invisible to user.
Each row contains minimum amount and maximum amount of the tier and its type
either ?PERCENT? or ?AMOUNT?. Tiers of Rate dimension information.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CN_RATE_DIM_TIERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
RATE_DIM_TIER_ID
ORG_ID |
CN_RATE_DIM_TIERS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | RATE_DIMENSION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORG_ID | NUMBER | (15) | Organization identifier | |
RATE_DIM_TIER_ID | NUMBER | (15) | Yes | Primary Key |
RATE_DIMENSION_ID | NUMBER | (15) | Yes | Foreign Key |
DIM_UNIT_CODE | VARCHAR2 | (30) | "PERCENT" or "AMOUNT" | |
MINIMUM_AMOUNT | NUMBER | minimum amount | ||
MAXIMUM_AMOUNT | NUMBER | maximum amount | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
TIER_SEQUENCE | NUMBER | (15) | The sequence number of the current tier. | |
STRING_VALUE | VARCHAR2 | (30) | The value of the current tier in a string based dimension. | |
MIN_EXP_ID | NUMBER | (15) | The foreign key to CN_CALC_SQL_EXPS_ALL. This defines the minimum value of the current tier. | |
MAX_EXP_ID | NUMBER | (15) | The foreign key to CN_CALC_SQL_EXPS_ALL. This defines the maximum value of the current tier. | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | This column is used for locking purposes | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT ORG_ID
, RATE_DIM_TIER_ID
, RATE_DIMENSION_ID
, DIM_UNIT_CODE
, MINIMUM_AMOUNT
, MAXIMUM_AMOUNT
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, TIER_SEQUENCE
, STRING_VALUE
, MIN_EXP_ID
, MAX_EXP_ID
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
FROM CN.CN_RATE_DIM_TIERS_ALL;
CN.CN_RATE_DIM_TIERS_ALL does not reference any database object
CN.CN_RATE_DIM_TIERS_ALL is referenced by following:
|
|
|