eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: PO.PO_DRAFTS#

Source

View Text - Preformatted


select DRAFT_ID DRAFT_ID, DOCUMENT_ID DOCUMENT_ID, REVISION_NUM REVISION_NUM, OWNER_USER_ID OWNER_USER_ID, OWNER_ROLE OWNER_ROLE, STATUS STATUS, JUSTIFICATION JUSTIFICATION, NOTE_TO_SUPPLIER NOTE_TO_SUPPLIER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, REQUEST_ID REQUEST_ID, DRAFT_TYPE DRAFT_TYPE, MOD_EFFECTIVE_DATE MOD_EFFECTIVE_DATE, MODIFICATION_NUMBER MODIFICATION_NUMBER, CLM_NOOFCOPIES CLM_NOOFCOPIES, CD_GENERATED_DATE CD_GENERATED_DATE, CD_EDITBYUSER_FLAG CD_EDITBYUSER_FLAG, CD_GENERATED_FLAG CD_GENERATED_FLAG, MODUPDATED_AFTERCDGENERATED MODUPDATED_AFTERCDGENERATED, CHANGEDESCRIPTION_DATA CHANGEDESCRIPTION_DATA, CONCURRENT_REQID CONCURRENT_REQID, CLM_STANDARD_FORM CLM_STANDARD_FORM, CLM_DOCUMENT_FORMAT CLM_DOCUMENT_FORMAT, CHANGED_AMT CHANGED_AMT, CHANGED_AMT_EXCL_OPT CHANGED_AMT_EXCL_OPT, CLM_CONTRACT_OFFICER CLM_CONTRACT_OFFICER, AGENT_ID AGENT_ID, CLM_EDAGEN_DATE CLM_EDAGEN_DATE, DRAFT_SUB_TYPE DRAFT_SUB_TYPE from "PO"."PO_DRAFTS"

View Text - HTML Formatted

SELECT DRAFT_ID DRAFT_ID
, DOCUMENT_ID DOCUMENT_ID
, REVISION_NUM REVISION_NUM
, OWNER_USER_ID OWNER_USER_ID
, OWNER_ROLE OWNER_ROLE
, STATUS STATUS
, JUSTIFICATION JUSTIFICATION
, NOTE_TO_SUPPLIER NOTE_TO_SUPPLIER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, REQUEST_ID REQUEST_ID
, DRAFT_TYPE DRAFT_TYPE
, MOD_EFFECTIVE_DATE MOD_EFFECTIVE_DATE
, MODIFICATION_NUMBER MODIFICATION_NUMBER
, CLM_NOOFCOPIES CLM_NOOFCOPIES
, CD_GENERATED_DATE CD_GENERATED_DATE
, CD_EDITBYUSER_FLAG CD_EDITBYUSER_FLAG
, CD_GENERATED_FLAG CD_GENERATED_FLAG
, MODUPDATED_AFTERCDGENERATED MODUPDATED_AFTERCDGENERATED
, CHANGEDESCRIPTION_DATA CHANGEDESCRIPTION_DATA
, CONCURRENT_REQID CONCURRENT_REQID
, CLM_STANDARD_FORM CLM_STANDARD_FORM
, CLM_DOCUMENT_FORMAT CLM_DOCUMENT_FORMAT
, CHANGED_AMT CHANGED_AMT
, CHANGED_AMT_EXCL_OPT CHANGED_AMT_EXCL_OPT
, CLM_CONTRACT_OFFICER CLM_CONTRACT_OFFICER
, AGENT_ID AGENT_ID
, CLM_EDAGEN_DATE CLM_EDAGEN_DATE
, DRAFT_SUB_TYPE DRAFT_SUB_TYPE
FROM "PO"."PO_DRAFTS"