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


VIEW: APPS.PMIBV_ITEM_COST_FROM_GL_V

Object Details
Object Name: PMIBV_ITEM_COST_FROM_GL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPMI.PMIBV_ITEM_COST_FROM_GL_V
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Costing info for an item. Costing info is retrieved from the GL equivalent of the item_cost view which retrieves data from OPM 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.
WAREHOUSE_CODE VARCHAR2 (4)
Warehouse for the cost. ( Plant whse or default costing whse.)
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.
PERIOD_CODE VARCHAR2 (4)
Costing period code.
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.
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 VARCHAR2 (32) Yes Standard who column
CREATION_DATE VARCHAR2 (240) Yes Standard who column
LAST_UPDATE_DATE NUMBER (10) Yes Standard who column
LAST_UPDATED_BY NUMBER (5) Yes Standard who column
COST_CMPNTCLS_CODE NUMBER (10) Yes Cost component class
COST_CMPNTCLS_DESC NUMBER (5) Yes Cost component class description
SORT_SEQUENCE NUMBER (5) Yes Sequence the component costs are sorted by on Cost details screen
USAGE_IND VARCHAR2 (32)
Component Usage indicator. 1=material 2=burden(overhead) 3=routing 4=GL expense allocation 5=Standard Cost adjustment
PRIMARY_CMPNTCLS_ID NUMBER (5) 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 (15) 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 DATE
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 DATE
Yes Component Group this component class belongs to. FK to cm_cmpt_grp.cmpnt_group
PPV_IND NUMBER (15) Yes Indicates if PPV calculations should use this component cost or not. 1=include in PPV calculations. 0=Do not include in PPV calculations.
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
,      WAREHOUSE_CODE
,      ITEM_ID
,      COST_MTHD_CODE
,      CALENDAR_CODE
,      PERIOD_CODE
,      FORMULA_EFF_ID
,      GL_ITEMCOST_ID
,      FINAL_FLAG
,      END_DATE
,      START_DATE
,      COST_TYPE
,      ACCTG_COST
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      COST_CMPNTCLS_CODE
,      COST_CMPNTCLS_DESC
,      SORT_SEQUENCE
,      USAGE_IND
,      PRIMARY_CMPNTCLS_ID
,      PRODUCT_COST_IND
,      UPDATE_COST_IND
,      CMPNT_GROUP
,      PPV_IND
FROM APPS.PMIBV_ITEM_COST_FROM_GL_V;

Dependencies

[top of page]

APPS.PMIBV_ITEM_COST_FROM_GL_V references the following:

SchemaAPPS
SynonymCM_CMPT_MST
SynonymGL_ITEM_CST
SynonymGL_ITEM_DTL

APPS.PMIBV_ITEM_COST_FROM_GL_V is not referenced by any database object