[Home] [Help]
View: HR_H2PI_US_MODIFIED_GEOCODES_V
Product: | PER - Human Resources |
Description: | Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for US midfied geocodes |
Implementation/DBA Data: |
APPS.HR_H2PI_US_MODIFIED_GEOCODES_V
|
View Text
SELECT GEO.CITY_NAME
, GEO.STATE_CODE
, GEO.COUNTY_CODE
, GEO.NEW_CITY_CODE
, GEO.OLD_CITY_CODE
, GEO.PRIMARY_FLAG
, GEO.PROCESS_TYPE
, GEO.PATCH_NAME
FROM PAY_US_MODIFIED_GEOCODES GEO
Columns
Name |
CITY_NAME |
STATE_CODE |
COUNTY_CODE |
NEW_CITY_CODE |
OLD_CITY_CODE |
PRIMARY_FLAG |
PROCESS_TYPE |
PATCH_NAME |