VIEW: APPS.PMIBV_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, 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

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
, 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