VIEW: APPS.CM_CMPT_DTL_VW1

Source

View Text - Preformatted

SELECT cd.inventory_item_id, cd.organization_id, mst.calendar_code, mst.period_code, mst.period_id, mthd.cost_mthd_code, cd.cost_cmpntcls_id, cm.cost_cmpntcls_code, cm.cost_cmpntcls_desc, cm.sort_sequence, cm.usage_ind, cd.cost_analysis_code, cd.cost_level, cd.cmpnt_cost, cd.burden_ind, cd.trans_cnt, cd.text_code, cd.delete_mark, mthd.cost_type_id FROM cm_cmpt_dtl cd, cm_cmpt_mst cm, cm_mthd_mst mthd, gmf_period_statuses mst WHERE cd.cost_cmpntcls_id = cm.cost_cmpntcls_id AND cd.cost_type_id = mthd.cost_type_id AND cd.period_id = mst.period_id

View Text - HTML Formatted

SELECT CD.INVENTORY_ITEM_ID
, CD.ORGANIZATION_ID
, MST.CALENDAR_CODE
, MST.PERIOD_CODE
, MST.PERIOD_ID
, MTHD.COST_MTHD_CODE
, CD.COST_CMPNTCLS_ID
, CM.COST_CMPNTCLS_CODE
, CM.COST_CMPNTCLS_DESC
, CM.SORT_SEQUENCE
, CM.USAGE_IND
, CD.COST_ANALYSIS_CODE
, CD.COST_LEVEL
, CD.CMPNT_COST
, CD.BURDEN_IND
, CD.TRANS_CNT
, CD.TEXT_CODE
, CD.DELETE_MARK
, MTHD.COST_TYPE_ID
FROM CM_CMPT_DTL CD
, CM_CMPT_MST CM
, CM_MTHD_MST MTHD
, GMF_PERIOD_STATUSES MST
WHERE CD.COST_CMPNTCLS_ID = CM.COST_CMPNTCLS_ID
AND CD.COST_TYPE_ID = MTHD.COST_TYPE_ID
AND CD.PERIOD_ID = MST.PERIOD_ID