DBA Data[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