VIEW: PO.PO_MASSCANCEL_INTERIM#

Source

View Text - Preformatted

select NAME NAME, OBJECT_TYPE OBJECT_TYPE, OBJECT_ID OBJECT_ID, OBJECT_NUMBER OBJECT_NUMBER, DISTRIBUTIONS_INCLUDED DISTRIBUTIONS_INCLUDED, FULLY_IN_RANGE_FLAG FULLY_IN_RANGE_FLAG, DEFAULT_CANCEL_FLAG DEFAULT_CANCEL_FLAG, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, OBJECT_CREATION_DATE OBJECT_CREATION_DATE, CANNOT_CANCEL_REASON CANNOT_CANCEL_REASON, AUTHORIZATION_STATUS AUTHORIZATION_STATUS, CURRENCY_CODE CURRENCY_CODE, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PO_VENDOR_ID PO_VENDOR_ID, ONLINE_REPORT_ID ONLINE_REPORT_ID, CANCEL_REQS_ON_PO_CANCEL_FLAG CANCEL_REQS_ON_PO_CANCEL_FLAG from "PO"."PO_MASSCANCEL_INTERIM"

View Text - HTML Formatted

SELECT NAME NAME
, OBJECT_TYPE OBJECT_TYPE
, OBJECT_ID OBJECT_ID
, OBJECT_NUMBER OBJECT_NUMBER
, DISTRIBUTIONS_INCLUDED DISTRIBUTIONS_INCLUDED
, FULLY_IN_RANGE_FLAG FULLY_IN_RANGE_FLAG
, DEFAULT_CANCEL_FLAG DEFAULT_CANCEL_FLAG
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, OBJECT_CREATION_DATE OBJECT_CREATION_DATE
, CANNOT_CANCEL_REASON CANNOT_CANCEL_REASON
, AUTHORIZATION_STATUS AUTHORIZATION_STATUS
, CURRENCY_CODE CURRENCY_CODE
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PO_VENDOR_ID PO_VENDOR_ID
, ONLINE_REPORT_ID ONLINE_REPORT_ID
, CANCEL_REQS_ON_PO_CANCEL_FLAG CANCEL_REQS_ON_PO_CANCEL_FLAG
FROM "PO"."PO_MASSCANCEL_INTERIM"