View: PMIFV_ITEM_COST_V

Product:	PMI - Process Manufacturing Intelligence
Description:	Costing information for an item retrieved from costing tables. This is the OPM costing tables equivalent of the item_cost_from_GL view which retrieves data from the GL tables.
Implementation/DBA Data:	APPS.PMIFV_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
, WAREHOUSE.WHSE_NAME
, COSTDETAIL.CALENDAR_CODE
, CLDRHDR.CALENDAR_DESC
, COSTDETAIL.PERIOD_CODE
, CLDRDTL.PERIOD_DESC
, CLDRDTL.START_DATE
, CLDRDTL.END_DATE
, COSTDETAIL.COST_MTHD_CODE
, COSTDETAIL.COST_CMPNTCLS_ID
, COSTDETAIL.COST_ANALYSIS_CODE
, ITEM.ITEM_NO
, PMI_COST_ANALZ_PACK.GMCA_GET_LINE_TYPE(COSTDETAIL.ITEM_ID)
, 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
, COSTDETAIL.CREATED_BY
, COSTDETAIL.CREATION_DATE
, COSTDETAIL.LAST_UPDATE_DATE
, COSTDETAIL.LAST_UPDATED_BY
FROM CM_CMPT_DTL COSTDETAIL
, CM_CMPT_MST COSTMASTER
, IC_ITEM_MST ITEM
, IC_WHSE_MST WAREHOUSE
, CM_CLDR_HDR CLDRHDR
, CM_CLDR_DTL CLDRDTL
WHERE COSTMASTER.COST_CMPNTCLS_ID = COSTDETAIL.COST_CMPNTCLS_ID
AND COSTDETAIL.ITEM_ID = ITEM.ITEM_ID
AND COSTDETAIL.WHSE_CODE = WAREHOUSE.WHSE_CODE(+)
AND COSTDETAIL.CALENDAR_CODE = CLDRHDR.CALENDAR_CODE(+)
AND COSTDETAIL.CALENDAR_CODE = CLDRDTL.CALENDAR_CODE(+)
AND COSTDETAIL.PERIOD_CODE = CLDRDTL.PERIOD_CODE(+)
AND COSTDETAIL.DELETE_MARK = 0
AND COSTMASTER.DELETE_MARK = 0
AND ITEM.DELETE_MARK = 0
AND (WAREHOUSE.ORGN_CODE IS NULL OR WAREHOUSE.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