PO_VERSIONS_INIT_SEQUENCE

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 InitSeqVer.CREATED_BY, InitSeqVer.CHECKLIST_ID, InitSeqVer.COMMUNICATED_TO_SUPPLIER, InitSeqVer.CREATION_DATE, InitSeqVer.LAST_UPDATED_BY, InitSeqVer.LAST_UPDATE_DATE, InitSeqVer.LAST_UPDATE_LOGIN, InitSeqVer.VERSION_ID, InitSeqVer.PO_HEADER_ID, InitSeqVer.CO_SEQUENCE, InitSeqVer.CO_NUM, InitSeqVer.REVISION_NUM, InitSeqVer.CHANGE_ORDER_DESC, InitSeqVer.CHANGE_ORDER_TYPE, InitSeqVer.CHANGE_ORDER_STATUS, InitSeqVer.ONLINE_REPORT_ID, InitSeqVer.MODIFIED_FLAG, InitSeqVer.REJECTED_FLAG, InitSeqVer.WITHDRAWN_FLAG, InitSeqVer.EXTERNAL_SYSTEM_FLAG, InitSeqVer.ORIGINATOR_ID, InitSeqVer.ORIGINATOR_ROLE, InitSeqVer.CO_CANCELED_FLAG, InitSeqVer.CANCEL_BACKING_REQ_FLAG, InitSeqVer.CO_CANCELED_BY_ROLE, InitSeqVer.CO_CANCELED_BY_USER_ID, InitSeqVer.REQUEST_DATE, InitSeqVer.REQUEST_ID, InitSeqVer.JOB_DEFINITION_NAME, InitSeqVer.JOB_DEFINITION_PACKAGE, InitSeqVer.PROGRAM_NAME, InitSeqVer.PROGRAM_APP_NAME, InitSeqVer.CANCEL_DOC_FLAG, InitSeqVer.PROCESSED_DATE, InitSeqVer.PENDING_RESPONSE_ROLE, InitSeqVer.OBJECT_VERSION_NUMBER, InitSeqVer.CREATED_BY_PROGRAM_NAME, InitSeqVer.DOCUMENT_DATE, InitSeqVer.ACCEPTED_DATE, InitSeqVer.SUBMITTED_DATE, InitSeqVer.APPROVED_DATE, InitSeqVer.COMMUNICATED_DATE , InitSeqVer.FUNDS_STATUS FROM PO_VERSIONS InitSeqVer WHERE InitSeqVer.CO_SEQUENCE = 0

SQL_Statement

SELECT

InitSeqVer.CREATED_BY,

InitSeqVer.CHECKLIST_ID,

InitSeqVer.COMMUNICATED_TO_SUPPLIER,

InitSeqVer.CREATION_DATE,

InitSeqVer.LAST_UPDATED_BY,

InitSeqVer.LAST_UPDATE_DATE,

InitSeqVer.LAST_UPDATE_LOGIN,

InitSeqVer.VERSION_ID,

InitSeqVer.PO_HEADER_ID,

InitSeqVer.CO_SEQUENCE,

InitSeqVer.CO_NUM,

InitSeqVer.REVISION_NUM,

InitSeqVer.CHANGE_ORDER_DESC,

InitSeqVer.CHANGE_ORDER_TYPE,

InitSeqVer.CHANGE_ORDER_STATUS,

InitSeqVer.ONLINE_REPORT_ID,

InitSeqVer.MODIFIED_FLAG,

InitSeqVer.REJECTED_FLAG,

InitSeqVer.WITHDRAWN_FLAG,

InitSeqVer.EXTERNAL_SYSTEM_FLAG,

InitSeqVer.ORIGINATOR_ID,

InitSeqVer.ORIGINATOR_ROLE,

InitSeqVer.CO_CANCELED_FLAG,

InitSeqVer.CANCEL_BACKING_REQ_FLAG,

InitSeqVer.CO_CANCELED_BY_ROLE,

InitSeqVer.CO_CANCELED_BY_USER_ID,

InitSeqVer.REQUEST_DATE,

InitSeqVer.REQUEST_ID,

InitSeqVer.JOB_DEFINITION_NAME,

InitSeqVer.JOB_DEFINITION_PACKAGE,

InitSeqVer.PROGRAM_NAME,

InitSeqVer.PROGRAM_APP_NAME,

InitSeqVer.CANCEL_DOC_FLAG,

InitSeqVer.PROCESSED_DATE,

InitSeqVer.PENDING_RESPONSE_ROLE,

InitSeqVer.OBJECT_VERSION_NUMBER,

InitSeqVer.CREATED_BY_PROGRAM_NAME,

InitSeqVer.DOCUMENT_DATE,

InitSeqVer.ACCEPTED_DATE,

InitSeqVer.SUBMITTED_DATE,

InitSeqVer.APPROVED_DATE,

InitSeqVer.COMMUNICATED_DATE ,

InitSeqVer.FUNDS_STATUS

FROM

PO_VERSIONS InitSeqVer

WHERE

InitSeqVer.CO_SEQUENCE = 0