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
FROM ap_suppliers APS
WHERE vendor_name = <Supplier name>;
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
FROM ap_suppliers APS
WHERE vendor_name = <Supplier name>;
Comments
Post a Comment