VIEW: CSI.CSI_DIAGNOSTICS_TEMP#

Source

View Text - Preformatted

select DIAG_SEQ_ID DIAG_SEQ_ID, SERIAL_NUMBER SERIAL_NUMBER, MTL_TXN_DATE MTL_TXN_DATE, MTL_TXN_ID MTL_TXN_ID, MTL_TXN_NAME MTL_TXN_NAME, MTL_TXN_QTY MTL_TXN_QTY, MTL_TYPE_ID MTL_TYPE_ID, MTL_ACTION_ID MTL_ACTION_ID, MTL_SRC_TYPE_ID MTL_SRC_TYPE_ID, MTL_TYPE_CLASS MTL_TYPE_CLASS, SOURCE_TYPE SOURCE_TYPE, CSI_TXN_TYPE_ID CSI_TXN_TYPE_ID, CSI_TXN_ID CSI_TXN_ID, ERROR_FLAG ERROR_FLAG, ERROR_TEXT ERROR_TEXT, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, SERIAL_CONTROL_CODE SERIAL_CONTROL_CODE, LOT_CONTROL_CODE LOT_CONTROL_CODE, LOT_NUMBER LOT_NUMBER, ORGANIZATION_ID ORGANIZATION_ID, OE_ORDER_LINE_ID OE_ORDER_LINE_ID, WIP_JOB_ID WIP_JOB_ID, OE_RMA_LINE_ID OE_RMA_LINE_ID, INSTANCE_ID INSTANCE_ID, INSTANCE_VLD_ORGANIZATION_ID INSTANCE_VLD_ORGANIZATION_ID, INSTANCE_LOCATION INSTANCE_LOCATION, INSTANCE_USAGE_CODE INSTANCE_USAGE_CODE, INSTANCE_ORGANIZATION_ID INSTANCE_ORGANIZATION_ID, INSTANCE_SUBINV_NAME INSTANCE_SUBINV_NAME, INSTANCE_REVISION INSTANCE_REVISION, INSTANCE_END_DATE INSTANCE_END_DATE, INSTANCE_OWNER_PARTY_ID INSTANCE_OWNER_PARTY_ID, INSTANCE_OWNER_ACCOUNT_ID INSTANCE_OWNER_ACCOUNT_ID, INSTANCE_MIG_FLAG INSTANCE_MIG_FLAG, INTERNAL_PARTY_ID INTERNAL_PARTY_ID, LAST_TRANSACTION_FLAG LAST_TRANSACTION_FLAG, ENTANGLED_FLAG ENTANGLED_FLAG, CREATE_FLAG CREATE_FLAG, EXPIRE_FLAG EXPIRE_FLAG, PROCESS_CODE PROCESS_CODE, PROCESS_FLAG PROCESS_FLAG, TEMPORARY_MESSAGE TEMPORARY_MESSAGE, MTL_CREATION_DATE MTL_CREATION_DATE, REVISION_CONTROL_CODE REVISION_CONTROL_CODE, MTL_XFER_TXN_ID MTL_XFER_TXN_ID, MTL_ITEM_REVISION MTL_ITEM_REVISION from "CSI"."CSI_DIAGNOSTICS_TEMP"

View Text - HTML Formatted

SELECT DIAG_SEQ_ID DIAG_SEQ_ID
, SERIAL_NUMBER SERIAL_NUMBER
, MTL_TXN_DATE MTL_TXN_DATE
, MTL_TXN_ID MTL_TXN_ID
, MTL_TXN_NAME MTL_TXN_NAME
, MTL_TXN_QTY MTL_TXN_QTY
, MTL_TYPE_ID MTL_TYPE_ID
, MTL_ACTION_ID MTL_ACTION_ID
, MTL_SRC_TYPE_ID MTL_SRC_TYPE_ID
, MTL_TYPE_CLASS MTL_TYPE_CLASS
, SOURCE_TYPE SOURCE_TYPE
, CSI_TXN_TYPE_ID CSI_TXN_TYPE_ID
, CSI_TXN_ID CSI_TXN_ID
, ERROR_FLAG ERROR_FLAG
, ERROR_TEXT ERROR_TEXT
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SERIAL_CONTROL_CODE SERIAL_CONTROL_CODE
, LOT_CONTROL_CODE LOT_CONTROL_CODE
, LOT_NUMBER LOT_NUMBER
, ORGANIZATION_ID ORGANIZATION_ID
, OE_ORDER_LINE_ID OE_ORDER_LINE_ID
, WIP_JOB_ID WIP_JOB_ID
, OE_RMA_LINE_ID OE_RMA_LINE_ID
, INSTANCE_ID INSTANCE_ID
, INSTANCE_VLD_ORGANIZATION_ID INSTANCE_VLD_ORGANIZATION_ID
, INSTANCE_LOCATION INSTANCE_LOCATION
, INSTANCE_USAGE_CODE INSTANCE_USAGE_CODE
, INSTANCE_ORGANIZATION_ID INSTANCE_ORGANIZATION_ID
, INSTANCE_SUBINV_NAME INSTANCE_SUBINV_NAME
, INSTANCE_REVISION INSTANCE_REVISION
, INSTANCE_END_DATE INSTANCE_END_DATE
, INSTANCE_OWNER_PARTY_ID INSTANCE_OWNER_PARTY_ID
, INSTANCE_OWNER_ACCOUNT_ID INSTANCE_OWNER_ACCOUNT_ID
, INSTANCE_MIG_FLAG INSTANCE_MIG_FLAG
, INTERNAL_PARTY_ID INTERNAL_PARTY_ID
, LAST_TRANSACTION_FLAG LAST_TRANSACTION_FLAG
, ENTANGLED_FLAG ENTANGLED_FLAG
, CREATE_FLAG CREATE_FLAG
, EXPIRE_FLAG EXPIRE_FLAG
, PROCESS_CODE PROCESS_CODE
, PROCESS_FLAG PROCESS_FLAG
, TEMPORARY_MESSAGE TEMPORARY_MESSAGE
, MTL_CREATION_DATE MTL_CREATION_DATE
, REVISION_CONTROL_CODE REVISION_CONTROL_CODE
, MTL_XFER_TXN_ID MTL_XFER_TXN_ID
, MTL_ITEM_REVISION MTL_ITEM_REVISION
FROM "CSI"."CSI_DIAGNOSTICS_TEMP"