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

TABLE: GR.GR_ITEMS_REQUESTED

Object Details
Object Name: GR_ITEMS_REQUESTED
Object Type: TABLE
Owner: GR
FND Design Data: TableGR.GR_ITEMS_REQUESTED
Subobject Name:
Status: VALID


Regulatory Items Requests log table, which is updated on every GRIRI inbound requests.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
MESSAGE_ICN NUMBER

This column determines the Message ICN for the Inbound Message
ORGANIZATION NUMBER

Name of organization under which the Items are requested.
FROM_ITEM VARCHAR2 (40)
First Item Name of Range of Items to be searched
TO_ITEM VARCHAR2 (40)
Last Item Name of Range of Items to be searched
Query Text

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


SELECT MESSAGE_ICN
,      ORGANIZATION
,      FROM_ITEM
,      TO_ITEM
FROM GR.GR_ITEMS_REQUESTED;

Dependencies

[top of page]

GR.GR_ITEMS_REQUESTED does not reference any database object

GR.GR_ITEMS_REQUESTED is referenced by following:

SchemaAPPS
SynonymGR_ITEMS_REQUESTED