How To Determine Matching Approval Level In Supplier Table ap_suppliers

This SQL can be used ...



SELECT DECODE (NVL(APS.receipt_required_flag, 'N'),
               'Y', DECODE(NVL(APS.inspection_required_flag, 'N'),
                           'Y', '4-Way',
                           '3-Way'),
               '2-Way') matching_Level
  FROM ap_suppliers APS