[Home] [Help] [Dependency Information]
Object Name: | GR_DOCUMENT_HEADINGS |
---|---|
Object Type: | TABLE |
Owner: | GR |
FND Design Data: | GR.GR_DOCUMENT_HEADINGS |
Subobject Name: | |
Status: | VALID |
Contains the headings and subheadings linked to a document.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GR_DOCUMENT_HEADINGS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | DOCUMENT_HEADINGS_SEQNO |
GR_DOCUMENT_HEADINGS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DOCUMENT_CODE |
GR_DOCUMENT_HEADINGS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | MAIN_HEADING_CODE |
GR_DOCUMENT_HEADINGS_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SUB_HEADING_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DOCUMENT_HEADINGS_SEQNO | NUMBER | Yes | Surrogate key for the item. | |
DOCUMENT_CODE | VARCHAR2 | (10) | Yes | The Document Code for the document. |
MAIN_HEADING_CODE | VARCHAR2 | (10) | Yes | The Main Heading Code where the heading text is located. |
MAIN_DISPLAY_ORDER | NUMBER | (15) | Yes | Display Order value to arrange the Document Main Headings as required. |
SUB_HEADING_CODE | VARCHAR2 | (10) | The Sub Heading Code for the sub heading text. | |
SUB_DISPLAY_ORDER | NUMBER | (15) | Display Order value to arrange the Document Sub Headings as required. | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
CREATION_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column |
Cut, paste (and edit) the following text to query this object:
SELECT DOCUMENT_HEADINGS_SEQNO
, DOCUMENT_CODE
, MAIN_HEADING_CODE
, MAIN_DISPLAY_ORDER
, SUB_HEADING_CODE
, SUB_DISPLAY_ORDER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM GR.GR_DOCUMENT_HEADINGS;
GR.GR_DOCUMENT_HEADINGS does not reference any database object
GR.GR_DOCUMENT_HEADINGS is referenced by following:
|
|
|