VIEW: INV.MTL_CONSIGNED_DIAG_ERRORS#

Source

View Text - Preformatted

select RECORD_ID RECORD_ID, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, REVISION REVISION, OWNING_TP_TYPE OWNING_TP_TYPE, OWNING_ORGANIZATION_ID OWNING_ORGANIZATION_ID, PLANNING_TP_TYPE PLANNING_TP_TYPE, PLANNING_ORGANIZATION_ID PLANNING_ORGANIZATION_ID, PO_HEADER_ID PO_HEADER_ID, AGENT_ID AGENT_ID, RECORD_TYPE RECORD_TYPE, ERROR_CODE ERROR_CODE, ERROR_TYPE ERROR_TYPE, ACTION_CODE ACTION_CODE, PURCHASING_UOM PURCHASING_UOM, PRIMARY_UOM PRIMARY_UOM, LAST_NOTIFICATION_DATE LAST_NOTIFICATION_DATE, NOTIFICATION_ID NOTIFICATION_ID, CONSUMPTION_DATE CONSUMPTION_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 from "INV"."MTL_CONSIGNED_DIAG_ERRORS"

View Text - HTML Formatted

SELECT RECORD_ID RECORD_ID
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, REVISION REVISION
, OWNING_TP_TYPE OWNING_TP_TYPE
, OWNING_ORGANIZATION_ID OWNING_ORGANIZATION_ID
, PLANNING_TP_TYPE PLANNING_TP_TYPE
, PLANNING_ORGANIZATION_ID PLANNING_ORGANIZATION_ID
, PO_HEADER_ID PO_HEADER_ID
, AGENT_ID AGENT_ID
, RECORD_TYPE RECORD_TYPE
, ERROR_CODE ERROR_CODE
, ERROR_TYPE ERROR_TYPE
, ACTION_CODE ACTION_CODE
, PURCHASING_UOM PURCHASING_UOM
, PRIMARY_UOM PRIMARY_UOM
, LAST_NOTIFICATION_DATE LAST_NOTIFICATION_DATE
, NOTIFICATION_ID NOTIFICATION_ID
, CONSUMPTION_DATE CONSUMPTION_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
FROM "INV"."MTL_CONSIGNED_DIAG_ERRORS"