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

TABLE: GMA.GMA_UPGRADE_SETUP

Object Details
Object Name: GMA_UPGRADE_SETUP
Object Type: TABLE
Owner: GMA
Subobject Name:
Status: VALID


Table to store data for the migraiton data transformation


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
UPGRADE_ID NUMBER (15)
Upgrade id for the upgrade
TABLE_NAME VARCHAR2 (80)
Name of the table from which the data is migrated and to which the data is migrated
OLD_COLUMN_NAME VARCHAR2 (80)
Name of the old column value for org, Item, Lot and UOM in OPM inventory
NEW_COLUMN_NAME VARCHAR2 (80)
Name of the new column to which the transformed values will be kept
ORG_TABLE_NAME VARCHAR2 (80)
Organization table name for the item and lot transformation
ORG_COLUMN_NAME VARCHAR2 (80)
Column name for the organization value in OPM table
ORG_JOIN_KEY_COLUMN VARCHAR2 (80)
Org join key column between the org and old table name
UPGRADE_TYPE NUMBER (5)
1,2,3,4 dependign on ORG, UOM, ITM and lot migraiton
MIGRATED_IND NUMBER (5)
Defines the success of teh migraiton
PRODUCT_CODE VARCHAR2 (10)
Product for the table
COMMENTS VARCHAR2 (2000)
Developers comments on the table migration and data transformation
ITEM_COLUMN_NAME VARCHAR2 (80)
Item values for the column
CREATION_DATE DATE

Standard Who column
LAST_UPDATE_DATE DATE

Standard who column
Query Text

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


SELECT UPGRADE_ID
,      TABLE_NAME
,      OLD_COLUMN_NAME
,      NEW_COLUMN_NAME
,      ORG_TABLE_NAME
,      ORG_COLUMN_NAME
,      ORG_JOIN_KEY_COLUMN
,      UPGRADE_TYPE
,      MIGRATED_IND
,      PRODUCT_CODE
,      COMMENTS
,      ITEM_COLUMN_NAME
,      CREATION_DATE
,      LAST_UPDATE_DATE
FROM GMA.GMA_UPGRADE_SETUP;

Dependencies

[top of page]

GMA.GMA_UPGRADE_SETUP does not reference any database object

GMA.GMA_UPGRADE_SETUP is referenced by following:

SchemaAPPS
SynonymGMA_UPGRADE_SETUP