That one field is actually controlled by the interaction of two columns, AP_SUPPLIERS . Receipt_Required_Flag and AP_SUPPLIERS . Inspection_Required_Flag . If both columns are NULL or "N", that is 2-Way matching. If AP_SUPPLIERS.Receipt_Required_Flag is "Y" and AP_SUPPLIERS.Inspection_Required_Flag is NULL or "N", that is 3-Way matching. If both columns are "Y", that is 4-Way matching. AP_SUPPLIERS.Receipt_Required_Flag = NULL or "N" and AP_SUPPLIERS.Inspection_Required_Flag = "Y" is undefined. 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 ...