機械翻訳について

WSH_SRS_PICK_SLIP_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: WSH

• オブジェクト・タイプ: VIEW

列

名前
PICK_SLIP_NUMBER

問合せ

SQL_Statement
SELECT pick_slip_number FROM INV_MATERIAL_TXNS_temp WHERE pick_slip_number IS NOT NULL AND nvl(transaction_quantity,0) > 0 UNION SELECT /*+ INDEX(m) */ pick_slip_number FROM INV_MATERIAL_TXNS m WHERE pick_slip_number IS NOT NULL AND nvl(transaction_quantity,0) < 0 UNION SELECT /*+ INDEX(r) */ pick_slip_number FROM INV_TXN_REQUEST_LINES r WHERE pick_slip_number is not null