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)

1 comment:

  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, BI Publisher, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete