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_ORGANIZATION_DELTA_SYNC#

Source

View Text - Preformatted


select BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ORGANIZATION_ID ORGANIZATION_ID, BUSINESS_GROUP_NAME BUSINESS_GROUP_NAME, EFFECTIVE_DATE EFFECTIVE_DATE, EFFECTIVE_STATUS EFFECTIVE_STATUS, COMPANY COMPANY, SETID_LOCATION SETID_LOCATION, LOCATION_ID LOCATION_ID, MANAGER_ID MANAGER_ID, MANAGER_FULL_NAME MANAGER_FULL_NAME, LAST_UPDATE_DATE LAST_UPDATE_DATE, STATUS STATUS, EFFECTIVE_STATUS_DATE EFFECTIVE_STATUS_DATE, EVENT_KEY EVENT_KEY from "HR"."HR_ORGANIZATION_DELTA_SYNC"

View Text - HTML Formatted

SELECT BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ORGANIZATION_ID ORGANIZATION_ID
, BUSINESS_GROUP_NAME BUSINESS_GROUP_NAME
, EFFECTIVE_DATE EFFECTIVE_DATE
, EFFECTIVE_STATUS EFFECTIVE_STATUS
, COMPANY COMPANY
, SETID_LOCATION SETID_LOCATION
, LOCATION_ID LOCATION_ID
, MANAGER_ID MANAGER_ID
, MANAGER_FULL_NAME MANAGER_FULL_NAME
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, STATUS STATUS
, EFFECTIVE_STATUS_DATE EFFECTIVE_STATUS_DATE
, EVENT_KEY EVENT_KEY
FROM "HR"."HR_ORGANIZATION_DELTA_SYNC"