VIEW: CSD.CSD_PRODUCT_TRANSACTIONS#

Source

View Text - Preformatted

select PRODUCT_TRANSACTION_ID PRODUCT_TRANSACTION_ID, REPAIR_LINE_ID REPAIR_LINE_ID, ESTIMATE_DETAIL_ID ESTIMATE_DETAIL_ID, ACTION_TYPE ACTION_TYPE, ACTION_CODE ACTION_CODE, INTERFACE_TO_OM_FLAG INTERFACE_TO_OM_FLAG, BOOK_SALES_ORDER_FLAG BOOK_SALES_ORDER_FLAG, RELEASE_SALES_ORDER_FLAG RELEASE_SALES_ORDER_FLAG, SHIP_SALES_ORDER_FLAG SHIP_SALES_ORDER_FLAG, SUB_INVENTORY SUB_INVENTORY, LOT_NUMBER LOT_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, CONTEXT CONTEXT, 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, SECURITY_GROUP_ID SECURITY_GROUP_ID, PROD_TXN_STATUS PROD_TXN_STATUS, PROD_TXN_CODE PROD_TXN_CODE, SHIPPED_SERIAL_NUMBER SHIPPED_SERIAL_NUMBER, SOURCE_SERIAL_NUMBER SOURCE_SERIAL_NUMBER, NON_SOURCE_SERIAL_NUMBER NON_SOURCE_SERIAL_NUMBER, SOURCE_INSTANCE_ID SOURCE_INSTANCE_ID, NON_SOURCE_INSTANCE_ID NON_SOURCE_INSTANCE_ID, REQ_HEADER_ID REQ_HEADER_ID, REQ_LINE_ID REQ_LINE_ID, ORDER_HEADER_ID ORDER_HEADER_ID, ORDER_LINE_ID ORDER_LINE_ID, QUANTITY_RECEIVED QUANTITY_RECEIVED, QUANTITY_SHIPPED QUANTITY_SHIPPED, LOCATOR_ID LOCATOR_ID, SUB_INVENTORY_RCVD SUB_INVENTORY_RCVD, LOT_NUMBER_RCVD LOT_NUMBER_RCVD, PICKING_RULE_ID PICKING_RULE_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, UNIT_NUMBER UNIT_NUMBER, INTERNAL_PO_HEADER_ID INTERNAL_PO_HEADER_ID, UNPLANNED_RECEIPT_FLAG UNPLANNED_RECEIPT_FLAG, EXP_QUANTITY EXP_QUANTITY, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, SHIP_FROM_OU SHIP_FROM_OU, SHIP_FROM_ORG SHIP_FROM_ORG, RCV_INTO_OU RCV_INTO_OU, RCV_INTO_ORG RCV_INTO_ORG, QUANTITY_PICKED QUANTITY_PICKED, DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID, QUANTITY_AVAILABLE QUANTITY_AVAILABLE from "CSD"."CSD_PRODUCT_TRANSACTIONS"

View Text - HTML Formatted

SELECT PRODUCT_TRANSACTION_ID PRODUCT_TRANSACTION_ID
, REPAIR_LINE_ID REPAIR_LINE_ID
, ESTIMATE_DETAIL_ID ESTIMATE_DETAIL_ID
, ACTION_TYPE ACTION_TYPE
, ACTION_CODE ACTION_CODE
, INTERFACE_TO_OM_FLAG INTERFACE_TO_OM_FLAG
, BOOK_SALES_ORDER_FLAG BOOK_SALES_ORDER_FLAG
, RELEASE_SALES_ORDER_FLAG RELEASE_SALES_ORDER_FLAG
, SHIP_SALES_ORDER_FLAG SHIP_SALES_ORDER_FLAG
, SUB_INVENTORY SUB_INVENTORY
, LOT_NUMBER LOT_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
, CONTEXT CONTEXT
, 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
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, PROD_TXN_STATUS PROD_TXN_STATUS
, PROD_TXN_CODE PROD_TXN_CODE
, SHIPPED_SERIAL_NUMBER SHIPPED_SERIAL_NUMBER
, SOURCE_SERIAL_NUMBER SOURCE_SERIAL_NUMBER
, NON_SOURCE_SERIAL_NUMBER NON_SOURCE_SERIAL_NUMBER
, SOURCE_INSTANCE_ID SOURCE_INSTANCE_ID
, NON_SOURCE_INSTANCE_ID NON_SOURCE_INSTANCE_ID
, REQ_HEADER_ID REQ_HEADER_ID
, REQ_LINE_ID REQ_LINE_ID
, ORDER_HEADER_ID ORDER_HEADER_ID
, ORDER_LINE_ID ORDER_LINE_ID
, QUANTITY_RECEIVED QUANTITY_RECEIVED
, QUANTITY_SHIPPED QUANTITY_SHIPPED
, LOCATOR_ID LOCATOR_ID
, SUB_INVENTORY_RCVD SUB_INVENTORY_RCVD
, LOT_NUMBER_RCVD LOT_NUMBER_RCVD
, PICKING_RULE_ID PICKING_RULE_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, UNIT_NUMBER UNIT_NUMBER
, INTERNAL_PO_HEADER_ID INTERNAL_PO_HEADER_ID
, UNPLANNED_RECEIPT_FLAG UNPLANNED_RECEIPT_FLAG
, EXP_QUANTITY EXP_QUANTITY
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, SHIP_FROM_OU SHIP_FROM_OU
, SHIP_FROM_ORG SHIP_FROM_ORG
, RCV_INTO_OU RCV_INTO_OU
, RCV_INTO_ORG RCV_INTO_ORG
, QUANTITY_PICKED QUANTITY_PICKED
, DELIVERY_DETAIL_ID DELIVERY_DETAIL_ID
, QUANTITY_AVAILABLE QUANTITY_AVAILABLE
FROM "CSD"."CSD_PRODUCT_TRANSACTIONS"