VIEW: APPS.CM_CMPT_DTL_VW

Source

View Text - Preformatted

SELECT 0, item_id, whse_code, calendar_code, period_code, cost_mthd_code, cost_cmpntcls_id, cost_analysis_code, 0 cost_level, SUM (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 WHERE NVL(rmcalc_type,0) > 0 GROUP BY item_id, whse_code, calendar_code, period_code, cost_mthd_code, cost_cmpntcls_id, cost_analysis_code, 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 UNION ALL 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 WHERE NVL(rmcalc_type,0) = 0

View Text - HTML Formatted

SELECT 0
, ITEM_ID
, WHSE_CODE
, CALENDAR_CODE
, PERIOD_CODE
, COST_MTHD_CODE
, COST_CMPNTCLS_ID
, COST_ANALYSIS_CODE
, 0 COST_LEVEL
, SUM (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
WHERE NVL(RMCALC_TYPE
, 0) > 0 GROUP BY ITEM_ID
, WHSE_CODE
, CALENDAR_CODE
, PERIOD_CODE
, COST_MTHD_CODE
, COST_CMPNTCLS_ID
, COST_ANALYSIS_CODE
, 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 UNION ALL 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
WHERE NVL(RMCALC_TYPE
, 0) = 0