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


TABLE: GMF.CM_CUPD_MSG

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


Cost Update Process Error Messages Table - error messages found during the process. No duplicate eroror messages are written. These error messages are used by the OPM user to evaluate performance and accuracy of the process and, if necessary, to take proper action and re-run the process.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CM_CUPD_MSG_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUPROC_ID
ColumnLINE_NO
Columns
Name Datatype Length Mandatory Comments
CUPROC_ID NUMBER (10) Yes Cost Update process reference number
LINE_NO NUMBER (10) Yes Sequential number to order the messages generated
MESSAGE_COMMENT VARCHAR2 (240) Yes Message text generated/composed during the Cost Update process
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
DELETE_MARK NUMBER (5) Yes Standard delete mark
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
Query Text

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


SELECT CUPROC_ID
,      LINE_NO
,      MESSAGE_COMMENT
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      DELETE_MARK
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM GMF.CM_CUPD_MSG;

Dependencies

[top of page]

GMF.CM_CUPD_MSG does not reference any database object

GMF.CM_CUPD_MSG is referenced by following:

SchemaAPPS
SynonymCM_CUPD_MSG