[Home] [Help] [Dependency Information]
Object Name: | PO_DRAFTS# |
---|---|
Object Type: | VIEW |
Owner: | PO |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DRAFT_ID | NUMBER | Yes | ||
DOCUMENT_ID | NUMBER | Yes | ||
REVISION_NUM | NUMBER | |||
OWNER_USER_ID | NUMBER | Yes | ||
OWNER_ROLE | VARCHAR2 | (10) | Yes | |
STATUS | VARCHAR2 | (15) | Yes | |
JUSTIFICATION | VARCHAR2 | (4000) | ||
NOTE_TO_SUPPLIER | VARCHAR2 | (4000) | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
REQUEST_ID | NUMBER | |||
DRAFT_TYPE | VARCHAR2 | (30) | ||
MOD_EFFECTIVE_DATE | DATE | |||
MODIFICATION_NUMBER | VARCHAR2 | (100) | ||
CLM_NOOFCOPIES | NUMBER | |||
CD_GENERATED_DATE | DATE | |||
CD_EDITBYUSER_FLAG | VARCHAR2 | (1) | ||
CD_GENERATED_FLAG | VARCHAR2 | (1) | ||
MODUPDATED_AFTERCDGENERATED | VARCHAR2 | (1) | ||
CHANGEDESCRIPTION_DATA | CLOB | (4000) | ||
CONCURRENT_REQID | VARCHAR2 | (20) | ||
CLM_STANDARD_FORM | VARCHAR2 | (200) | ||
CLM_DOCUMENT_FORMAT | VARCHAR2 | (50) | ||
CHANGED_AMT | NUMBER | |||
CHANGED_AMT_EXCL_OPT | NUMBER | |||
CLM_CONTRACT_OFFICER | NUMBER | |||
AGENT_ID | NUMBER | |||
CLM_EDAGEN_DATE | DATE | |||
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#;
|
|
|