[Home] [Help]
View: CSP_PICKLIST_SERIAL_LOTS_V1
View Text
SELECT CPISL.PICKLIST_LINE_ID
, CPISL.SERIAL_NUMBER
, CPISL.LOT_NUMBER
, CPISL.QUANTITY - CSP_PACKLIST_PVT.PACKED_SERIAL_LOTS(CPISL.PICKLIST_LINE_ID
, CPISL.SERIAL_NUMBER
, CPISL.LOT_NUMBER)
FROM CSP_PICKLIST_SERIAL_LOTS CPISL
WHERE CPISL.QUANTITY - CSP_PACKLIST_PVT.PACKED_SERIAL_LOTS(CPISL.PICKLIST_LINE_ID
, CPISL.SERIAL_NUMBER
, CPISL.LOT_NUMBER) > 0
Columns
Name |
PICKLIST_LINE_ID |
SERIAL_NUMBER |
LOT_NUMBER |
QUANTITY |