[Home] [Help]
View: PAYLV_LOOKUP_V
View Text
SELECT HL.APPLICATION_ID
, HL.LOOKUP_TYPE
, HL.LOOKUP_CODE
, HL.MEANING
, HL.ENABLED_FLAG
, HL.START_DATE_ACTIVE
, HL.END_DATE_ACTIVE
, HL.DESCRIPTION
, HL.LOOKUP_TYPE ORDER_BY
, HL.LAST_UPDATE_DATE
, HL.LAST_UPDATED_BY
, HL.LAST_UPDATE_LOGIN
, HL.CREATED_BY
, HL.CREATION_DATE
FROM HR_LOOKUPS HL UNION ALL SELECT -1
, NULL
, NULL
, NULL
, 'Y'
, TO_DATE(NULL)
, TO_DATE(NULL)
, NULL
, ' '
, TO_DATE(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_DATE(NULL) ORDER_BY
FROM DUAL WITH READ ONLY
Columns
Name |
APPLICATION_ID |
LOOKUP_TYPE |
LOOKUP_CODE |
MEANING |
ENABLED_FLAG |
START_DATE_ACTIVE |
END_DATE_ACTIVE |
DESCRIPTION |
ORDER_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
CREATED_BY |
CREATION_DATE |