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

TABLE: GMF.CM_ADJS_DTL

Object Details
Object Name: CM_ADJS_DTL
Object Type: TABLE
Owner: GMF
FND Design Data: TableGMF.CM_ADJS_DTL
Subobject Name:
Status: VALID


The Actual Cost Adjustments Details tables contains the adjustments
details required and entered for cost adjustments.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CM_ADJS_DTLI1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOST_ADJUST_ID
CM_ADJS_DTL_PK NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnINVENTORY_ITEM_ID
ColumnPERIOD_ID
ColumnCOST_TYPE_ID
ColumnCOST_CMPNTCLS_ID
ColumnCOST_ANALYSIS_CODE#1
ColumnCOST_ADJUST_ID
Columns
Name Datatype Length Mandatory Comments
ITEM_ID NUMBER (10)
surrogate for item
WHSE_CODE VARCHAR2 (4)
specific warehouse for the cost
CALENDAR_CODE VARCHAR2 (4)
Cost Calendar defined for the transaction based on dates
PERIOD_CODE VARCHAR2 (4)
Cost Period defined for the transaction based on dates
COST_MTHD_CODE VARCHAR2 (4)
Actual cost method code used
COST_CMPNTCLS_ID NUMBER (10) Yes component class surrogate
COST_ADJUST_ID NUMBER (10) Yes Natural unique key, also serves as a tie breaker for multiple adjustments within the cm_cmpt_dtll key structure
ADJUST_QTY NUMBER
Yes Adjustment quantity(+ or -)
ADJUST_QTY_UM VARCHAR2 (4)
Adjustment quantity uom
ADJUST_COST NUMBER
Yes Adjustment cost per uom(+ or -)
REASON_CODE VARCHAR2 (4) Yes Adjustment Reason. FK to cm_reas_cds
ADJUST_STATUS NUMBER (5) Yes Adjustment status: (0) Not applied (1) Applied (2) Modified
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
TEXT_CODE NUMBER (10)
ID which joins any rows of text in this table to the Text Table for this Module
TRANS_CNT NUMBER (10)
Not currently used
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
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Who Columns
ATTRIBUTE1 VARCHAR2 (240)
Who Columns
ATTRIBUTE2 VARCHAR2 (240)
Who Columns
ATTRIBUTE3 VARCHAR2 (240)
Who Columns
ATTRIBUTE4 VARCHAR2 (240)
Who Columns
ATTRIBUTE5 VARCHAR2 (240)
Who Columns
ATTRIBUTE6 VARCHAR2 (240)
Who Columns
ATTRIBUTE7 VARCHAR2 (240)
Who Columns
ATTRIBUTE8 VARCHAR2 (240)
Who Columns
ATTRIBUTE9 VARCHAR2 (240)
Who Columns
ATTRIBUTE10 VARCHAR2 (240)
Who Columns
ATTRIBUTE11 VARCHAR2 (240)
Who Columns
ATTRIBUTE12 VARCHAR2 (240)
Who Columns
ATTRIBUTE13 VARCHAR2 (240)
Who Columns
ATTRIBUTE14 VARCHAR2 (240)
Who Columns
ATTRIBUTE15 VARCHAR2 (240)
Who Columns
ATTRIBUTE16 VARCHAR2 (240)
Who Columns
ATTRIBUTE17 VARCHAR2 (240)
Who Columns
ATTRIBUTE18 VARCHAR2 (240)
Who Columns
ATTRIBUTE19 VARCHAR2 (240)
Who Columns
ATTRIBUTE20 VARCHAR2 (240)
Who Columns
ATTRIBUTE21 VARCHAR2 (240)
Who Columns
ATTRIBUTE22 VARCHAR2 (240)
Who Columns
ATTRIBUTE23 VARCHAR2 (240)
Who Columns
ATTRIBUTE24 VARCHAR2 (240)
Who Columns
ATTRIBUTE25 VARCHAR2 (240)
Who Columns
ATTRIBUTE26 VARCHAR2 (240)
Who Columns
ATTRIBUTE27 VARCHAR2 (240)
Who Columns
ATTRIBUTE28 VARCHAR2 (240)
Who Columns
ATTRIBUTE29 VARCHAR2 (240)
Who Columns
ATTRIBUTE30 VARCHAR2 (240)
Who Columns
ADJUST_QTY_UOM VARCHAR2 (3)
Adjustment unit of measure
COST_TYPE_ID NUMBER (15)
cost type identifier
INVENTORY_ITEM_ID NUMBER (15)
inventory item identifier
ORGANIZATION_ID NUMBER (15)
organization identifier
PERIOD_ID NUMBER (15)
period identifier
ADJUSTMENT_DATE DATE

Adjustment Date
ADJUSTMENT_IND NUMBER (5)
Adjustment Indicator (0 => Average, 1 => Value, 2 => Unit)
GL_POSTED_IND NUMBER (5)
GL Posting Indicator (0 => No, 1 => Yes)
SUBLEDGER_IND NUMBER (5)
Subledger Entry Indicator (0 => No, 1 => Yes)
COST_ANALYSIS_CODE#1 VARCHAR2 (32) Yes COST ANALYSIS CODE #1
Query Text

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


SELECT ITEM_ID
,      WHSE_CODE
,      CALENDAR_CODE
,      PERIOD_CODE
,      COST_MTHD_CODE
,      COST_CMPNTCLS_ID
,      COST_ADJUST_ID
,      ADJUST_QTY
,      ADJUST_QTY_UM
,      ADJUST_COST
,      REASON_CODE
,      ADJUST_STATUS
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      TEXT_CODE
,      TRANS_CNT
,      DELETE_MARK
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      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
,      ADJUST_QTY_UOM
,      COST_TYPE_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      PERIOD_ID
,      ADJUSTMENT_DATE
,      ADJUSTMENT_IND
,      GL_POSTED_IND
,      SUBLEDGER_IND
,      COST_ANALYSIS_CODE#1
FROM GMF.CM_ADJS_DTL;

Dependencies

[top of page]

GMF.CM_ADJS_DTL does not reference any database object

GMF.CM_ADJS_DTL is referenced by following:

SchemaGMF
ViewCM_ADJS_DTL#