[Home] [Help]
View: PA_EVENT_TYPE_OUS_V
View Text
SELECT DISTINCT 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 L.ORG_ID IN (EOU.ORG_ID
, -99)
AND L.ENABLED_FLAG = 'Y'
AND HR.ORG_ID = EOU.ORG_ID
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(L.START_DATE_ACTIVE
, SYSDATE))
AND TRUNC(NVL(L.END_DATE_ACTIVE
, SYSDATE))
Columns
Name |
ROW_ID |
EVENT_TYPE |
OUTPUT_TAX_CLASSIFICATION_CODE |
TAX_DESCRIPTION |
ORG_ID |
OPERATING_UNIT |