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: TableGR.GR_PROP_CHNG_TEMP
Subobject Name:
Status: VALID


GR Table used by the Map to temporaily property change information


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory 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:

SchemaAPPS
SynonymGR_PROP_CHNG_TEMP