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

TABLE: GMF.CM_RLUP_ITM

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


Contains the list of items for which Cost Rollup is to be run. Will have rows only for those rollup runs that are submitted as a List of Items Rollup. Regarding removal of the delete_mark column between the 4.1 and 11.0 releases - OPM only selects or inserts rows into this table, therefore the 'delete_mark' column is not needed. While migrating we can migrate all the rows irrespective of the delete_mark column (actually there should not be any rows with delete_mark = 1)


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CM_RLUP_ITM_PK NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnROLLUP_ID
ColumnORGANIZATION_ID
ColumnINVENTORY_ITEM_ID
Columns
Name Datatype Length Mandatory Comments
ROLLUP_ID NUMBER (10) Yes Rollup reference number
ITEM_ID NUMBER (10)
Surrogate to the item that is entered in the List of Items during Rollup process submission
IN_USE NUMBER (10)
Not currently used
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
INVENTORY_ITEM_ID NUMBER (15)
Inventory Item identifier
ORGANIZATION_ID NUMBER (15)
Inventory Organization identifier
Query Text

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


SELECT ROLLUP_ID
,      ITEM_ID
,      IN_USE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
FROM GMF.CM_RLUP_ITM;

Dependencies

[top of page]

GMF.CM_RLUP_ITM does not reference any database object

GMF.CM_RLUP_ITM is referenced by following:

SchemaAPPS
SynonymCM_RLUP_ITM