[Home] [Help]
View: PA_EVENT_TYPE_OUS_V
View Text
SELECT EOU.ROWID
, EOU.EVENT_TYPE
, EOU.OUTPUT_TAX_CLASSIFICATION_CODE
, L.MEANING TAX_DESCRIPTION
, EOU.ORG_ID
, HR.OPERATING_UNIT
FROM PA_EVENT_TYPE_OUS_ALL EOU
, ZX_OUTPUT_CLASSIFICATIONS_V L
, PA_OPERATING_UNITS_V HR
WHERE EOU.OUTPUT_TAX_CLASSIFICATION_CODE = L.LOOKUP_CODE
AND EOU.ORG_ID IN( L.ORG_ID
, -99)
AND L.ENABLED_FLAG = 'Y'
AND HR.ORG_ID = EOU.ORG_ID
Columns
Name |
ROW_ID |
EVENT_TYPE |
OUTPUT_TAX_CLASSIFICATION_CODE |
TAX_DESCRIPTION |
ORG_ID |
OPERATING_UNIT |