[Home] [Help]
View: PA_EVENT_TYPES_RES_V
View Text
SELECT EVENT_TYPE
, DESCRIPTION
, EVENT_TYPE_CLASSIFICATION
, REVENUE_CATEGORY_CODE
, 'N'
, NULL
, 'N'
FROM PA_EVENT_TYPES
WHERE EVENT_TYPE_CLASSIFICATION IN ('AUTOMATIC'
, 'MANUAL'
, 'WRITE OFF'
, 'WRITE ON')
AND DECODE(PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES
, 'Y'
, START_DATE_ACTIVE
, TRUNC(SYSDATE)) BETWEEN START_DATE_ACTIVE
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE))
Columns
Name |
EVENT_TYPE |
DESCRIPTION |
EVENT_TYPE_CLASSIFICATION |
REVENUE_CATEGORY_CODE |
TRACK_AS_LABOR_FLAG |
UNIT_OF_MEASURE |
ROLLUP_QUANTITY_FLAG |