PO_VERSIONS_UNPROCESSED

Details

Schema: FUSION
Object owner: PO
Object type: VIEW

Columns

Name
CREATED_BY CHECKLIST_ID COMMUNICATED_TO_SUPPLIER CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN VERSION_ID PO_HEADER_ID CO_SEQUENCE CO_NUM REVISION_NUM CHANGE_ORDER_DESC CHANGE_ORDER_TYPE CHANGE_ORDER_STATUS ONLINE_REPORT_ID MODIFIED_FLAG REJECTED_FLAG WITHDRAWN_FLAG EXTERNAL_SYSTEM_FLAG ORIGINATOR_ID ORIGINATOR_ROLE CO_CANCELED_FLAG CANCEL_BACKING_REQ_FLAG CO_CANCELED_BY_ROLE CO_CANCELED_BY_USER_ID REQUEST_DATE REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE PROGRAM_NAME PROGRAM_APP_NAME CANCEL_DOC_FLAG PROCESSED_DATE PENDING_RESPONSE_ROLE OBJECT_VERSION_NUMBER CREATED_BY_PROGRAM_NAME DOCUMENT_DATE ACCEPTED_DATE SUBMITTED_DATE APPROVED_DATE COMMUNICATED_DATE FUNDS_STATUS

Name

CREATED_BY

CHECKLIST_ID

COMMUNICATED_TO_SUPPLIER

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

VERSION_ID

PO_HEADER_ID

CO_SEQUENCE

CO_NUM

REVISION_NUM

CHANGE_ORDER_DESC

CHANGE_ORDER_TYPE

CHANGE_ORDER_STATUS

ONLINE_REPORT_ID

MODIFIED_FLAG

REJECTED_FLAG

WITHDRAWN_FLAG

EXTERNAL_SYSTEM_FLAG

ORIGINATOR_ID

ORIGINATOR_ROLE

CO_CANCELED_FLAG

CANCEL_BACKING_REQ_FLAG

CO_CANCELED_BY_ROLE

CO_CANCELED_BY_USER_ID

REQUEST_DATE

REQUEST_ID

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

PROGRAM_NAME

PROGRAM_APP_NAME

CANCEL_DOC_FLAG

PROCESSED_DATE

PENDING_RESPONSE_ROLE

OBJECT_VERSION_NUMBER

CREATED_BY_PROGRAM_NAME

DOCUMENT_DATE

ACCEPTED_DATE

SUBMITTED_DATE

APPROVED_DATE

COMMUNICATED_DATE

FUNDS_STATUS

Query

SQL_Statement
SELECT UpVer.CREATED_BY, UpVer.CHECKLIST_ID, UpVer.COMMUNICATED_TO_SUPPLIER, UpVer.CREATION_DATE, UpVer.LAST_UPDATED_BY, UpVer.LAST_UPDATE_DATE, UpVer.LAST_UPDATE_LOGIN, UpVer.VERSION_ID, UpVer.PO_HEADER_ID, UpVer.CO_SEQUENCE, UpVer.CO_NUM, UpVer.REVISION_NUM, UpVer.CHANGE_ORDER_DESC, UpVer.CHANGE_ORDER_TYPE, UpVer.CHANGE_ORDER_STATUS, UpVer.ONLINE_REPORT_ID, UpVer.MODIFIED_FLAG, UpVer.REJECTED_FLAG, UpVer.WITHDRAWN_FLAG, UpVer.EXTERNAL_SYSTEM_FLAG, UpVer.ORIGINATOR_ID, UpVer.ORIGINATOR_ROLE, UpVer.CO_CANCELED_FLAG, UpVer.CANCEL_BACKING_REQ_FLAG, UpVer.CO_CANCELED_BY_ROLE, UpVer.CO_CANCELED_BY_USER_ID, UpVer.REQUEST_DATE, UpVer.REQUEST_ID, UpVer.JOB_DEFINITION_NAME, UpVer.JOB_DEFINITION_PACKAGE, UpVer.PROGRAM_NAME, UpVer.PROGRAM_APP_NAME, UpVer.CANCEL_DOC_FLAG, UpVer.PROCESSED_DATE, UpVer.PENDING_RESPONSE_ROLE, UpVer.OBJECT_VERSION_NUMBER, UpVer.CREATED_BY_PROGRAM_NAME, UpVer.DOCUMENT_DATE, UpVer.ACCEPTED_DATE, UpVer.SUBMITTED_DATE, UpVer.APPROVED_DATE, UpVer.COMMUNICATED_DATE , UpVer.FUNDS_STATUS FROM PO_VERSIONS UpVer WHERE UpVer.CHANGE_ORDER_STATUS <> 'PROCESSED' and UpVer.CO_SEQUENCE > 0

SQL_Statement

SELECT

UpVer.CREATED_BY,

UpVer.CHECKLIST_ID,

UpVer.COMMUNICATED_TO_SUPPLIER,

UpVer.CREATION_DATE,

UpVer.LAST_UPDATED_BY,

UpVer.LAST_UPDATE_DATE,

UpVer.LAST_UPDATE_LOGIN,

UpVer.VERSION_ID,

UpVer.PO_HEADER_ID,

UpVer.CO_SEQUENCE,

UpVer.CO_NUM,

UpVer.REVISION_NUM,

UpVer.CHANGE_ORDER_DESC,

UpVer.CHANGE_ORDER_TYPE,

UpVer.CHANGE_ORDER_STATUS,

UpVer.ONLINE_REPORT_ID,

UpVer.MODIFIED_FLAG,

UpVer.REJECTED_FLAG,

UpVer.WITHDRAWN_FLAG,

UpVer.EXTERNAL_SYSTEM_FLAG,

UpVer.ORIGINATOR_ID,

UpVer.ORIGINATOR_ROLE,

UpVer.CO_CANCELED_FLAG,

UpVer.CANCEL_BACKING_REQ_FLAG,

UpVer.CO_CANCELED_BY_ROLE,

UpVer.CO_CANCELED_BY_USER_ID,

UpVer.REQUEST_DATE,

UpVer.REQUEST_ID,

UpVer.JOB_DEFINITION_NAME,

UpVer.JOB_DEFINITION_PACKAGE,

UpVer.PROGRAM_NAME,

UpVer.PROGRAM_APP_NAME,

UpVer.CANCEL_DOC_FLAG,

UpVer.PROCESSED_DATE,

UpVer.PENDING_RESPONSE_ROLE,

UpVer.OBJECT_VERSION_NUMBER,

UpVer.CREATED_BY_PROGRAM_NAME,

UpVer.DOCUMENT_DATE,

UpVer.ACCEPTED_DATE,

UpVer.SUBMITTED_DATE,

UpVer.APPROVED_DATE,

UpVer.COMMUNICATED_DATE ,

UpVer.FUNDS_STATUS

FROM

PO_VERSIONS UpVer

WHERE

UpVer.CHANGE_ORDER_STATUS <> 'PROCESSED' and UpVer.CO_SEQUENCE > 0