VIEW: CSD.CSD_BULK_RECEIVE_ITEMS_B#

Source

View Text - Preformatted

select BULK_RECEIVE_ID BULK_RECEIVE_ID, TRANSACTION_NUMBER TRANSACTION_NUMBER, ORIG_PARTY_ID ORIG_PARTY_ID, ORIG_CUST_ACCOUNT_ID ORIG_CUST_ACCOUNT_ID, PARTY_ID PARTY_ID, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, SERIAL_NUMBER SERIAL_NUMBER, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, INSTANCE_ID INSTANCE_ID, QUANTITY QUANTITY, UOM_CODE UOM_CODE, STATUS STATUS, CHANGE_OWNER_FLAG CHANGE_OWNER_FLAG, INTERNAL_SR_FLAG INTERNAL_SR_FLAG, WARNING_FLAG WARNING_FLAG, WARNING_REASON_CODE WARNING_REASON_CODE, INCIDENT_ID INCIDENT_ID, REPAIR_LINE_ID REPAIR_LINE_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, 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, UNPLANNED_RECEIPT_FLAG UNPLANNED_RECEIPT_FLAG, ORDER_HEADER_ID ORDER_HEADER_ID, ORDER_LINE_ID ORDER_LINE_ID, UNDER_RECEIPT_FLAG UNDER_RECEIPT_FLAG, OVER_RECEIPT_FLAG OVER_RECEIPT_FLAG, UNDER_RECEIPT_QTY UNDER_RECEIPT_QTY, OVER_RECEIPT_QTY OVER_RECEIPT_QTY, EXTERNAL_REFERENCE EXTERNAL_REFERENCE, OM_CROSS_REFERENCE OM_CROSS_REFERENCE, LOT_NUMBER LOT_NUMBER, ITEM_REVISION ITEM_REVISION, SUBINVENTORY SUBINVENTORY, LOCATOR_ID LOCATOR_ID, RCV_ATTRIBUTE_CATEGORY RCV_ATTRIBUTE_CATEGORY, RCV_ATTRIBUTE1 RCV_ATTRIBUTE1, RCV_ATTRIBUTE2 RCV_ATTRIBUTE2, RCV_ATTRIBUTE3 RCV_ATTRIBUTE3, RCV_ATTRIBUTE4 RCV_ATTRIBUTE4, RCV_ATTRIBUTE5 RCV_ATTRIBUTE5, RCV_ATTRIBUTE6 RCV_ATTRIBUTE6, RCV_ATTRIBUTE7 RCV_ATTRIBUTE7, RCV_ATTRIBUTE8 RCV_ATTRIBUTE8, RCV_ATTRIBUTE9 RCV_ATTRIBUTE9, RCV_ATTRIBUTE10 RCV_ATTRIBUTE10, RCV_ATTRIBUTE11 RCV_ATTRIBUTE11, RCV_ATTRIBUTE12 RCV_ATTRIBUTE12, RCV_ATTRIBUTE13 RCV_ATTRIBUTE13, RCV_ATTRIBUTE14 RCV_ATTRIBUTE14, RCV_ATTRIBUTE15 RCV_ATTRIBUTE15 from "CSD"."CSD_BULK_RECEIVE_ITEMS_B"

View Text - HTML Formatted

SELECT BULK_RECEIVE_ID BULK_RECEIVE_ID
, TRANSACTION_NUMBER TRANSACTION_NUMBER
, ORIG_PARTY_ID ORIG_PARTY_ID
, ORIG_CUST_ACCOUNT_ID ORIG_CUST_ACCOUNT_ID
, PARTY_ID PARTY_ID
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, SERIAL_NUMBER SERIAL_NUMBER
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, INSTANCE_ID INSTANCE_ID
, QUANTITY QUANTITY
, UOM_CODE UOM_CODE
, STATUS STATUS
, CHANGE_OWNER_FLAG CHANGE_OWNER_FLAG
, INTERNAL_SR_FLAG INTERNAL_SR_FLAG
, WARNING_FLAG WARNING_FLAG
, WARNING_REASON_CODE WARNING_REASON_CODE
, INCIDENT_ID INCIDENT_ID
, REPAIR_LINE_ID REPAIR_LINE_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, 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
, UNPLANNED_RECEIPT_FLAG UNPLANNED_RECEIPT_FLAG
, ORDER_HEADER_ID ORDER_HEADER_ID
, ORDER_LINE_ID ORDER_LINE_ID
, UNDER_RECEIPT_FLAG UNDER_RECEIPT_FLAG
, OVER_RECEIPT_FLAG OVER_RECEIPT_FLAG
, UNDER_RECEIPT_QTY UNDER_RECEIPT_QTY
, OVER_RECEIPT_QTY OVER_RECEIPT_QTY
, EXTERNAL_REFERENCE EXTERNAL_REFERENCE
, OM_CROSS_REFERENCE OM_CROSS_REFERENCE
, LOT_NUMBER LOT_NUMBER
, ITEM_REVISION ITEM_REVISION
, SUBINVENTORY SUBINVENTORY
, LOCATOR_ID LOCATOR_ID
, RCV_ATTRIBUTE_CATEGORY RCV_ATTRIBUTE_CATEGORY
, RCV_ATTRIBUTE1 RCV_ATTRIBUTE1
, RCV_ATTRIBUTE2 RCV_ATTRIBUTE2
, RCV_ATTRIBUTE3 RCV_ATTRIBUTE3
, RCV_ATTRIBUTE4 RCV_ATTRIBUTE4
, RCV_ATTRIBUTE5 RCV_ATTRIBUTE5
, RCV_ATTRIBUTE6 RCV_ATTRIBUTE6
, RCV_ATTRIBUTE7 RCV_ATTRIBUTE7
, RCV_ATTRIBUTE8 RCV_ATTRIBUTE8
, RCV_ATTRIBUTE9 RCV_ATTRIBUTE9
, RCV_ATTRIBUTE10 RCV_ATTRIBUTE10
, RCV_ATTRIBUTE11 RCV_ATTRIBUTE11
, RCV_ATTRIBUTE12 RCV_ATTRIBUTE12
, RCV_ATTRIBUTE13 RCV_ATTRIBUTE13
, RCV_ATTRIBUTE14 RCV_ATTRIBUTE14
, RCV_ATTRIBUTE15 RCV_ATTRIBUTE15
FROM "CSD"."CSD_BULK_RECEIVE_ITEMS_B"