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

TABLE: IGS.IGS_AS_DUP_DOCS

Object Details
Object Name: IGS_AS_DUP_DOCS
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_AS_DUP_DOCS
Subobject Name:
Status: VALID


Duplicate Documents stores all the duplicate requests for a document.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_AS_DUP_DOCS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnITEM_NUMBER
ColumnREQUESTED_DATE
IGS_AS_DUP_DOCS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORDER_NUMBER
ColumnITEM_NUMBER
Columns
Name Datatype Length Mandatory Comments
ORDER_NUMBER NUMBER (15) Yes Order Number
ITEM_NUMBER NUMBER (15) Yes Item Number for which duplicate is created
REQUESTED_BY NUMBER (15) Yes Person ID of the person who requested the duplicate document
REQUESTED_DATE DATE
Yes Date the duplicate is requested.
FULFILLED_BY NUMBER (15)
Person ID of the person who input the date the duplicate document was sent or submitted the CM job in which the document is created
FULFILLED_DATE DATE

Date the duplicate document is sent; May be manually entered by Admin in case of Manual fulfillment
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
Query Text

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


SELECT ORDER_NUMBER
,      ITEM_NUMBER
,      REQUESTED_BY
,      REQUESTED_DATE
,      FULFILLED_BY
,      FULFILLED_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_AS_DUP_DOCS;

Dependencies

[top of page]

IGS.IGS_AS_DUP_DOCS does not reference any database object

IGS.IGS_AS_DUP_DOCS is referenced by following:

SchemaAPPS
SynonymIGS_AS_DUP_DOCS