FND Design Data [Home] [Help]

View: CM_CMPT_DTL_VW

Product: GMF - Process Manufacturing Financials
Description: View of TOTAL_COST
Implementation/DBA Data: ViewAPPS.CM_CMPT_DTL_VW
View Text

SELECT CMPNTCOST_ID
, ITEM_ID
, WHSE_CODE
, CALENDAR_CODE
, PERIOD_CODE
, COST_MTHD_CODE
, COST_CMPNTCLS_ID
, COST_ANALYSIS_CODE
, COST_LEVEL
, CMPNT_COST
, BURDEN_IND
, FMEFF_ID
, ROLLOVER_IND
, TOTAL_QTY
, COSTCALC_ORIG
, RMCALC_TYPE
, ROLLUP_REF_NO
, ACPROC_ID
, TRANS_CNT
, TEXT_CODE
, DELETE_MARK
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY
, PERIOD_TRANS_QTY
, PERIOD_PERP_QTY
, COST_TYPE_ID
, INVENTORY_ITEM_ID
, ORGANIZATION_ID
, PERIOD_ID
FROM CM_CMPT_DTL

Columns

Name
CMPNTCOST_ID
ITEM_ID
WHSE_CODE
CALENDAR_CODE
PERIOD_CODE
COST_MTHD_CODE
COST_CMPNTCLS_ID
COST_ANALYSIS_CODE
COST_LEVEL
CMPNT_COST
BURDEN_IND
FMEFF_ID
ROLLOVER_IND
TOTAL_QTY
COSTCALC_ORIG
RMCALC_TYPE
ROLLUP_REF_NO
ACPROC_ID
TRANS_CNT
TEXT_CODE
DELETE_MARK
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
ATTRIBUTE21
ATTRIBUTE22
ATTRIBUTE23
ATTRIBUTE24
ATTRIBUTE25
ATTRIBUTE26
ATTRIBUTE27
ATTRIBUTE28
ATTRIBUTE29
ATTRIBUTE30
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
ATTRIBUTE_CATEGORY
PERIOD_TRANS_QTY
PERIOD_PERP_QTY
COST_TYPE_ID
INVENTORY_ITEM_ID
ORGANIZATION_ID
PERIOD_ID