VIEW: APPS.PA_CURRENCY_UOM_V

Source

View Text - Preformatted

SELECT MEANING , LOOKUP_CODE , DECODE(UPPER(MEANING),'DOLLARS','Y','N') CURRENCY_UOM_FLAG FROM PA_LOOKUPS WHERE LOOKUP_TYPE = 'UNIT'

View Text - HTML Formatted

SELECT MEANING
, LOOKUP_CODE
, DECODE(UPPER(MEANING)
, 'DOLLARS'
, 'Y'
, 'N') CURRENCY_UOM_FLAG
FROM PA_LOOKUPS
WHERE LOOKUP_TYPE = 'UNIT'