VIEW: APPS.HR_DM_EXP_HR_LOC_ALL_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'