[Home] [Help]
View: RCV_COR_SUP_LOTS_V
View Text
SELECT RLT.LOT_NUM LOT_NUMBER
, RLT.EXPIRATION_DATE
, RUI.SHIPMENT_LINE_ID
, RLT.ITEM_ID
, RLT.TRANSACTION_ID
, RLT.PRIMARY_QUANTITY ORDER_QUANTITY
, RUI.PRIMARY_QUANTITY LOT_QUANTITY
FROM RCV_UNPROCESSED_LOT_ISSUES_V RUI
, RCV_LOT_TRANSACTIONS RLT
WHERE RUI.PARENT_TRANSACTION_ID(+) = RLT.TRANSACTION_ID
AND RUI.ITEM_ID(+) = RLT.ITEM_ID
AND RUI.LOT_NUM(+) = RLT.LOT_NUM
Columns
| Name |
| LOT_NUMBER |
| EXPIRATION_DATE |
| SHIPMENT_LINE_ID |
| ITEM_ID |
| TRANSACTION_ID |
| ORDER_QUANTITY |
| LOT_QUANTITY |
APPS.RCV_COR_SUP_LOTS_V