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


TABLE: BOM.CST_COST_UPDATES

Object Details
Object Name: CST_COST_UPDATES
Object Type: TABLE
Owner: BOM
FND Design Data: TableBOM.CST_COST_UPDATES
Subobject Name:
Status: VALID


CST_COST_UPDATES stores a record for every Update Standard Cost
request submitted. The adjustment columns for WIP may not include
adjustments for resource or overhead rates. They only include
standard cost adjustments for the items issued and completed from
Oracle Work in Process.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CST_COST_UPDATES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOST_UPDATE_ID
CST_COST_UPDATES_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnCOST_UPDATE_ID
Columns
Name Datatype Length Mandatory Comments
COST_UPDATE_ID NUMBER
Yes Cost update session identifier
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
STATUS NUMBER
Yes Status of the cost update program
ORGANIZATION_ID NUMBER
Yes Organization identifier
COST_TYPE_ID NUMBER
Yes Cost type identifier
UPDATE_DATE DATE

Cost update session start time
DESCRIPTION VARCHAR2 (240) Yes Description
RANGE_OPTION NUMBER
Yes Item range option
UPDATE_RESOURCE_OVHD_FLAG NUMBER
Yes Flag indicating whether resource and overhead costs should be updated
UPDATE_ACTIVITY_FLAG NUMBER

Flag indicating whether activity cost should be updated
SNAPSHOT_SAVED_FLAG NUMBER

Flag indicating whether adjustment details should be saved
INV_ADJUSTMENT_ACCOUNT NUMBER

Code combination identifier for the inventory adjustment account
SINGLE_ITEM NUMBER

Inventory item identifier
ITEM_RANGE_LOW VARCHAR2 (240)
Inventory item range from
ITEM_RANGE_HIGH VARCHAR2 (240)
Inventory item range to
CATEGORY_ID NUMBER

Category identifier
CATEGORY_SET_ID NUMBER

Category set identifier
INVENTORY_ADJUSTMENT_VALUE NUMBER

Adjustment total for on-hand inventories
INTRANSIT_ADJUSTMENT_VALUE NUMBER

Adjustment total for intransit inventories
WIP_ADJUSTMENT_VALUE NUMBER

Adjustment total for Work in Process
SCRAP_ADJUSTMENT_VALUE NUMBER

Adjustment total for scrap
REQUEST_ID NUMBER

Concurrent Who column
PROGRAM_APPLICATION_ID NUMBER

Concurrent Who column
PROGRAM_ID NUMBER

Concurrent Who column
PROGRAM_UPDATE_DATE DATE

Concurrent Who column
Query Text

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


SELECT COST_UPDATE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      STATUS
,      ORGANIZATION_ID
,      COST_TYPE_ID
,      UPDATE_DATE
,      DESCRIPTION
,      RANGE_OPTION
,      UPDATE_RESOURCE_OVHD_FLAG
,      UPDATE_ACTIVITY_FLAG
,      SNAPSHOT_SAVED_FLAG
,      INV_ADJUSTMENT_ACCOUNT
,      SINGLE_ITEM
,      ITEM_RANGE_LOW
,      ITEM_RANGE_HIGH
,      CATEGORY_ID
,      CATEGORY_SET_ID
,      INVENTORY_ADJUSTMENT_VALUE
,      INTRANSIT_ADJUSTMENT_VALUE
,      WIP_ADJUSTMENT_VALUE
,      SCRAP_ADJUSTMENT_VALUE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM BOM.CST_COST_UPDATES;

Dependencies

[top of page]

BOM.CST_COST_UPDATES does not reference any database object

BOM.CST_COST_UPDATES is referenced by following:

SchemaBOM
ViewCST_COST_UPDATES#