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

VIEW: APPS.CM_CMPT_DTL_VW1

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

View Type

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


View on cm_cmpt_dtl


[View Source]

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER (15)
item identifier
ORGANIZATION_ID NUMBER (15)
organization identifier
CALENDAR_CODE VARCHAR2 (10) Yes calendar code
PERIOD_CODE VARCHAR2 (10) Yes period code
PERIOD_ID NUMBER (15) Yes period identifier
COST_MTHD_CODE VARCHAR2 (10) Yes cost method code
COST_CMPNTCLS_ID NUMBER (10) Yes cost component class identifier
COST_CMPNTCLS_CODE VARCHAR2 (16) Yes cost component code
COST_CMPNTCLS_DESC VARCHAR2 (40) Yes cost component class description
SORT_SEQUENCE NUMBER (10) Yes sorting sequence
USAGE_IND NUMBER (5) Yes usage indicator
COST_ANALYSIS_CODE VARCHAR2 (4) Yes analysis code
COST_LEVEL NUMBER (5) Yes cost level
CMPNT_COST NUMBER
Yes component cost
BURDEN_IND NUMBER (5) Yes burden indicator
TRANS_CNT NUMBER (10)
transaction count
TEXT_CODE NUMBER (10)
text code
DELETE_MARK NUMBER (5) Yes delete mark
COST_TYPE_ID NUMBER (15)
cost type identifier
Query Text

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


SELECT 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
FROM APPS.CM_CMPT_DTL_VW1;

Dependencies

[top of page]

APPS.CM_CMPT_DTL_VW1 references the following:

SchemaAPPS
SynonymCM_CMPT_DTL
SynonymCM_CMPT_MST
SynonymCM_MTHD_MST
SynonymGMF_PERIOD_STATUSES

APPS.CM_CMPT_DTL_VW1 is not referenced by any database object