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

TABLE: GMF.CM_REAS_CDS

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


The Cost Adjustments Reason Codes Table will allow the user to define
specific codes for given reason of making the adjustment. These codes
will be user defined.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CM_REAS_CDS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREASON_CODE
Columns
Name Datatype Length Mandatory Comments
REASON_CODE VARCHAR2 (4) Yes Reason Code
REASON_DESC VARCHAR2 (40) Yes Description of reason code
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.
CREATION_DATE DATE
Yes 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
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
SUBLEDGER_IND NUMBER (5)
Subledger Entry Indicator (0 => No, 1 => Yes)
Query Text

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


SELECT REASON_CODE
,      REASON_DESC
,      TEXT_CODE
,      TRANS_CNT
,      DELETE_MARK
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SUBLEDGER_IND
FROM GMF.CM_REAS_CDS;

Dependencies

[top of page]

GMF.CM_REAS_CDS does not reference any database object

GMF.CM_REAS_CDS is referenced by following:

SchemaGMF
ViewCM_REAS_CDS#