[Home] [Help] [Dependency Information]
Object Name: | GR_ITEM_DOC_STATUSES |
---|---|
Object Type: | TABLE |
Owner: | GR |
FND Design Data: | GR.GR_ITEM_DOC_STATUSES |
Subobject Name: | |
Status: | VALID |
Contains the last change date and Item Document Status.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GR_ITEM_DOC_STATUSES_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ITEM_CODE
DOCUMENT_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_CODE | VARCHAR2 | (32) | Yes | The Item Code for the substance used in or produced by the process. |
DOCUMENT_CODE | VARCHAR2 | (10) | Yes | The Document Code for the document. |
ITEM_DOCUMENT_STATUS | VARCHAR2 | (1) | Yes | The Item Document Status. Valid Item Document Statuses are: P - Pending approvalL - Locked; in use or cannot be rebuiltA - ApprovedS - Secure; cannot be modified. |
ITEM_DOCUMENT_VERSION | NUMBER | The Item Document Version. | ||
REBUILD_ITEM_DOC_FLAG | VARCHAR2 | (1) | Yes | Y or N to indicate whether the document has been approved to rebuild with the current changes, additions, and deletions in effect. The default is N. |
LAST_APPROVAL_USER | NUMBER | When the Use Workflow preference is set to Y, this field will contain the user ID of the last person who approved changes to this Item Document. When the Use Workflow preference is set to N, this field will be empty. | ||
LAST_DOC_AUTHOR_LOCK | NUMBER | Contains the user ID of the author who last modified the Item Document. | ||
LAST_DOC_UPDATE_DATE | DATE | Yes | Contains the Date when the document was last modified. | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_CODE
, DOCUMENT_CODE
, ITEM_DOCUMENT_STATUS
, ITEM_DOCUMENT_VERSION
, REBUILD_ITEM_DOC_FLAG
, LAST_APPROVAL_USER
, LAST_DOC_AUTHOR_LOCK
, LAST_DOC_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM GR.GR_ITEM_DOC_STATUSES;
GR.GR_ITEM_DOC_STATUSES does not reference any database object
GR.GR_ITEM_DOC_STATUSES is referenced by following:
|
|
|