eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

Skip to content FND Design Data

[Home] [Help]

View: PO_EDA_CLM_DOC_NBR_V

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.PO_EDA_CLM_DOC_NBR_V

View Text

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

Columns

Name
CLM_DOCUMENT_NUMBER
ISMOD