eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.PMIFV_STANDARD_COST_LEDGER_V

Object Details

Object Name:	PMIFV_STANDARD_COST_LEDGER_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PMI.PMIFV_STANDARD_COST_LEDGER_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Ledger of Process Manufacturing Costing detail information produced during Cost Rollup process.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
STD_QTY	NUMBER		Yes	Effectivity standard quantity converted to an item inventory uom.
FORM_PROD_UOM	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
LINE_TYPE	NUMBER	(10)	Yes	Type of line 1=ingredient, -1=byproduct
LINE_TYPE_MEANING	VARCHAR2	(80)		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
COMPONENT_COST	NUMBER		Yes	Ingredient/byproduct Component cost
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_UOM	VARCHAR2	(4)		Standard resource uom
RUDTL_ID	NUMBER	(10)	Yes	Surrogate for this row
ITEM_ID	NUMBER	(10)		Surrogate for the ingedient/byproduct
WHSE_CODE	VARCHAR2	(4)		Warehouse code
RESOURCES	VARCHAR2	(16)		Resource
CMPNTCOST_ID	NUMBER	(10)	Yes	Surrogate from cost component details
ITEM_NUMBER	VARCHAR2	(32)		Name of the item.
ITEM_DESCRIPTION	VARCHAR2	(70)		Short description of the item that is displayed during the item look up.
ITEM_UOM	VARCHAR2	(4)		Uom of the item by which the inventory balances are maintained.
ITEM_UOM2	VARCHAR2	(4)		Second UOM for in which inventory balances are maintained, for dual UOM items.
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column

Query Text

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


SELECT STD_QTY
,      FORM_PROD_UOM
,      ROUTING_QTY
,      PRODUCT_QTY
,      COST_ALLOC
,      LINE_TYPE
,      LINE_TYPE_MEANING
,      ITEM_QTY
,      ITEM_FMQTY
,      ITEM_FMQTY_UM
,      COMPONENT_COST
,      RESOURCE_COUNT
,      RESOURCE_USAGE
,      NOMINAL_COST
,      USAGE_UOM
,      RUDTL_ID
,      ITEM_ID
,      WHSE_CODE
,      RESOURCES
,      CMPNTCOST_ID
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      ITEM_UOM
,      ITEM_UOM2
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.PMIFV_STANDARD_COST_LEDGER_V;

Dependencies

[top of page]

APPS.PMIFV_STANDARD_COST_LEDGER_V references the following:

APPS: CM_SCST_LED; IC_ITEM_MST; IC_WHSE_MST; PMI_COST_ANALZ_PACK - show dependent code; PMI_SECURITY_PKG - show dependent code; SY_ORGN_MST

APPS.PMIFV_STANDARD_COST_LEDGER_V is not referenced by any database object