DBA Data[Home] [Help]

VIEW: APPS.PO_EDA_CLM_DOC_NBR_V

Source

View Text - Preformatted

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