[Home] [Help] [Dependency Information]
Object Name: | CST_WIP_OPERATION_TXN_COSTS |
---|---|
Object Type: | TABLE |
Owner: | BOM |
FND Design Data: | BOM.CST_WIP_OPERATION_TXN_COSTS |
Subobject Name: | |
Status: | VALID |
CST_WIP_OPERATION_TXN_COSTS stores snapshots of WIP_REQUIREMENT_OPERATIONS,
WIP_REQ_OPERATION_COST_DETAILS, WIP_OPERAION_OVERHEADS, and
WIP_OPERATION_RESOURCES. This information can be used to track the value
changes for a WIP job or schedule.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CST_WIP_OPERATION_TXN_COSTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TXN_COST_ID |
CST_WIP_OPERATION_TXN_COSTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
TRANSACTION_ID
TRANSACTION_SOURCE_CODE |
CST_WIP_OPERATION_TXN_COSTS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
WIP_ENTITY_ID
REPETITIVE_SCHEDULE_ID TRANSACTION_DATE TRANSACTION_ID TRANSACTION_SOURCE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TXN_COST_ID | NUMBER | Yes | Primary key sequence identifier | |
TRANSACTION_ID | NUMBER | Yes | Transaction identifier | |
TRANSACTION_SOURCE_CODE | NUMBER | Yes | Transaction source code | |
WIP_ENTITY_ID | NUMBER | Yes | WIP job or schedule identifier | |
REPETITIVE_SCHEDULE_ID | NUMBER | WIP repetitive schedule identifier | ||
OPERATION_SEQ_NUM | NUMBER | Yes | Operation sequence number in a routing | |
COST_ELEMENT_ID | NUMBER | Yes | Cost element identifier | |
LEVEL_TYPE | NUMBER | Yes | Level type | |
TRANSACTION_DATE | DATE | Transaction date | ||
COMPONENT_ITEM_ID | NUMBER | Component item identifier | ||
COMPONENT_SEQUENCE_ID | NUMBER | Bill identifier of this component | ||
RESOURCE_ID | NUMBER | Resource identifier | ||
RESOURCE_SEQ_NUM | NUMBER | Resource sequence number | ||
BASIS_TYPE | NUMBER | Basis type | ||
PRIOR_APPLIED_UNITS | NUMBER | Prior quantity applied | ||
NEW_APPLIED_UNITS | NUMBER | New quantity applied | ||
PRIOR_APPLIED_VALUE | NUMBER | Prior value applied | ||
NEW_APPLIED_VALUE | NUMBER | New value applied | ||
PRIOR_RELIEVED_SCRAP_UNITS | NUMBER | Prior quantity relieved due to WIP scrap | ||
NEW_RELIEVED_SCRAP_UNITS | NUMBER | New quantity relieved due to WIP scrap | ||
PRIOR_RELIEVED_SCRAP_VALUE | NUMBER | Prior value relieved due to WIP scrap | ||
NEW_RELIEVED_SCRAP_VALUE | NUMBER | New value relieved due to WIP scrap | ||
PRIOR_RELIEVED_VAR_VALUE | NUMBER | Prior value relieved to WIP variance | ||
NEW_RELIEVED_VAR_VALUE | NUMBER | New value relieved to WIP variance | ||
PRIOR_RELIEVED_FINAL_UNITS | NUMBER | Prior quantity relieved due to WIP final completion | ||
NEW_RELIEVED_FINAL_UNITS | NUMBER | New quantity relieved due to WIP final completion | ||
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 | ||
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 | ||
ORGANIZATION_ID | NUMBER | (15) | Yes | Organization identifier |
PRIOR_RELIEVED_COMP_UNITS | NUMBER | Prior quantity relieved due to WIP completion | ||
NEW_RELIEVED_COMP_UNITS | NUMBER | New quantity relieved due to WIP completion | ||
PRIOR_RELIEVED_COMP_VALUE | NUMBER | Prior value relieved due to WIP completion | ||
NEW_RELIEVED_COMP_VALUE | NUMBER | New value relieved due to WIP completion |
Cut, paste (and edit) the following text to query this object:
SELECT TXN_COST_ID
, TRANSACTION_ID
, TRANSACTION_SOURCE_CODE
, WIP_ENTITY_ID
, REPETITIVE_SCHEDULE_ID
, OPERATION_SEQ_NUM
, COST_ELEMENT_ID
, LEVEL_TYPE
, TRANSACTION_DATE
, COMPONENT_ITEM_ID
, COMPONENT_SEQUENCE_ID
, RESOURCE_ID
, RESOURCE_SEQ_NUM
, BASIS_TYPE
, PRIOR_APPLIED_UNITS
, NEW_APPLIED_UNITS
, PRIOR_APPLIED_VALUE
, NEW_APPLIED_VALUE
, PRIOR_RELIEVED_SCRAP_UNITS
, NEW_RELIEVED_SCRAP_UNITS
, PRIOR_RELIEVED_SCRAP_VALUE
, NEW_RELIEVED_SCRAP_VALUE
, PRIOR_RELIEVED_VAR_VALUE
, NEW_RELIEVED_VAR_VALUE
, PRIOR_RELIEVED_FINAL_UNITS
, NEW_RELIEVED_FINAL_UNITS
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORGANIZATION_ID
, PRIOR_RELIEVED_COMP_UNITS
, NEW_RELIEVED_COMP_UNITS
, PRIOR_RELIEVED_COMP_VALUE
, NEW_RELIEVED_COMP_VALUE
FROM BOM.CST_WIP_OPERATION_TXN_COSTS;
BOM.CST_WIP_OPERATION_TXN_COSTS does not reference any database object
BOM.CST_WIP_OPERATION_TXN_COSTS is referenced by following:
|
|
|