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

TABLE: GR.GR_DOCUMENT_RTK

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


Contains the Right-to-Know (RTK) detail information that will display or print on the document.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GR_DOCUMENT_RTK_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDOCUMENT_CODE
ColumnLOCATION_SEGMENT_QUALIFIER
ColumnLOCATION_SEGMENT_VALUE
ColumnPARENT_SEGMENT_ID
GR_DOCUMENT_RTK_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOCATION_SEGMENT_QUALIFIER
ColumnLOCATION_SEGMENT_VALUE
ColumnPARENT_SEGMENT_ID
Columns
Name Datatype Length Mandatory Comments
DOCUMENT_CODE VARCHAR2 (10) Yes The Document Code for the document.
LOCATION_SEGMENT_QUALIFIER VARCHAR2 (30) Yes Identifies which authority this location is for. Values may be sourced from RA_ADDRESSES.
LOCATION_SEGMENT_VALUE VARCHAR2 (60) Yes Upper case of the value in AR_LOCATION_VALUES.LOCATION_SEGMENT_USER_VALUE.
PARENT_SEGMENT_ID NUMBER
Yes Identifies which location 'owns' this location (for example, which State owns this County).
CREATED_BY NUMBER
Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
Query Text

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


SELECT DOCUMENT_CODE
,      LOCATION_SEGMENT_QUALIFIER
,      LOCATION_SEGMENT_VALUE
,      PARENT_SEGMENT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM GR.GR_DOCUMENT_RTK;

Dependencies

[top of page]

GR.GR_DOCUMENT_RTK does not reference any database object

GR.GR_DOCUMENT_RTK is referenced by following:

SchemaAPPS
SynonymGR_DOCUMENT_RTK