eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: GMD.GMD_MSNR_RESULTS

Object Details

Object Name:	GMD_MSNR_RESULTS
Object Type:	TABLE
Owner:	GMD
FND Design Data:	GMD.GMD_MSNR_RESULTS
Subobject Name:
Status:	VALID

GMD Mass Search and Replace table for storing query results

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
CONCURRENT_ID	NUMBER	(15)	Stores ID that is used by concurrent program for mass replace
OBJECT_ID	NUMBER	(15)	Object Id e.g Formula Id or Recipe Id that is manipulated in Mass search and Replace
OBJECT_NAME	VARCHAR2	(80)	Object Name e.g Formula No or Recipe No that is manipulated in Mass search and Replace
OBJECT_VERS	NUMBER	(5)	Object Version e.g Formula Vers or Recipe Version that is manipulated in Mass search and Replace
OBJECT_STATUS_CODE	VARCHAR2	(32)	Object Status e.g Formula Status or Recipe Status
OBJECT_STATUS_DESC	VARCHAR2	(80)	Object Status Description e.g Approved for General Use or New or On-Hold
OBJECT_SELECT_IND	VARCHAR2	(1)	Incates if the object is selected for Mass Replace. Valid values are 0 and 1
OBJECT_DESC#1	VARCHAR2	(240)	Object description e.g Formula Description or Recipe Description

Query Text

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


SELECT CONCURRENT_ID
,      OBJECT_ID
,      OBJECT_NAME
,      OBJECT_VERS
,      OBJECT_STATUS_CODE
,      OBJECT_STATUS_DESC
,      OBJECT_SELECT_IND
,      OBJECT_DESC#1
FROM GMD.GMD_MSNR_RESULTS;

Dependencies

[top of page]

GMD.GMD_MSNR_RESULTS does not reference any database object

GMD.GMD_MSNR_RESULTS is referenced by following:

GMD: GMD_MSNR_RESULTS#