[Home] [Help] [Dependency Information]
Object Name: | PO_DRAFTS |
---|---|
Object Type: | TABLE |
Owner: | PO |
FND Design Data: | PO.PO_DRAFTS |
Subobject Name: | |
Status: | VALID |
This table serves as the control table for draft changes. Each record in document draft tables should reference a record in this table. Records in this table also contain status information for the draft change requests.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PO_DRAFTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | DRAFT_ID |
SYS_IL0000409365C00023$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
PO_DRAFTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
OWNER_ROLE
STATUS |
PO_DRAFTS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | DOCUMENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DRAFT_ID | NUMBER | Yes | Draft Unique Identifier | |
DOCUMENT_ID | NUMBER | Yes | ID of the document. For draft for po documents, it is PO_HEADER_ID | |
REVISION_NUM | NUMBER | Revision of the document this draft is created for | ||
OWNER_USER_ID | NUMBER | Yes | User Id of the owner of the draft | |
OWNER_ROLE | VARCHAR2 | (10) | Yes | Role of the user owning the draft. Possible values: BUYER, SUPPLIER, CAT ADMIN |
STATUS | VARCHAR2 | (15) | Yes | Current stautus of the draft |
JUSTIFICATION | VARCHAR2 | (4000) | Reason for creating this draft | |
NOTE_TO_SUPPLIER | VARCHAR2 | (4000) | Note to supplier | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
DRAFT_TYPE | VARCHAR2 | (30) | The type of the draft record. | |
MOD_EFFECTIVE_DATE | DATE | Modification effecting date | ||
MODIFICATION_NUMBER | VARCHAR2 | (100) | Modification Number for the Document | |
CLM_NOOFCOPIES | NUMBER | Number of Copies of the Document to be sent to Supplier | ||
CD_GENERATED_DATE | DATE | Change Description generation date | ||
CD_EDITBYUSER_FLAG | VARCHAR2 | (1) | Is Change Description edited by user | |
CD_GENERATED_FLAG | VARCHAR2 | (1) | Has Change Description been generated | |
MODUPDATED_AFTERCDGENERATED | VARCHAR2 | (1) | Is Modification updated after Change Description generation | |
CHANGEDESCRIPTION_DATA | CLOB | (4000) | Stores the Change Description data | |
CONCURRENT_REQID | VARCHAR2 | (20) | Concurrent request id which updated this row | |
CLM_STANDARD_FORM | VARCHAR2 | (200) | Standard Form for Printing | |
CLM_DOCUMENT_FORMAT | VARCHAR2 | (50) | Document Format for Printing | |
CHANGED_AMT | NUMBER | Sum of amount changed in all lines including option lines | ||
CHANGED_AMT_EXCL_OPT | NUMBER | Sum of amount changed in all lines excluding option lines | ||
CLM_CONTRACT_OFFICER | NUMBER | Contracting officer of the Modification | ||
AGENT_ID | NUMBER | |||
CLM_EDAGEN_DATE | DATE | Date on which EDA was generated | ||
DRAFT_SUB_TYPE | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT DRAFT_ID
, DOCUMENT_ID
, REVISION_NUM
, OWNER_USER_ID
, OWNER_ROLE
, STATUS
, JUSTIFICATION
, NOTE_TO_SUPPLIER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, REQUEST_ID
, DRAFT_TYPE
, MOD_EFFECTIVE_DATE
, MODIFICATION_NUMBER
, CLM_NOOFCOPIES
, CD_GENERATED_DATE
, CD_EDITBYUSER_FLAG
, CD_GENERATED_FLAG
, MODUPDATED_AFTERCDGENERATED
, CHANGEDESCRIPTION_DATA
, CONCURRENT_REQID
, CLM_STANDARD_FORM
, CLM_DOCUMENT_FORMAT
, CHANGED_AMT
, CHANGED_AMT_EXCL_OPT
, CLM_CONTRACT_OFFICER
, AGENT_ID
, CLM_EDAGEN_DATE
, DRAFT_SUB_TYPE
FROM PO.PO_DRAFTS;
PO.PO_DRAFTS does not reference any database object
PO.PO_DRAFTS is referenced by following:
|
|
|