VIEW: PO.PO_CHANGE_REQUESTS#

Source

View Text - Preformatted

select CHANGE_REQUEST_GROUP_ID CHANGE_REQUEST_GROUP_ID, CHANGE_REQUEST_ID CHANGE_REQUEST_ID, INITIATOR INITIATOR, ACTION_TYPE ACTION_TYPE, REQUEST_REASON REQUEST_REASON, REQUEST_LEVEL REQUEST_LEVEL, REQUEST_STATUS REQUEST_STATUS, DOCUMENT_TYPE DOCUMENT_TYPE, DOCUMENT_HEADER_ID DOCUMENT_HEADER_ID, DOCUMENT_NUM DOCUMENT_NUM, DOCUMENT_REVISION_NUM DOCUMENT_REVISION_NUM, PO_RELEASE_ID PO_RELEASE_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DOCUMENT_LINE_ID DOCUMENT_LINE_ID, DOCUMENT_LINE_NUMBER DOCUMENT_LINE_NUMBER, DOCUMENT_LINE_LOCATION_ID DOCUMENT_LINE_LOCATION_ID, DOCUMENT_SHIPMENT_NUMBER DOCUMENT_SHIPMENT_NUMBER, PARENT_LINE_LOCATION_ID PARENT_LINE_LOCATION_ID, DOCUMENT_DISTRIBUTION_ID DOCUMENT_DISTRIBUTION_ID, DOCUMENT_DISTRIBUTION_NUMBER DOCUMENT_DISTRIBUTION_NUMBER, OLD_QUANTITY OLD_QUANTITY, NEW_QUANTITY NEW_QUANTITY, OLD_PROMISED_DATE OLD_PROMISED_DATE, NEW_PROMISED_DATE NEW_PROMISED_DATE, OLD_SUPPLIER_PART_NUMBER OLD_SUPPLIER_PART_NUMBER, NEW_SUPPLIER_PART_NUMBER NEW_SUPPLIER_PART_NUMBER, OLD_PRICE OLD_PRICE, NEW_PRICE NEW_PRICE, OLD_NEED_BY_DATE OLD_NEED_BY_DATE, NEW_NEED_BY_DATE NEW_NEED_BY_DATE, OLD_SUPPLIER_REFERENCE_NUMBER OLD_SUPPLIER_REFERENCE_NUMBER, NEW_SUPPLIER_REFERENCE_NUMBER NEW_SUPPLIER_REFERENCE_NUMBER, REQUESTER_ID REQUESTER_ID, RESPONDED_BY RESPONDED_BY, RESPONSE_DATE RESPONSE_DATE, RESPONSE_REASON RESPONSE_REASON, VENDOR_ID VENDOR_ID, VENDOR_SITE_ID VENDOR_SITE_ID, VENDOR_CONTACT_ID VENDOR_CONTACT_ID, REQUEST_EXPIRATION_DATE REQUEST_EXPIRATION_DATE, OLD_CURRENCY_UNIT_PRICE OLD_CURRENCY_UNIT_PRICE, NEW_CURRENCY_UNIT_PRICE NEW_CURRENCY_UNIT_PRICE, RECOVERABLE_TAX RECOVERABLE_TAX, NONRECOVERABLE_TAX NONRECOVERABLE_TAX, WF_ITEM_TYPE WF_ITEM_TYPE, WF_ITEM_KEY WF_ITEM_KEY, PARENT_CHANGE_REQUEST_ID PARENT_CHANGE_REQUEST_ID, VALIDATION_ERROR VALIDATION_ERROR, APPROVAL_REQUIRED_FLAG APPROVAL_REQUIRED_FLAG, OLD_SUPPLIER_ORDER_NUMBER OLD_SUPPLIER_ORDER_NUMBER, NEW_SUPPLIER_ORDER_NUMBER NEW_SUPPLIER_ORDER_NUMBER, OLD_SUPPLIER_ORDER_LINE_NUMBER OLD_SUPPLIER_ORDER_LINE_NUMBER, NEW_SUPPLIER_ORDER_LINE_NUMBER NEW_SUPPLIER_ORDER_LINE_NUMBER, CHANGE_ACTIVE_FLAG CHANGE_ACTIVE_FLAG, CANCEL_BACKING_REQ CANCEL_BACKING_REQ, REF_PO_NUM REF_PO_NUM, REF_PO_HEADER_ID REF_PO_HEADER_ID, REF_PO_RELEASE_ID REF_PO_RELEASE_ID, REF_PO_REL_NUM REF_PO_REL_NUM, MSG_CONT_NUM MSG_CONT_NUM, REQUEST_ORIGIN REQUEST_ORIGIN, ADDITIONAL_CHANGES ADDITIONAL_CHANGES, OLD_START_DATE OLD_START_DATE, NEW_START_DATE NEW_START_DATE, OLD_EXPIRATION_DATE OLD_EXPIRATION_DATE, NEW_EXPIRATION_DATE NEW_EXPIRATION_DATE, OLD_AMOUNT OLD_AMOUNT, NEW_AMOUNT NEW_AMOUNT, OLD_CURRENCY_AMOUNT OLD_CURRENCY_AMOUNT, NEW_CURRENCY_AMOUNT NEW_CURRENCY_AMOUNT, SUPPLIER_DOC_REF SUPPLIER_DOC_REF, SUPPLIER_LINE_REF SUPPLIER_LINE_REF, SUPPLIER_SHIPMENT_REF SUPPLIER_SHIPMENT_REF, NEW_PROGRESS_TYPE NEW_PROGRESS_TYPE, NEW_PAY_DESCRIPTION NEW_PAY_DESCRIPTION from "PO"."PO_CHANGE_REQUESTS"

View Text - HTML Formatted

SELECT CHANGE_REQUEST_GROUP_ID CHANGE_REQUEST_GROUP_ID
, CHANGE_REQUEST_ID CHANGE_REQUEST_ID
, INITIATOR INITIATOR
, ACTION_TYPE ACTION_TYPE
, REQUEST_REASON REQUEST_REASON
, REQUEST_LEVEL REQUEST_LEVEL
, REQUEST_STATUS REQUEST_STATUS
, DOCUMENT_TYPE DOCUMENT_TYPE
, DOCUMENT_HEADER_ID DOCUMENT_HEADER_ID
, DOCUMENT_NUM DOCUMENT_NUM
, DOCUMENT_REVISION_NUM DOCUMENT_REVISION_NUM
, PO_RELEASE_ID PO_RELEASE_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DOCUMENT_LINE_ID DOCUMENT_LINE_ID
, DOCUMENT_LINE_NUMBER DOCUMENT_LINE_NUMBER
, DOCUMENT_LINE_LOCATION_ID DOCUMENT_LINE_LOCATION_ID
, DOCUMENT_SHIPMENT_NUMBER DOCUMENT_SHIPMENT_NUMBER
, PARENT_LINE_LOCATION_ID PARENT_LINE_LOCATION_ID
, DOCUMENT_DISTRIBUTION_ID DOCUMENT_DISTRIBUTION_ID
, DOCUMENT_DISTRIBUTION_NUMBER DOCUMENT_DISTRIBUTION_NUMBER
, OLD_QUANTITY OLD_QUANTITY
, NEW_QUANTITY NEW_QUANTITY
, OLD_PROMISED_DATE OLD_PROMISED_DATE
, NEW_PROMISED_DATE NEW_PROMISED_DATE
, OLD_SUPPLIER_PART_NUMBER OLD_SUPPLIER_PART_NUMBER
, NEW_SUPPLIER_PART_NUMBER NEW_SUPPLIER_PART_NUMBER
, OLD_PRICE OLD_PRICE
, NEW_PRICE NEW_PRICE
, OLD_NEED_BY_DATE OLD_NEED_BY_DATE
, NEW_NEED_BY_DATE NEW_NEED_BY_DATE
, OLD_SUPPLIER_REFERENCE_NUMBER OLD_SUPPLIER_REFERENCE_NUMBER
, NEW_SUPPLIER_REFERENCE_NUMBER NEW_SUPPLIER_REFERENCE_NUMBER
, REQUESTER_ID REQUESTER_ID
, RESPONDED_BY RESPONDED_BY
, RESPONSE_DATE RESPONSE_DATE
, RESPONSE_REASON RESPONSE_REASON
, VENDOR_ID VENDOR_ID
, VENDOR_SITE_ID VENDOR_SITE_ID
, VENDOR_CONTACT_ID VENDOR_CONTACT_ID
, REQUEST_EXPIRATION_DATE REQUEST_EXPIRATION_DATE
, OLD_CURRENCY_UNIT_PRICE OLD_CURRENCY_UNIT_PRICE
, NEW_CURRENCY_UNIT_PRICE NEW_CURRENCY_UNIT_PRICE
, RECOVERABLE_TAX RECOVERABLE_TAX
, NONRECOVERABLE_TAX NONRECOVERABLE_TAX
, WF_ITEM_TYPE WF_ITEM_TYPE
, WF_ITEM_KEY WF_ITEM_KEY
, PARENT_CHANGE_REQUEST_ID PARENT_CHANGE_REQUEST_ID
, VALIDATION_ERROR VALIDATION_ERROR
, APPROVAL_REQUIRED_FLAG APPROVAL_REQUIRED_FLAG
, OLD_SUPPLIER_ORDER_NUMBER OLD_SUPPLIER_ORDER_NUMBER
, NEW_SUPPLIER_ORDER_NUMBER NEW_SUPPLIER_ORDER_NUMBER
, OLD_SUPPLIER_ORDER_LINE_NUMBER OLD_SUPPLIER_ORDER_LINE_NUMBER
, NEW_SUPPLIER_ORDER_LINE_NUMBER NEW_SUPPLIER_ORDER_LINE_NUMBER
, CHANGE_ACTIVE_FLAG CHANGE_ACTIVE_FLAG
, CANCEL_BACKING_REQ CANCEL_BACKING_REQ
, REF_PO_NUM REF_PO_NUM
, REF_PO_HEADER_ID REF_PO_HEADER_ID
, REF_PO_RELEASE_ID REF_PO_RELEASE_ID
, REF_PO_REL_NUM REF_PO_REL_NUM
, MSG_CONT_NUM MSG_CONT_NUM
, REQUEST_ORIGIN REQUEST_ORIGIN
, ADDITIONAL_CHANGES ADDITIONAL_CHANGES
, OLD_START_DATE OLD_START_DATE
, NEW_START_DATE NEW_START_DATE
, OLD_EXPIRATION_DATE OLD_EXPIRATION_DATE
, NEW_EXPIRATION_DATE NEW_EXPIRATION_DATE
, OLD_AMOUNT OLD_AMOUNT
, NEW_AMOUNT NEW_AMOUNT
, OLD_CURRENCY_AMOUNT OLD_CURRENCY_AMOUNT
, NEW_CURRENCY_AMOUNT NEW_CURRENCY_AMOUNT
, SUPPLIER_DOC_REF SUPPLIER_DOC_REF
, SUPPLIER_LINE_REF SUPPLIER_LINE_REF
, SUPPLIER_SHIPMENT_REF SUPPLIER_SHIPMENT_REF
, NEW_PROGRESS_TYPE NEW_PROGRESS_TYPE
, NEW_PAY_DESCRIPTION NEW_PAY_DESCRIPTION
FROM "PO"."PO_CHANGE_REQUESTS"