eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: CM_CMPT_DTL_VW1

Product:	GMF - Process Manufacturing Financials
Description:	View on cm_cmpt_dtl
Implementation/DBA Data:	APPS.CM_CMPT_DTL_VW1

View Text

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

Columns

Name
INVENTORY_ITEM_ID
ORGANIZATION_ID
CALENDAR_CODE
PERIOD_CODE
PERIOD_ID
COST_MTHD_CODE
COST_CMPNTCLS_ID
COST_CMPNTCLS_CODE
COST_CMPNTCLS_DESC
SORT_SEQUENCE
USAGE_IND
COST_ANALYSIS_CODE
COST_LEVEL
CMPNT_COST
BURDEN_IND
TRANS_CNT
TEXT_CODE
DELETE_MARK
COST_TYPE_ID