View: RCV_TRX_INT_LOTS_V

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.RCV_TRX_INT_LOTS_V

View Text

SELECT RLS.LOT_NUM LOT_NUMBER
, RLS.EXPIRATION_DATE
, RLS.SHIPMENT_LINE_ID
, RSL.TO_ORGANIZATION_ID
, RSL.ITEM_ID
, RLS.PRIMARY_QUANTITY ORDER_QUANTITY
, RUL.PRIMARY_QUANTITY LOT_QUANTITY
FROM RCV_LOTS_SUPPLY RLS
, RCV_UNPROCESSED_LOTS_V RUL
, RCV_SHIPMENT_LINES RSL
WHERE RUL.SHIPMENT_LINE_ID(+) = RLS.SHIPMENT_LINE_ID
AND RUL.LOT_NUM(+) = RLS.LOT_NUM

Columns