DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.CM_CMPT_DTL_VW

Object Details
Object Name: CM_CMPT_DTL_VW
Object Type: VIEW
Owner: APPS
FND Design Data: ViewGMF.CM_CMPT_DTL_VW
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


View in cm_cmpt_dtl table


[View Source]

Columns
Name Datatype Length Mandatory Comments
CMPNTCOST_ID NUMBER (10) Yes Surrogate ID for the Cost Component
ITEM_ID NUMBER (10)
Surrogate for item for which the cost is specified
WHSE_CODE VARCHAR2 (4)
Warehouse for which the cost is specified
CALENDAR_CODE VARCHAR2 (4)
Cost Calendar for which the cost is specified
PERIOD_CODE VARCHAR2 (4)
Costing Period for which the cost is specified
COST_MTHD_CODE VARCHAR2 (4)
Cost Method for which the cost is specified
COST_CMPNTCLS_ID NUMBER (10) Yes Surrogate for component class
COST_ANALYSIS_CODE VARCHAR2 (32) Yes Cost analysis code
COST_LEVEL NUMBER (5) Yes Cost source. 0=Directly entered or Routing/Burden costs calculated by Cost Rollup process or Calculated by Actual Cost Process, 1= Costs via Ingredients calculated by Cost Rollup Process
CMPNT_COST NUMBER
Yes Component cost
BURDEN_IND NUMBER (5) Yes Indicates if costs came from burdens 0=No 1=Yes
FMEFF_ID NUMBER (10)
Effectivity used in determining Product(hence formula, routing - if any) during Cost Rollup Process
ROLLOVER_IND NUMBER (5) Yes Indicates if costs have been updated to GL area and hence frozen or not - 0=No 1=Yes, updated.
TOTAL_QTY NUMBER

Written by Actual Cost Process. Usually the total transaction quantity of the item used in calculating the actual cost but not used currently by other programs.
COSTCALC_ORIG NUMBER (5)
Cost calculation origin for actual costs only; 0 = Actual Cost Calculaion, 1 = Cost Development Process
RMCALC_TYPE NUMBER (5)
Raw Material Cost Calculation Type (applicable under actual costs only, =0 otherwise) 1-PMAC, 2-PWAC, 3-PPAC, 4-LSTT, 5 -LSTI
ROLLUP_REF_NO NUMBER (10)
Reference number of the Cost Rollup process that calculated this cost
ACPROC_ID NUMBER (10)
Reference number of the Actual Cost Process that calculated this cost
TRANS_CNT NUMBER (10)
Not currently used
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
DELETE_MARK NUMBER (5) Yes Standard: 0=Active record (default); 1=Marked for (logical) deletion.
REQUEST_ID NUMBER (15)
Concurrent who column
PROGRAM_APPLICATION_ID NUMBER (15)
Concurrent who column
PROGRAM_ID NUMBER (15)
Concurrent who column
PROGRAM_UPDATE_DATE DATE

Concurrent who column
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE21 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE22 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE23 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE24 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE25 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE26 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE27 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE28 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE29 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE30 VARCHAR2 (240)
Descriptive flexfield segment
CREATION_DATE DATE
Yes Concurrent who column
CREATED_BY NUMBER (15) Yes Concurrent who column
LAST_UPDATE_DATE DATE
Yes Concurrent who column
LAST_UPDATED_BY NUMBER (15) Yes Concurrent who column
LAST_UPDATE_LOGIN NUMBER (15)
Concurrent who column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield segment
PERIOD_TRANS_QTY NUMBER

Total perpetual transaction quantity
PERIOD_PERP_QTY NUMBER

Total period transaction quantity
COST_TYPE_ID NUMBER (15)
Surrogate id uniquely identifying an cost type
INVENTORY_ITEM_ID NUMBER (15)
Surrogate id uniquely identifying an item
ORGANIZATION_ID NUMBER (15)
Surrogate id uniquely identifying an Organization
PERIOD_ID NUMBER (15)
Surrogate id uniquely identifying an period.
Query Text

Cut, paste (and edit) the following text to query this object:


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 APPS.CM_CMPT_DTL_VW;

Dependencies

[top of page]

APPS.CM_CMPT_DTL_VW references the following:

SchemaAPPS
SynonymCM_CMPT_DTL

APPS.CM_CMPT_DTL_VW is not referenced by any database object