WIE_DETAIL_COMPLETE_ERRORS_V

Details

• Schema: FUSION

• Object owner: WIE

• Object type: VIEW

Columns

Name
INTERFACE_ERROR_ID INVENTORY_ITEM_NUMBER ERROR_TEXT INV_TRANSACTION_HEADER_ID INTERFACE_ROW_ID TABLE_NAME

Query

SQL_Statement

select errors.interface_error_id , material.inventory_item_number , errors.error_text , material.inv_transaction_header_id , null interface_row_id, errors.table_name from wie_material_transactions_int material , wie_int_errors errors where material.interface_row_id = errors.interface_row_id and material.inv_transaction_header_id is not null and errors.message_severity = 'E' and errors.table_name ='WIE_OPERATION_TRANSACTIONS_INT' UNION ALL select errors.interface_error_id , items.item_number , errors.error_text , null , optxnintf.interface_row_id, errors.table_name from wie_int_errors errors , wie_operation_transactions_int optxnintf , egp_system_items items where errors.interface_row_id = optxnintf.interface_row_id and items.inventory_item_id = optxnintf.inventory_item_id and items.organization_id = optxnintf.organization_id and errors.message_severity = 'E' and errors.table_name IN ('WIE_MATERIAL_TRANSACTIONS_INT','WIE_OPERATION_TRANSACTIONS_INT')