View: PMIBV_ITEM_COST_FROM_GL_V

Product:	PMI - Process Manufacturing Intelligence
Description:	Costing info for an item. Costing info is retrieved from the GL equivalent of the item_cost view which retrieves data from OPM tables.
Implementation/DBA Data:	APPS.PMIBV_ITEM_COST_FROM_GL_V

View Text

SELECT COSTDETAIL.CMPTCOST_AMT
, COSTDETAIL.ITEMCOST_ID
, /* ID */ COSTDETAIL.COST_CMPNTCLS_ID
, COSTDETAIL.COST_ANALYSIS_CODE
, GLITEMCOST.ORGN_CODE
, GLITEMCOST.WHSE_CODE
, GLITEMCOST.ITEM_ID
, GLITEMCOST.COST_MTHD_CODE
, GLITEMCOST.CALENDAR_CODE
, GLITEMCOST.PERIOD_CODE
, GLITEMCOST.FMEFF_ID
, GLITEMCOST.ITEMCOST_ID
, GLITEMCOST.FINAL_FLAG
, GLITEMCOST.END_DATE
, GLITEMCOST.START_DATE
, GLITEMCOST.COST_TYPE
, GLITEMCOST.ACCTG_COST
, 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
, /* WHO COLUMNS */ COSTDETAIL.CREATION_DATE
, COSTDETAIL.LAST_UPDATE_DATE
, COSTDETAIL.LAST_UPDATED_BY
FROM GL_ITEM_DTL COSTDETAIL
, GL_ITEM_CST GLITEMCOST
, CM_CMPT_MST COSTMASTER
WHERE COSTDETAIL.ITEMCOST_ID = GLITEMCOST.ITEMCOST_ID
AND COSTMASTER.COST_CMPNTCLS_ID = COSTDETAIL.COST_CMPNTCLS_ID
AND COSTDETAIL.DELETE_MARK = 0
AND GLITEMCOST.DELETE_MARK = 0 WITH READ ONLY

Columns