VIEW: APPS.CM_CMPT_DTL_VW

Source

View Text - Preformatted

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

View Text - HTML Formatted

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