WSH_SRS_PICK_SLIP_V

Details

• Schema: FUSION

• Object owner: WSH

• Object type: VIEW

Columns

Name
PICK_SLIP_NUMBER

Query

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