eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: HR.HR_LOCN_DELTA_SYNC#

Source

View Text - Preformatted


select BUSINESS_GROUP_ID BUSINESS_GROUP_ID, LOCATION_ID LOCATION_ID, EFFECTIVE_DATE EFFECTIVE_DATE, EFFECTIVE_STATUS EFFECTIVE_STATUS, LOCATION_CODE LOCATION_CODE, LOCATION_DESCRIPTION LOCATION_DESCRIPTION, LOCATION_STYLE LOCATION_STYLE, COUNTRY COUNTRY, ADDRESS_LINE1 ADDRESS_LINE1, ADDRESS_LINE2 ADDRESS_LINE2, ADDRESS_LINE3 ADDRESS_LINE3, TOWN_OR_CITY TOWN_OR_CITY, REGION_1 REGION_1, REGION_2 REGION_2, REGION_3 REGION_3, POSTAL_CODE POSTAL_CODE, TELEPHONE_NUMBER_1 TELEPHONE_NUMBER_1, TELEPHONE_NUMBER_2 TELEPHONE_NUMBER_2, TELEPHONE_NUMBER_3 TELEPHONE_NUMBER_3, LOCATION_INFORMATION13 LOCATION_INFORMATION13, LOCATION_INFORMATION14 LOCATION_INFORMATION14, LOCATION_INFORMATION15 LOCATION_INFORMATION15, LOCATION_INFORMATION16 LOCATION_INFORMATION16, LOCATION_INFORMATION17 LOCATION_INFORMATION17, LOCATION_INFORMATION18 LOCATION_INFORMATION18, LOCATION_INFORMATION19 LOCATION_INFORMATION19, LOCATION_INFORMATION20 LOCATION_INFORMATION20, STATUS STATUS, EFFECTIVE_STATUS_DATE EFFECTIVE_STATUS_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, EVENT_KEY EVENT_KEY from "HR"."HR_LOCN_DELTA_SYNC"

View Text - HTML Formatted

SELECT BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, LOCATION_ID LOCATION_ID
, EFFECTIVE_DATE EFFECTIVE_DATE
, EFFECTIVE_STATUS EFFECTIVE_STATUS
, LOCATION_CODE LOCATION_CODE
, LOCATION_DESCRIPTION LOCATION_DESCRIPTION
, LOCATION_STYLE LOCATION_STYLE
, COUNTRY COUNTRY
, ADDRESS_LINE1 ADDRESS_LINE1
, ADDRESS_LINE2 ADDRESS_LINE2
, ADDRESS_LINE3 ADDRESS_LINE3
, TOWN_OR_CITY TOWN_OR_CITY
, REGION_1 REGION_1
, REGION_2 REGION_2
, REGION_3 REGION_3
, POSTAL_CODE POSTAL_CODE
, TELEPHONE_NUMBER_1 TELEPHONE_NUMBER_1
, TELEPHONE_NUMBER_2 TELEPHONE_NUMBER_2
, TELEPHONE_NUMBER_3 TELEPHONE_NUMBER_3
, LOCATION_INFORMATION13 LOCATION_INFORMATION13
, LOCATION_INFORMATION14 LOCATION_INFORMATION14
, LOCATION_INFORMATION15 LOCATION_INFORMATION15
, LOCATION_INFORMATION16 LOCATION_INFORMATION16
, LOCATION_INFORMATION17 LOCATION_INFORMATION17
, LOCATION_INFORMATION18 LOCATION_INFORMATION18
, LOCATION_INFORMATION19 LOCATION_INFORMATION19
, LOCATION_INFORMATION20 LOCATION_INFORMATION20
, STATUS STATUS
, EFFECTIVE_STATUS_DATE EFFECTIVE_STATUS_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, EVENT_KEY EVENT_KEY
FROM "HR"."HR_LOCN_DELTA_SYNC"