WSH_SERIAL_NUMBERS_V

Details

• Schema: FUSION

• Object owner: WSH

• Object type: VIEW

Columns

Name
SERIAL_TYPE DELIVERY_DETAIL_ID TRANSACTION_TEMP_ID INVENTORY_ITEM_ID ORGANIZATION_ID FM_SERIAL_NUMBER TO_SERIAL_NUMBER

Query

SQL_Statement

SELECT 'INV' serial_type, WDD.delivery_detail_id, WDD.transaction_temp_id, WDD.inventory_item_id, WDD.organization_id, ISNT.fm_serial_number, ISNT.to_serial_number FROM INV_SERIAL_NUMBERS_TEMP ISNT, wsh_delivery_details WDD WHERE ISNT.transaction_temp_id = WDD.transaction_temp_id UNION ALL SELECT 'WSH' serial_type, WDD.delivery_detail_id, WDD.transaction_temp_id, WDD.inventory_item_id, WDD.organization_id, WSN.fm_serial_number, WSN.to_serial_number FROM WSH_SERIAL_NUMBERS WSN, wsh_delivery_details WDD WHERE WSN.delivery_detail_id = WDD.delivery_detail_id