[Home] [Help] [Dependency Information]
Object Name: | IEX_COSTS |
---|---|
Object Type: | TABLE |
Owner: | IEX |
Subobject Name: | |
Status: | VALID |
Maintains the actual and budgeted costs for a case or a delinquency
The cost will either be for a case or a delinquency . So both case_id and delinquency_ id are kept optional and the rule will be enfored in the API to make one of them mandatory.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IEX_COSTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | COST_ID |
IEX_COSTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | COST_TYPE_CODE |
IEX_COSTS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | COST_ITEM_TYPE_CODE |
IEX_COSTS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DELINQUENCY_ID |
IEX_COSTS_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CASE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COST_ID | NUMBER | Yes | Cost Identifier | |
DELINQUENCY_ID | NUMBER | Foreign Key to iex_delinquencies_all table | ||
CASE_ID | NUMBER | Foreign Key to Iex_Cases_b table | ||
COST_TYPE_CODE | VARCHAR2 | (240) | Yes | Cost type - Actual or Budgeted |
COST_ITEM_TYPE_CODE | VARCHAR2 | (240) | Yes | Cost item type - dunning letter mailed, dunning letter faxed, repossession , etc |
COST_ITEM_TYPE_DESC | VARCHAR2 | (240) | Cost item type description | |
COST_ITEM_AMOUNT | NUMBER | Holds the actual or budgeted cost | ||
COST_ITEM_CURRENCY_CODE | VARCHAR2 | (15) | Actual or budgeted currency code | |
COST_ITEM_QTY | NUMBER | Holds the budgeted quantity | ||
COST_ITEM_DATE | DATE | This will be target_date or planned for budgeted costs and will be cost_incurred date for actual costs. We are using the same columns for both typesof costs. | ||
EXCHANGE_TYPE | VARCHAR2 | (240) | Exchange type for currency conversion .the amounts are always shown in functional currency. so we have to store the exchange type | |
EXCHANGE_RATE | NUMBER | Exchange rate for currency conversion .the amounts are always shown in functional currency. so we have to store the exchange rate | ||
FUNCTIONAL_AMOUNT | NUMBER | Stores the cost_item_amount in functional amount based on the functional currency | ||
EXCHANGE_DATE | DATE | Exchange date for currency conversion .the amounts are always shown in functional currency. so we have to store the exchange date. this is the date on which the exchange was done | ||
ACTIVE_FLAG | VARCHAR2 | (240) | Yes | Active Flag |
COST_ITEM_APPROVED | VARCHAR2 | (1) | Yes | indicates if the cost item was approved or not |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | Standard HTML front end column |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Yes | 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). | |
REQUEST_ID | NUMBER | (15) | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | |
PROGRAM_ID | NUMBER | (15) | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | |
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (240) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive flexfield segment | |
SECURITY_GROUP_ID | NUMBER | Used in hosted environments |
Cut, paste (and edit) the following text to query this object:
SELECT COST_ID
, DELINQUENCY_ID
, CASE_ID
, COST_TYPE_CODE
, COST_ITEM_TYPE_CODE
, COST_ITEM_TYPE_DESC
, COST_ITEM_AMOUNT
, COST_ITEM_CURRENCY_CODE
, COST_ITEM_QTY
, COST_ITEM_DATE
, EXCHANGE_TYPE
, EXCHANGE_RATE
, FUNCTIONAL_AMOUNT
, EXCHANGE_DATE
, ACTIVE_FLAG
, COST_ITEM_APPROVED
, OBJECT_VERSION_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_GROUP_ID
FROM IEX.IEX_COSTS;
IEX.IEX_COSTS does not reference any database object
IEX.IEX_COSTS is referenced by following:
|
|
|