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_ITEM_COST_FROM_GL_V

Object Details

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

View Type

A Business Intelligence System view

Costing information for an item retrieved from Oracle Financial GL tables. This is the GL equivalent of the item_cost view which retrieves data from the OPM costing tables.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
COMPONENT_COST_AMT	NUMBER		Yes	Component Cost
ITEMCOST_ID	NUMBER	(10)	Yes	Unique item cost identifier. Foreign key from GL_ITEM_CST table.
COST_CMPNTCLS_ID	NUMBER	(10)	Yes	Unique item cost component class identifier.
COST_ANALYSIS_CODE	VARCHAR2	(32)	Yes	Cost analysis code of cost component.
ORGANIZATION_CODE	VARCHAR2	(4)		Organization of item cost.
ORGANIZATION_NAME	VARCHAR2	(40)	Yes	Organization name.
WAREHOUSE_CODE	VARCHAR2	(4)		Warehouse for the cost. ( Plant whse or default costing whse.)
WAREHOUSE_NAME	VARCHAR2	(40)	Yes	Name of the warehouse.
ITEM_ID	NUMBER	(10)		Item for which cost is stored
COST_MTHD_CODE	VARCHAR2	(4)		Cost method for accounting cost.
CALENDAR_CODE	VARCHAR2	(4)		Costing calendar code.
CALENDAR_DESCRIPTION	VARCHAR2	(40)		Costing Calendar description
PERIOD_CODE	VARCHAR2	(4)		Costing period code.
PERIOD_DESCRIPTION	VARCHAR2	(40)		Costing Period Description
PERIOD_START_DATE	DATE			Starting date of the costing period
PERIOD_END_DATE	DATE			Ending date of the costing period
FORMULA_EFF_ID	NUMBER	(10)		Formula effectivity used in the calculation of accounting cost.
GL_ITEMCOST_ID	NUMBER	(10)	Yes	Surrogate key to the row. Foreign Key to GL_ITEM_DTL table.
ITEM_NUMBER	VARCHAR2	(32)	Yes	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)	Yes	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.
COST_CMPNTCLS_CODE	VARCHAR2	(32)	Yes	Cost component class
COST_CMPNTCLS_DESC	VARCHAR2	(240)	Yes	Cost component class description
SORT_SEQUENCE	NUMBER	(10)	Yes	Sequence the component costs are sorted by on Cost details screen
USAGE_IND	NUMBER	(5)	Yes	Component Usage indicator. 1=material 2=burden(overhead) 3=routing 4=GL expense allocation 5=Standard Cost adjustment
PRIMARY_CMPNTCLS_ID	NUMBER	(10)	Yes	Primary cost component class. This field will be used to identify the primary cost component class that this component class is associated with.
PRODUCT_COST_IND	NUMBER	(5)	Yes	This field indicates whether the component class will affect the cost of a product or not . Valid values are: 0 = Not a product cost, 1= Product Cost
UPDATE_COST_IND	NUMBER	(5)	Yes	This field indicates whether the component cost will be updated to the GL area. Valid values are 0= Do not update to GL Area, 1=Update to GL Area.
CMPNT_GROUP	VARCHAR2	(32)		Component Group this component class belongs to. FK to cm_cmpt_grp.cmpnt_group
PPV_IND	NUMBER	(5)	Yes	Indicates if PPV calculations should use this component cost or not. 1=include in PPV calculations. 0=Do not include in PPV calculations.
FINAL_FLAG	NUMBER	(5)	Yes	Indicates if Cost is frozen: 0 - not frozen, can be updated from CDA by running Cost Update process; 1 - Frozen, cannot be modified.
END_DATE	DATE		Yes	End effective date for the accounting cost.
START_DATE	DATE		Yes	Start Effective date for accounting cost.
COST_TYPE	NUMBER	(5)	Yes	Type of cost. 0=other; 1=std; 2=avg actual; 3=current. Not currently used.
ACCTG_COST	NUMBER		Yes	Item cost as seen by OPM programs, especially Susidiary Ledger Update process.
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 COMPONENT_COST_AMT
,      ITEMCOST_ID
,      COST_CMPNTCLS_ID
,      COST_ANALYSIS_CODE
,      ORGANIZATION_CODE
,      ORGANIZATION_NAME
,      WAREHOUSE_CODE
,      WAREHOUSE_NAME
,      ITEM_ID
,      COST_MTHD_CODE
,      CALENDAR_CODE
,      CALENDAR_DESCRIPTION
,      PERIOD_CODE
,      PERIOD_DESCRIPTION
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      FORMULA_EFF_ID
,      GL_ITEMCOST_ID
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      ITEM_UOM
,      ITEM_UOM2
,      COST_CMPNTCLS_CODE
,      COST_CMPNTCLS_DESC
,      SORT_SEQUENCE
,      USAGE_IND
,      PRIMARY_CMPNTCLS_ID
,      PRODUCT_COST_IND
,      UPDATE_COST_IND
,      CMPNT_GROUP
,      PPV_IND
,      FINAL_FLAG
,      END_DATE
,      START_DATE
,      COST_TYPE
,      ACCTG_COST
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM APPS.PMIFV_ITEM_COST_FROM_GL_V;

Dependencies

[top of page]

APPS.PMIFV_ITEM_COST_FROM_GL_V references the following:

APPS: CM_CLDR_DTL; CM_CLDR_HDR; CM_CMPT_MST; GL_ITEM_CST; GL_ITEM_DTL; IC_ITEM_MST_B; IC_WHSE_MST; PMI_SECURITY_PKG - show dependent code; SY_ORGN_MST

APPS.PMIFV_ITEM_COST_FROM_GL_V is not referenced by any database object