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

TABLE: GMF.CM_SCST_LED

Object Details
Object Name: CM_SCST_LED
Object Type: TABLE
Owner: GMF
FND Design Data: TableGMF.CM_SCST_LED
Subobject Name:
Status: VALID


Standard Costs Ledger. This table is created during the cost rollup
process. It serves the purpose of a ledger on the performed cost
calculations of each product. Formula and routing information is
maintained within this table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CM_SCST_LED_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnRUDTL_ID
CM_SCST_LEDI1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCMPNTCOST_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
CM_SCST_LED CM_SCST_LED_CM_CMPT_DTL_FK TableCM_CMPT_DTL CM_SCST_LED CMPNTCOST_ID
Columns
Name Datatype Length Mandatory Comments
RUDTL_ID NUMBER (10) Yes Surrogate for this row
STD_QTY NUMBER
Yes Effectivity standard quantity converted to an item inventory uom.
FORM_PROD_UM VARCHAR2 (4)
UOM of the product within the formula
ROUTING_QTY NUMBER
Yes Routing quantity converted to product inventory uom
PRODUCT_QTY NUMBER
Yes Product qty converted to product inventory uom
COST_ALLOC NUMBER (10) Yes Cost allocation percentage - The percentage of the ingredient costs that contribute towards the Product cost
CMPNTCOST_ID NUMBER (10) Yes Surrogate from cost component details
ITEM_ID NUMBER (10)
Surrogate for the ingedient/byproduct
LINE_TYPE NUMBER (10) Yes Type of line 1=ingredient, -1=byproduct
ITEM_QTY NUMBER
Yes Ingredient/byproduct quantity converted to inventory uom
ITEM_FMQTY NUMBER
Yes Ingredient/byproduct quantity at formula uom
ITEM_FMQTY_UM VARCHAR2 (4)
Ingredient/byproduct formula uom
WHSE_CODE VARCHAR2 (4)
Warehouse code
CMPNT_COST NUMBER
Yes Ingredient/byproduct Component cost
RESOURCES VARCHAR2 (16)
Resource
RESOURCE_COUNT NUMBER

Resource count from the operation details
RESOURCE_USAGE NUMBER

Resource usage from the operation details
NOMINAL_COST NUMBER

Nominal cost for the resource at usage uom
USAGE_UM VARCHAR2 (4)
Standard resource uom
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
DELETE_MARK NUMBER (5) Yes Standard: 0=Active record (default); 1=Marked for (logical) deletion.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
REQUEST_ID NUMBER (15)
Concurrent who column
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent who column
PROGRAM_ID NUMBER (15)
Concurrent who column
PROGRAM_UPDATE_DATE DATE

Concurrent who column
FORM_PROD_UOM VARCHAR2 (3)
Product Unit of Measure
INVENTORY_ITEM_ID NUMBER (15)
Inventory Item identifier
ITEM_FMQTY_UOM VARCHAR2 (3)
Ingredient unit of measure
ORGANIZATION_ID NUMBER (15)
Organization identifier
USAGE_UOM VARCHAR2 (3)
Unit of Measure for resource
Query Text

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


SELECT RUDTL_ID
,      STD_QTY
,      FORM_PROD_UM
,      ROUTING_QTY
,      PRODUCT_QTY
,      COST_ALLOC
,      CMPNTCOST_ID
,      ITEM_ID
,      LINE_TYPE
,      ITEM_QTY
,      ITEM_FMQTY
,      ITEM_FMQTY_UM
,      WHSE_CODE
,      CMPNT_COST
,      RESOURCES
,      RESOURCE_COUNT
,      RESOURCE_USAGE
,      NOMINAL_COST
,      USAGE_UM
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      DELETE_MARK
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      FORM_PROD_UOM
,      INVENTORY_ITEM_ID
,      ITEM_FMQTY_UOM
,      ORGANIZATION_ID
,      USAGE_UOM
FROM GMF.CM_SCST_LED;

Dependencies

[top of page]

GMF.CM_SCST_LED does not reference any database object

GMF.CM_SCST_LED is referenced by following:

SchemaGMF
ViewCM_SCST_LED#