VIEW: PO.PO_INTERFACE_ERRORS#

Source

View Text - Preformatted

select INTERFACE_TYPE INTERFACE_TYPE, INTERFACE_TRANSACTION_ID INTERFACE_TRANSACTION_ID, COLUMN_NAME COLUMN_NAME, ERROR_MESSAGE ERROR_MESSAGE, PROCESSING_DATE PROCESSING_DATE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, ERROR_MESSAGE_NAME ERROR_MESSAGE_NAME, TABLE_NAME TABLE_NAME, BATCH_ID BATCH_ID, INTERFACE_HEADER_ID INTERFACE_HEADER_ID, INTERFACE_LINE_ID INTERFACE_LINE_ID, INTERFACE_DISTRIBUTION_ID INTERFACE_DISTRIBUTION_ID, COLUMN_VALUE COLUMN_VALUE, INTERFACE_LINE_LOCATION_ID INTERFACE_LINE_LOCATION_ID, INTERFACE_ATTR_VALUES_ID INTERFACE_ATTR_VALUES_ID, INTERFACE_ATTR_VALUES_TLP_ID INTERFACE_ATTR_VALUES_TLP_ID, PRICE_DIFF_INTERFACE_ID PRICE_DIFF_INTERFACE_ID, TOKEN1_NAME TOKEN1_NAME, TOKEN1_VALUE TOKEN1_VALUE, TOKEN2_NAME TOKEN2_NAME, TOKEN2_VALUE TOKEN2_VALUE, TOKEN3_NAME TOKEN3_NAME, TOKEN3_VALUE TOKEN3_VALUE, TOKEN4_NAME TOKEN4_NAME, TOKEN4_VALUE TOKEN4_VALUE, TOKEN5_NAME TOKEN5_NAME, TOKEN5_VALUE TOKEN5_VALUE, TOKEN6_NAME TOKEN6_NAME, TOKEN6_VALUE TOKEN6_VALUE, APP_NAME APP_NAME from "PO"."PO_INTERFACE_ERRORS"

View Text - HTML Formatted

SELECT INTERFACE_TYPE INTERFACE_TYPE
, INTERFACE_TRANSACTION_ID INTERFACE_TRANSACTION_ID
, COLUMN_NAME COLUMN_NAME
, ERROR_MESSAGE ERROR_MESSAGE
, PROCESSING_DATE PROCESSING_DATE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, ERROR_MESSAGE_NAME ERROR_MESSAGE_NAME
, TABLE_NAME TABLE_NAME
, BATCH_ID BATCH_ID
, INTERFACE_HEADER_ID INTERFACE_HEADER_ID
, INTERFACE_LINE_ID INTERFACE_LINE_ID
, INTERFACE_DISTRIBUTION_ID INTERFACE_DISTRIBUTION_ID
, COLUMN_VALUE COLUMN_VALUE
, INTERFACE_LINE_LOCATION_ID INTERFACE_LINE_LOCATION_ID
, INTERFACE_ATTR_VALUES_ID INTERFACE_ATTR_VALUES_ID
, INTERFACE_ATTR_VALUES_TLP_ID INTERFACE_ATTR_VALUES_TLP_ID
, PRICE_DIFF_INTERFACE_ID PRICE_DIFF_INTERFACE_ID
, TOKEN1_NAME TOKEN1_NAME
, TOKEN1_VALUE TOKEN1_VALUE
, TOKEN2_NAME TOKEN2_NAME
, TOKEN2_VALUE TOKEN2_VALUE
, TOKEN3_NAME TOKEN3_NAME
, TOKEN3_VALUE TOKEN3_VALUE
, TOKEN4_NAME TOKEN4_NAME
, TOKEN4_VALUE TOKEN4_VALUE
, TOKEN5_NAME TOKEN5_NAME
, TOKEN5_VALUE TOKEN5_VALUE
, TOKEN6_NAME TOKEN6_NAME
, TOKEN6_VALUE TOKEN6_VALUE
, APP_NAME APP_NAME
FROM "PO"."PO_INTERFACE_ERRORS"