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: GR.GR_PROP_CHNG_TEMP

Object Details

Object Name:	GR_PROP_CHNG_TEMP
Object Type:	TABLE
Owner:	GR
FND Design Data:	GR.GR_PROP_CHNG_TEMP
Subobject Name:
Status:	VALID

GR Table used by the Map to temporaily property change information

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
ORGN_ID	NUMBER		Organization Id for which the Property Change is recorded
ITEM_CODE	VARCHAR2	(32)	Item Code for which the Property Change is recorded
PROPERTY_NAME	VARCHAR2	(240)	Property Name for which the Property Change is recorded
PROPERTY_VALUE	VARCHAR2	(240)	Property Value for which the Property Change is recorded
MESSAGE_ICN	NUMBER		This column determines the Message ICN for the Inbound Message

Query Text

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


SELECT ORGN_ID
,      ITEM_CODE
,      PROPERTY_NAME
,      PROPERTY_VALUE
,      MESSAGE_ICN
FROM GR.GR_PROP_CHNG_TEMP;

Dependencies

[top of page]

GR.GR_PROP_CHNG_TEMP does not reference any database object

GR.GR_PROP_CHNG_TEMP is referenced by following:

GR: GR_PROP_CHNG_TEMP#