APPS.HR_DM_EXP_HR_LOC_ALL_V
[Home] [Help]
| Product: | PER - Human Resources |
|---|---|
| Description: | View to export hr_locations_all |
| Implementation/DBA Data: |
APPS.HR_DM_EXP_HR_LOC_ALL_V
|
SELECT EXP_IMP_ID
, TABLE_NAME
, PVAL001 LOCATION_ID
, PVAL002 LOCATION_CODE
, PVAL003 BUSINESS_GROUP_ID
, PVAL004 DESCRIPTION
, PVAL005 SHIP_TO_LOCATION_ID
, PVAL006 SHIP_TO_SITE_FLAG
, PVAL007 RECEIVING_SITE_FLAG
, PVAL008 BILL_TO_SITE_FLAG
, PVAL009 IN_ORGANIZATION_FLAG
, PVAL010 OFFICE_SITE_FLAG
, PVAL011 DESIGNATED_RECEIVER_ID
, PVAL012 INVENTORY_ORGANIZATION_ID
, PVAL013 TAX_NAME
, PVAL014 INACTIVE_DATE
, PVAL015 STYLE
, PVAL016 ADDRESS_LINE_1
, PVAL017 ADDRESS_LINE_2
, PVAL018 ADDRESS_LINE_3
, PVAL019 TOWN_OR_CITY
, PVAL020 COUNTRY
, PVAL021 POSTAL_CODE
, PVAL022 REGION_1
, PVAL023 REGION_2
, PVAL024 REGION_3
, PVAL025 TELEPHONE_NUMBER_1
, PVAL026 TELEPHONE_NUMBER_2
, PVAL027 TELEPHONE_NUMBER_3
, PVAL028 LOC_INFORMATION13
, PVAL029 LOC_INFORMATION14
, PVAL030 LOC_INFORMATION15
, PVAL031 LOC_INFORMATION16
, PVAL032 LOC_INFORMATION17
, PVAL033 ATTRIBUTE_CATEGORY
, PVAL034 ATTRIBUTE1
, PVAL035 ATTRIBUTE2
, PVAL036 ATTRIBUTE3
, PVAL037 ATTRIBUTE4
, PVAL038 ATTRIBUTE5
, PVAL039 ATTRIBUTE6
, PVAL040 ATTRIBUTE7
, PVAL041 ATTRIBUTE8
, PVAL042 ATTRIBUTE9
, PVAL043 ATTRIBUTE10
, PVAL044 ATTRIBUTE11
, PVAL045 ATTRIBUTE12
, PVAL046 ATTRIBUTE13
, PVAL047 ATTRIBUTE14
, PVAL048 ATTRIBUTE15
, PVAL049 ATTRIBUTE16
, PVAL050 ATTRIBUTE17
, PVAL051 ATTRIBUTE18
, PVAL052 ATTRIBUTE19
, PVAL053 ATTRIBUTE20
, PVAL054 GLOBAL_ATTRIBUTE_CATEGORY
, PVAL055 GLOBAL_ATTRIBUTE1
, PVAL056 GLOBAL_ATTRIBUTE2
, PVAL057 GLOBAL_ATTRIBUTE3
, PVAL058 GLOBAL_ATTRIBUTE4
, PVAL059 GLOBAL_ATTRIBUTE5
, PVAL060 GLOBAL_ATTRIBUTE6
, PVAL061 GLOBAL_ATTRIBUTE7
, PVAL062 GLOBAL_ATTRIBUTE8
, PVAL063 GLOBAL_ATTRIBUTE9
, PVAL064 GLOBAL_ATTRIBUTE10
, PVAL065 GLOBAL_ATTRIBUTE11
, PVAL066 GLOBAL_ATTRIBUTE12
, PVAL067 GLOBAL_ATTRIBUTE13
, PVAL068 GLOBAL_ATTRIBUTE14
, PVAL069 GLOBAL_ATTRIBUTE15
, PVAL070 GLOBAL_ATTRIBUTE16
, PVAL071 GLOBAL_ATTRIBUTE17
, PVAL072 GLOBAL_ATTRIBUTE18
, PVAL073 GLOBAL_ATTRIBUTE19
, PVAL074 GLOBAL_ATTRIBUTE20
, PVAL075 LONGITUDE
, PVAL076 LATITUDE
, PVAL077 LAST_UPDATE_DATE
, PVAL078 LAST_UPDATED_BY
, PVAL079 LAST_UPDATE_LOGIN
, PVAL080 CREATED_BY
, PVAL081 CREATION_DATE
, PVAL082 ENTERED_BY
, PVAL083 TP_HEADER_ID
, PVAL084 ECE_TP_LOCATION_CODE
, PVAL085 OBJECT_VERSION_NUMBER
FROM HR_DM_EXP_IMPS
WHERE TABLE_NAME = 'HR_LOCATIONS_ALL'