[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CN_RATE_SCHEDULES_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | CN |
| FND Design Data: |  CN.CN_RATE_SCHEDULES_ALL
|
| Subobject Name: | |
| Status: | VALID |
CN_RATE_SCHEDULES contains information about the your rate tables.
You need one row for each rate table you create. Each rate table can
have many rate tiers.
RATE_SCHEDULE_ID is the system generated primary key and is invisible
to the user. NAME is the user defined value you use to uniquely
identify the rate table in forms and reports
Each row contains the units in which the table's tiers and commission
are defined.
| Tablespace: |  APPS_TS_SEED |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| CN_RATE_SCHEDULES_U1 | NORMAL | UNIQUE |
APPS_TS_SEED
|
 RATE_SCHEDULE_ID
ORG_ID
|
| CN_RATE_SCHEDULES_U2 | NORMAL | UNIQUE |
APPS_TS_SEED
|
NAME
ORG_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORG_ID | NUMBER | (15) | Organization identifier | |
| RATE_SCHEDULE_ID | NUMBER | (15) | Yes | Primary key |
| NAME | VARCHAR2 | (80) | Yes | Rate table name |
| TIER_UNIT_CODE | VARCHAR2 | (30) | ||
| COMMISSION_UNIT_CODE | VARCHAR2 | (30) | Yes | Unique identifier of the unit in which the commission is defined |
| STATUS_CODE | VARCHAR2 | (30) | No longer used | |
| 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_UPDATED_BY | NUMBER | (15) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
| 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). | |
| NUMBER_DIM | NUMBER | (15) | Number of Rate Dimension | |
| 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_SCHEDULE_ID
, NAME
, TIER_UNIT_CODE
, COMMISSION_UNIT_CODE
, STATUS_CODE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, NUMBER_DIM
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
FROM CN.CN_RATE_SCHEDULES_ALL;
CN.CN_RATE_SCHEDULES_ALL does not reference any database object
CN.CN_RATE_SCHEDULES_ALL is referenced by following:
APPS
CN_RATE_SCHEDULES
CN_RATE_SCHEDULES_ALL
|
|
|
|