VIEW: PO.RCV_LOT_TRANSACTIONS#

Source

View Text - Preformatted

select LOT_TRANSACTION_TYPE LOT_TRANSACTION_TYPE, LOT_NUM LOT_NUM, QUANTITY QUANTITY, PRIMARY_QUANTITY PRIMARY_QUANTITY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_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, SHIPMENT_LINE_ID SHIPMENT_LINE_ID, TRANSACTION_ID TRANSACTION_ID, TRANSACTION_DATE TRANSACTION_DATE, EXPIRATION_DATE EXPIRATION_DATE, SOURCE_TRANSACTION_ID SOURCE_TRANSACTION_ID, CORRECTION_TRANSACTION_ID CORRECTION_TRANSACTION_ID, ITEM_ID ITEM_ID, SUBLOT_NUM SUBLOT_NUM, SECONDARY_QUANTITY SECONDARY_QUANTITY, QC_GRADE QC_GRADE, REASON_CODE REASON_CODE from "PO"."RCV_LOT_TRANSACTIONS"

View Text - HTML Formatted

SELECT LOT_TRANSACTION_TYPE LOT_TRANSACTION_TYPE
, LOT_NUM LOT_NUM
, QUANTITY QUANTITY
, PRIMARY_QUANTITY PRIMARY_QUANTITY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_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
, SHIPMENT_LINE_ID SHIPMENT_LINE_ID
, TRANSACTION_ID TRANSACTION_ID
, TRANSACTION_DATE TRANSACTION_DATE
, EXPIRATION_DATE EXPIRATION_DATE
, SOURCE_TRANSACTION_ID SOURCE_TRANSACTION_ID
, CORRECTION_TRANSACTION_ID CORRECTION_TRANSACTION_ID
, ITEM_ID ITEM_ID
, SUBLOT_NUM SUBLOT_NUM
, SECONDARY_QUANTITY SECONDARY_QUANTITY
, QC_GRADE QC_GRADE
, REASON_CODE REASON_CODE
FROM "PO"."RCV_LOT_TRANSACTIONS"