VIEW: APPS.RCV_COR_SUP_LOTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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