VIEW: PON.PON_INTERFACE_ERRORS#

Source

View Text - Preformatted

select INTERFACE_TYPE INTERFACE_TYPE, COLUMN_NAME COLUMN_NAME, TABLE_NAME TABLE_NAME, BATCH_ID BATCH_ID, INTERFACE_LINE_ID INTERFACE_LINE_ID, ERROR_MESSAGE_NAME ERROR_MESSAGE_NAME, ERROR_VALUE ERROR_VALUE, 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, PAYMENT_ID PAYMENT_ID, BID_PAYMENT_ID BID_PAYMENT_ID, REQUEST_ID REQUEST_ID, EXPIRATION_DATE EXPIRATION_DATE, ENTITY_TYPE ENTITY_TYPE, ENTITY_ATTR_NAME ENTITY_ATTR_NAME, ERROR_VALUE_DATE ERROR_VALUE_DATE, ERROR_VALUE_NUMBER ERROR_VALUE_NUMBER, ERROR_VALUE_DATATYPE ERROR_VALUE_DATATYPE, AUCTION_HEADER_ID AUCTION_HEADER_ID, BID_NUMBER BID_NUMBER, LINE_NUMBER LINE_NUMBER, ATTRIBUTE_NAME ATTRIBUTE_NAME, PRICE_ELEMENT_TYPE_ID PRICE_ELEMENT_TYPE_ID, SHIPMENT_NUMBER SHIPMENT_NUMBER, PRICE_DIFFERENTIAL_NUMBER PRICE_DIFFERENTIAL_NUMBER, 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, APPLICATION_SHORT_NAME APPLICATION_SHORT_NAME, WORKSHEET_NAME WORKSHEET_NAME, ENTITY_MESSAGE_CODE ENTITY_MESSAGE_CODE, WORKSHEET_SEQUENCE_NUMBER WORKSHEET_SEQUENCE_NUMBER from "PON"."PON_INTERFACE_ERRORS"

View Text - HTML Formatted

SELECT INTERFACE_TYPE INTERFACE_TYPE
, COLUMN_NAME COLUMN_NAME
, TABLE_NAME TABLE_NAME
, BATCH_ID BATCH_ID
, INTERFACE_LINE_ID INTERFACE_LINE_ID
, ERROR_MESSAGE_NAME ERROR_MESSAGE_NAME
, ERROR_VALUE ERROR_VALUE
, 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
, PAYMENT_ID PAYMENT_ID
, BID_PAYMENT_ID BID_PAYMENT_ID
, REQUEST_ID REQUEST_ID
, EXPIRATION_DATE EXPIRATION_DATE
, ENTITY_TYPE ENTITY_TYPE
, ENTITY_ATTR_NAME ENTITY_ATTR_NAME
, ERROR_VALUE_DATE ERROR_VALUE_DATE
, ERROR_VALUE_NUMBER ERROR_VALUE_NUMBER
, ERROR_VALUE_DATATYPE ERROR_VALUE_DATATYPE
, AUCTION_HEADER_ID AUCTION_HEADER_ID
, BID_NUMBER BID_NUMBER
, LINE_NUMBER LINE_NUMBER
, ATTRIBUTE_NAME ATTRIBUTE_NAME
, PRICE_ELEMENT_TYPE_ID PRICE_ELEMENT_TYPE_ID
, SHIPMENT_NUMBER SHIPMENT_NUMBER
, PRICE_DIFFERENTIAL_NUMBER PRICE_DIFFERENTIAL_NUMBER
, 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
, APPLICATION_SHORT_NAME APPLICATION_SHORT_NAME
, WORKSHEET_NAME WORKSHEET_NAME
, ENTITY_MESSAGE_CODE ENTITY_MESSAGE_CODE
, WORKSHEET_SEQUENCE_NUMBER WORKSHEET_SEQUENCE_NUMBER
FROM "PON"."PON_INTERFACE_ERRORS"