Wednesday 27 April 2016

How to check the PO 2-WAY, 3-WAY ,4-WAY matching using SQL

/* Formatted on 4/27/2016 10:22:49 AM (QP5 v5.114.809.3010) */
SELECT   MATCH_OPTION,PO_HEADER_ID,
         DECODE (INSPECTION_REQUIRED_FLAG, 'Y', '4-WAY') FOUR_WAY_MATCH,
         DECODE (RECEIPT_REQUIRED_FLAG, 'Y', '3-WAY') THREE_WAY_MATCH,
         DECODE (MATCH_OPTION, 'P', '2-WAY') TWO_WAY_MATCH
  FROM   po_line_locations_all
 WHERE   PO_HEADER_ID in(1015,1016,2004,2007)

No comments:

Post a Comment