[Home] [Help]
View: CM_CMPT_DTL_VW
Product: | GMF - Process Manufacturing Financials |
Description: | View of TOTAL_COST |
Implementation/DBA Data: |
APPS.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 |