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.

VIEW: APPS.PA_EVENT_OUTPUT_TAX

Source

View Text - Preformatted


SELECT EV.EVENT_ID ,EOU.OUTPUT_TAX_CLASSIFICATION_CODE ,LK.MEANING FROM PA_EVENTS EV, PA_EVENT_TYPE_OUS EOU, ZX_OUTPUT_CLASSIFICATIONS_V LK WHERE EV.EVENT_TYPE = EOU.EVENT_TYPE AND EOU.OUTPUT_TAX_CLASSIFICATION_CODE = LK.LOOKUP_CODE AND LK.ORG_ID in ( EOU.ORG_ID, -99) AND LK.ENABLED_FLAG = 'Y'

View Text - HTML Formatted

SELECT EV.EVENT_ID
, EOU.OUTPUT_TAX_CLASSIFICATION_CODE
, LK.MEANING
FROM PA_EVENTS EV
, PA_EVENT_TYPE_OUS EOU
, ZX_OUTPUT_CLASSIFICATIONS_V LK
WHERE EV.EVENT_TYPE = EOU.EVENT_TYPE
AND EOU.OUTPUT_TAX_CLASSIFICATION_CODE = LK.LOOKUP_CODE
AND LK.ORG_ID IN ( EOU.ORG_ID
, -99)
AND LK.ENABLED_FLAG = 'Y'