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