[Home] [Help] [Dependency Information]
Object Name: | GR_RECIPIENT_DOCUMENTS |
---|---|
Object Type: | TABLE |
Owner: | GR |
FND Design Data: | GR.GR_RECIPIENT_DOCUMENTS |
Subobject Name: | |
Status: | VALID |
This entity will only be populated if the ADDITIONAL DOCUMENT
FLAG on the customer entity is set to 'Y'. It allows the user to specify
the printing of additional documents with the primary document. An
example of this might be the primary document being the MSDS and
an additional document being a technical or VOC data sheet.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GR_RECIPIENT_DOCUMENTS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
RECIPIENT_CODE
DOCUMENT_CODE |
GR_RECIPIENT_DOCUMENTS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DOCUMENT_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
RECIPIENT_CODE | VARCHAR2 | (32) | Yes | The customer code. |
DOCUMENT_CODE | VARCHAR2 | (10) | Yes | The Document code for the document. |
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 CREATED_BY
, RECIPIENT_CODE
, DOCUMENT_CODE
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM GR.GR_RECIPIENT_DOCUMENTS;
GR.GR_RECIPIENT_DOCUMENTS does not reference any database object
GR.GR_RECIPIENT_DOCUMENTS is referenced by following:
|
|
|