SELECT CLM_DOCUMENT_NUMBER, 'N' ismod FROM PO_HEADERS_ALL WHERE uda_template_id IS NOT null UNION SELECT modification_number, 'Y' ismod FROM po_drafts
View Text - HTML Formatted
SELECT CLM_DOCUMENT_NUMBER , 'N' ISMOD FROM PO_HEADERS_ALL WHERE UDA_TEMPLATE_ID IS NOT NULL UNION SELECT MODIFICATION_NUMBER , 'Y' ISMOD FROM PO_DRAFTS