View: PMIFV_ITEM_COST_FROM_GL_V

Product:	PMI - Process Manufacturing Intelligence (Obsolete)
Description:	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.
Implementation/DBA Data:	APPS.PMIFV_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
, ORGN.ORGN_NAME
, GLITEMCOST.WHSE_CODE
, WHSE.WHSE_NAME
, GLITEMCOST.ITEM_ID
, GLITEMCOST.COST_MTHD_CODE
, GLITEMCOST.CALENDAR_CODE
, CLDRHDR.CALENDAR_DESC
, GLITEMCOST.PERIOD_CODE
, CLDRDTL.PERIOD_DESC
, CLDRDTL.START_DATE
, CLDRDTL.END_DATE
, GLITEMCOST.FMEFF_ID
, GLITEMCOST.ITEMCOST_ID
, ITEM.ITEM_NO
, ITEM.ITEM_DESC1
, ITEM.ITEM_UM
, ITEM.ITEM_UM2
, 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
, GLITEMCOST.FINAL_FLAG
, GLITEMCOST.END_DATE
, GLITEMCOST.START_DATE
, GLITEMCOST.COST_TYPE
, GLITEMCOST.ACCTG_COST
, COSTDETAIL.CREATED_BY
, /* WHO COLUMNS */ COSTDETAIL.CREATION_DATE
, COSTDETAIL.LAST_UPDATE_DATE
, COSTDETAIL.LAST_UPDATED_BY
FROM GL_ITEM_DTL COSTDETAIL
, CM_CMPT_MST COSTMASTER
, GL_ITEM_CST GLITEMCOST
, IC_ITEM_MST_B ITEM
, IC_WHSE_MST WHSE
, SY_ORGN_MST ORGN
, CM_CLDR_HDR CLDRHDR
, CM_CLDR_DTL CLDRDTL
WHERE COSTMASTER.COST_CMPNTCLS_ID = COSTDETAIL.COST_CMPNTCLS_ID
AND COSTDETAIL.ITEMCOST_ID = GLITEMCOST.ITEMCOST_ID
AND GLITEMCOST.ITEM_ID = ITEM.ITEM_ID
AND GLITEMCOST.ORGN_CODE = ORGN.ORGN_CODE
AND GLITEMCOST.WHSE_CODE = WHSE.WHSE_CODE
AND GLITEMCOST.CALENDAR_CODE = CLDRHDR.CALENDAR_CODE(+)
AND GLITEMCOST.CALENDAR_CODE = CLDRDTL.CALENDAR_CODE(+)
AND GLITEMCOST.PERIOD_CODE = CLDRDTL.PERIOD_CODE(+)
AND COSTDETAIL.DELETE_MARK = 0
AND (GLITEMCOST.ORGN_CODE IS NULL OR GLITEMCOST.ORGN_CODE IN (SELECT SECORG.ORGN_CODE
FROM SY_ORGN_MST SECORG
WHERE PMI_SECURITY_PKG.SHOW_RECORD(SECORG.ORGN_CODE) = 'TRUE')) WITH READ ONLY

Columns