VIEW: APPS.PMIFV_ITEM_COST_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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