[Home] [Help] [Dependency Information]
Object Name: | CST_CG_COST_HISTORY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BOM.CST_CG_COST_HISTORY_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Inventory Item Identifier | ||
TRANSACTION_ID | NUMBER | Transaction ID | ||
ORGANIZATION_ID | NUMBER | Organization Identifier | ||
LAYER_ID | NUMBER | Layer ID | ||
TRANSACTION_COSTED_DATE | DATE | Transaction costed date | ||
TRANSACTION_DATE | DATE | Transaction date | ||
PRIOR_COSTED_QUANTITY | NUMBER | Prior Costed Quantity | ||
PRIMARY_QUANTITY | NUMBER | Primary Quantity | ||
NEW_QUANTITY | NUMBER | New quantity | ||
COST_GROUP_ID | NUMBER | Cost group id | ||
TRANSACTION_TYPE | VARCHAR2 | (80) | Transaction type | |
ACTUAL_COST | NUMBER | Actual Cost | ||
ACTUAL_MATERIAL | NUMBER | Material Element Cost | ||
ACTUAL_MATERIAL_OVERHEAD | NUMBER | Material Overhead Element Cost | ||
ACTUAL_RESOURCE | NUMBER | Resource Element Cost | ||
ACTUAL_OUTSIDE_PROCESSING | NUMBER | Outside Processing Element Cost | ||
ACTUAL_OVERHEAD | NUMBER | Overhead Cost | ||
PRIOR_COST | NUMBER | Prior Cost | ||
PRIOR_MATERIAL | NUMBER | Prior material element cost | ||
PRIOR_MATERIAL_OVERHEAD | NUMBER | Prior material overhead cost | ||
PRIOR_RESOURCE | NUMBER | Prior resource element cost | ||
PRIOR_OUTSIDE_PROCESSING | NUMBER | Prior outside processing element cost | ||
PRIOR_OVERHEAD | NUMBER | Prior overhead cost | ||
NEW_COST | NUMBER | New cost | ||
NEW_MATERIAL | NUMBER | New material element cost | ||
NEW_MATERIAL_OVERHEAD | NUMBER | New material overhead element cost | ||
NEW_RESOURCE | NUMBER | New resource element cost | ||
NEW_OUTSIDE_PROCESSING | NUMBER | New outside processing element cost | ||
NEW_OVERHEAD | NUMBER | New overhead cost | ||
CHANGE | VARCHAR2 | (1) | Cost element change flag |
Cut, paste (and edit) the following text to query this object:
SELECT INVENTORY_ITEM_ID
, TRANSACTION_ID
, ORGANIZATION_ID
, LAYER_ID
, TRANSACTION_COSTED_DATE
, TRANSACTION_DATE
, PRIOR_COSTED_QUANTITY
, PRIMARY_QUANTITY
, NEW_QUANTITY
, COST_GROUP_ID
, TRANSACTION_TYPE
, ACTUAL_COST
, ACTUAL_MATERIAL
, ACTUAL_MATERIAL_OVERHEAD
, ACTUAL_RESOURCE
, ACTUAL_OUTSIDE_PROCESSING
, ACTUAL_OVERHEAD
, PRIOR_COST
, PRIOR_MATERIAL
, PRIOR_MATERIAL_OVERHEAD
, PRIOR_RESOURCE
, PRIOR_OUTSIDE_PROCESSING
, PRIOR_OVERHEAD
, NEW_COST
, NEW_MATERIAL
, NEW_MATERIAL_OVERHEAD
, NEW_RESOURCE
, NEW_OUTSIDE_PROCESSING
, NEW_OVERHEAD
, CHANGE
FROM APPS.CST_CG_COST_HISTORY_V;
|
|
|