View: GHR_MASS_REAL_POS_INFO_V

Product:	GHR - US Federal Human Resources
Description:	This form is used by Mass Realignment for Position Information.
Implementation/DBA Data:	APPS.GHR_MASS_REAL_POS_INFO_V

View Text

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

Columns