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.

VIEW: APPS.GHR_MASS_REAL_POS_INFO_V

Source

View Text - Preformatted


SELECT MASS_REALIGNMENT_ID , TARGET_AGENCY_CODE_SUBELEMENT AGENCY_CODE_SUBELEMENT , TARGET_APPROPRIATION_CODE1 APPROPRIATION_CODE1 , TARGET_APPROPRIATION_CODE2 APPROPRIATION_CODE2 , TARGET_DUTY_STATION_CODE DUTY_STATION_CODE , TARGET_DUTY_STATION_ID DUTY_STATION_ID , TARGET_DUTY_STN_LOCATION_ID LOCATION_ID , TARGET_OFFICE_SYMBOL OFFICE_SYMBOL , TARGET_ORG_FUNCTION_CODE ORG_FUNCTION_CODE , TARGET_PAYROLL_OFFICE_ID PAYROLL_OFFICE_ID , TARGET_PERSONNEL_OFFICE_ID PERSONNEL_OFFICE_ID , TARGET_POSITION_ORG_ID POSITION_ORGANIZATION_ID , TARGET_POSITION_ORG_NAME POSITION_ORGANIZATION_NAME , CREATED_BY , CREATION_DATE , LAST_UPDATED_BY , LAST_UPDATE_DATE , LAST_UPDATE_LOGIN FROM GHR_MASS_REALIGNMENT

View Text - HTML Formatted

SELECT MASS_REALIGNMENT_ID
, TARGET_AGENCY_CODE_SUBELEMENT AGENCY_CODE_SUBELEMENT
, TARGET_APPROPRIATION_CODE1 APPROPRIATION_CODE1
, TARGET_APPROPRIATION_CODE2 APPROPRIATION_CODE2
, TARGET_DUTY_STATION_CODE DUTY_STATION_CODE
, TARGET_DUTY_STATION_ID DUTY_STATION_ID
, TARGET_DUTY_STN_LOCATION_ID LOCATION_ID
, TARGET_OFFICE_SYMBOL OFFICE_SYMBOL
, TARGET_ORG_FUNCTION_CODE ORG_FUNCTION_CODE
, TARGET_PAYROLL_OFFICE_ID PAYROLL_OFFICE_ID
, TARGET_PERSONNEL_OFFICE_ID PERSONNEL_OFFICE_ID
, TARGET_POSITION_ORG_ID POSITION_ORGANIZATION_ID
, TARGET_POSITION_ORG_NAME POSITION_ORGANIZATION_NAME
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM GHR_MASS_REALIGNMENT