[Home] [Help]
[Dependency Information]
| Object Name: | CST_ACTIVITY_COSTS_EFC |
|---|---|
| Object Type: | TABLE |
| Owner: | BOM |
| FND Design Data: | BOM.CST_ACTIVITY_COSTS_EFC
|
| Subobject Name: | |
| Status: | VALID |
CST_ACTIVITY_COSTS_EFC is used exclusively as an archive table
for the "Euro as a functional currency" project. It mirrors the table
CST_ACTIVITY_COSTS prior to conversion to the euro currency.
| Tablespace: | APPS_TS_ARCHIVE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| UNIT_COST | NUMBER | Unit Cost | ||
| ORGANIZATION_ID | NUMBER | Yes | Organization Identifier | |
| ACTIVITY_ID | NUMBER | Yes | Activity Identifier | |
| TOTAL_COST | NUMBER | Total Cost | ||
| COST_TYPE_ID | NUMBER | Yes | Cost Type Identifier | |
| SET_OF_BOOKS_ID | NUMBER | Set Of Books Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT UNIT_COST
, ORGANIZATION_ID
, ACTIVITY_ID
, TOTAL_COST
, COST_TYPE_ID
, SET_OF_BOOKS_ID
FROM BOM.CST_ACTIVITY_COSTS_EFC;
BOM.CST_ACTIVITY_COSTS_EFC does not reference any database object
BOM.CST_ACTIVITY_COSTS_EFC is referenced by following:
BOM
CST_ACTIVITY_COSTS_EFC#
|
|
|
|