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 |