VIEW: APPS.PAYLV_LOOKUP_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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