/* 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)
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