View: PMIBV_ITEM_COST_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	Costing info for an item. Costing info is retrieved from CM tables, OPM equivalent of the item_cost_from_GL view which retrieves data from the GL tables.
Implementation/DBA Data:	APPS.PMIBV_ITEM_COST_V

View Text

SELECT COSTDETAIL.COST_LEVEL
, COSTDETAIL.CMPNT_COST
, COSTDETAIL.BURDEN_IND
, COSTDETAIL.ROLLOVER_IND
, COSTDETAIL.TOTAL_QTY
, COSTDETAIL.COSTCALC_ORIG
, COSTDETAIL.RMCALC_TYPE
, COSTDETAIL.ROLLUP_REF_NO
, COSTDETAIL.FMEFF_ID
, /* IDENTIFICATION */ COSTDETAIL.CMPNTCOST_ID
, COSTDETAIL.ITEM_ID
, COSTDETAIL.WHSE_CODE
, COSTDETAIL.CALENDAR_CODE
, COSTDETAIL.PERIOD_CODE
, COSTDETAIL.COST_MTHD_CODE
, COSTDETAIL.COST_CMPNTCLS_ID
, COSTDETAIL.COST_ANALYSIS_CODE
, COSTMASTER.COST_CMPNTCLS_CODE
, COSTMASTER.COST_CMPNTCLS_DESC
, COSTMASTER.SORT_SEQUENCE
, COSTMASTER.USAGE_IND
, COSTMASTER.PRIMARY_CMPNTCLS_ID
, COSTMASTER.PRODUCT_COST_IND
, COSTMASTER.UPDATE_COST_IND
, COSTMASTER.CMPNT_GROUP
, COSTMASTER.PPV_IND
, COSTDETAIL.CREATED_BY
, COSTDETAIL.CREATION_DATE
, COSTDETAIL.LAST_UPDATE_DATE
, COSTDETAIL.LAST_UPDATED_BY
FROM CM_CMPT_DTL COSTDETAIL
, CM_CMPT_MST COSTMASTER
WHERE COSTMASTER.COST_CMPNTCLS_ID = COSTDETAIL.COST_CMPNTCLS_ID
AND COSTDETAIL.DELETE_MARK = 0 WITH READ ONLY

Columns