How to find the Matching Type for a PO line.


SELECT pol.line_num,


DECODE (


PLL.RECEIPT_REQUIRED_FLAG,


'N', DECODE (PLL.INSPECTION_REQUIRED_FLAG, 'N', '2-Way', '2-Way'),


'Y', DECODE (PLL.INSPECTION_REQUIRED_FLAG,


'N', '3-Way',


'Y', '4-Way',


'3-Way'))




matching_type
FROM po_headers_all poh, po_lines_all pol, PO_LINE_LOCATIONS_all pll
WHERE pol.po_header_id = poh.po_header_id
AND pll.po_line_id = pol.po_line_id