DBA Data[Home] [Help]

VIEW: PO.PO_ONLINE_REPORT_TEXT#

Source

View Text - Preformatted

select ONLINE_REPORT_ID ONLINE_REPORT_ID, SEQUENCE SEQUENCE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, TEXT_LINE TEXT_LINE, LINE_NUM LINE_NUM, SHIPMENT_NUM SHIPMENT_NUM, DISTRIBUTION_NUM DISTRIBUTION_NUM, TRANSACTION_LEVEL TRANSACTION_LEVEL, QUANTITY QUANTITY, TRANSACTION_ID TRANSACTION_ID, TRANSACTION_DATE TRANSACTION_DATE, TRANSACTION_TYPE TRANSACTION_TYPE, TRANSACTION_UOM TRANSACTION_UOM, TRANSACTION_LOCATION TRANSACTION_LOCATION, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, MESSAGE_TYPE MESSAGE_TYPE, SHOW_IN_PSA_FLAG SHOW_IN_PSA_FLAG, SEGMENT1 SEGMENT1, DISTRIBUTION_TYPE DISTRIBUTION_TYPE from "PO"."PO_ONLINE_REPORT_TEXT"
View Text - HTML Formatted

SELECT ONLINE_REPORT_ID ONLINE_REPORT_ID
, SEQUENCE SEQUENCE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TEXT_LINE TEXT_LINE
, LINE_NUM LINE_NUM
, SHIPMENT_NUM SHIPMENT_NUM
, DISTRIBUTION_NUM DISTRIBUTION_NUM
, TRANSACTION_LEVEL TRANSACTION_LEVEL
, QUANTITY QUANTITY
, TRANSACTION_ID TRANSACTION_ID
, TRANSACTION_DATE TRANSACTION_DATE
, TRANSACTION_TYPE TRANSACTION_TYPE
, TRANSACTION_UOM TRANSACTION_UOM
, TRANSACTION_LOCATION TRANSACTION_LOCATION
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, MESSAGE_TYPE MESSAGE_TYPE
, SHOW_IN_PSA_FLAG SHOW_IN_PSA_FLAG
, SEGMENT1 SEGMENT1
, DISTRIBUTION_TYPE DISTRIBUTION_TYPE
FROM "PO"."PO_ONLINE_REPORT_TEXT"