[Home] [Help]
VIEW: APPS.CLN_RN_UTIL_TO_ROLE_INTERNAL_V
Source
View Text - Preformatted
SELECT hrl.location_id TP_ID ,hrl.location_id TP_SITE_ID ,hrl.location_code ,null ,hrl.telephone_number_1 ,null ,hrl.ece_tp_location_code FROM HR_LOCATIONS hrl
View Text - HTML Formatted
SELECT HRL.LOCATION_ID TP_ID
, HRL.LOCATION_ID TP_SITE_ID
, HRL.LOCATION_CODE
, NULL
, HRL.TELEPHONE_NUMBER_1
, NULL
, HRL.ECE_TP_LOCATION_CODE
FROM HR_LOCATIONS HRL