DOO_LOT_SERIAL_NUMBERS_V
Details
-
Schema: FUSION
-
Object owner: DOO
-
Object type: VIEW
Columns
Name |
---|
FULFILL_LINE_ID ITEM_REVISION_NUMBER ITEM_SERIAL_NUMBER_FROM ITEM_SERIAL_NUMBER_TO LINE_ID LOCATOR_ID LOT_NUMBER LOT_SERIAL_ID ORIG_SYS_LOTSERIAL_REF QUANTITY SECONDARY_QUANTITY |
Query
SQL_Statement |
---|
SELECT DLSN.FULFILL_LINE_ID, DLSN.ITEM_REVISION_NUMBER, DLSN.ITEM_SERIAL_NUMBER_FROM, DLSN.ITEM_SERIAL_NUMBER_TO, DLSN.LINE_ID, DLSN.LOCATOR_ID, DLSN.LOT_NUMBER, DLSN.LOT_SERIAL_ID, DLSN.ORIG_SYS_LOTSERIAL_REF, DLSN.QUANTITY, DLSN.SECONDARY_QUANTITY FROM DOO_LOT_SERIAL_NUMBERS DLSN |