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

TABLE: GMF.CM_ADJS_DTL_EFC

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


Shadow table of CM_ADJS_DTL for EFC migration. Stores the original values of columns of CM_ADJS_DTL that are to be converted to the Euro currency as a part of EFC migration. The table consists of the primary key columns of CM_ADJS_DTL and only the columns that are actually converted to the Euro currency.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
COST_CMPNTCLS_ID NUMBER
Yes Cost component class surrogate
WHSE_CODE VARCHAR2 (4) Yes Warehouse for the cost
ADJUST_COST NUMBER
Yes Adjustment cost per uom (+ or -)
ITEM_ID NUMBER
Yes Item code surrogate
CALENDAR_CODE VARCHAR2 (4) Yes Cost calendar for the transaction based on transaction date
PERIOD_CODE VARCHAR2 (4) Yes Cost period for the transaction based on transaction date
COST_ANALYSIS_CODE VARCHAR2 (4) Yes Cost analysis code
COST_ADJUST_ID NUMBER
Yes Natural unique key, also serves as a tie breaker for multiple adjustments within the cm_cmpt_dtl1 key structure
COST_MTHD_CODE VARCHAR2 (4) Yes Actual cost method code used
SET_OF_BOOKS_ID NUMBER
Yes Set of books identifier
Query Text

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


SELECT COST_CMPNTCLS_ID
,      WHSE_CODE
,      ADJUST_COST
,      ITEM_ID
,      CALENDAR_CODE
,      PERIOD_CODE
,      COST_ANALYSIS_CODE
,      COST_ADJUST_ID
,      COST_MTHD_CODE
,      SET_OF_BOOKS_ID
FROM GMF.CM_ADJS_DTL_EFC;

Dependencies

[top of page]

GMF.CM_ADJS_DTL_EFC does not reference any database object

GMF.CM_ADJS_DTL_EFC is referenced by following:

SchemaAPPS
SynonymCM_ADJS_DTL_EFC