WSH_SERIAL_NUMBERS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: WSH
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
SERIAL_TYPE DELIVERY_DETAIL_ID TRANSACTION_TEMP_ID INVENTORY_ITEM_ID ORGANIZATION_ID FM_SERIAL_NUMBER TO_SERIAL_NUMBER |
問合せ
| 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 |