ENGINATICSSYSTEM_ADMINISTRATORSYSADMIN22FFB94618DB3DA4E0630100007FD7CFAR Registry StatusYselect
al.lookup_code id,
al.meaning value,
null description
from
ar_lookups al
where
al.lookup_type='REGISTRY_STATUS' and
al.lookup_code in ('I','A')
order by
valueUSE811F942597A2075E0530100007FF4F2Blitz Upload ModeYselect xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all
select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual
US8E2FF36EDE8379D2E0530100007F1FF2CountryYselect
ftv.territory_short_name value,
ftv.territory_code||': '||ftv.description description
from
fnd_territories_vl ftv
order by
ftv.territory_short_nameUS0087D0A1D042F831E0630100007F0109HR LocationYselect
hl.location_code value,
hl.description||' ('||hl.address_line_1||', '||hl.town_or_city||', '||ftv.territory_short_name||')' description
from
hr_locations hl,
fnd_territories_vl ftv
where
hl.country=ftv.territory_code(+)
order by
hl.location_codeUS8E2FF36EDEA679D2E0530100007F1FF2YesYselect 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dualUS4F288F94CCB109E3E0630100007FECF2select
null action_,
null status_,
null message_,
null request_id_,
null modified_columns_,
hla.location_id,
hla.location_code,
hlat.description,
hla.inactive_date,
to_char(null) delete_location,
pbg.name business_group,
xxen_util.meaning(case when hla.legal_address_flag='Y' then 'Y' end,'YES_NO',0) legal_address_flag,
xxen_util.display_flexfield_context(800,'Address Location',hla.style) address_style,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'ADDRESS_LINE_1',hla.rowid,hla.address_line_1) address_line_1,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'ADDRESS_LINE_2',hla.rowid,hla.address_line_2) address_line_2,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'ADDRESS_LINE_3',hla.rowid,hla.address_line_3) address_line_3,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'TOWN_OR_CITY',hla.rowid,hla.town_or_city) town_or_city,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'REGION_1',hla.rowid,hla.region_1) region_1,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'REGION_2',hla.rowid,hla.region_2) region_2,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'REGION_3',hla.rowid,hla.region_3) region_3,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'POSTAL_CODE',hla.rowid,hla.postal_code) postal_code,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'COUNTRY',hla.rowid,hla.country) country,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'TELEPHONE_NUMBER_1',hla.rowid,hla.telephone_number_1) telephone_number_1,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'TELEPHONE_NUMBER_2',hla.rowid,hla.telephone_number_2) telephone_number_2,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'TELEPHONE_NUMBER_3',hla.rowid,hla.telephone_number_3) telephone_number_3,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'LOC_INFORMATION13',hla.rowid,hla.loc_information13) loc_information13,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'LOC_INFORMATION14',hla.rowid,hla.loc_information14) loc_information14,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'LOC_INFORMATION15',hla.rowid,hla.loc_information15) loc_information15,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'LOC_INFORMATION16',hla.rowid,hla.loc_information16) loc_information16,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'LOC_INFORMATION17',hla.rowid,hla.loc_information17) loc_information17,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'LOC_INFORMATION18',hla.rowid,hla.loc_information18) loc_information18,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'LOC_INFORMATION19',hla.rowid,hla.loc_information19) loc_information19,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'LOC_INFORMATION20',hla.rowid,hla.loc_information20) loc_information20,
hla2.location_code ship_to_location,
xxen_util.meaning(case when hla.ship_to_site_flag='Y' then 'Y' end,'YES_NO',0) ship_to_site_flag,
xxen_util.meaning(case when hla.receiving_site_flag='Y' then 'Y' end,'YES_NO',0) receiving_site_flag,
xxen_util.meaning(case when hla.bill_to_site_flag='Y' then 'Y' end,'YES_NO',0) bill_to_site_flag,
xxen_util.meaning(case when hla.office_site_flag='Y' then 'Y' end,'YES_NO',0) office_site_flag,
xxen_util.meaning(case when hla.in_organization_flag='Y' then 'Y' end,'YES_NO',0) in_organization_flag,
mp.organization_code inventory_organization,
ppf.full_name contact,
(select ftv.name from fnd_timezones_vl ftv where ftv.timezone_code=hla.timezone_code) timezone_code,
hla.ece_tp_location_code,
xxen_util.display_flexfield_context(800,'HR_LOCATIONS',hla.attribute_category) loc_attribute_category,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE1',hla.rowid,hla.attribute1) loc_attribute1,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE2',hla.rowid,hla.attribute2) loc_attribute2,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE3',hla.rowid,hla.attribute3) loc_attribute3,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE4',hla.rowid,hla.attribute4) loc_attribute4,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE5',hla.rowid,hla.attribute5) loc_attribute5,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE6',hla.rowid,hla.attribute6) loc_attribute6,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE7',hla.rowid,hla.attribute7) loc_attribute7,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE8',hla.rowid,hla.attribute8) loc_attribute8,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE9',hla.rowid,hla.attribute9) loc_attribute9,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE10',hla.rowid,hla.attribute10) loc_attribute10,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE11',hla.rowid,hla.attribute11) loc_attribute11,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE12',hla.rowid,hla.attribute12) loc_attribute12,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE13',hla.rowid,hla.attribute13) loc_attribute13,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE14',hla.rowid,hla.attribute14) loc_attribute14,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE15',hla.rowid,hla.attribute15) loc_attribute15,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE16',hla.rowid,hla.attribute16) loc_attribute16,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE17',hla.rowid,hla.attribute17) loc_attribute17,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE18',hla.rowid,hla.attribute18) loc_attribute18,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE19',hla.rowid,hla.attribute19) loc_attribute19,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE20',hla.rowid,hla.attribute20) loc_attribute20,
to_number(null) upload_row
from
hr_locations_all hla,
hr_locations_all_tl hlat,
hr_locations_all hla2,
mtl_parameters mp,
per_all_people_f ppf,
per_business_groups pbg
where
1=1 and
nvl(hla.business_group_id,nvl(hr_general.get_business_group_id,-99))=nvl(hr_general.get_business_group_id,nvl(hla.business_group_id,-99)) and
hla.location_id=hlat.location_id and
hlat.language=userenv('lang') and
hla.ship_to_location_id=hla2.location_id(+) and
hla.inventory_organization_id=mp.organization_id(+) and
hla.designated_receiver_id=ppf.person_id(+) and
hla.business_group_id=pbg.business_group_id(+)YUAxxen_per_upload.create_update_locationUSPER Location UploadUpload to create, update, and delete HR Locations.
Supports all country-specific address styles with address field validation.
Includes site flags (Ship-To, Bill-To, Receiving, Office, Internal) with autocorrection for Ship-To and Receiving flags based on the Ship-To Location relationship.
Includes the Descriptive Flexfield attributes with validation.
Business group security restricts downloaded locations to the user's current business group plus global locations. New locations can optionally be made local by assigning the location to the user's current business group. If not assigned to a business group, the location is a global location.
Legal Address locations are protected from inactivation and deletion. The upload cannot set or change the Legal Address Flag. This is for information only.
By default, new locations are created with themselves as the ship to location (self-referencing)
The upload will automatically set the ship to site flag based on the ship to location. When the ship to site is self-referencing, the ship to flag and receiving flag are always set to Yes. If the ship to location references a different location, the ship to site flag will be set to No.
If the ship to site flag is set to Yes, the receiving site flag is also set to Yes. Otherwise, the receiving site flag will be set as specified in the upload excel.
EnginaticsR12 onlyUpload1=11101=1:p_upload_mode like '%' || xxen_upload.action_updateLOVBlitz Upload ModeE811F942597A2075E0530100007FF4F2Yselect xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all
select xxen_upload.action_create || ',' || xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual
C,UYUSUpload Mode2201=1:default_address_style=:default_address_styleLOV customYselect
fdfcv.descriptive_flex_context_code id,
fdfcv.descriptive_flex_context_name value,
fdfcv.description description
from
fnd_descr_flex_contexts_vl fdfcv
where
fdfcv.application_id=800 and
fdfcv.descriptive_flexfield_name='Address Location' and
fdfcv.enabled_flag='Y' and
fdfcv.descriptive_flex_context_code<>'Global Data Elements'
order by
2select
coalesce(
(select fdfcv.descriptive_flex_context_code from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=800 and fdfcv.descriptive_flexfield_name='Address Location' and fdfcv.enabled_flag='Y' and fdfcv.descriptive_flex_context_code=pbg.legislation_code),
(select min(fdfcv.descriptive_flex_context_code) from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=800 and fdfcv.descriptive_flexfield_name='Address Location' and fdfcv.enabled_flag='Y' and substr(fdfcv.descriptive_flex_context_code,1,2)=pbg.legislation_code),
'GENERIC')
from
per_business_groups pbg
where
pbg.business_group_id=fnd_profile.value('PER_BUSINESS_GROUP_ID')YUSDefault Address Style3301=1hla.location_code=:location_nameLOVHR Location0087D0A1D042F831E0630100007F0109Yselect
hl.location_code value,
hl.description||' ('||hl.address_line_1||', '||hl.town_or_city||', '||ftv.territory_short_name||')' description
from
hr_locations hl,
fnd_territories_vl ftv
where
hl.country=ftv.territory_code(+)
order by
hl.location_codeUSLocation Name4401=1lower(hla.location_code) like lower(:location_name_like)USLocation Name Like5501=1nvl(hla.inactive_date,trunc(sysdate))>=trunc(sysdate)LOVAR Registry Status22FFB94618DB3DA4E0630100007FD7CFYselect
al.lookup_code id,
al.meaning value,
null description
from
ar_lookups al
where
al.lookup_type='REGISTRY_STATUS' and
al.lookup_code in ('I','A')
order by
valueAUSLocation Status61=1hla.inactive_date<trunc(sysdate)IUSLocation Status7601=1hla.country=(select ftv.territory_code from fnd_territories_vl ftv where ftv.territory_short_name=:country)LOVCountry8E2FF36EDE8379D2E0530100007F1FF2Yselect
ftv.territory_short_name value,
ftv.territory_code||': '||ftv.description description
from
fnd_territories_vl ftv
order by
ftv.territory_short_nameUSCountry8701=1hla.business_group_id is nullLOV OracleYes_NoYselect
lookup_code id,
meaning value,
null description
from
fnd_lookups
where fnd_lookups.lookup_type='YES_NO'
order by value,descriptionYUSGlobal91=1hla.business_group_id=fnd_profile.value('PER_BUSINESS_GROUP_ID')NUSGlobal10801=1hla.legal_address_flag='Y'LOV OracleYes_NoYselect
lookup_code id,
meaning value,
null description
from
fnd_lookups
where fnd_lookups.lookup_type='YES_NO'
order by value,descriptionYUSLegal Address111=1nvl(hla.legal_address_flag,'N')='N'NUSLegal Address12901=1hla.bill_to_site_flag=:bill_to_siteLOVYes8E2FF36EDEA679D2E0530100007F1FF2Yselect 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dualUSBill To Site131001=1hla.ship_to_site_flag=:ship_to_siteLOVYes8E2FF36EDEA679D2E0530100007F1FF2Yselect 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dualUSShip To Site141101=1hla.receiving_site_flag=:receiving_siteLOVYes8E2FF36EDEA679D2E0530100007F1FF2Yselect 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dualUSReceiving Site151201=1hla.in_organization_flag=:internal_siteLOVYes8E2FF36EDEA679D2E0530100007F1FF2Yselect 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dualUSInternal Site161301=1hla.office_site_flag=:office_siteLOVYes8E2FF36EDEA679D2E0530100007F1FF2Yselect 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dualUSOffice Site1ACTION_Charvarchar22STATUS_Charvarchar23MESSAGE_Charvarchar24REQUEST_ID_Charvarchar2Y5MODIFIED_COLUMNS_Charvarchar2Y6LOCATION_IDNumbernumberY7LOCATION_CODECharvarchar2Required. Unique identifier for the location. Used as the business key for matching existing locations on update.Y8DESCRIPTIONCharvarchar29INACTIVE_DATEDatedateDate the location becomes inactive. Cannot be set on locations flagged as Legal Address.10DELETE_LOCATIONLOVvarchar2Yes8E2FF36EDEA679D2E0530100007F1FF2Yselect 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dualSet to Yes to delete the location. The location must not be referenced by any assignments, organizations, positions, or other entities. Legal Address locations cannot be deleted.11BUSINESS_GROUPLOV customvarchar2Yselect
pbg.business_group_id id,
pbg.name value,
null description
from
per_business_groups pbg
where
pbg.business_group_id=fnd_profile.value('PER_BUSINESS_GROUP_ID')
order by
pbg.nameRead-only on downloaded data. For new locations, optionally select a Business Group to make the location local to that BG. Leave blank for a global location visible to all Business Groups.Y12LEGAL_ADDRESS_FLAGLOVvarchar2Yes8E2FF36EDEA679D2E0530100007F1FF2Yselect 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dualRead-only. Set by the legal entity assignment process, not directly editable. When set to Yes, the Inactive Date field is protected.Y13ADDRESS_STYLELOV customvarchar2Yselect
fdfcv.descriptive_flex_context_code id,
fdfcv.descriptive_flex_context_name value,
fdfcv.description description
from
fnd_descr_flex_contexts_vl fdfcv
where
fdfcv.application_id=800 and
fdfcv.descriptive_flexfield_name='Address Location' and
fdfcv.enabled_flag='Y' and
fdfcv.descriptive_flex_context_code<>'Global Data Elements'
order by
2select
fdfcv.descriptive_flex_context_name
from
fnd_descr_flex_contexts_vl fdfcv
where
fdfcv.application_id=800 and
fdfcv.descriptive_flexfield_name='Address Location' and
fdfcv.descriptive_flex_context_code=:$flex$.Default_Address_StyleDetermines the country-specific address format and which address fields are active and validated. Defaults from the Default Address Style report parameter.14ADDRESS_LINE_1LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_per_upload.address_location_lov(
p_context=>:$column$.address_style,
p_column_name=>'ADDRESS_LINE_1',
p_address_line_1=>:$column$.address_line_1,
p_address_line_2=>:$column$.address_line_2,
p_address_line_3=>:$column$.address_line_3,
p_town_or_city=>:$column$.town_or_city,
p_region_1=>:$column$.region_1,
p_region_2=>:$column$.region_2,
p_region_3=>:$column$.region_3,
p_postal_code=>:$column$.postal_code,
p_country=>:$column$.country,
p_telephone_number_1=>:$column$.telephone_number_1,
p_telephone_number_2=>:$column$.telephone_number_2,
p_telephone_number_3=>:$column$.telephone_number_3,
p_loc_information13=>:$column$.loc_information13,
p_loc_information14=>:$column$.loc_information14,
p_loc_information15=>:$column$.loc_information15,
p_loc_information16=>:$column$.loc_information16,
p_loc_information17=>:$column$.loc_information17,
p_loc_information18=>:$column$.loc_information18,
p_loc_information19=>:$column$.loc_information19,
p_loc_information20=>:$column$.loc_information20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_name || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts_vl fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='Address Location' and
fdfcuv.application_column_name='ADDRESS_LINE_1'15ADDRESS_LINE_2LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_per_upload.address_location_lov(
p_context=>:$column$.address_style,
p_column_name=>'ADDRESS_LINE_2',
p_address_line_1=>:$column$.address_line_1,
p_address_line_2=>:$column$.address_line_2,
p_address_line_3=>:$column$.address_line_3,
p_town_or_city=>:$column$.town_or_city,
p_region_1=>:$column$.region_1,
p_region_2=>:$column$.region_2,
p_region_3=>:$column$.region_3,
p_postal_code=>:$column$.postal_code,
p_country=>:$column$.country,
p_telephone_number_1=>:$column$.telephone_number_1,
p_telephone_number_2=>:$column$.telephone_number_2,
p_telephone_number_3=>:$column$.telephone_number_3,
p_loc_information13=>:$column$.loc_information13,
p_loc_information14=>:$column$.loc_information14,
p_loc_information15=>:$column$.loc_information15,
p_loc_information16=>:$column$.loc_information16,
p_loc_information17=>:$column$.loc_information17,
p_loc_information18=>:$column$.loc_information18,
p_loc_information19=>:$column$.loc_information19,
p_loc_information20=>:$column$.loc_information20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_name || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts_vl fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='Address Location' and
fdfcuv.application_column_name='ADDRESS_LINE_2'16ADDRESS_LINE_3LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_per_upload.address_location_lov(
p_context=>:$column$.address_style,
p_column_name=>'ADDRESS_LINE_3',
p_address_line_1=>:$column$.address_line_1,
p_address_line_2=>:$column$.address_line_2,
p_address_line_3=>:$column$.address_line_3,
p_town_or_city=>:$column$.town_or_city,
p_region_1=>:$column$.region_1,
p_region_2=>:$column$.region_2,
p_region_3=>:$column$.region_3,
p_postal_code=>:$column$.postal_code,
p_country=>:$column$.country,
p_telephone_number_1=>:$column$.telephone_number_1,
p_telephone_number_2=>:$column$.telephone_number_2,
p_telephone_number_3=>:$column$.telephone_number_3,
p_loc_information13=>:$column$.loc_information13,
p_loc_information14=>:$column$.loc_information14,
p_loc_information15=>:$column$.loc_information15,
p_loc_information16=>:$column$.loc_information16,
p_loc_information17=>:$column$.loc_information17,
p_loc_information18=>:$column$.loc_information18,
p_loc_information19=>:$column$.loc_information19,
p_loc_information20=>:$column$.loc_information20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_name || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts_vl fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='Address Location' and
fdfcuv.application_column_name='ADDRESS_LINE_3'17TOWN_OR_CITYLOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_per_upload.address_location_lov(
p_context=>:$column$.address_style,
p_column_name=>'TOWN_OR_CITY',
p_address_line_1=>:$column$.address_line_1,
p_address_line_2=>:$column$.address_line_2,
p_address_line_3=>:$column$.address_line_3,
p_town_or_city=>:$column$.town_or_city,
p_region_1=>:$column$.region_1,
p_region_2=>:$column$.region_2,
p_region_3=>:$column$.region_3,
p_postal_code=>:$column$.postal_code,
p_country=>:$column$.country,
p_telephone_number_1=>:$column$.telephone_number_1,
p_telephone_number_2=>:$column$.telephone_number_2,
p_telephone_number_3=>:$column$.telephone_number_3,
p_loc_information13=>:$column$.loc_information13,
p_loc_information14=>:$column$.loc_information14,
p_loc_information15=>:$column$.loc_information15,
p_loc_information16=>:$column$.loc_information16,
p_loc_information17=>:$column$.loc_information17,
p_loc_information18=>:$column$.loc_information18,
p_loc_information19=>:$column$.loc_information19,
p_loc_information20=>:$column$.loc_information20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_name || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts_vl fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='Address Location' and
fdfcuv.application_column_name='TOWN_OR_CITY'18REGION_1LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_per_upload.address_location_lov(
p_context=>:$column$.address_style,
p_column_name=>'REGION_1',
p_address_line_1=>:$column$.address_line_1,
p_address_line_2=>:$column$.address_line_2,
p_address_line_3=>:$column$.address_line_3,
p_town_or_city=>:$column$.town_or_city,
p_region_1=>:$column$.region_1,
p_region_2=>:$column$.region_2,
p_region_3=>:$column$.region_3,
p_postal_code=>:$column$.postal_code,
p_country=>:$column$.country,
p_telephone_number_1=>:$column$.telephone_number_1,
p_telephone_number_2=>:$column$.telephone_number_2,
p_telephone_number_3=>:$column$.telephone_number_3,
p_loc_information13=>:$column$.loc_information13,
p_loc_information14=>:$column$.loc_information14,
p_loc_information15=>:$column$.loc_information15,
p_loc_information16=>:$column$.loc_information16,
p_loc_information17=>:$column$.loc_information17,
p_loc_information18=>:$column$.loc_information18,
p_loc_information19=>:$column$.loc_information19,
p_loc_information20=>:$column$.loc_information20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_name || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts_vl fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='Address Location' and
fdfcuv.application_column_name='REGION_1'19REGION_2LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_per_upload.address_location_lov(
p_context=>:$column$.address_style,
p_column_name=>'REGION_2',
p_address_line_1=>:$column$.address_line_1,
p_address_line_2=>:$column$.address_line_2,
p_address_line_3=>:$column$.address_line_3,
p_town_or_city=>:$column$.town_or_city,
p_region_1=>:$column$.region_1,
p_region_2=>:$column$.region_2,
p_region_3=>:$column$.region_3,
p_postal_code=>:$column$.postal_code,
p_country=>:$column$.country,
p_telephone_number_1=>:$column$.telephone_number_1,
p_telephone_number_2=>:$column$.telephone_number_2,
p_telephone_number_3=>:$column$.telephone_number_3,
p_loc_information13=>:$column$.loc_information13,
p_loc_information14=>:$column$.loc_information14,
p_loc_information15=>:$column$.loc_information15,
p_loc_information16=>:$column$.loc_information16,
p_loc_information17=>:$column$.loc_information17,
p_loc_information18=>:$column$.loc_information18,
p_loc_information19=>:$column$.loc_information19,
p_loc_information20=>:$column$.loc_information20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_name || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts_vl fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='Address Location' and
fdfcuv.application_column_name='REGION_2'20REGION_3LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_per_upload.address_location_lov(
p_context=>:$column$.address_style,
p_column_name=>'REGION_3',
p_address_line_1=>:$column$.address_line_1,
p_address_line_2=>:$column$.address_line_2,
p_address_line_3=>:$column$.address_line_3,
p_town_or_city=>:$column$.town_or_city,
p_region_1=>:$column$.region_1,
p_region_2=>:$column$.region_2,
p_region_3=>:$column$.region_3,
p_postal_code=>:$column$.postal_code,
p_country=>:$column$.country,
p_telephone_number_1=>:$column$.telephone_number_1,
p_telephone_number_2=>:$column$.telephone_number_2,
p_telephone_number_3=>:$column$.telephone_number_3,
p_loc_information13=>:$column$.loc_information13,
p_loc_information14=>:$column$.loc_information14,
p_loc_information15=>:$column$.loc_information15,
p_loc_information16=>:$column$.loc_information16,
p_loc_information17=>:$column$.loc_information17,
p_loc_information18=>:$column$.loc_information18,
p_loc_information19=>:$column$.loc_information19,
p_loc_information20=>:$column$.loc_information20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_name || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts_vl fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='Address Location' and
fdfcuv.application_column_name='REGION_3'21POSTAL_CODELOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_per_upload.address_location_lov(
p_context=>:$column$.address_style,
p_column_name=>'POSTAL_CODE',
p_address_line_1=>:$column$.address_line_1,
p_address_line_2=>:$column$.address_line_2,
p_address_line_3=>:$column$.address_line_3,
p_town_or_city=>:$column$.town_or_city,
p_region_1=>:$column$.region_1,
p_region_2=>:$column$.region_2,
p_region_3=>:$column$.region_3,
p_postal_code=>:$column$.postal_code,
p_country=>:$column$.country,
p_telephone_number_1=>:$column$.telephone_number_1,
p_telephone_number_2=>:$column$.telephone_number_2,
p_telephone_number_3=>:$column$.telephone_number_3,
p_loc_information13=>:$column$.loc_information13,
p_loc_information14=>:$column$.loc_information14,
p_loc_information15=>:$column$.loc_information15,
p_loc_information16=>:$column$.loc_information16,
p_loc_information17=>:$column$.loc_information17,
p_loc_information18=>:$column$.loc_information18,
p_loc_information19=>:$column$.loc_information19,
p_loc_information20=>:$column$.loc_information20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_name || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts_vl fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='Address Location' and
fdfcuv.application_column_name='POSTAL_CODE'22COUNTRYLOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_per_upload.address_location_lov(
p_context=>:$column$.address_style,
p_column_name=>'COUNTRY',
p_address_line_1=>:$column$.address_line_1,
p_address_line_2=>:$column$.address_line_2,
p_address_line_3=>:$column$.address_line_3,
p_town_or_city=>:$column$.town_or_city,
p_region_1=>:$column$.region_1,
p_region_2=>:$column$.region_2,
p_region_3=>:$column$.region_3,
p_postal_code=>:$column$.postal_code,
p_country=>:$column$.country,
p_telephone_number_1=>:$column$.telephone_number_1,
p_telephone_number_2=>:$column$.telephone_number_2,
p_telephone_number_3=>:$column$.telephone_number_3,
p_loc_information13=>:$column$.loc_information13,
p_loc_information14=>:$column$.loc_information14,
p_loc_information15=>:$column$.loc_information15,
p_loc_information16=>:$column$.loc_information16,
p_loc_information17=>:$column$.loc_information17,
p_loc_information18=>:$column$.loc_information18,
p_loc_information19=>:$column$.loc_information19,
p_loc_information20=>:$column$.loc_information20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_name || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts_vl fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='Address Location' and
fdfcuv.application_column_name='COUNTRY'23TELEPHONE_NUMBER_1LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_per_upload.address_location_lov(
p_context=>:$column$.address_style,
p_column_name=>'TELEPHONE_NUMBER_1',
p_address_line_1=>:$column$.address_line_1,
p_address_line_2=>:$column$.address_line_2,
p_address_line_3=>:$column$.address_line_3,
p_town_or_city=>:$column$.town_or_city,
p_region_1=>:$column$.region_1,
p_region_2=>:$column$.region_2,
p_region_3=>:$column$.region_3,
p_postal_code=>:$column$.postal_code,
p_country=>:$column$.country,
p_telephone_number_1=>:$column$.telephone_number_1,
p_telephone_number_2=>:$column$.telephone_number_2,
p_telephone_number_3=>:$column$.telephone_number_3,
p_loc_information13=>:$column$.loc_information13,
p_loc_information14=>:$column$.loc_information14,
p_loc_information15=>:$column$.loc_information15,
p_loc_information16=>:$column$.loc_information16,
p_loc_information17=>:$column$.loc_information17,
p_loc_information18=>:$column$.loc_information18,
p_loc_information19=>:$column$.loc_information19,
p_loc_information20=>:$column$.loc_information20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_name || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts_vl fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='Address Location' and
fdfcuv.application_column_name='TELEPHONE_NUMBER_1'24TELEPHONE_NUMBER_2LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_per_upload.address_location_lov(
p_context=>:$column$.address_style,
p_column_name=>'TELEPHONE_NUMBER_2',
p_address_line_1=>:$column$.address_line_1,
p_address_line_2=>:$column$.address_line_2,
p_address_line_3=>:$column$.address_line_3,
p_town_or_city=>:$column$.town_or_city,
p_region_1=>:$column$.region_1,
p_region_2=>:$column$.region_2,
p_region_3=>:$column$.region_3,
p_postal_code=>:$column$.postal_code,
p_country=>:$column$.country,
p_telephone_number_1=>:$column$.telephone_number_1,
p_telephone_number_2=>:$column$.telephone_number_2,
p_telephone_number_3=>:$column$.telephone_number_3,
p_loc_information13=>:$column$.loc_information13,
p_loc_information14=>:$column$.loc_information14,
p_loc_information15=>:$column$.loc_information15,
p_loc_information16=>:$column$.loc_information16,
p_loc_information17=>:$column$.loc_information17,
p_loc_information18=>:$column$.loc_information18,
p_loc_information19=>:$column$.loc_information19,
p_loc_information20=>:$column$.loc_information20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_name || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts_vl fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='Address Location' and
fdfcuv.application_column_name='TELEPHONE_NUMBER_2'25TELEPHONE_NUMBER_3LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_per_upload.address_location_lov(
p_context=>:$column$.address_style,
p_column_name=>'TELEPHONE_NUMBER_3',
p_address_line_1=>:$column$.address_line_1,
p_address_line_2=>:$column$.address_line_2,
p_address_line_3=>:$column$.address_line_3,
p_town_or_city=>:$column$.town_or_city,
p_region_1=>:$column$.region_1,
p_region_2=>:$column$.region_2,
p_region_3=>:$column$.region_3,
p_postal_code=>:$column$.postal_code,
p_country=>:$column$.country,
p_telephone_number_1=>:$column$.telephone_number_1,
p_telephone_number_2=>:$column$.telephone_number_2,
p_telephone_number_3=>:$column$.telephone_number_3,
p_loc_information13=>:$column$.loc_information13,
p_loc_information14=>:$column$.loc_information14,
p_loc_information15=>:$column$.loc_information15,
p_loc_information16=>:$column$.loc_information16,
p_loc_information17=>:$column$.loc_information17,
p_loc_information18=>:$column$.loc_information18,
p_loc_information19=>:$column$.loc_information19,
p_loc_information20=>:$column$.loc_information20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_name || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts_vl fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='Address Location' and
fdfcuv.application_column_name='TELEPHONE_NUMBER_3'26LOC_INFORMATION13LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_per_upload.address_location_lov(
p_context=>:$column$.address_style,
p_column_name=>'LOC_INFORMATION13',
p_address_line_1=>:$column$.address_line_1,
p_address_line_2=>:$column$.address_line_2,
p_address_line_3=>:$column$.address_line_3,
p_town_or_city=>:$column$.town_or_city,
p_region_1=>:$column$.region_1,
p_region_2=>:$column$.region_2,
p_region_3=>:$column$.region_3,
p_postal_code=>:$column$.postal_code,
p_country=>:$column$.country,
p_telephone_number_1=>:$column$.telephone_number_1,
p_telephone_number_2=>:$column$.telephone_number_2,
p_telephone_number_3=>:$column$.telephone_number_3,
p_loc_information13=>:$column$.loc_information13,
p_loc_information14=>:$column$.loc_information14,
p_loc_information15=>:$column$.loc_information15,
p_loc_information16=>:$column$.loc_information16,
p_loc_information17=>:$column$.loc_information17,
p_loc_information18=>:$column$.loc_information18,
p_loc_information19=>:$column$.loc_information19,
p_loc_information20=>:$column$.loc_information20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_name || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts_vl fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='Address Location' and
fdfcuv.application_column_name='LOC_INFORMATION13'27LOC_INFORMATION14LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_per_upload.address_location_lov(
p_context=>:$column$.address_style,
p_column_name=>'LOC_INFORMATION14',
p_address_line_1=>:$column$.address_line_1,
p_address_line_2=>:$column$.address_line_2,
p_address_line_3=>:$column$.address_line_3,
p_town_or_city=>:$column$.town_or_city,
p_region_1=>:$column$.region_1,
p_region_2=>:$column$.region_2,
p_region_3=>:$column$.region_3,
p_postal_code=>:$column$.postal_code,
p_country=>:$column$.country,
p_telephone_number_1=>:$column$.telephone_number_1,
p_telephone_number_2=>:$column$.telephone_number_2,
p_telephone_number_3=>:$column$.telephone_number_3,
p_loc_information13=>:$column$.loc_information13,
p_loc_information14=>:$column$.loc_information14,
p_loc_information15=>:$column$.loc_information15,
p_loc_information16=>:$column$.loc_information16,
p_loc_information17=>:$column$.loc_information17,
p_loc_information18=>:$column$.loc_information18,
p_loc_information19=>:$column$.loc_information19,
p_loc_information20=>:$column$.loc_information20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_name || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts_vl fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='Address Location' and
fdfcuv.application_column_name='LOC_INFORMATION14'28LOC_INFORMATION15LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_per_upload.address_location_lov(
p_context=>:$column$.address_style,
p_column_name=>'LOC_INFORMATION15',
p_address_line_1=>:$column$.address_line_1,
p_address_line_2=>:$column$.address_line_2,
p_address_line_3=>:$column$.address_line_3,
p_town_or_city=>:$column$.town_or_city,
p_region_1=>:$column$.region_1,
p_region_2=>:$column$.region_2,
p_region_3=>:$column$.region_3,
p_postal_code=>:$column$.postal_code,
p_country=>:$column$.country,
p_telephone_number_1=>:$column$.telephone_number_1,
p_telephone_number_2=>:$column$.telephone_number_2,
p_telephone_number_3=>:$column$.telephone_number_3,
p_loc_information13=>:$column$.loc_information13,
p_loc_information14=>:$column$.loc_information14,
p_loc_information15=>:$column$.loc_information15,
p_loc_information16=>:$column$.loc_information16,
p_loc_information17=>:$column$.loc_information17,
p_loc_information18=>:$column$.loc_information18,
p_loc_information19=>:$column$.loc_information19,
p_loc_information20=>:$column$.loc_information20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_name || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts_vl fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='Address Location' and
fdfcuv.application_column_name='LOC_INFORMATION15'29LOC_INFORMATION16LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_per_upload.address_location_lov(
p_context=>:$column$.address_style,
p_column_name=>'LOC_INFORMATION16',
p_address_line_1=>:$column$.address_line_1,
p_address_line_2=>:$column$.address_line_2,
p_address_line_3=>:$column$.address_line_3,
p_town_or_city=>:$column$.town_or_city,
p_region_1=>:$column$.region_1,
p_region_2=>:$column$.region_2,
p_region_3=>:$column$.region_3,
p_postal_code=>:$column$.postal_code,
p_country=>:$column$.country,
p_telephone_number_1=>:$column$.telephone_number_1,
p_telephone_number_2=>:$column$.telephone_number_2,
p_telephone_number_3=>:$column$.telephone_number_3,
p_loc_information13=>:$column$.loc_information13,
p_loc_information14=>:$column$.loc_information14,
p_loc_information15=>:$column$.loc_information15,
p_loc_information16=>:$column$.loc_information16,
p_loc_information17=>:$column$.loc_information17,
p_loc_information18=>:$column$.loc_information18,
p_loc_information19=>:$column$.loc_information19,
p_loc_information20=>:$column$.loc_information20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_name || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts_vl fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='Address Location' and
fdfcuv.application_column_name='LOC_INFORMATION16'30LOC_INFORMATION17LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_per_upload.address_location_lov(
p_context=>:$column$.address_style,
p_column_name=>'LOC_INFORMATION17',
p_address_line_1=>:$column$.address_line_1,
p_address_line_2=>:$column$.address_line_2,
p_address_line_3=>:$column$.address_line_3,
p_town_or_city=>:$column$.town_or_city,
p_region_1=>:$column$.region_1,
p_region_2=>:$column$.region_2,
p_region_3=>:$column$.region_3,
p_postal_code=>:$column$.postal_code,
p_country=>:$column$.country,
p_telephone_number_1=>:$column$.telephone_number_1,
p_telephone_number_2=>:$column$.telephone_number_2,
p_telephone_number_3=>:$column$.telephone_number_3,
p_loc_information13=>:$column$.loc_information13,
p_loc_information14=>:$column$.loc_information14,
p_loc_information15=>:$column$.loc_information15,
p_loc_information16=>:$column$.loc_information16,
p_loc_information17=>:$column$.loc_information17,
p_loc_information18=>:$column$.loc_information18,
p_loc_information19=>:$column$.loc_information19,
p_loc_information20=>:$column$.loc_information20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_name || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts_vl fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='Address Location' and
fdfcuv.application_column_name='LOC_INFORMATION17'31LOC_INFORMATION18LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_per_upload.address_location_lov(
p_context=>:$column$.address_style,
p_column_name=>'LOC_INFORMATION18',
p_address_line_1=>:$column$.address_line_1,
p_address_line_2=>:$column$.address_line_2,
p_address_line_3=>:$column$.address_line_3,
p_town_or_city=>:$column$.town_or_city,
p_region_1=>:$column$.region_1,
p_region_2=>:$column$.region_2,
p_region_3=>:$column$.region_3,
p_postal_code=>:$column$.postal_code,
p_country=>:$column$.country,
p_telephone_number_1=>:$column$.telephone_number_1,
p_telephone_number_2=>:$column$.telephone_number_2,
p_telephone_number_3=>:$column$.telephone_number_3,
p_loc_information13=>:$column$.loc_information13,
p_loc_information14=>:$column$.loc_information14,
p_loc_information15=>:$column$.loc_information15,
p_loc_information16=>:$column$.loc_information16,
p_loc_information17=>:$column$.loc_information17,
p_loc_information18=>:$column$.loc_information18,
p_loc_information19=>:$column$.loc_information19,
p_loc_information20=>:$column$.loc_information20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_name || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts_vl fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='Address Location' and
fdfcuv.application_column_name='LOC_INFORMATION18'32LOC_INFORMATION19LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_per_upload.address_location_lov(
p_context=>:$column$.address_style,
p_column_name=>'LOC_INFORMATION19',
p_address_line_1=>:$column$.address_line_1,
p_address_line_2=>:$column$.address_line_2,
p_address_line_3=>:$column$.address_line_3,
p_town_or_city=>:$column$.town_or_city,
p_region_1=>:$column$.region_1,
p_region_2=>:$column$.region_2,
p_region_3=>:$column$.region_3,
p_postal_code=>:$column$.postal_code,
p_country=>:$column$.country,
p_telephone_number_1=>:$column$.telephone_number_1,
p_telephone_number_2=>:$column$.telephone_number_2,
p_telephone_number_3=>:$column$.telephone_number_3,
p_loc_information13=>:$column$.loc_information13,
p_loc_information14=>:$column$.loc_information14,
p_loc_information15=>:$column$.loc_information15,
p_loc_information16=>:$column$.loc_information16,
p_loc_information17=>:$column$.loc_information17,
p_loc_information18=>:$column$.loc_information18,
p_loc_information19=>:$column$.loc_information19,
p_loc_information20=>:$column$.loc_information20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_name || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts_vl fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='Address Location' and
fdfcuv.application_column_name='LOC_INFORMATION19'33LOC_INFORMATION20LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_per_upload.address_location_lov(
p_context=>:$column$.address_style,
p_column_name=>'LOC_INFORMATION20',
p_address_line_1=>:$column$.address_line_1,
p_address_line_2=>:$column$.address_line_2,
p_address_line_3=>:$column$.address_line_3,
p_town_or_city=>:$column$.town_or_city,
p_region_1=>:$column$.region_1,
p_region_2=>:$column$.region_2,
p_region_3=>:$column$.region_3,
p_postal_code=>:$column$.postal_code,
p_country=>:$column$.country,
p_telephone_number_1=>:$column$.telephone_number_1,
p_telephone_number_2=>:$column$.telephone_number_2,
p_telephone_number_3=>:$column$.telephone_number_3,
p_loc_information13=>:$column$.loc_information13,
p_loc_information14=>:$column$.loc_information14,
p_loc_information15=>:$column$.loc_information15,
p_loc_information16=>:$column$.loc_information16,
p_loc_information17=>:$column$.loc_information17,
p_loc_information18=>:$column$.loc_information18,
p_loc_information19=>:$column$.loc_information19,
p_loc_information20=>:$column$.loc_information20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_name || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts_vl fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='Address Location' and
fdfcuv.application_column_name='LOC_INFORMATION20'34SHIP_TO_LOCATIONLOV customvarchar2Yselect
hla.location_id id,
hla.location_code value,
hla.description description
from
hr_locations_all hla
where
hla.ship_to_site_flag='Y' and
nvl(hla.inactive_date,sysdate+1)>sysdate and
(:$column$.business_group is null or
nvl(hla.business_group_id,(select pbg.business_group_id from per_business_groups pbg where pbg.name=:$column$.business_group))=
(select pbg.business_group_id from per_business_groups pbg where pbg.name=:$column$.business_group))
order by
hla.location_codeThe ship-to location for this location. If left blank, defaults to the location itself (self-referencing).35SHIP_TO_SITE_FLAGLOVvarchar2Yes8E2FF36EDEA679D2E0530100007F1FF2Yselect 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dualAuto-corrected: automatically set to Yes when Ship To Location is self-referencing (blank or same as location), and No when pointing to another location.36RECEIVING_SITE_FLAGLOVvarchar2Yes8E2FF36EDEA679D2E0530100007F1FF2Yselect 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dualAuto-corrected: automatically set to Yes when Ship To Site Flag is Yes.37BILL_TO_SITE_FLAGLOVvarchar2Yes8E2FF36EDEA679D2E0530100007F1FF2Yselect 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual38OFFICE_SITE_FLAGLOVvarchar2Yes8E2FF36EDEA679D2E0530100007F1FF2Yselect 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual39IN_ORGANIZATION_FLAGLOVvarchar2Yes8E2FF36EDEA679D2E0530100007F1FF2Yselect 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual40INVENTORY_ORGANIZATIONLOV customvarchar2Yselect
mp.organization_id id,
mp.organization_code value,
ood.organization_name description
from
mtl_parameters mp,
org_organization_definitions ood
where
mp.organization_id=ood.organization_id
order by
241CONTACTLOV customvarchar2YYselect
ppf.person_id id,
ppf.full_name value,
ppf.employee_number description
from
per_all_people_f ppf
where
ppf.employee_number is not null and
sysdate between ppf.effective_start_date and ppf.effective_end_date and
(:$column$.business_group is null or
ppf.business_group_id=(select pbg.business_group_id from per_business_groups pbg where pbg.name=:$column$.business_group))
order by
ppf.full_nameThe designated receiver (contact person) for this location. Must be an employee within the same Business Group as the location, or any employee for global locations.42TIMEZONE_CODELOV customvarchar2Yselect
ftv.timezone_code id,
ftv.name value,
ftv.timezone_code description
from
fnd_timezones_vl ftv
where
ftv.enabled_flag='Y'
order by
143ECE_TP_LOCATION_CODECharvarchar244LOC_ATTRIBUTE_CATEGORYLOV customvarchar2Yselect
fdfcv.descriptive_flex_context_code id,
fdfcv.descriptive_flex_context_name value,
fdfcv.description description
from
fnd_descr_flex_contexts_vl fdfcv
where
fdfcv.application_id=800 and
fdfcv.descriptive_flexfield_name='HR_LOCATIONS' and
fdfcv.enabled_flag='Y' and
fdfcv.descriptive_flex_context_code<>'Global Data Elements'
order by
245LOC_ATTRIBUTE1LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>800,
p_descriptive_flexfield_name=>'HR_LOCATIONS',
p_context_name=>:$column$.loc_attribute_category,
p_column_name=>'ATTRIBUTE1',
p_attribute1=>:$column$.loc_attribute1,
p_attribute2=>:$column$.loc_attribute2,
p_attribute3=>:$column$.loc_attribute3,
p_attribute4=>:$column$.loc_attribute4,
p_attribute5=>:$column$.loc_attribute5,
p_attribute6=>:$column$.loc_attribute6,
p_attribute7=>:$column$.loc_attribute7,
p_attribute8=>:$column$.loc_attribute8,
p_attribute9=>:$column$.loc_attribute9,
p_attribute10=>:$column$.loc_attribute10,
p_attribute11=>:$column$.loc_attribute11,
p_attribute12=>:$column$.loc_attribute12,
p_attribute13=>:$column$.loc_attribute13,
p_attribute14=>:$column$.loc_attribute14,
p_attribute15=>:$column$.loc_attribute15,
p_attribute16=>:$column$.loc_attribute16,
p_attribute17=>:$column$.loc_attribute17,
p_attribute18=>:$column$.loc_attribute18,
p_attribute19=>:$column$.loc_attribute19,
p_attribute20=>:$column$.loc_attribute20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='HR_LOCATIONS' and
fdfcuv.application_column_name='ATTRIBUTE1'46LOC_ATTRIBUTE2LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>800,
p_descriptive_flexfield_name=>'HR_LOCATIONS',
p_context_name=>:$column$.loc_attribute_category,
p_column_name=>'ATTRIBUTE2',
p_attribute1=>:$column$.loc_attribute1,
p_attribute2=>:$column$.loc_attribute2,
p_attribute3=>:$column$.loc_attribute3,
p_attribute4=>:$column$.loc_attribute4,
p_attribute5=>:$column$.loc_attribute5,
p_attribute6=>:$column$.loc_attribute6,
p_attribute7=>:$column$.loc_attribute7,
p_attribute8=>:$column$.loc_attribute8,
p_attribute9=>:$column$.loc_attribute9,
p_attribute10=>:$column$.loc_attribute10,
p_attribute11=>:$column$.loc_attribute11,
p_attribute12=>:$column$.loc_attribute12,
p_attribute13=>:$column$.loc_attribute13,
p_attribute14=>:$column$.loc_attribute14,
p_attribute15=>:$column$.loc_attribute15,
p_attribute16=>:$column$.loc_attribute16,
p_attribute17=>:$column$.loc_attribute17,
p_attribute18=>:$column$.loc_attribute18,
p_attribute19=>:$column$.loc_attribute19,
p_attribute20=>:$column$.loc_attribute20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='HR_LOCATIONS' and
fdfcuv.application_column_name='ATTRIBUTE2'47LOC_ATTRIBUTE3LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>800,
p_descriptive_flexfield_name=>'HR_LOCATIONS',
p_context_name=>:$column$.loc_attribute_category,
p_column_name=>'ATTRIBUTE3',
p_attribute1=>:$column$.loc_attribute1,
p_attribute2=>:$column$.loc_attribute2,
p_attribute3=>:$column$.loc_attribute3,
p_attribute4=>:$column$.loc_attribute4,
p_attribute5=>:$column$.loc_attribute5,
p_attribute6=>:$column$.loc_attribute6,
p_attribute7=>:$column$.loc_attribute7,
p_attribute8=>:$column$.loc_attribute8,
p_attribute9=>:$column$.loc_attribute9,
p_attribute10=>:$column$.loc_attribute10,
p_attribute11=>:$column$.loc_attribute11,
p_attribute12=>:$column$.loc_attribute12,
p_attribute13=>:$column$.loc_attribute13,
p_attribute14=>:$column$.loc_attribute14,
p_attribute15=>:$column$.loc_attribute15,
p_attribute16=>:$column$.loc_attribute16,
p_attribute17=>:$column$.loc_attribute17,
p_attribute18=>:$column$.loc_attribute18,
p_attribute19=>:$column$.loc_attribute19,
p_attribute20=>:$column$.loc_attribute20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='HR_LOCATIONS' and
fdfcuv.application_column_name='ATTRIBUTE3'48LOC_ATTRIBUTE4LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>800,
p_descriptive_flexfield_name=>'HR_LOCATIONS',
p_context_name=>:$column$.loc_attribute_category,
p_column_name=>'ATTRIBUTE4',
p_attribute1=>:$column$.loc_attribute1,
p_attribute2=>:$column$.loc_attribute2,
p_attribute3=>:$column$.loc_attribute3,
p_attribute4=>:$column$.loc_attribute4,
p_attribute5=>:$column$.loc_attribute5,
p_attribute6=>:$column$.loc_attribute6,
p_attribute7=>:$column$.loc_attribute7,
p_attribute8=>:$column$.loc_attribute8,
p_attribute9=>:$column$.loc_attribute9,
p_attribute10=>:$column$.loc_attribute10,
p_attribute11=>:$column$.loc_attribute11,
p_attribute12=>:$column$.loc_attribute12,
p_attribute13=>:$column$.loc_attribute13,
p_attribute14=>:$column$.loc_attribute14,
p_attribute15=>:$column$.loc_attribute15,
p_attribute16=>:$column$.loc_attribute16,
p_attribute17=>:$column$.loc_attribute17,
p_attribute18=>:$column$.loc_attribute18,
p_attribute19=>:$column$.loc_attribute19,
p_attribute20=>:$column$.loc_attribute20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='HR_LOCATIONS' and
fdfcuv.application_column_name='ATTRIBUTE4'49LOC_ATTRIBUTE5LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>800,
p_descriptive_flexfield_name=>'HR_LOCATIONS',
p_context_name=>:$column$.loc_attribute_category,
p_column_name=>'ATTRIBUTE5',
p_attribute1=>:$column$.loc_attribute1,
p_attribute2=>:$column$.loc_attribute2,
p_attribute3=>:$column$.loc_attribute3,
p_attribute4=>:$column$.loc_attribute4,
p_attribute5=>:$column$.loc_attribute5,
p_attribute6=>:$column$.loc_attribute6,
p_attribute7=>:$column$.loc_attribute7,
p_attribute8=>:$column$.loc_attribute8,
p_attribute9=>:$column$.loc_attribute9,
p_attribute10=>:$column$.loc_attribute10,
p_attribute11=>:$column$.loc_attribute11,
p_attribute12=>:$column$.loc_attribute12,
p_attribute13=>:$column$.loc_attribute13,
p_attribute14=>:$column$.loc_attribute14,
p_attribute15=>:$column$.loc_attribute15,
p_attribute16=>:$column$.loc_attribute16,
p_attribute17=>:$column$.loc_attribute17,
p_attribute18=>:$column$.loc_attribute18,
p_attribute19=>:$column$.loc_attribute19,
p_attribute20=>:$column$.loc_attribute20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='HR_LOCATIONS' and
fdfcuv.application_column_name='ATTRIBUTE5'50LOC_ATTRIBUTE6LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>800,
p_descriptive_flexfield_name=>'HR_LOCATIONS',
p_context_name=>:$column$.loc_attribute_category,
p_column_name=>'ATTRIBUTE6',
p_attribute1=>:$column$.loc_attribute1,
p_attribute2=>:$column$.loc_attribute2,
p_attribute3=>:$column$.loc_attribute3,
p_attribute4=>:$column$.loc_attribute4,
p_attribute5=>:$column$.loc_attribute5,
p_attribute6=>:$column$.loc_attribute6,
p_attribute7=>:$column$.loc_attribute7,
p_attribute8=>:$column$.loc_attribute8,
p_attribute9=>:$column$.loc_attribute9,
p_attribute10=>:$column$.loc_attribute10,
p_attribute11=>:$column$.loc_attribute11,
p_attribute12=>:$column$.loc_attribute12,
p_attribute13=>:$column$.loc_attribute13,
p_attribute14=>:$column$.loc_attribute14,
p_attribute15=>:$column$.loc_attribute15,
p_attribute16=>:$column$.loc_attribute16,
p_attribute17=>:$column$.loc_attribute17,
p_attribute18=>:$column$.loc_attribute18,
p_attribute19=>:$column$.loc_attribute19,
p_attribute20=>:$column$.loc_attribute20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='HR_LOCATIONS' and
fdfcuv.application_column_name='ATTRIBUTE6'51LOC_ATTRIBUTE7LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>800,
p_descriptive_flexfield_name=>'HR_LOCATIONS',
p_context_name=>:$column$.loc_attribute_category,
p_column_name=>'ATTRIBUTE7',
p_attribute1=>:$column$.loc_attribute1,
p_attribute2=>:$column$.loc_attribute2,
p_attribute3=>:$column$.loc_attribute3,
p_attribute4=>:$column$.loc_attribute4,
p_attribute5=>:$column$.loc_attribute5,
p_attribute6=>:$column$.loc_attribute6,
p_attribute7=>:$column$.loc_attribute7,
p_attribute8=>:$column$.loc_attribute8,
p_attribute9=>:$column$.loc_attribute9,
p_attribute10=>:$column$.loc_attribute10,
p_attribute11=>:$column$.loc_attribute11,
p_attribute12=>:$column$.loc_attribute12,
p_attribute13=>:$column$.loc_attribute13,
p_attribute14=>:$column$.loc_attribute14,
p_attribute15=>:$column$.loc_attribute15,
p_attribute16=>:$column$.loc_attribute16,
p_attribute17=>:$column$.loc_attribute17,
p_attribute18=>:$column$.loc_attribute18,
p_attribute19=>:$column$.loc_attribute19,
p_attribute20=>:$column$.loc_attribute20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='HR_LOCATIONS' and
fdfcuv.application_column_name='ATTRIBUTE7'52LOC_ATTRIBUTE8LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>800,
p_descriptive_flexfield_name=>'HR_LOCATIONS',
p_context_name=>:$column$.loc_attribute_category,
p_column_name=>'ATTRIBUTE8',
p_attribute1=>:$column$.loc_attribute1,
p_attribute2=>:$column$.loc_attribute2,
p_attribute3=>:$column$.loc_attribute3,
p_attribute4=>:$column$.loc_attribute4,
p_attribute5=>:$column$.loc_attribute5,
p_attribute6=>:$column$.loc_attribute6,
p_attribute7=>:$column$.loc_attribute7,
p_attribute8=>:$column$.loc_attribute8,
p_attribute9=>:$column$.loc_attribute9,
p_attribute10=>:$column$.loc_attribute10,
p_attribute11=>:$column$.loc_attribute11,
p_attribute12=>:$column$.loc_attribute12,
p_attribute13=>:$column$.loc_attribute13,
p_attribute14=>:$column$.loc_attribute14,
p_attribute15=>:$column$.loc_attribute15,
p_attribute16=>:$column$.loc_attribute16,
p_attribute17=>:$column$.loc_attribute17,
p_attribute18=>:$column$.loc_attribute18,
p_attribute19=>:$column$.loc_attribute19,
p_attribute20=>:$column$.loc_attribute20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='HR_LOCATIONS' and
fdfcuv.application_column_name='ATTRIBUTE8'53LOC_ATTRIBUTE9LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>800,
p_descriptive_flexfield_name=>'HR_LOCATIONS',
p_context_name=>:$column$.loc_attribute_category,
p_column_name=>'ATTRIBUTE9',
p_attribute1=>:$column$.loc_attribute1,
p_attribute2=>:$column$.loc_attribute2,
p_attribute3=>:$column$.loc_attribute3,
p_attribute4=>:$column$.loc_attribute4,
p_attribute5=>:$column$.loc_attribute5,
p_attribute6=>:$column$.loc_attribute6,
p_attribute7=>:$column$.loc_attribute7,
p_attribute8=>:$column$.loc_attribute8,
p_attribute9=>:$column$.loc_attribute9,
p_attribute10=>:$column$.loc_attribute10,
p_attribute11=>:$column$.loc_attribute11,
p_attribute12=>:$column$.loc_attribute12,
p_attribute13=>:$column$.loc_attribute13,
p_attribute14=>:$column$.loc_attribute14,
p_attribute15=>:$column$.loc_attribute15,
p_attribute16=>:$column$.loc_attribute16,
p_attribute17=>:$column$.loc_attribute17,
p_attribute18=>:$column$.loc_attribute18,
p_attribute19=>:$column$.loc_attribute19,
p_attribute20=>:$column$.loc_attribute20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='HR_LOCATIONS' and
fdfcuv.application_column_name='ATTRIBUTE9'54LOC_ATTRIBUTE10LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>800,
p_descriptive_flexfield_name=>'HR_LOCATIONS',
p_context_name=>:$column$.loc_attribute_category,
p_column_name=>'ATTRIBUTE10',
p_attribute1=>:$column$.loc_attribute1,
p_attribute2=>:$column$.loc_attribute2,
p_attribute3=>:$column$.loc_attribute3,
p_attribute4=>:$column$.loc_attribute4,
p_attribute5=>:$column$.loc_attribute5,
p_attribute6=>:$column$.loc_attribute6,
p_attribute7=>:$column$.loc_attribute7,
p_attribute8=>:$column$.loc_attribute8,
p_attribute9=>:$column$.loc_attribute9,
p_attribute10=>:$column$.loc_attribute10,
p_attribute11=>:$column$.loc_attribute11,
p_attribute12=>:$column$.loc_attribute12,
p_attribute13=>:$column$.loc_attribute13,
p_attribute14=>:$column$.loc_attribute14,
p_attribute15=>:$column$.loc_attribute15,
p_attribute16=>:$column$.loc_attribute16,
p_attribute17=>:$column$.loc_attribute17,
p_attribute18=>:$column$.loc_attribute18,
p_attribute19=>:$column$.loc_attribute19,
p_attribute20=>:$column$.loc_attribute20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='HR_LOCATIONS' and
fdfcuv.application_column_name='ATTRIBUTE10'55LOC_ATTRIBUTE11LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>800,
p_descriptive_flexfield_name=>'HR_LOCATIONS',
p_context_name=>:$column$.loc_attribute_category,
p_column_name=>'ATTRIBUTE11',
p_attribute1=>:$column$.loc_attribute1,
p_attribute2=>:$column$.loc_attribute2,
p_attribute3=>:$column$.loc_attribute3,
p_attribute4=>:$column$.loc_attribute4,
p_attribute5=>:$column$.loc_attribute5,
p_attribute6=>:$column$.loc_attribute6,
p_attribute7=>:$column$.loc_attribute7,
p_attribute8=>:$column$.loc_attribute8,
p_attribute9=>:$column$.loc_attribute9,
p_attribute10=>:$column$.loc_attribute10,
p_attribute11=>:$column$.loc_attribute11,
p_attribute12=>:$column$.loc_attribute12,
p_attribute13=>:$column$.loc_attribute13,
p_attribute14=>:$column$.loc_attribute14,
p_attribute15=>:$column$.loc_attribute15,
p_attribute16=>:$column$.loc_attribute16,
p_attribute17=>:$column$.loc_attribute17,
p_attribute18=>:$column$.loc_attribute18,
p_attribute19=>:$column$.loc_attribute19,
p_attribute20=>:$column$.loc_attribute20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='HR_LOCATIONS' and
fdfcuv.application_column_name='ATTRIBUTE11'56LOC_ATTRIBUTE12LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>800,
p_descriptive_flexfield_name=>'HR_LOCATIONS',
p_context_name=>:$column$.loc_attribute_category,
p_column_name=>'ATTRIBUTE12',
p_attribute1=>:$column$.loc_attribute1,
p_attribute2=>:$column$.loc_attribute2,
p_attribute3=>:$column$.loc_attribute3,
p_attribute4=>:$column$.loc_attribute4,
p_attribute5=>:$column$.loc_attribute5,
p_attribute6=>:$column$.loc_attribute6,
p_attribute7=>:$column$.loc_attribute7,
p_attribute8=>:$column$.loc_attribute8,
p_attribute9=>:$column$.loc_attribute9,
p_attribute10=>:$column$.loc_attribute10,
p_attribute11=>:$column$.loc_attribute11,
p_attribute12=>:$column$.loc_attribute12,
p_attribute13=>:$column$.loc_attribute13,
p_attribute14=>:$column$.loc_attribute14,
p_attribute15=>:$column$.loc_attribute15,
p_attribute16=>:$column$.loc_attribute16,
p_attribute17=>:$column$.loc_attribute17,
p_attribute18=>:$column$.loc_attribute18,
p_attribute19=>:$column$.loc_attribute19,
p_attribute20=>:$column$.loc_attribute20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='HR_LOCATIONS' and
fdfcuv.application_column_name='ATTRIBUTE12'57LOC_ATTRIBUTE13LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>800,
p_descriptive_flexfield_name=>'HR_LOCATIONS',
p_context_name=>:$column$.loc_attribute_category,
p_column_name=>'ATTRIBUTE13',
p_attribute1=>:$column$.loc_attribute1,
p_attribute2=>:$column$.loc_attribute2,
p_attribute3=>:$column$.loc_attribute3,
p_attribute4=>:$column$.loc_attribute4,
p_attribute5=>:$column$.loc_attribute5,
p_attribute6=>:$column$.loc_attribute6,
p_attribute7=>:$column$.loc_attribute7,
p_attribute8=>:$column$.loc_attribute8,
p_attribute9=>:$column$.loc_attribute9,
p_attribute10=>:$column$.loc_attribute10,
p_attribute11=>:$column$.loc_attribute11,
p_attribute12=>:$column$.loc_attribute12,
p_attribute13=>:$column$.loc_attribute13,
p_attribute14=>:$column$.loc_attribute14,
p_attribute15=>:$column$.loc_attribute15,
p_attribute16=>:$column$.loc_attribute16,
p_attribute17=>:$column$.loc_attribute17,
p_attribute18=>:$column$.loc_attribute18,
p_attribute19=>:$column$.loc_attribute19,
p_attribute20=>:$column$.loc_attribute20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='HR_LOCATIONS' and
fdfcuv.application_column_name='ATTRIBUTE13'58LOC_ATTRIBUTE14LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>800,
p_descriptive_flexfield_name=>'HR_LOCATIONS',
p_context_name=>:$column$.loc_attribute_category,
p_column_name=>'ATTRIBUTE14',
p_attribute1=>:$column$.loc_attribute1,
p_attribute2=>:$column$.loc_attribute2,
p_attribute3=>:$column$.loc_attribute3,
p_attribute4=>:$column$.loc_attribute4,
p_attribute5=>:$column$.loc_attribute5,
p_attribute6=>:$column$.loc_attribute6,
p_attribute7=>:$column$.loc_attribute7,
p_attribute8=>:$column$.loc_attribute8,
p_attribute9=>:$column$.loc_attribute9,
p_attribute10=>:$column$.loc_attribute10,
p_attribute11=>:$column$.loc_attribute11,
p_attribute12=>:$column$.loc_attribute12,
p_attribute13=>:$column$.loc_attribute13,
p_attribute14=>:$column$.loc_attribute14,
p_attribute15=>:$column$.loc_attribute15,
p_attribute16=>:$column$.loc_attribute16,
p_attribute17=>:$column$.loc_attribute17,
p_attribute18=>:$column$.loc_attribute18,
p_attribute19=>:$column$.loc_attribute19,
p_attribute20=>:$column$.loc_attribute20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='HR_LOCATIONS' and
fdfcuv.application_column_name='ATTRIBUTE14'59LOC_ATTRIBUTE15LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>800,
p_descriptive_flexfield_name=>'HR_LOCATIONS',
p_context_name=>:$column$.loc_attribute_category,
p_column_name=>'ATTRIBUTE15',
p_attribute1=>:$column$.loc_attribute1,
p_attribute2=>:$column$.loc_attribute2,
p_attribute3=>:$column$.loc_attribute3,
p_attribute4=>:$column$.loc_attribute4,
p_attribute5=>:$column$.loc_attribute5,
p_attribute6=>:$column$.loc_attribute6,
p_attribute7=>:$column$.loc_attribute7,
p_attribute8=>:$column$.loc_attribute8,
p_attribute9=>:$column$.loc_attribute9,
p_attribute10=>:$column$.loc_attribute10,
p_attribute11=>:$column$.loc_attribute11,
p_attribute12=>:$column$.loc_attribute12,
p_attribute13=>:$column$.loc_attribute13,
p_attribute14=>:$column$.loc_attribute14,
p_attribute15=>:$column$.loc_attribute15,
p_attribute16=>:$column$.loc_attribute16,
p_attribute17=>:$column$.loc_attribute17,
p_attribute18=>:$column$.loc_attribute18,
p_attribute19=>:$column$.loc_attribute19,
p_attribute20=>:$column$.loc_attribute20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='HR_LOCATIONS' and
fdfcuv.application_column_name='ATTRIBUTE15'60LOC_ATTRIBUTE16LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>800,
p_descriptive_flexfield_name=>'HR_LOCATIONS',
p_context_name=>:$column$.loc_attribute_category,
p_column_name=>'ATTRIBUTE16',
p_attribute1=>:$column$.loc_attribute1,
p_attribute2=>:$column$.loc_attribute2,
p_attribute3=>:$column$.loc_attribute3,
p_attribute4=>:$column$.loc_attribute4,
p_attribute5=>:$column$.loc_attribute5,
p_attribute6=>:$column$.loc_attribute6,
p_attribute7=>:$column$.loc_attribute7,
p_attribute8=>:$column$.loc_attribute8,
p_attribute9=>:$column$.loc_attribute9,
p_attribute10=>:$column$.loc_attribute10,
p_attribute11=>:$column$.loc_attribute11,
p_attribute12=>:$column$.loc_attribute12,
p_attribute13=>:$column$.loc_attribute13,
p_attribute14=>:$column$.loc_attribute14,
p_attribute15=>:$column$.loc_attribute15,
p_attribute16=>:$column$.loc_attribute16,
p_attribute17=>:$column$.loc_attribute17,
p_attribute18=>:$column$.loc_attribute18,
p_attribute19=>:$column$.loc_attribute19,
p_attribute20=>:$column$.loc_attribute20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='HR_LOCATIONS' and
fdfcuv.application_column_name='ATTRIBUTE16'61LOC_ATTRIBUTE17LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>800,
p_descriptive_flexfield_name=>'HR_LOCATIONS',
p_context_name=>:$column$.loc_attribute_category,
p_column_name=>'ATTRIBUTE17',
p_attribute1=>:$column$.loc_attribute1,
p_attribute2=>:$column$.loc_attribute2,
p_attribute3=>:$column$.loc_attribute3,
p_attribute4=>:$column$.loc_attribute4,
p_attribute5=>:$column$.loc_attribute5,
p_attribute6=>:$column$.loc_attribute6,
p_attribute7=>:$column$.loc_attribute7,
p_attribute8=>:$column$.loc_attribute8,
p_attribute9=>:$column$.loc_attribute9,
p_attribute10=>:$column$.loc_attribute10,
p_attribute11=>:$column$.loc_attribute11,
p_attribute12=>:$column$.loc_attribute12,
p_attribute13=>:$column$.loc_attribute13,
p_attribute14=>:$column$.loc_attribute14,
p_attribute15=>:$column$.loc_attribute15,
p_attribute16=>:$column$.loc_attribute16,
p_attribute17=>:$column$.loc_attribute17,
p_attribute18=>:$column$.loc_attribute18,
p_attribute19=>:$column$.loc_attribute19,
p_attribute20=>:$column$.loc_attribute20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='HR_LOCATIONS' and
fdfcuv.application_column_name='ATTRIBUTE17'62LOC_ATTRIBUTE18LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>800,
p_descriptive_flexfield_name=>'HR_LOCATIONS',
p_context_name=>:$column$.loc_attribute_category,
p_column_name=>'ATTRIBUTE18',
p_attribute1=>:$column$.loc_attribute1,
p_attribute2=>:$column$.loc_attribute2,
p_attribute3=>:$column$.loc_attribute3,
p_attribute4=>:$column$.loc_attribute4,
p_attribute5=>:$column$.loc_attribute5,
p_attribute6=>:$column$.loc_attribute6,
p_attribute7=>:$column$.loc_attribute7,
p_attribute8=>:$column$.loc_attribute8,
p_attribute9=>:$column$.loc_attribute9,
p_attribute10=>:$column$.loc_attribute10,
p_attribute11=>:$column$.loc_attribute11,
p_attribute12=>:$column$.loc_attribute12,
p_attribute13=>:$column$.loc_attribute13,
p_attribute14=>:$column$.loc_attribute14,
p_attribute15=>:$column$.loc_attribute15,
p_attribute16=>:$column$.loc_attribute16,
p_attribute17=>:$column$.loc_attribute17,
p_attribute18=>:$column$.loc_attribute18,
p_attribute19=>:$column$.loc_attribute19,
p_attribute20=>:$column$.loc_attribute20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='HR_LOCATIONS' and
fdfcuv.application_column_name='ATTRIBUTE18'63LOC_ATTRIBUTE19LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>800,
p_descriptive_flexfield_name=>'HR_LOCATIONS',
p_context_name=>:$column$.loc_attribute_category,
p_column_name=>'ATTRIBUTE19',
p_attribute1=>:$column$.loc_attribute1,
p_attribute2=>:$column$.loc_attribute2,
p_attribute3=>:$column$.loc_attribute3,
p_attribute4=>:$column$.loc_attribute4,
p_attribute5=>:$column$.loc_attribute5,
p_attribute6=>:$column$.loc_attribute6,
p_attribute7=>:$column$.loc_attribute7,
p_attribute8=>:$column$.loc_attribute8,
p_attribute9=>:$column$.loc_attribute9,
p_attribute10=>:$column$.loc_attribute10,
p_attribute11=>:$column$.loc_attribute11,
p_attribute12=>:$column$.loc_attribute12,
p_attribute13=>:$column$.loc_attribute13,
p_attribute14=>:$column$.loc_attribute14,
p_attribute15=>:$column$.loc_attribute15,
p_attribute16=>:$column$.loc_attribute16,
p_attribute17=>:$column$.loc_attribute17,
p_attribute18=>:$column$.loc_attribute18,
p_attribute19=>:$column$.loc_attribute19,
p_attribute20=>:$column$.loc_attribute20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='HR_LOCATIONS' and
fdfcuv.application_column_name='ATTRIBUTE19'64LOC_ATTRIBUTE20LOV customvarchar2Yselect
substrb(lov.column_value,1,instrb(lov.column_value,'~',1,1)-1) value,
substrb(lov.column_value,instrb(lov.column_value,'~',1,1)+1,lengthb(lov.column_value)) description
from
table(
xxen_util.dff_attribute_lov(
p_application_id=>800,
p_descriptive_flexfield_name=>'HR_LOCATIONS',
p_context_name=>:$column$.loc_attribute_category,
p_column_name=>'ATTRIBUTE20',
p_attribute1=>:$column$.loc_attribute1,
p_attribute2=>:$column$.loc_attribute2,
p_attribute3=>:$column$.loc_attribute3,
p_attribute4=>:$column$.loc_attribute4,
p_attribute5=>:$column$.loc_attribute5,
p_attribute6=>:$column$.loc_attribute6,
p_attribute7=>:$column$.loc_attribute7,
p_attribute8=>:$column$.loc_attribute8,
p_attribute9=>:$column$.loc_attribute9,
p_attribute10=>:$column$.loc_attribute10,
p_attribute11=>:$column$.loc_attribute11,
p_attribute12=>:$column$.loc_attribute12,
p_attribute13=>:$column$.loc_attribute13,
p_attribute14=>:$column$.loc_attribute14,
p_attribute15=>:$column$.loc_attribute15,
p_attribute16=>:$column$.loc_attribute16,
p_attribute17=>:$column$.loc_attribute17,
p_attribute18=>:$column$.loc_attribute18,
p_attribute19=>:$column$.loc_attribute19,
p_attribute20=>:$column$.loc_attribute20)
) lov
order by
valueselect distinct
'(Context) ' || initcap(fdfcuv.application_column_name) || ': ' ||
listagg(decode(fdfc.descriptive_flex_context_code,'Global Data Elements','(Global)','(' || fdfc.descriptive_flex_context_code || ')') || ' ' || fdfcuv.form_left_prompt,', ') within group (order by decode(fdfc.descriptive_flex_context_code,'Global Data Elements',1,2),fdfc.descriptive_flex_context_code) over (partition by fdfcuv.application_column_name)
from
fnd_descriptive_flexs_vl fdfv,
fnd_descr_flex_contexts fdfc,
fnd_descr_flex_col_usage_vl fdfcuv
where
fdfc.application_id=fdfv.application_id and
fdfc.descriptive_flexfield_name=fdfv.descriptive_flexfield_name and
fdfc.enabled_flag='Y' and
fdfcuv.application_id=fdfc.application_id and
fdfcuv.descriptive_flexfield_name=fdfc.descriptive_flexfield_name and
fdfcuv.descriptive_flex_context_code=fdfc.descriptive_flex_context_code and
fdfcuv.enabled_flag='Y' and
fdfv.application_id=800 and
fdfv.descriptive_flexfield_name='HR_LOCATIONS' and
fdfcuv.application_column_name='ATTRIBUTE20'65UPLOAD_ROWCharvarchar2YU1action_inCharACTION_CODE_U2p_location_idinNumberYLOCATION_IDU3p_location_codeinCharLOCATION_CODEU4p_descriptioninCharYDESCRIPTIONU5p_inactive_dateinDateYINACTIVE_DATEU6p_delete_locationinCharYDELETE_LOCATIONU7p_business_group_idinNumberYBUSINESS_GROUPU8p_address_styleinCharYADDRESS_STYLEU9p_address_line_1inCharYADDRESS_LINE_1U10p_address_line_2inCharYADDRESS_LINE_2U11p_address_line_3inCharYADDRESS_LINE_3U12p_town_or_cityinCharYTOWN_OR_CITYU13p_region_1inCharYREGION_1U14p_region_2inCharYREGION_2U15p_region_3inCharYREGION_3U16p_postal_codeinCharYPOSTAL_CODEU17p_countryinCharYCOUNTRYU18p_telephone_number_1inCharYTELEPHONE_NUMBER_1U19p_telephone_number_2inCharYTELEPHONE_NUMBER_2U20p_telephone_number_3inCharYTELEPHONE_NUMBER_3U21p_loc_information13inCharYLOC_INFORMATION13U22p_loc_information14inCharYLOC_INFORMATION14U23p_loc_information15inCharYLOC_INFORMATION15U24p_loc_information16inCharYLOC_INFORMATION16U25p_loc_information17inCharYLOC_INFORMATION17U26p_loc_information18inCharYLOC_INFORMATION18U27p_loc_information19inCharYLOC_INFORMATION19U28p_loc_information20inCharYLOC_INFORMATION20U29p_ship_to_location_idinNumberYSHIP_TO_LOCATIONU30p_ship_to_site_flaginCharYSHIP_TO_SITE_FLAGU31p_receiving_site_flaginCharYRECEIVING_SITE_FLAGU32p_bill_to_site_flaginCharYBILL_TO_SITE_FLAGU33p_office_site_flaginCharYOFFICE_SITE_FLAGU34p_in_organization_flaginCharYIN_ORGANIZATION_FLAGU35p_inventory_organization_idinNumberYINVENTORY_ORGANIZATIONU36p_designated_receiver_idinNumberYU37p_timezone_codeinCharYTIMEZONE_CODEU38p_ece_tp_location_codeinCharYECE_TP_LOCATION_CODEU39p_loc_attribute_categoryinCharYLOC_ATTRIBUTE_CATEGORYU40p_loc_attribute1inCharYLOC_ATTRIBUTE1U41p_loc_attribute2inCharYLOC_ATTRIBUTE2U42p_loc_attribute3inCharYLOC_ATTRIBUTE3U43p_loc_attribute4inCharYLOC_ATTRIBUTE4U44p_loc_attribute5inCharYLOC_ATTRIBUTE5U45p_loc_attribute6inCharYLOC_ATTRIBUTE6U46p_loc_attribute7inCharYLOC_ATTRIBUTE7U47p_loc_attribute8inCharYLOC_ATTRIBUTE8U48p_loc_attribute9inCharYLOC_ATTRIBUTE9U49p_loc_attribute10inCharYLOC_ATTRIBUTE10U50p_loc_attribute11inCharYLOC_ATTRIBUTE11U51p_loc_attribute12inCharYLOC_ATTRIBUTE12U52p_loc_attribute13inCharYLOC_ATTRIBUTE13U53p_loc_attribute14inCharYLOC_ATTRIBUTE14U54p_loc_attribute15inCharYLOC_ATTRIBUTE15U55p_loc_attribute16inCharYLOC_ATTRIBUTE16U56p_loc_attribute17inCharYLOC_ATTRIBUTE17U57p_loc_attribute18inCharYLOC_ATTRIBUTE18U58p_loc_attribute19inCharYLOC_ATTRIBUTE19U59p_loc_attribute20inCharYLOC_ATTRIBUTE20U60status_outCharSTATUS_CODE_U61message_outCharMESSAGE_Error SQLOrder Byupload_row, location_codeSuccess SQLselect
xu.action_,
xu.status_,
xu.message_,
xu.request_id_,
xu.modified_columns_,
hla.location_id,
nvl(hla.location_code,xu.location_code) location_code,
nvl(hlat.description,xu.description) description,
hla.inactive_date,
xu.delete_location,
pbg.name business_group,
xxen_util.meaning(case when hla.legal_address_flag='Y' then 'Y' end,'YES_NO',0) legal_address_flag,
xxen_util.display_flexfield_context(800,'Address Location',hla.style) address_style,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'ADDRESS_LINE_1',hla.rowid,hla.address_line_1) address_line_1,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'ADDRESS_LINE_2',hla.rowid,hla.address_line_2) address_line_2,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'ADDRESS_LINE_3',hla.rowid,hla.address_line_3) address_line_3,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'TOWN_OR_CITY',hla.rowid,hla.town_or_city) town_or_city,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'REGION_1',hla.rowid,hla.region_1) region_1,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'REGION_2',hla.rowid,hla.region_2) region_2,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'REGION_3',hla.rowid,hla.region_3) region_3,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'POSTAL_CODE',hla.rowid,hla.postal_code) postal_code,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'COUNTRY',hla.rowid,hla.country) country,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'TELEPHONE_NUMBER_1',hla.rowid,hla.telephone_number_1) telephone_number_1,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'TELEPHONE_NUMBER_2',hla.rowid,hla.telephone_number_2) telephone_number_2,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'TELEPHONE_NUMBER_3',hla.rowid,hla.telephone_number_3) telephone_number_3,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'LOC_INFORMATION13',hla.rowid,hla.loc_information13) loc_information13,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'LOC_INFORMATION14',hla.rowid,hla.loc_information14) loc_information14,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'LOC_INFORMATION15',hla.rowid,hla.loc_information15) loc_information15,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'LOC_INFORMATION16',hla.rowid,hla.loc_information16) loc_information16,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'LOC_INFORMATION17',hla.rowid,hla.loc_information17) loc_information17,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'LOC_INFORMATION18',hla.rowid,hla.loc_information18) loc_information18,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'LOC_INFORMATION19',hla.rowid,hla.loc_information19) loc_information19,
xxen_util.display_flexfield_value(800,'Address Location',hla.style,'LOC_INFORMATION20',hla.rowid,hla.loc_information20) loc_information20,
hla2.location_code ship_to_location,
xxen_util.meaning(case when hla.ship_to_site_flag='Y' then 'Y' end,'YES_NO',0) ship_to_site_flag,
xxen_util.meaning(case when hla.receiving_site_flag='Y' then 'Y' end,'YES_NO',0) receiving_site_flag,
xxen_util.meaning(case when hla.bill_to_site_flag='Y' then 'Y' end,'YES_NO',0) bill_to_site_flag,
xxen_util.meaning(case when hla.office_site_flag='Y' then 'Y' end,'YES_NO',0) office_site_flag,
xxen_util.meaning(case when hla.in_organization_flag='Y' then 'Y' end,'YES_NO',0) in_organization_flag,
mp.organization_code inventory_organization,
ppf.full_name contact,
(select ftv.name from fnd_timezones_vl ftv where ftv.timezone_code=hla.timezone_code) timezone_code,
hla.ece_tp_location_code,
xxen_util.display_flexfield_context(800,'HR_LOCATIONS',hla.attribute_category) loc_attribute_category,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE1',hla.rowid,hla.attribute1) loc_attribute1,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE2',hla.rowid,hla.attribute2) loc_attribute2,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE3',hla.rowid,hla.attribute3) loc_attribute3,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE4',hla.rowid,hla.attribute4) loc_attribute4,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE5',hla.rowid,hla.attribute5) loc_attribute5,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE6',hla.rowid,hla.attribute6) loc_attribute6,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE7',hla.rowid,hla.attribute7) loc_attribute7,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE8',hla.rowid,hla.attribute8) loc_attribute8,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE9',hla.rowid,hla.attribute9) loc_attribute9,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE10',hla.rowid,hla.attribute10) loc_attribute10,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE11',hla.rowid,hla.attribute11) loc_attribute11,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE12',hla.rowid,hla.attribute12) loc_attribute12,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE13',hla.rowid,hla.attribute13) loc_attribute13,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE14',hla.rowid,hla.attribute14) loc_attribute14,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE15',hla.rowid,hla.attribute15) loc_attribute15,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE16',hla.rowid,hla.attribute16) loc_attribute16,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE17',hla.rowid,hla.attribute17) loc_attribute17,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE18',hla.rowid,hla.attribute18) loc_attribute18,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE19',hla.rowid,hla.attribute19) loc_attribute19,
xxen_util.display_flexfield_value(800,'HR_LOCATIONS',hla.attribute_category,'ATTRIBUTE20',hla.rowid,hla.attribute20) loc_attribute20,
xu.upload_row
from
xxen_per_location_uploa_9062_u xu,
hr_locations_all hla,
hr_locations_all_tl hlat,
hr_locations_all hla2,
mtl_parameters mp,
per_all_people_f ppf,
per_business_groups pbg
where
xu.status_code_=xxen_upload.status_success and
xu.location_code=hla.location_code(+) and
hla.location_id=hlat.location_id(+) and
hlat.language(+)=userenv('lang') and
hla.ship_to_location_id=hla2.location_id(+) and
hla.inventory_organization_id=mp.organization_id(+) and
hla.designated_receiver_id=ppf.person_id(+) and
hla.business_group_id=pbg.business_group_id(+)LOV query:$column$.address_line_1ADDRESS_LINE_1ADDRESS_LINE_1LOV query:$column$.address_line_2ADDRESS_LINE_2ADDRESS_LINE_1LOV query:$column$.address_line_3ADDRESS_LINE_3ADDRESS_LINE_1LOV query:$column$.address_styleADDRESS_STYLEADDRESS_LINE_1LOV query:$column$.countryCOUNTRYADDRESS_LINE_1LOV query:$column$.loc_information13LOC_INFORMATION13ADDRESS_LINE_1LOV query:$column$.loc_information14LOC_INFORMATION14ADDRESS_LINE_1LOV query:$column$.loc_information15LOC_INFORMATION15ADDRESS_LINE_1LOV query:$column$.loc_information16LOC_INFORMATION16ADDRESS_LINE_1LOV query:$column$.loc_information17LOC_INFORMATION17ADDRESS_LINE_1LOV query:$column$.loc_information18LOC_INFORMATION18ADDRESS_LINE_1LOV query:$column$.loc_information19LOC_INFORMATION19ADDRESS_LINE_1LOV query:$column$.loc_information20LOC_INFORMATION20ADDRESS_LINE_1LOV query:$column$.postal_codePOSTAL_CODEADDRESS_LINE_1LOV query:$column$.region_1REGION_1ADDRESS_LINE_1LOV query:$column$.region_2REGION_2ADDRESS_LINE_1LOV query:$column$.region_3REGION_3ADDRESS_LINE_1LOV query:$column$.telephone_number_1TELEPHONE_NUMBER_1ADDRESS_LINE_1LOV query:$column$.telephone_number_2TELEPHONE_NUMBER_2ADDRESS_LINE_1LOV query:$column$.telephone_number_3TELEPHONE_NUMBER_3ADDRESS_LINE_1LOV query:$column$.town_or_cityTOWN_OR_CITYADDRESS_LINE_1LOV query:$column$.address_line_1ADDRESS_LINE_1ADDRESS_LINE_2LOV query:$column$.address_line_2ADDRESS_LINE_2ADDRESS_LINE_2LOV query:$column$.address_line_3ADDRESS_LINE_3ADDRESS_LINE_2LOV query:$column$.address_styleADDRESS_STYLEADDRESS_LINE_2LOV query:$column$.countryCOUNTRYADDRESS_LINE_2LOV query:$column$.loc_information13LOC_INFORMATION13ADDRESS_LINE_2LOV query:$column$.loc_information14LOC_INFORMATION14ADDRESS_LINE_2LOV query:$column$.loc_information15LOC_INFORMATION15ADDRESS_LINE_2LOV query:$column$.loc_information16LOC_INFORMATION16ADDRESS_LINE_2LOV query:$column$.loc_information17LOC_INFORMATION17ADDRESS_LINE_2LOV query:$column$.loc_information18LOC_INFORMATION18ADDRESS_LINE_2LOV query:$column$.loc_information19LOC_INFORMATION19ADDRESS_LINE_2LOV query:$column$.loc_information20LOC_INFORMATION20ADDRESS_LINE_2LOV query:$column$.postal_codePOSTAL_CODEADDRESS_LINE_2LOV query:$column$.region_1REGION_1ADDRESS_LINE_2LOV query:$column$.region_2REGION_2ADDRESS_LINE_2LOV query:$column$.region_3REGION_3ADDRESS_LINE_2LOV query:$column$.telephone_number_1TELEPHONE_NUMBER_1ADDRESS_LINE_2LOV query:$column$.telephone_number_2TELEPHONE_NUMBER_2ADDRESS_LINE_2LOV query:$column$.telephone_number_3TELEPHONE_NUMBER_3ADDRESS_LINE_2LOV query:$column$.town_or_cityTOWN_OR_CITYADDRESS_LINE_2LOV query:$column$.address_line_1ADDRESS_LINE_1ADDRESS_LINE_3LOV query:$column$.address_line_2ADDRESS_LINE_2ADDRESS_LINE_3LOV query:$column$.address_line_3ADDRESS_LINE_3ADDRESS_LINE_3LOV query:$column$.address_styleADDRESS_STYLEADDRESS_LINE_3LOV query:$column$.countryCOUNTRYADDRESS_LINE_3LOV query:$column$.loc_information13LOC_INFORMATION13ADDRESS_LINE_3LOV query:$column$.loc_information14LOC_INFORMATION14ADDRESS_LINE_3LOV query:$column$.loc_information15LOC_INFORMATION15ADDRESS_LINE_3LOV query:$column$.loc_information16LOC_INFORMATION16ADDRESS_LINE_3LOV query:$column$.loc_information17LOC_INFORMATION17ADDRESS_LINE_3LOV query:$column$.loc_information18LOC_INFORMATION18ADDRESS_LINE_3LOV query:$column$.loc_information19LOC_INFORMATION19ADDRESS_LINE_3LOV query:$column$.loc_information20LOC_INFORMATION20ADDRESS_LINE_3LOV query:$column$.postal_codePOSTAL_CODEADDRESS_LINE_3LOV query:$column$.region_1REGION_1ADDRESS_LINE_3LOV query:$column$.region_2REGION_2ADDRESS_LINE_3LOV query:$column$.region_3REGION_3ADDRESS_LINE_3LOV query:$column$.telephone_number_1TELEPHONE_NUMBER_1ADDRESS_LINE_3LOV query:$column$.telephone_number_2TELEPHONE_NUMBER_2ADDRESS_LINE_3LOV query:$column$.telephone_number_3TELEPHONE_NUMBER_3ADDRESS_LINE_3LOV query:$column$.town_or_cityTOWN_OR_CITYADDRESS_LINE_3Default value:$flex$.Default_Address_StyleDefault Address Style|1=1|ADDRESS_STYLELOV query:$column$.business_groupBUSINESS_GROUPCONTACTLOV query:$column$.address_line_1ADDRESS_LINE_1COUNTRYLOV query:$column$.address_line_2ADDRESS_LINE_2COUNTRYLOV query:$column$.address_line_3ADDRESS_LINE_3COUNTRYLOV query:$column$.address_styleADDRESS_STYLECOUNTRYLOV query:$column$.countryCOUNTRYCOUNTRYLOV query:$column$.loc_information13LOC_INFORMATION13COUNTRYLOV query:$column$.loc_information14LOC_INFORMATION14COUNTRYLOV query:$column$.loc_information15LOC_INFORMATION15COUNTRYLOV query:$column$.loc_information16LOC_INFORMATION16COUNTRYLOV query:$column$.loc_information17LOC_INFORMATION17COUNTRYLOV query:$column$.loc_information18LOC_INFORMATION18COUNTRYLOV query:$column$.loc_information19LOC_INFORMATION19COUNTRYLOV query:$column$.loc_information20LOC_INFORMATION20COUNTRYLOV query:$column$.postal_codePOSTAL_CODECOUNTRYLOV query:$column$.region_1REGION_1COUNTRYLOV query:$column$.region_2REGION_2COUNTRYLOV query:$column$.region_3REGION_3COUNTRYLOV query:$column$.telephone_number_1TELEPHONE_NUMBER_1COUNTRYLOV query:$column$.telephone_number_2TELEPHONE_NUMBER_2COUNTRYLOV query:$column$.telephone_number_3TELEPHONE_NUMBER_3COUNTRYLOV query:$column$.town_or_cityTOWN_OR_CITYCOUNTRYLOV query:$column$.loc_attribute1LOC_ATTRIBUTE1LOC_ATTRIBUTE1LOV query:$column$.loc_attribute10LOC_ATTRIBUTE10LOC_ATTRIBUTE1LOV query:$column$.loc_attribute11LOC_ATTRIBUTE11LOC_ATTRIBUTE1LOV query:$column$.loc_attribute12LOC_ATTRIBUTE12LOC_ATTRIBUTE1LOV query:$column$.loc_attribute13LOC_ATTRIBUTE13LOC_ATTRIBUTE1LOV query:$column$.loc_attribute14LOC_ATTRIBUTE14LOC_ATTRIBUTE1LOV query:$column$.loc_attribute15LOC_ATTRIBUTE15LOC_ATTRIBUTE1LOV query:$column$.loc_attribute16LOC_ATTRIBUTE16LOC_ATTRIBUTE1LOV query:$column$.loc_attribute17LOC_ATTRIBUTE17LOC_ATTRIBUTE1LOV query:$column$.loc_attribute18LOC_ATTRIBUTE18LOC_ATTRIBUTE1LOV query:$column$.loc_attribute19LOC_ATTRIBUTE19LOC_ATTRIBUTE1LOV query:$column$.loc_attribute2LOC_ATTRIBUTE2LOC_ATTRIBUTE1LOV query:$column$.loc_attribute20LOC_ATTRIBUTE20LOC_ATTRIBUTE1LOV query:$column$.loc_attribute3LOC_ATTRIBUTE3LOC_ATTRIBUTE1LOV query:$column$.loc_attribute4LOC_ATTRIBUTE4LOC_ATTRIBUTE1LOV query:$column$.loc_attribute5LOC_ATTRIBUTE5LOC_ATTRIBUTE1LOV query:$column$.loc_attribute6LOC_ATTRIBUTE6LOC_ATTRIBUTE1LOV query:$column$.loc_attribute7LOC_ATTRIBUTE7LOC_ATTRIBUTE1LOV query:$column$.loc_attribute8LOC_ATTRIBUTE8LOC_ATTRIBUTE1LOV query:$column$.loc_attribute9LOC_ATTRIBUTE9LOC_ATTRIBUTE1LOV query:$column$.loc_attribute_categoryLOC_ATTRIBUTE_CATEGORYLOC_ATTRIBUTE1LOV query:$column$.loc_attribute1LOC_ATTRIBUTE1LOC_ATTRIBUTE10LOV query:$column$.loc_attribute10LOC_ATTRIBUTE10LOC_ATTRIBUTE10LOV query:$column$.loc_attribute11LOC_ATTRIBUTE11LOC_ATTRIBUTE10LOV query:$column$.loc_attribute12LOC_ATTRIBUTE12LOC_ATTRIBUTE10LOV query:$column$.loc_attribute13LOC_ATTRIBUTE13LOC_ATTRIBUTE10LOV query:$column$.loc_attribute14LOC_ATTRIBUTE14LOC_ATTRIBUTE10LOV query:$column$.loc_attribute15LOC_ATTRIBUTE15LOC_ATTRIBUTE10LOV query:$column$.loc_attribute16LOC_ATTRIBUTE16LOC_ATTRIBUTE10LOV query:$column$.loc_attribute17LOC_ATTRIBUTE17LOC_ATTRIBUTE10LOV query:$column$.loc_attribute18LOC_ATTRIBUTE18LOC_ATTRIBUTE10LOV query:$column$.loc_attribute19LOC_ATTRIBUTE19LOC_ATTRIBUTE10LOV query:$column$.loc_attribute2LOC_ATTRIBUTE2LOC_ATTRIBUTE10LOV query:$column$.loc_attribute20LOC_ATTRIBUTE20LOC_ATTRIBUTE10LOV query:$column$.loc_attribute3LOC_ATTRIBUTE3LOC_ATTRIBUTE10LOV query:$column$.loc_attribute4LOC_ATTRIBUTE4LOC_ATTRIBUTE10LOV query:$column$.loc_attribute5LOC_ATTRIBUTE5LOC_ATTRIBUTE10LOV query:$column$.loc_attribute6LOC_ATTRIBUTE6LOC_ATTRIBUTE10LOV query:$column$.loc_attribute7LOC_ATTRIBUTE7LOC_ATTRIBUTE10LOV query:$column$.loc_attribute8LOC_ATTRIBUTE8LOC_ATTRIBUTE10LOV query:$column$.loc_attribute9LOC_ATTRIBUTE9LOC_ATTRIBUTE10LOV query:$column$.loc_attribute_categoryLOC_ATTRIBUTE_CATEGORYLOC_ATTRIBUTE10LOV query:$column$.loc_attribute1LOC_ATTRIBUTE1LOC_ATTRIBUTE11LOV query:$column$.loc_attribute10LOC_ATTRIBUTE10LOC_ATTRIBUTE11LOV query:$column$.loc_attribute11LOC_ATTRIBUTE11LOC_ATTRIBUTE11LOV query:$column$.loc_attribute12LOC_ATTRIBUTE12LOC_ATTRIBUTE11LOV query:$column$.loc_attribute13LOC_ATTRIBUTE13LOC_ATTRIBUTE11LOV query:$column$.loc_attribute14LOC_ATTRIBUTE14LOC_ATTRIBUTE11LOV query:$column$.loc_attribute15LOC_ATTRIBUTE15LOC_ATTRIBUTE11LOV query:$column$.loc_attribute16LOC_ATTRIBUTE16LOC_ATTRIBUTE11LOV query:$column$.loc_attribute17LOC_ATTRIBUTE17LOC_ATTRIBUTE11LOV query:$column$.loc_attribute18LOC_ATTRIBUTE18LOC_ATTRIBUTE11LOV query:$column$.loc_attribute19LOC_ATTRIBUTE19LOC_ATTRIBUTE11LOV query:$column$.loc_attribute2LOC_ATTRIBUTE2LOC_ATTRIBUTE11LOV query:$column$.loc_attribute20LOC_ATTRIBUTE20LOC_ATTRIBUTE11LOV query:$column$.loc_attribute3LOC_ATTRIBUTE3LOC_ATTRIBUTE11LOV query:$column$.loc_attribute4LOC_ATTRIBUTE4LOC_ATTRIBUTE11LOV query:$column$.loc_attribute5LOC_ATTRIBUTE5LOC_ATTRIBUTE11LOV query:$column$.loc_attribute6LOC_ATTRIBUTE6LOC_ATTRIBUTE11LOV query:$column$.loc_attribute7LOC_ATTRIBUTE7LOC_ATTRIBUTE11LOV query:$column$.loc_attribute8LOC_ATTRIBUTE8LOC_ATTRIBUTE11LOV query:$column$.loc_attribute9LOC_ATTRIBUTE9LOC_ATTRIBUTE11LOV query:$column$.loc_attribute_categoryLOC_ATTRIBUTE_CATEGORYLOC_ATTRIBUTE11LOV query:$column$.loc_attribute1LOC_ATTRIBUTE1LOC_ATTRIBUTE12LOV query:$column$.loc_attribute10LOC_ATTRIBUTE10LOC_ATTRIBUTE12LOV query:$column$.loc_attribute11LOC_ATTRIBUTE11LOC_ATTRIBUTE12LOV query:$column$.loc_attribute12LOC_ATTRIBUTE12LOC_ATTRIBUTE12LOV query:$column$.loc_attribute13LOC_ATTRIBUTE13LOC_ATTRIBUTE12LOV query:$column$.loc_attribute14LOC_ATTRIBUTE14LOC_ATTRIBUTE12LOV query:$column$.loc_attribute15LOC_ATTRIBUTE15LOC_ATTRIBUTE12LOV query:$column$.loc_attribute16LOC_ATTRIBUTE16LOC_ATTRIBUTE12LOV query:$column$.loc_attribute17LOC_ATTRIBUTE17LOC_ATTRIBUTE12LOV query:$column$.loc_attribute18LOC_ATTRIBUTE18LOC_ATTRIBUTE12LOV query:$column$.loc_attribute19LOC_ATTRIBUTE19LOC_ATTRIBUTE12LOV query:$column$.loc_attribute2LOC_ATTRIBUTE2LOC_ATTRIBUTE12LOV query:$column$.loc_attribute20LOC_ATTRIBUTE20LOC_ATTRIBUTE12LOV query:$column$.loc_attribute3LOC_ATTRIBUTE3LOC_ATTRIBUTE12LOV query:$column$.loc_attribute4LOC_ATTRIBUTE4LOC_ATTRIBUTE12LOV query:$column$.loc_attribute5LOC_ATTRIBUTE5LOC_ATTRIBUTE12LOV query:$column$.loc_attribute6LOC_ATTRIBUTE6LOC_ATTRIBUTE12LOV query:$column$.loc_attribute7LOC_ATTRIBUTE7LOC_ATTRIBUTE12LOV query:$column$.loc_attribute8LOC_ATTRIBUTE8LOC_ATTRIBUTE12LOV query:$column$.loc_attribute9LOC_ATTRIBUTE9LOC_ATTRIBUTE12LOV query:$column$.loc_attribute_categoryLOC_ATTRIBUTE_CATEGORYLOC_ATTRIBUTE12LOV query:$column$.loc_attribute1LOC_ATTRIBUTE1LOC_ATTRIBUTE13LOV query:$column$.loc_attribute10LOC_ATTRIBUTE10LOC_ATTRIBUTE13LOV query:$column$.loc_attribute11LOC_ATTRIBUTE11LOC_ATTRIBUTE13LOV query:$column$.loc_attribute12LOC_ATTRIBUTE12LOC_ATTRIBUTE13LOV query:$column$.loc_attribute13LOC_ATTRIBUTE13LOC_ATTRIBUTE13LOV query:$column$.loc_attribute14LOC_ATTRIBUTE14LOC_ATTRIBUTE13LOV query:$column$.loc_attribute15LOC_ATTRIBUTE15LOC_ATTRIBUTE13LOV query:$column$.loc_attribute16LOC_ATTRIBUTE16LOC_ATTRIBUTE13LOV query:$column$.loc_attribute17LOC_ATTRIBUTE17LOC_ATTRIBUTE13LOV query:$column$.loc_attribute18LOC_ATTRIBUTE18LOC_ATTRIBUTE13LOV query:$column$.loc_attribute19LOC_ATTRIBUTE19LOC_ATTRIBUTE13LOV query:$column$.loc_attribute2LOC_ATTRIBUTE2LOC_ATTRIBUTE13LOV query:$column$.loc_attribute20LOC_ATTRIBUTE20LOC_ATTRIBUTE13LOV query:$column$.loc_attribute3LOC_ATTRIBUTE3LOC_ATTRIBUTE13LOV query:$column$.loc_attribute4LOC_ATTRIBUTE4LOC_ATTRIBUTE13LOV query:$column$.loc_attribute5LOC_ATTRIBUTE5LOC_ATTRIBUTE13LOV query:$column$.loc_attribute6LOC_ATTRIBUTE6LOC_ATTRIBUTE13LOV query:$column$.loc_attribute7LOC_ATTRIBUTE7LOC_ATTRIBUTE13LOV query:$column$.loc_attribute8LOC_ATTRIBUTE8LOC_ATTRIBUTE13LOV query:$column$.loc_attribute9LOC_ATTRIBUTE9LOC_ATTRIBUTE13LOV query:$column$.loc_attribute_categoryLOC_ATTRIBUTE_CATEGORYLOC_ATTRIBUTE13LOV query:$column$.loc_attribute1LOC_ATTRIBUTE1LOC_ATTRIBUTE14LOV query:$column$.loc_attribute10LOC_ATTRIBUTE10LOC_ATTRIBUTE14LOV query:$column$.loc_attribute11LOC_ATTRIBUTE11LOC_ATTRIBUTE14LOV query:$column$.loc_attribute12LOC_ATTRIBUTE12LOC_ATTRIBUTE14LOV query:$column$.loc_attribute13LOC_ATTRIBUTE13LOC_ATTRIBUTE14LOV query:$column$.loc_attribute14LOC_ATTRIBUTE14LOC_ATTRIBUTE14LOV query:$column$.loc_attribute15LOC_ATTRIBUTE15LOC_ATTRIBUTE14LOV query:$column$.loc_attribute16LOC_ATTRIBUTE16LOC_ATTRIBUTE14LOV query:$column$.loc_attribute17LOC_ATTRIBUTE17LOC_ATTRIBUTE14LOV query:$column$.loc_attribute18LOC_ATTRIBUTE18LOC_ATTRIBUTE14LOV query:$column$.loc_attribute19LOC_ATTRIBUTE19LOC_ATTRIBUTE14LOV query:$column$.loc_attribute2LOC_ATTRIBUTE2LOC_ATTRIBUTE14LOV query:$column$.loc_attribute20LOC_ATTRIBUTE20LOC_ATTRIBUTE14LOV query:$column$.loc_attribute3LOC_ATTRIBUTE3LOC_ATTRIBUTE14LOV query:$column$.loc_attribute4LOC_ATTRIBUTE4LOC_ATTRIBUTE14LOV query:$column$.loc_attribute5LOC_ATTRIBUTE5LOC_ATTRIBUTE14LOV query:$column$.loc_attribute6LOC_ATTRIBUTE6LOC_ATTRIBUTE14LOV query:$column$.loc_attribute7LOC_ATTRIBUTE7LOC_ATTRIBUTE14LOV query:$column$.loc_attribute8LOC_ATTRIBUTE8LOC_ATTRIBUTE14LOV query:$column$.loc_attribute9LOC_ATTRIBUTE9LOC_ATTRIBUTE14LOV query:$column$.loc_attribute_categoryLOC_ATTRIBUTE_CATEGORYLOC_ATTRIBUTE14LOV query:$column$.loc_attribute1LOC_ATTRIBUTE1LOC_ATTRIBUTE15LOV query:$column$.loc_attribute10LOC_ATTRIBUTE10LOC_ATTRIBUTE15LOV query:$column$.loc_attribute11LOC_ATTRIBUTE11LOC_ATTRIBUTE15LOV query:$column$.loc_attribute12LOC_ATTRIBUTE12LOC_ATTRIBUTE15LOV query:$column$.loc_attribute13LOC_ATTRIBUTE13LOC_ATTRIBUTE15LOV query:$column$.loc_attribute14LOC_ATTRIBUTE14LOC_ATTRIBUTE15LOV query:$column$.loc_attribute15LOC_ATTRIBUTE15LOC_ATTRIBUTE15LOV query:$column$.loc_attribute16LOC_ATTRIBUTE16LOC_ATTRIBUTE15LOV query:$column$.loc_attribute17LOC_ATTRIBUTE17LOC_ATTRIBUTE15LOV query:$column$.loc_attribute18LOC_ATTRIBUTE18LOC_ATTRIBUTE15LOV query:$column$.loc_attribute19LOC_ATTRIBUTE19LOC_ATTRIBUTE15LOV query:$column$.loc_attribute2LOC_ATTRIBUTE2LOC_ATTRIBUTE15LOV query:$column$.loc_attribute20LOC_ATTRIBUTE20LOC_ATTRIBUTE15LOV query:$column$.loc_attribute3LOC_ATTRIBUTE3LOC_ATTRIBUTE15LOV query:$column$.loc_attribute4LOC_ATTRIBUTE4LOC_ATTRIBUTE15LOV query:$column$.loc_attribute5LOC_ATTRIBUTE5LOC_ATTRIBUTE15LOV query:$column$.loc_attribute6LOC_ATTRIBUTE6LOC_ATTRIBUTE15LOV query:$column$.loc_attribute7LOC_ATTRIBUTE7LOC_ATTRIBUTE15LOV query:$column$.loc_attribute8LOC_ATTRIBUTE8LOC_ATTRIBUTE15LOV query:$column$.loc_attribute9LOC_ATTRIBUTE9LOC_ATTRIBUTE15LOV query:$column$.loc_attribute_categoryLOC_ATTRIBUTE_CATEGORYLOC_ATTRIBUTE15LOV query:$column$.loc_attribute1LOC_ATTRIBUTE1LOC_ATTRIBUTE16LOV query:$column$.loc_attribute10LOC_ATTRIBUTE10LOC_ATTRIBUTE16LOV query:$column$.loc_attribute11LOC_ATTRIBUTE11LOC_ATTRIBUTE16LOV query:$column$.loc_attribute12LOC_ATTRIBUTE12LOC_ATTRIBUTE16LOV query:$column$.loc_attribute13LOC_ATTRIBUTE13LOC_ATTRIBUTE16LOV query:$column$.loc_attribute14LOC_ATTRIBUTE14LOC_ATTRIBUTE16LOV query:$column$.loc_attribute15LOC_ATTRIBUTE15LOC_ATTRIBUTE16LOV query:$column$.loc_attribute16LOC_ATTRIBUTE16LOC_ATTRIBUTE16LOV query:$column$.loc_attribute17LOC_ATTRIBUTE17LOC_ATTRIBUTE16LOV query:$column$.loc_attribute18LOC_ATTRIBUTE18LOC_ATTRIBUTE16LOV query:$column$.loc_attribute19LOC_ATTRIBUTE19LOC_ATTRIBUTE16LOV query:$column$.loc_attribute2LOC_ATTRIBUTE2LOC_ATTRIBUTE16LOV query:$column$.loc_attribute20LOC_ATTRIBUTE20LOC_ATTRIBUTE16LOV query:$column$.loc_attribute3LOC_ATTRIBUTE3LOC_ATTRIBUTE16LOV query:$column$.loc_attribute4LOC_ATTRIBUTE4LOC_ATTRIBUTE16LOV query:$column$.loc_attribute5LOC_ATTRIBUTE5LOC_ATTRIBUTE16LOV query:$column$.loc_attribute6LOC_ATTRIBUTE6LOC_ATTRIBUTE16LOV query:$column$.loc_attribute7LOC_ATTRIBUTE7LOC_ATTRIBUTE16LOV query:$column$.loc_attribute8LOC_ATTRIBUTE8LOC_ATTRIBUTE16LOV query:$column$.loc_attribute9LOC_ATTRIBUTE9LOC_ATTRIBUTE16LOV query:$column$.loc_attribute_categoryLOC_ATTRIBUTE_CATEGORYLOC_ATTRIBUTE16LOV query:$column$.loc_attribute1LOC_ATTRIBUTE1LOC_ATTRIBUTE17LOV query:$column$.loc_attribute10LOC_ATTRIBUTE10LOC_ATTRIBUTE17LOV query:$column$.loc_attribute11LOC_ATTRIBUTE11LOC_ATTRIBUTE17LOV query:$column$.loc_attribute12LOC_ATTRIBUTE12LOC_ATTRIBUTE17LOV query:$column$.loc_attribute13LOC_ATTRIBUTE13LOC_ATTRIBUTE17LOV query:$column$.loc_attribute14LOC_ATTRIBUTE14LOC_ATTRIBUTE17LOV query:$column$.loc_attribute15LOC_ATTRIBUTE15LOC_ATTRIBUTE17LOV query:$column$.loc_attribute16LOC_ATTRIBUTE16LOC_ATTRIBUTE17LOV query:$column$.loc_attribute17LOC_ATTRIBUTE17LOC_ATTRIBUTE17LOV query:$column$.loc_attribute18LOC_ATTRIBUTE18LOC_ATTRIBUTE17LOV query:$column$.loc_attribute19LOC_ATTRIBUTE19LOC_ATTRIBUTE17LOV query:$column$.loc_attribute2LOC_ATTRIBUTE2LOC_ATTRIBUTE17LOV query:$column$.loc_attribute20LOC_ATTRIBUTE20LOC_ATTRIBUTE17LOV query:$column$.loc_attribute3LOC_ATTRIBUTE3LOC_ATTRIBUTE17LOV query:$column$.loc_attribute4LOC_ATTRIBUTE4LOC_ATTRIBUTE17LOV query:$column$.loc_attribute5LOC_ATTRIBUTE5LOC_ATTRIBUTE17LOV query:$column$.loc_attribute6LOC_ATTRIBUTE6LOC_ATTRIBUTE17LOV query:$column$.loc_attribute7LOC_ATTRIBUTE7LOC_ATTRIBUTE17LOV query:$column$.loc_attribute8LOC_ATTRIBUTE8LOC_ATTRIBUTE17LOV query:$column$.loc_attribute9LOC_ATTRIBUTE9LOC_ATTRIBUTE17LOV query:$column$.loc_attribute_categoryLOC_ATTRIBUTE_CATEGORYLOC_ATTRIBUTE17LOV query:$column$.loc_attribute1LOC_ATTRIBUTE1LOC_ATTRIBUTE18LOV query:$column$.loc_attribute10LOC_ATTRIBUTE10LOC_ATTRIBUTE18LOV query:$column$.loc_attribute11LOC_ATTRIBUTE11LOC_ATTRIBUTE18LOV query:$column$.loc_attribute12LOC_ATTRIBUTE12LOC_ATTRIBUTE18LOV query:$column$.loc_attribute13LOC_ATTRIBUTE13LOC_ATTRIBUTE18LOV query:$column$.loc_attribute14LOC_ATTRIBUTE14LOC_ATTRIBUTE18LOV query:$column$.loc_attribute15LOC_ATTRIBUTE15LOC_ATTRIBUTE18LOV query:$column$.loc_attribute16LOC_ATTRIBUTE16LOC_ATTRIBUTE18LOV query:$column$.loc_attribute17LOC_ATTRIBUTE17LOC_ATTRIBUTE18LOV query:$column$.loc_attribute18LOC_ATTRIBUTE18LOC_ATTRIBUTE18LOV query:$column$.loc_attribute19LOC_ATTRIBUTE19LOC_ATTRIBUTE18LOV query:$column$.loc_attribute2LOC_ATTRIBUTE2LOC_ATTRIBUTE18LOV query:$column$.loc_attribute20LOC_ATTRIBUTE20LOC_ATTRIBUTE18LOV query:$column$.loc_attribute3LOC_ATTRIBUTE3LOC_ATTRIBUTE18LOV query:$column$.loc_attribute4LOC_ATTRIBUTE4LOC_ATTRIBUTE18LOV query:$column$.loc_attribute5LOC_ATTRIBUTE5LOC_ATTRIBUTE18LOV query:$column$.loc_attribute6LOC_ATTRIBUTE6LOC_ATTRIBUTE18LOV query:$column$.loc_attribute7LOC_ATTRIBUTE7LOC_ATTRIBUTE18LOV query:$column$.loc_attribute8LOC_ATTRIBUTE8LOC_ATTRIBUTE18LOV query:$column$.loc_attribute9LOC_ATTRIBUTE9LOC_ATTRIBUTE18LOV query:$column$.loc_attribute_categoryLOC_ATTRIBUTE_CATEGORYLOC_ATTRIBUTE18LOV query:$column$.loc_attribute1LOC_ATTRIBUTE1LOC_ATTRIBUTE19LOV query:$column$.loc_attribute10LOC_ATTRIBUTE10LOC_ATTRIBUTE19LOV query:$column$.loc_attribute11LOC_ATTRIBUTE11LOC_ATTRIBUTE19LOV query:$column$.loc_attribute12LOC_ATTRIBUTE12LOC_ATTRIBUTE19LOV query:$column$.loc_attribute13LOC_ATTRIBUTE13LOC_ATTRIBUTE19LOV query:$column$.loc_attribute14LOC_ATTRIBUTE14LOC_ATTRIBUTE19LOV query:$column$.loc_attribute15LOC_ATTRIBUTE15LOC_ATTRIBUTE19LOV query:$column$.loc_attribute16LOC_ATTRIBUTE16LOC_ATTRIBUTE19LOV query:$column$.loc_attribute17LOC_ATTRIBUTE17LOC_ATTRIBUTE19LOV query:$column$.loc_attribute18LOC_ATTRIBUTE18LOC_ATTRIBUTE19LOV query:$column$.loc_attribute19LOC_ATTRIBUTE19LOC_ATTRIBUTE19LOV query:$column$.loc_attribute2LOC_ATTRIBUTE2LOC_ATTRIBUTE19LOV query:$column$.loc_attribute20LOC_ATTRIBUTE20LOC_ATTRIBUTE19LOV query:$column$.loc_attribute3LOC_ATTRIBUTE3LOC_ATTRIBUTE19LOV query:$column$.loc_attribute4LOC_ATTRIBUTE4LOC_ATTRIBUTE19LOV query:$column$.loc_attribute5LOC_ATTRIBUTE5LOC_ATTRIBUTE19LOV query:$column$.loc_attribute6LOC_ATTRIBUTE6LOC_ATTRIBUTE19LOV query:$column$.loc_attribute7LOC_ATTRIBUTE7LOC_ATTRIBUTE19LOV query:$column$.loc_attribute8LOC_ATTRIBUTE8LOC_ATTRIBUTE19LOV query:$column$.loc_attribute9LOC_ATTRIBUTE9LOC_ATTRIBUTE19LOV query:$column$.loc_attribute_categoryLOC_ATTRIBUTE_CATEGORYLOC_ATTRIBUTE19LOV query:$column$.loc_attribute1LOC_ATTRIBUTE1LOC_ATTRIBUTE2LOV query:$column$.loc_attribute10LOC_ATTRIBUTE10LOC_ATTRIBUTE2LOV query:$column$.loc_attribute11LOC_ATTRIBUTE11LOC_ATTRIBUTE2LOV query:$column$.loc_attribute12LOC_ATTRIBUTE12LOC_ATTRIBUTE2LOV query:$column$.loc_attribute13LOC_ATTRIBUTE13LOC_ATTRIBUTE2LOV query:$column$.loc_attribute14LOC_ATTRIBUTE14LOC_ATTRIBUTE2LOV query:$column$.loc_attribute15LOC_ATTRIBUTE15LOC_ATTRIBUTE2LOV query:$column$.loc_attribute16LOC_ATTRIBUTE16LOC_ATTRIBUTE2LOV query:$column$.loc_attribute17LOC_ATTRIBUTE17LOC_ATTRIBUTE2LOV query:$column$.loc_attribute18LOC_ATTRIBUTE18LOC_ATTRIBUTE2LOV query:$column$.loc_attribute19LOC_ATTRIBUTE19LOC_ATTRIBUTE2LOV query:$column$.loc_attribute2LOC_ATTRIBUTE2LOC_ATTRIBUTE2LOV query:$column$.loc_attribute20LOC_ATTRIBUTE20LOC_ATTRIBUTE2LOV query:$column$.loc_attribute3LOC_ATTRIBUTE3LOC_ATTRIBUTE2LOV query:$column$.loc_attribute4LOC_ATTRIBUTE4LOC_ATTRIBUTE2LOV query:$column$.loc_attribute5LOC_ATTRIBUTE5LOC_ATTRIBUTE2LOV query:$column$.loc_attribute6LOC_ATTRIBUTE6LOC_ATTRIBUTE2LOV query:$column$.loc_attribute7LOC_ATTRIBUTE7LOC_ATTRIBUTE2LOV query:$column$.loc_attribute8LOC_ATTRIBUTE8LOC_ATTRIBUTE2LOV query:$column$.loc_attribute9LOC_ATTRIBUTE9LOC_ATTRIBUTE2LOV query:$column$.loc_attribute_categoryLOC_ATTRIBUTE_CATEGORYLOC_ATTRIBUTE2LOV query:$column$.loc_attribute1LOC_ATTRIBUTE1LOC_ATTRIBUTE20LOV query:$column$.loc_attribute10LOC_ATTRIBUTE10LOC_ATTRIBUTE20LOV query:$column$.loc_attribute11LOC_ATTRIBUTE11LOC_ATTRIBUTE20LOV query:$column$.loc_attribute12LOC_ATTRIBUTE12LOC_ATTRIBUTE20LOV query:$column$.loc_attribute13LOC_ATTRIBUTE13LOC_ATTRIBUTE20LOV query:$column$.loc_attribute14LOC_ATTRIBUTE14LOC_ATTRIBUTE20LOV query:$column$.loc_attribute15LOC_ATTRIBUTE15LOC_ATTRIBUTE20LOV query:$column$.loc_attribute16LOC_ATTRIBUTE16LOC_ATTRIBUTE20LOV query:$column$.loc_attribute17LOC_ATTRIBUTE17LOC_ATTRIBUTE20LOV query:$column$.loc_attribute18LOC_ATTRIBUTE18LOC_ATTRIBUTE20LOV query:$column$.loc_attribute19LOC_ATTRIBUTE19LOC_ATTRIBUTE20LOV query:$column$.loc_attribute2LOC_ATTRIBUTE2LOC_ATTRIBUTE20LOV query:$column$.loc_attribute20LOC_ATTRIBUTE20LOC_ATTRIBUTE20LOV query:$column$.loc_attribute3LOC_ATTRIBUTE3LOC_ATTRIBUTE20LOV query:$column$.loc_attribute4LOC_ATTRIBUTE4LOC_ATTRIBUTE20LOV query:$column$.loc_attribute5LOC_ATTRIBUTE5LOC_ATTRIBUTE20LOV query:$column$.loc_attribute6LOC_ATTRIBUTE6LOC_ATTRIBUTE20LOV query:$column$.loc_attribute7LOC_ATTRIBUTE7LOC_ATTRIBUTE20LOV query:$column$.loc_attribute8LOC_ATTRIBUTE8LOC_ATTRIBUTE20LOV query:$column$.loc_attribute9LOC_ATTRIBUTE9LOC_ATTRIBUTE20LOV query:$column$.loc_attribute_categoryLOC_ATTRIBUTE_CATEGORYLOC_ATTRIBUTE20LOV query:$column$.loc_attribute1LOC_ATTRIBUTE1LOC_ATTRIBUTE3LOV query:$column$.loc_attribute10LOC_ATTRIBUTE10LOC_ATTRIBUTE3LOV query:$column$.loc_attribute11LOC_ATTRIBUTE11LOC_ATTRIBUTE3LOV query:$column$.loc_attribute12LOC_ATTRIBUTE12LOC_ATTRIBUTE3LOV query:$column$.loc_attribute13LOC_ATTRIBUTE13LOC_ATTRIBUTE3LOV query:$column$.loc_attribute14LOC_ATTRIBUTE14LOC_ATTRIBUTE3LOV query:$column$.loc_attribute15LOC_ATTRIBUTE15LOC_ATTRIBUTE3LOV query:$column$.loc_attribute16LOC_ATTRIBUTE16LOC_ATTRIBUTE3LOV query:$column$.loc_attribute17LOC_ATTRIBUTE17LOC_ATTRIBUTE3LOV query:$column$.loc_attribute18LOC_ATTRIBUTE18LOC_ATTRIBUTE3LOV query:$column$.loc_attribute19LOC_ATTRIBUTE19LOC_ATTRIBUTE3LOV query:$column$.loc_attribute2LOC_ATTRIBUTE2LOC_ATTRIBUTE3LOV query:$column$.loc_attribute20LOC_ATTRIBUTE20LOC_ATTRIBUTE3LOV query:$column$.loc_attribute3LOC_ATTRIBUTE3LOC_ATTRIBUTE3LOV query:$column$.loc_attribute4LOC_ATTRIBUTE4LOC_ATTRIBUTE3LOV query:$column$.loc_attribute5LOC_ATTRIBUTE5LOC_ATTRIBUTE3LOV query:$column$.loc_attribute6LOC_ATTRIBUTE6LOC_ATTRIBUTE3LOV query:$column$.loc_attribute7LOC_ATTRIBUTE7LOC_ATTRIBUTE3LOV query:$column$.loc_attribute8LOC_ATTRIBUTE8LOC_ATTRIBUTE3LOV query:$column$.loc_attribute9LOC_ATTRIBUTE9LOC_ATTRIBUTE3LOV query:$column$.loc_attribute_categoryLOC_ATTRIBUTE_CATEGORYLOC_ATTRIBUTE3LOV query:$column$.loc_attribute1LOC_ATTRIBUTE1LOC_ATTRIBUTE4LOV query:$column$.loc_attribute10LOC_ATTRIBUTE10LOC_ATTRIBUTE4LOV query:$column$.loc_attribute11LOC_ATTRIBUTE11LOC_ATTRIBUTE4LOV query:$column$.loc_attribute12LOC_ATTRIBUTE12LOC_ATTRIBUTE4LOV query:$column$.loc_attribute13LOC_ATTRIBUTE13LOC_ATTRIBUTE4LOV query:$column$.loc_attribute14LOC_ATTRIBUTE14LOC_ATTRIBUTE4LOV query:$column$.loc_attribute15LOC_ATTRIBUTE15LOC_ATTRIBUTE4LOV query:$column$.loc_attribute16LOC_ATTRIBUTE16LOC_ATTRIBUTE4LOV query:$column$.loc_attribute17LOC_ATTRIBUTE17LOC_ATTRIBUTE4LOV query:$column$.loc_attribute18LOC_ATTRIBUTE18LOC_ATTRIBUTE4LOV query:$column$.loc_attribute19LOC_ATTRIBUTE19LOC_ATTRIBUTE4LOV query:$column$.loc_attribute2LOC_ATTRIBUTE2LOC_ATTRIBUTE4LOV query:$column$.loc_attribute20LOC_ATTRIBUTE20LOC_ATTRIBUTE4LOV query:$column$.loc_attribute3LOC_ATTRIBUTE3LOC_ATTRIBUTE4LOV query:$column$.loc_attribute4LOC_ATTRIBUTE4LOC_ATTRIBUTE4LOV query:$column$.loc_attribute5LOC_ATTRIBUTE5LOC_ATTRIBUTE4LOV query:$column$.loc_attribute6LOC_ATTRIBUTE6LOC_ATTRIBUTE4LOV query:$column$.loc_attribute7LOC_ATTRIBUTE7LOC_ATTRIBUTE4LOV query:$column$.loc_attribute8LOC_ATTRIBUTE8LOC_ATTRIBUTE4LOV query:$column$.loc_attribute9LOC_ATTRIBUTE9LOC_ATTRIBUTE4LOV query:$column$.loc_attribute_categoryLOC_ATTRIBUTE_CATEGORYLOC_ATTRIBUTE4LOV query:$column$.loc_attribute1LOC_ATTRIBUTE1LOC_ATTRIBUTE5LOV query:$column$.loc_attribute10LOC_ATTRIBUTE10LOC_ATTRIBUTE5LOV query:$column$.loc_attribute11LOC_ATTRIBUTE11LOC_ATTRIBUTE5LOV query:$column$.loc_attribute12LOC_ATTRIBUTE12LOC_ATTRIBUTE5LOV query:$column$.loc_attribute13LOC_ATTRIBUTE13LOC_ATTRIBUTE5LOV query:$column$.loc_attribute14LOC_ATTRIBUTE14LOC_ATTRIBUTE5LOV query:$column$.loc_attribute15LOC_ATTRIBUTE15LOC_ATTRIBUTE5LOV query:$column$.loc_attribute16LOC_ATTRIBUTE16LOC_ATTRIBUTE5LOV query:$column$.loc_attribute17LOC_ATTRIBUTE17LOC_ATTRIBUTE5LOV query:$column$.loc_attribute18LOC_ATTRIBUTE18LOC_ATTRIBUTE5LOV query:$column$.loc_attribute19LOC_ATTRIBUTE19LOC_ATTRIBUTE5LOV query:$column$.loc_attribute2LOC_ATTRIBUTE2LOC_ATTRIBUTE5LOV query:$column$.loc_attribute20LOC_ATTRIBUTE20LOC_ATTRIBUTE5LOV query:$column$.loc_attribute3LOC_ATTRIBUTE3LOC_ATTRIBUTE5LOV query:$column$.loc_attribute4LOC_ATTRIBUTE4LOC_ATTRIBUTE5LOV query:$column$.loc_attribute5LOC_ATTRIBUTE5LOC_ATTRIBUTE5LOV query:$column$.loc_attribute6LOC_ATTRIBUTE6LOC_ATTRIBUTE5LOV query:$column$.loc_attribute7LOC_ATTRIBUTE7LOC_ATTRIBUTE5LOV query:$column$.loc_attribute8LOC_ATTRIBUTE8LOC_ATTRIBUTE5LOV query:$column$.loc_attribute9LOC_ATTRIBUTE9LOC_ATTRIBUTE5LOV query:$column$.loc_attribute_categoryLOC_ATTRIBUTE_CATEGORYLOC_ATTRIBUTE5LOV query:$column$.loc_attribute1LOC_ATTRIBUTE1LOC_ATTRIBUTE6LOV query:$column$.loc_attribute10LOC_ATTRIBUTE10LOC_ATTRIBUTE6LOV query:$column$.loc_attribute11LOC_ATTRIBUTE11LOC_ATTRIBUTE6LOV query:$column$.loc_attribute12LOC_ATTRIBUTE12LOC_ATTRIBUTE6LOV query:$column$.loc_attribute13LOC_ATTRIBUTE13LOC_ATTRIBUTE6LOV query:$column$.loc_attribute14LOC_ATTRIBUTE14LOC_ATTRIBUTE6LOV query:$column$.loc_attribute15LOC_ATTRIBUTE15LOC_ATTRIBUTE6LOV query:$column$.loc_attribute16LOC_ATTRIBUTE16LOC_ATTRIBUTE6LOV query:$column$.loc_attribute17LOC_ATTRIBUTE17LOC_ATTRIBUTE6LOV query:$column$.loc_attribute18LOC_ATTRIBUTE18LOC_ATTRIBUTE6LOV query:$column$.loc_attribute19LOC_ATTRIBUTE19LOC_ATTRIBUTE6LOV query:$column$.loc_attribute2LOC_ATTRIBUTE2LOC_ATTRIBUTE6LOV query:$column$.loc_attribute20LOC_ATTRIBUTE20LOC_ATTRIBUTE6LOV query:$column$.loc_attribute3LOC_ATTRIBUTE3LOC_ATTRIBUTE6LOV query:$column$.loc_attribute4LOC_ATTRIBUTE4LOC_ATTRIBUTE6LOV query:$column$.loc_attribute5LOC_ATTRIBUTE5LOC_ATTRIBUTE6LOV query:$column$.loc_attribute6LOC_ATTRIBUTE6LOC_ATTRIBUTE6LOV query:$column$.loc_attribute7LOC_ATTRIBUTE7LOC_ATTRIBUTE6LOV query:$column$.loc_attribute8LOC_ATTRIBUTE8LOC_ATTRIBUTE6LOV query:$column$.loc_attribute9LOC_ATTRIBUTE9LOC_ATTRIBUTE6LOV query:$column$.loc_attribute_categoryLOC_ATTRIBUTE_CATEGORYLOC_ATTRIBUTE6LOV query:$column$.loc_attribute1LOC_ATTRIBUTE1LOC_ATTRIBUTE7LOV query:$column$.loc_attribute10LOC_ATTRIBUTE10LOC_ATTRIBUTE7LOV query:$column$.loc_attribute11LOC_ATTRIBUTE11LOC_ATTRIBUTE7LOV query:$column$.loc_attribute12LOC_ATTRIBUTE12LOC_ATTRIBUTE7LOV query:$column$.loc_attribute13LOC_ATTRIBUTE13LOC_ATTRIBUTE7LOV query:$column$.loc_attribute14LOC_ATTRIBUTE14LOC_ATTRIBUTE7LOV query:$column$.loc_attribute15LOC_ATTRIBUTE15LOC_ATTRIBUTE7LOV query:$column$.loc_attribute16LOC_ATTRIBUTE16LOC_ATTRIBUTE7LOV query:$column$.loc_attribute17LOC_ATTRIBUTE17LOC_ATTRIBUTE7LOV query:$column$.loc_attribute18LOC_ATTRIBUTE18LOC_ATTRIBUTE7LOV query:$column$.loc_attribute19LOC_ATTRIBUTE19LOC_ATTRIBUTE7LOV query:$column$.loc_attribute2LOC_ATTRIBUTE2LOC_ATTRIBUTE7LOV query:$column$.loc_attribute20LOC_ATTRIBUTE20LOC_ATTRIBUTE7LOV query:$column$.loc_attribute3LOC_ATTRIBUTE3LOC_ATTRIBUTE7LOV query:$column$.loc_attribute4LOC_ATTRIBUTE4LOC_ATTRIBUTE7LOV query:$column$.loc_attribute5LOC_ATTRIBUTE5LOC_ATTRIBUTE7LOV query:$column$.loc_attribute6LOC_ATTRIBUTE6LOC_ATTRIBUTE7LOV query:$column$.loc_attribute7LOC_ATTRIBUTE7LOC_ATTRIBUTE7LOV query:$column$.loc_attribute8LOC_ATTRIBUTE8LOC_ATTRIBUTE7LOV query:$column$.loc_attribute9LOC_ATTRIBUTE9LOC_ATTRIBUTE7LOV query:$column$.loc_attribute_categoryLOC_ATTRIBUTE_CATEGORYLOC_ATTRIBUTE7LOV query:$column$.loc_attribute1LOC_ATTRIBUTE1LOC_ATTRIBUTE8LOV query:$column$.loc_attribute10LOC_ATTRIBUTE10LOC_ATTRIBUTE8LOV query:$column$.loc_attribute11LOC_ATTRIBUTE11LOC_ATTRIBUTE8LOV query:$column$.loc_attribute12LOC_ATTRIBUTE12LOC_ATTRIBUTE8LOV query:$column$.loc_attribute13LOC_ATTRIBUTE13LOC_ATTRIBUTE8LOV query:$column$.loc_attribute14LOC_ATTRIBUTE14LOC_ATTRIBUTE8LOV query:$column$.loc_attribute15LOC_ATTRIBUTE15LOC_ATTRIBUTE8LOV query:$column$.loc_attribute16LOC_ATTRIBUTE16LOC_ATTRIBUTE8LOV query:$column$.loc_attribute17LOC_ATTRIBUTE17LOC_ATTRIBUTE8LOV query:$column$.loc_attribute18LOC_ATTRIBUTE18LOC_ATTRIBUTE8LOV query:$column$.loc_attribute19LOC_ATTRIBUTE19LOC_ATTRIBUTE8LOV query:$column$.loc_attribute2LOC_ATTRIBUTE2LOC_ATTRIBUTE8LOV query:$column$.loc_attribute20LOC_ATTRIBUTE20LOC_ATTRIBUTE8LOV query:$column$.loc_attribute3LOC_ATTRIBUTE3LOC_ATTRIBUTE8LOV query:$column$.loc_attribute4LOC_ATTRIBUTE4LOC_ATTRIBUTE8LOV query:$column$.loc_attribute5LOC_ATTRIBUTE5LOC_ATTRIBUTE8LOV query:$column$.loc_attribute6LOC_ATTRIBUTE6LOC_ATTRIBUTE8LOV query:$column$.loc_attribute7LOC_ATTRIBUTE7LOC_ATTRIBUTE8LOV query:$column$.loc_attribute8LOC_ATTRIBUTE8LOC_ATTRIBUTE8LOV query:$column$.loc_attribute9LOC_ATTRIBUTE9LOC_ATTRIBUTE8LOV query:$column$.loc_attribute_categoryLOC_ATTRIBUTE_CATEGORYLOC_ATTRIBUTE8LOV query:$column$.loc_attribute1LOC_ATTRIBUTE1LOC_ATTRIBUTE9LOV query:$column$.loc_attribute10LOC_ATTRIBUTE10LOC_ATTRIBUTE9LOV query:$column$.loc_attribute11LOC_ATTRIBUTE11LOC_ATTRIBUTE9LOV query:$column$.loc_attribute12LOC_ATTRIBUTE12LOC_ATTRIBUTE9LOV query:$column$.loc_attribute13LOC_ATTRIBUTE13LOC_ATTRIBUTE9LOV query:$column$.loc_attribute14LOC_ATTRIBUTE14LOC_ATTRIBUTE9LOV query:$column$.loc_attribute15LOC_ATTRIBUTE15LOC_ATTRIBUTE9LOV query:$column$.loc_attribute16LOC_ATTRIBUTE16LOC_ATTRIBUTE9LOV query:$column$.loc_attribute17LOC_ATTRIBUTE17LOC_ATTRIBUTE9LOV query:$column$.loc_attribute18LOC_ATTRIBUTE18LOC_ATTRIBUTE9LOV query:$column$.loc_attribute19LOC_ATTRIBUTE19LOC_ATTRIBUTE9LOV query:$column$.loc_attribute2LOC_ATTRIBUTE2LOC_ATTRIBUTE9LOV query:$column$.loc_attribute20LOC_ATTRIBUTE20LOC_ATTRIBUTE9LOV query:$column$.loc_attribute3LOC_ATTRIBUTE3LOC_ATTRIBUTE9LOV query:$column$.loc_attribute4LOC_ATTRIBUTE4LOC_ATTRIBUTE9LOV query:$column$.loc_attribute5LOC_ATTRIBUTE5LOC_ATTRIBUTE9LOV query:$column$.loc_attribute6LOC_ATTRIBUTE6LOC_ATTRIBUTE9LOV query:$column$.loc_attribute7LOC_ATTRIBUTE7LOC_ATTRIBUTE9LOV query:$column$.loc_attribute8LOC_ATTRIBUTE8LOC_ATTRIBUTE9LOV query:$column$.loc_attribute9LOC_ATTRIBUTE9LOC_ATTRIBUTE9LOV query:$column$.loc_attribute_categoryLOC_ATTRIBUTE_CATEGORYLOC_ATTRIBUTE9LOV query:$column$.address_line_1ADDRESS_LINE_1LOC_INFORMATION13LOV query:$column$.address_line_2ADDRESS_LINE_2LOC_INFORMATION13LOV query:$column$.address_line_3ADDRESS_LINE_3LOC_INFORMATION13LOV query:$column$.address_styleADDRESS_STYLELOC_INFORMATION13LOV query:$column$.countryCOUNTRYLOC_INFORMATION13LOV query:$column$.loc_information13LOC_INFORMATION13LOC_INFORMATION13LOV query:$column$.loc_information14LOC_INFORMATION14LOC_INFORMATION13LOV query:$column$.loc_information15LOC_INFORMATION15LOC_INFORMATION13LOV query:$column$.loc_information16LOC_INFORMATION16LOC_INFORMATION13LOV query:$column$.loc_information17LOC_INFORMATION17LOC_INFORMATION13LOV query:$column$.loc_information18LOC_INFORMATION18LOC_INFORMATION13LOV query:$column$.loc_information19LOC_INFORMATION19LOC_INFORMATION13LOV query:$column$.loc_information20LOC_INFORMATION20LOC_INFORMATION13LOV query:$column$.postal_codePOSTAL_CODELOC_INFORMATION13LOV query:$column$.region_1REGION_1LOC_INFORMATION13LOV query:$column$.region_2REGION_2LOC_INFORMATION13LOV query:$column$.region_3REGION_3LOC_INFORMATION13LOV query:$column$.telephone_number_1TELEPHONE_NUMBER_1LOC_INFORMATION13LOV query:$column$.telephone_number_2TELEPHONE_NUMBER_2LOC_INFORMATION13LOV query:$column$.telephone_number_3TELEPHONE_NUMBER_3LOC_INFORMATION13LOV query:$column$.town_or_cityTOWN_OR_CITYLOC_INFORMATION13LOV query:$column$.address_line_1ADDRESS_LINE_1LOC_INFORMATION14LOV query:$column$.address_line_2ADDRESS_LINE_2LOC_INFORMATION14LOV query:$column$.address_line_3ADDRESS_LINE_3LOC_INFORMATION14LOV query:$column$.address_styleADDRESS_STYLELOC_INFORMATION14LOV query:$column$.countryCOUNTRYLOC_INFORMATION14LOV query:$column$.loc_information13LOC_INFORMATION13LOC_INFORMATION14LOV query:$column$.loc_information14LOC_INFORMATION14LOC_INFORMATION14LOV query:$column$.loc_information15LOC_INFORMATION15LOC_INFORMATION14LOV query:$column$.loc_information16LOC_INFORMATION16LOC_INFORMATION14LOV query:$column$.loc_information17LOC_INFORMATION17LOC_INFORMATION14LOV query:$column$.loc_information18LOC_INFORMATION18LOC_INFORMATION14LOV query:$column$.loc_information19LOC_INFORMATION19LOC_INFORMATION14LOV query:$column$.loc_information20LOC_INFORMATION20LOC_INFORMATION14LOV query:$column$.postal_codePOSTAL_CODELOC_INFORMATION14LOV query:$column$.region_1REGION_1LOC_INFORMATION14LOV query:$column$.region_2REGION_2LOC_INFORMATION14LOV query:$column$.region_3REGION_3LOC_INFORMATION14LOV query:$column$.telephone_number_1TELEPHONE_NUMBER_1LOC_INFORMATION14LOV query:$column$.telephone_number_2TELEPHONE_NUMBER_2LOC_INFORMATION14LOV query:$column$.telephone_number_3TELEPHONE_NUMBER_3LOC_INFORMATION14LOV query:$column$.town_or_cityTOWN_OR_CITYLOC_INFORMATION14LOV query:$column$.address_line_1ADDRESS_LINE_1LOC_INFORMATION15LOV query:$column$.address_line_2ADDRESS_LINE_2LOC_INFORMATION15LOV query:$column$.address_line_3ADDRESS_LINE_3LOC_INFORMATION15LOV query:$column$.address_styleADDRESS_STYLELOC_INFORMATION15LOV query:$column$.countryCOUNTRYLOC_INFORMATION15LOV query:$column$.loc_information13LOC_INFORMATION13LOC_INFORMATION15LOV query:$column$.loc_information14LOC_INFORMATION14LOC_INFORMATION15LOV query:$column$.loc_information15LOC_INFORMATION15LOC_INFORMATION15LOV query:$column$.loc_information16LOC_INFORMATION16LOC_INFORMATION15LOV query:$column$.loc_information17LOC_INFORMATION17LOC_INFORMATION15LOV query:$column$.loc_information18LOC_INFORMATION18LOC_INFORMATION15LOV query:$column$.loc_information19LOC_INFORMATION19LOC_INFORMATION15LOV query:$column$.loc_information20LOC_INFORMATION20LOC_INFORMATION15LOV query:$column$.postal_codePOSTAL_CODELOC_INFORMATION15LOV query:$column$.region_1REGION_1LOC_INFORMATION15LOV query:$column$.region_2REGION_2LOC_INFORMATION15LOV query:$column$.region_3REGION_3LOC_INFORMATION15LOV query:$column$.telephone_number_1TELEPHONE_NUMBER_1LOC_INFORMATION15LOV query:$column$.telephone_number_2TELEPHONE_NUMBER_2LOC_INFORMATION15LOV query:$column$.telephone_number_3TELEPHONE_NUMBER_3LOC_INFORMATION15LOV query:$column$.town_or_cityTOWN_OR_CITYLOC_INFORMATION15LOV query:$column$.address_line_1ADDRESS_LINE_1LOC_INFORMATION16LOV query:$column$.address_line_2ADDRESS_LINE_2LOC_INFORMATION16LOV query:$column$.address_line_3ADDRESS_LINE_3LOC_INFORMATION16LOV query:$column$.address_styleADDRESS_STYLELOC_INFORMATION16LOV query:$column$.countryCOUNTRYLOC_INFORMATION16LOV query:$column$.loc_information13LOC_INFORMATION13LOC_INFORMATION16LOV query:$column$.loc_information14LOC_INFORMATION14LOC_INFORMATION16LOV query:$column$.loc_information15LOC_INFORMATION15LOC_INFORMATION16LOV query:$column$.loc_information16LOC_INFORMATION16LOC_INFORMATION16LOV query:$column$.loc_information17LOC_INFORMATION17LOC_INFORMATION16LOV query:$column$.loc_information18LOC_INFORMATION18LOC_INFORMATION16LOV query:$column$.loc_information19LOC_INFORMATION19LOC_INFORMATION16LOV query:$column$.loc_information20LOC_INFORMATION20LOC_INFORMATION16LOV query:$column$.postal_codePOSTAL_CODELOC_INFORMATION16LOV query:$column$.region_1REGION_1LOC_INFORMATION16LOV query:$column$.region_2REGION_2LOC_INFORMATION16LOV query:$column$.region_3REGION_3LOC_INFORMATION16LOV query:$column$.telephone_number_1TELEPHONE_NUMBER_1LOC_INFORMATION16LOV query:$column$.telephone_number_2TELEPHONE_NUMBER_2LOC_INFORMATION16LOV query:$column$.telephone_number_3TELEPHONE_NUMBER_3LOC_INFORMATION16LOV query:$column$.town_or_cityTOWN_OR_CITYLOC_INFORMATION16LOV query:$column$.address_line_1ADDRESS_LINE_1LOC_INFORMATION17LOV query:$column$.address_line_2ADDRESS_LINE_2LOC_INFORMATION17LOV query:$column$.address_line_3ADDRESS_LINE_3LOC_INFORMATION17LOV query:$column$.address_styleADDRESS_STYLELOC_INFORMATION17LOV query:$column$.countryCOUNTRYLOC_INFORMATION17LOV query:$column$.loc_information13LOC_INFORMATION13LOC_INFORMATION17LOV query:$column$.loc_information14LOC_INFORMATION14LOC_INFORMATION17LOV query:$column$.loc_information15LOC_INFORMATION15LOC_INFORMATION17LOV query:$column$.loc_information16LOC_INFORMATION16LOC_INFORMATION17LOV query:$column$.loc_information17LOC_INFORMATION17LOC_INFORMATION17LOV query:$column$.loc_information18LOC_INFORMATION18LOC_INFORMATION17LOV query:$column$.loc_information19LOC_INFORMATION19LOC_INFORMATION17LOV query:$column$.loc_information20LOC_INFORMATION20LOC_INFORMATION17LOV query:$column$.postal_codePOSTAL_CODELOC_INFORMATION17LOV query:$column$.region_1REGION_1LOC_INFORMATION17LOV query:$column$.region_2REGION_2LOC_INFORMATION17LOV query:$column$.region_3REGION_3LOC_INFORMATION17LOV query:$column$.telephone_number_1TELEPHONE_NUMBER_1LOC_INFORMATION17LOV query:$column$.telephone_number_2TELEPHONE_NUMBER_2LOC_INFORMATION17LOV query:$column$.telephone_number_3TELEPHONE_NUMBER_3LOC_INFORMATION17LOV query:$column$.town_or_cityTOWN_OR_CITYLOC_INFORMATION17LOV query:$column$.address_line_1ADDRESS_LINE_1LOC_INFORMATION18LOV query:$column$.address_line_2ADDRESS_LINE_2LOC_INFORMATION18LOV query:$column$.address_line_3ADDRESS_LINE_3LOC_INFORMATION18LOV query:$column$.address_styleADDRESS_STYLELOC_INFORMATION18LOV query:$column$.countryCOUNTRYLOC_INFORMATION18LOV query:$column$.loc_information13LOC_INFORMATION13LOC_INFORMATION18LOV query:$column$.loc_information14LOC_INFORMATION14LOC_INFORMATION18LOV query:$column$.loc_information15LOC_INFORMATION15LOC_INFORMATION18LOV query:$column$.loc_information16LOC_INFORMATION16LOC_INFORMATION18LOV query:$column$.loc_information17LOC_INFORMATION17LOC_INFORMATION18LOV query:$column$.loc_information18LOC_INFORMATION18LOC_INFORMATION18LOV query:$column$.loc_information19LOC_INFORMATION19LOC_INFORMATION18LOV query:$column$.loc_information20LOC_INFORMATION20LOC_INFORMATION18LOV query:$column$.postal_codePOSTAL_CODELOC_INFORMATION18LOV query:$column$.region_1REGION_1LOC_INFORMATION18LOV query:$column$.region_2REGION_2LOC_INFORMATION18LOV query:$column$.region_3REGION_3LOC_INFORMATION18LOV query:$column$.telephone_number_1TELEPHONE_NUMBER_1LOC_INFORMATION18LOV query:$column$.telephone_number_2TELEPHONE_NUMBER_2LOC_INFORMATION18LOV query:$column$.telephone_number_3TELEPHONE_NUMBER_3LOC_INFORMATION18LOV query:$column$.town_or_cityTOWN_OR_CITYLOC_INFORMATION18LOV query:$column$.address_line_1ADDRESS_LINE_1LOC_INFORMATION19LOV query:$column$.address_line_2ADDRESS_LINE_2LOC_INFORMATION19LOV query:$column$.address_line_3ADDRESS_LINE_3LOC_INFORMATION19LOV query:$column$.address_styleADDRESS_STYLELOC_INFORMATION19LOV query:$column$.countryCOUNTRYLOC_INFORMATION19LOV query:$column$.loc_information13LOC_INFORMATION13LOC_INFORMATION19LOV query:$column$.loc_information14LOC_INFORMATION14LOC_INFORMATION19LOV query:$column$.loc_information15LOC_INFORMATION15LOC_INFORMATION19LOV query:$column$.loc_information16LOC_INFORMATION16LOC_INFORMATION19LOV query:$column$.loc_information17LOC_INFORMATION17LOC_INFORMATION19LOV query:$column$.loc_information18LOC_INFORMATION18LOC_INFORMATION19LOV query:$column$.loc_information19LOC_INFORMATION19LOC_INFORMATION19LOV query:$column$.loc_information20LOC_INFORMATION20LOC_INFORMATION19LOV query:$column$.postal_codePOSTAL_CODELOC_INFORMATION19LOV query:$column$.region_1REGION_1LOC_INFORMATION19LOV query:$column$.region_2REGION_2LOC_INFORMATION19LOV query:$column$.region_3REGION_3LOC_INFORMATION19LOV query:$column$.telephone_number_1TELEPHONE_NUMBER_1LOC_INFORMATION19LOV query:$column$.telephone_number_2TELEPHONE_NUMBER_2LOC_INFORMATION19LOV query:$column$.telephone_number_3TELEPHONE_NUMBER_3LOC_INFORMATION19LOV query:$column$.town_or_cityTOWN_OR_CITYLOC_INFORMATION19LOV query:$column$.address_line_1ADDRESS_LINE_1LOC_INFORMATION20LOV query:$column$.address_line_2ADDRESS_LINE_2LOC_INFORMATION20LOV query:$column$.address_line_3ADDRESS_LINE_3LOC_INFORMATION20LOV query:$column$.address_styleADDRESS_STYLELOC_INFORMATION20LOV query:$column$.countryCOUNTRYLOC_INFORMATION20LOV query:$column$.loc_information13LOC_INFORMATION13LOC_INFORMATION20LOV query:$column$.loc_information14LOC_INFORMATION14LOC_INFORMATION20LOV query:$column$.loc_information15LOC_INFORMATION15LOC_INFORMATION20LOV query:$column$.loc_information16LOC_INFORMATION16LOC_INFORMATION20LOV query:$column$.loc_information17LOC_INFORMATION17LOC_INFORMATION20LOV query:$column$.loc_information18LOC_INFORMATION18LOC_INFORMATION20LOV query:$column$.loc_information19LOC_INFORMATION19LOC_INFORMATION20LOV query:$column$.loc_information20LOC_INFORMATION20LOC_INFORMATION20LOV query:$column$.postal_codePOSTAL_CODELOC_INFORMATION20LOV query:$column$.region_1REGION_1LOC_INFORMATION20LOV query:$column$.region_2REGION_2LOC_INFORMATION20LOV query:$column$.region_3REGION_3LOC_INFORMATION20LOV query:$column$.telephone_number_1TELEPHONE_NUMBER_1LOC_INFORMATION20LOV query:$column$.telephone_number_2TELEPHONE_NUMBER_2LOC_INFORMATION20LOV query:$column$.telephone_number_3TELEPHONE_NUMBER_3LOC_INFORMATION20LOV query:$column$.town_or_cityTOWN_OR_CITYLOC_INFORMATION20LOV query:$column$.address_line_1ADDRESS_LINE_1POSTAL_CODELOV query:$column$.address_line_2ADDRESS_LINE_2POSTAL_CODELOV query:$column$.address_line_3ADDRESS_LINE_3POSTAL_CODELOV query:$column$.address_styleADDRESS_STYLEPOSTAL_CODELOV query:$column$.countryCOUNTRYPOSTAL_CODELOV query:$column$.loc_information13LOC_INFORMATION13POSTAL_CODELOV query:$column$.loc_information14LOC_INFORMATION14POSTAL_CODELOV query:$column$.loc_information15LOC_INFORMATION15POSTAL_CODELOV query:$column$.loc_information16LOC_INFORMATION16POSTAL_CODELOV query:$column$.loc_information17LOC_INFORMATION17POSTAL_CODELOV query:$column$.loc_information18LOC_INFORMATION18POSTAL_CODELOV query:$column$.loc_information19LOC_INFORMATION19POSTAL_CODELOV query:$column$.loc_information20LOC_INFORMATION20POSTAL_CODELOV query:$column$.postal_codePOSTAL_CODEPOSTAL_CODELOV query:$column$.region_1REGION_1POSTAL_CODELOV query:$column$.region_2REGION_2POSTAL_CODELOV query:$column$.region_3REGION_3POSTAL_CODELOV query:$column$.telephone_number_1TELEPHONE_NUMBER_1POSTAL_CODELOV query:$column$.telephone_number_2TELEPHONE_NUMBER_2POSTAL_CODELOV query:$column$.telephone_number_3TELEPHONE_NUMBER_3POSTAL_CODELOV query:$column$.town_or_cityTOWN_OR_CITYPOSTAL_CODELOV query:$column$.address_line_1ADDRESS_LINE_1REGION_1LOV query:$column$.address_line_2ADDRESS_LINE_2REGION_1LOV query:$column$.address_line_3ADDRESS_LINE_3REGION_1LOV query:$column$.address_styleADDRESS_STYLEREGION_1LOV query:$column$.countryCOUNTRYREGION_1LOV query:$column$.loc_information13LOC_INFORMATION13REGION_1LOV query:$column$.loc_information14LOC_INFORMATION14REGION_1LOV query:$column$.loc_information15LOC_INFORMATION15REGION_1LOV query:$column$.loc_information16LOC_INFORMATION16REGION_1LOV query:$column$.loc_information17LOC_INFORMATION17REGION_1LOV query:$column$.loc_information18LOC_INFORMATION18REGION_1LOV query:$column$.loc_information19LOC_INFORMATION19REGION_1LOV query:$column$.loc_information20LOC_INFORMATION20REGION_1LOV query:$column$.postal_codePOSTAL_CODEREGION_1LOV query:$column$.region_1REGION_1REGION_1LOV query:$column$.region_2REGION_2REGION_1LOV query:$column$.region_3REGION_3REGION_1LOV query:$column$.telephone_number_1TELEPHONE_NUMBER_1REGION_1LOV query:$column$.telephone_number_2TELEPHONE_NUMBER_2REGION_1LOV query:$column$.telephone_number_3TELEPHONE_NUMBER_3REGION_1LOV query:$column$.town_or_cityTOWN_OR_CITYREGION_1LOV query:$column$.address_line_1ADDRESS_LINE_1REGION_2LOV query:$column$.address_line_2ADDRESS_LINE_2REGION_2LOV query:$column$.address_line_3ADDRESS_LINE_3REGION_2LOV query:$column$.address_styleADDRESS_STYLEREGION_2LOV query:$column$.countryCOUNTRYREGION_2LOV query:$column$.loc_information13LOC_INFORMATION13REGION_2LOV query:$column$.loc_information14LOC_INFORMATION14REGION_2LOV query:$column$.loc_information15LOC_INFORMATION15REGION_2LOV query:$column$.loc_information16LOC_INFORMATION16REGION_2LOV query:$column$.loc_information17LOC_INFORMATION17REGION_2LOV query:$column$.loc_information18LOC_INFORMATION18REGION_2LOV query:$column$.loc_information19LOC_INFORMATION19REGION_2LOV query:$column$.loc_information20LOC_INFORMATION20REGION_2LOV query:$column$.postal_codePOSTAL_CODEREGION_2LOV query:$column$.region_1REGION_1REGION_2LOV query:$column$.region_2REGION_2REGION_2LOV query:$column$.region_3REGION_3REGION_2LOV query:$column$.telephone_number_1TELEPHONE_NUMBER_1REGION_2LOV query:$column$.telephone_number_2TELEPHONE_NUMBER_2REGION_2LOV query:$column$.telephone_number_3TELEPHONE_NUMBER_3REGION_2LOV query:$column$.town_or_cityTOWN_OR_CITYREGION_2LOV query:$column$.address_line_1ADDRESS_LINE_1REGION_3LOV query:$column$.address_line_2ADDRESS_LINE_2REGION_3LOV query:$column$.address_line_3ADDRESS_LINE_3REGION_3LOV query:$column$.address_styleADDRESS_STYLEREGION_3LOV query:$column$.countryCOUNTRYREGION_3LOV query:$column$.loc_information13LOC_INFORMATION13REGION_3LOV query:$column$.loc_information14LOC_INFORMATION14REGION_3LOV query:$column$.loc_information15LOC_INFORMATION15REGION_3LOV query:$column$.loc_information16LOC_INFORMATION16REGION_3LOV query:$column$.loc_information17LOC_INFORMATION17REGION_3LOV query:$column$.loc_information18LOC_INFORMATION18REGION_3LOV query:$column$.loc_information19LOC_INFORMATION19REGION_3LOV query:$column$.loc_information20LOC_INFORMATION20REGION_3LOV query:$column$.postal_codePOSTAL_CODEREGION_3LOV query:$column$.region_1REGION_1REGION_3LOV query:$column$.region_2REGION_2REGION_3LOV query:$column$.region_3REGION_3REGION_3LOV query:$column$.telephone_number_1TELEPHONE_NUMBER_1REGION_3LOV query:$column$.telephone_number_2TELEPHONE_NUMBER_2REGION_3LOV query:$column$.telephone_number_3TELEPHONE_NUMBER_3REGION_3LOV query:$column$.town_or_cityTOWN_OR_CITYREGION_3LOV query:$column$.business_groupBUSINESS_GROUPSHIP_TO_LOCATIONLOV query:$column$.address_line_1ADDRESS_LINE_1TELEPHONE_NUMBER_1LOV query:$column$.address_line_2ADDRESS_LINE_2TELEPHONE_NUMBER_1LOV query:$column$.address_line_3ADDRESS_LINE_3TELEPHONE_NUMBER_1LOV query:$column$.address_styleADDRESS_STYLETELEPHONE_NUMBER_1LOV query:$column$.countryCOUNTRYTELEPHONE_NUMBER_1LOV query:$column$.loc_information13LOC_INFORMATION13TELEPHONE_NUMBER_1LOV query:$column$.loc_information14LOC_INFORMATION14TELEPHONE_NUMBER_1LOV query:$column$.loc_information15LOC_INFORMATION15TELEPHONE_NUMBER_1LOV query:$column$.loc_information16LOC_INFORMATION16TELEPHONE_NUMBER_1LOV query:$column$.loc_information17LOC_INFORMATION17TELEPHONE_NUMBER_1LOV query:$column$.loc_information18LOC_INFORMATION18TELEPHONE_NUMBER_1LOV query:$column$.loc_information19LOC_INFORMATION19TELEPHONE_NUMBER_1LOV query:$column$.loc_information20LOC_INFORMATION20TELEPHONE_NUMBER_1LOV query:$column$.postal_codePOSTAL_CODETELEPHONE_NUMBER_1LOV query:$column$.region_1REGION_1TELEPHONE_NUMBER_1LOV query:$column$.region_2REGION_2TELEPHONE_NUMBER_1LOV query:$column$.region_3REGION_3TELEPHONE_NUMBER_1LOV query:$column$.telephone_number_1TELEPHONE_NUMBER_1TELEPHONE_NUMBER_1LOV query:$column$.telephone_number_2TELEPHONE_NUMBER_2TELEPHONE_NUMBER_1LOV query:$column$.telephone_number_3TELEPHONE_NUMBER_3TELEPHONE_NUMBER_1LOV query:$column$.town_or_cityTOWN_OR_CITYTELEPHONE_NUMBER_1LOV query:$column$.address_line_1ADDRESS_LINE_1TELEPHONE_NUMBER_2LOV query:$column$.address_line_2ADDRESS_LINE_2TELEPHONE_NUMBER_2LOV query:$column$.address_line_3ADDRESS_LINE_3TELEPHONE_NUMBER_2LOV query:$column$.address_styleADDRESS_STYLETELEPHONE_NUMBER_2LOV query:$column$.countryCOUNTRYTELEPHONE_NUMBER_2LOV query:$column$.loc_information13LOC_INFORMATION13TELEPHONE_NUMBER_2LOV query:$column$.loc_information14LOC_INFORMATION14TELEPHONE_NUMBER_2LOV query:$column$.loc_information15LOC_INFORMATION15TELEPHONE_NUMBER_2LOV query:$column$.loc_information16LOC_INFORMATION16TELEPHONE_NUMBER_2LOV query:$column$.loc_information17LOC_INFORMATION17TELEPHONE_NUMBER_2LOV query:$column$.loc_information18LOC_INFORMATION18TELEPHONE_NUMBER_2LOV query:$column$.loc_information19LOC_INFORMATION19TELEPHONE_NUMBER_2LOV query:$column$.loc_information20LOC_INFORMATION20TELEPHONE_NUMBER_2LOV query:$column$.postal_codePOSTAL_CODETELEPHONE_NUMBER_2LOV query:$column$.region_1REGION_1TELEPHONE_NUMBER_2LOV query:$column$.region_2REGION_2TELEPHONE_NUMBER_2LOV query:$column$.region_3REGION_3TELEPHONE_NUMBER_2LOV query:$column$.telephone_number_1TELEPHONE_NUMBER_1TELEPHONE_NUMBER_2LOV query:$column$.telephone_number_2TELEPHONE_NUMBER_2TELEPHONE_NUMBER_2LOV query:$column$.telephone_number_3TELEPHONE_NUMBER_3TELEPHONE_NUMBER_2LOV query:$column$.town_or_cityTOWN_OR_CITYTELEPHONE_NUMBER_2LOV query:$column$.address_line_1ADDRESS_LINE_1TELEPHONE_NUMBER_3LOV query:$column$.address_line_2ADDRESS_LINE_2TELEPHONE_NUMBER_3LOV query:$column$.address_line_3ADDRESS_LINE_3TELEPHONE_NUMBER_3LOV query:$column$.address_styleADDRESS_STYLETELEPHONE_NUMBER_3LOV query:$column$.countryCOUNTRYTELEPHONE_NUMBER_3LOV query:$column$.loc_information13LOC_INFORMATION13TELEPHONE_NUMBER_3LOV query:$column$.loc_information14LOC_INFORMATION14TELEPHONE_NUMBER_3LOV query:$column$.loc_information15LOC_INFORMATION15TELEPHONE_NUMBER_3LOV query:$column$.loc_information16LOC_INFORMATION16TELEPHONE_NUMBER_3LOV query:$column$.loc_information17LOC_INFORMATION17TELEPHONE_NUMBER_3LOV query:$column$.loc_information18LOC_INFORMATION18TELEPHONE_NUMBER_3LOV query:$column$.loc_information19LOC_INFORMATION19TELEPHONE_NUMBER_3LOV query:$column$.loc_information20LOC_INFORMATION20TELEPHONE_NUMBER_3LOV query:$column$.postal_codePOSTAL_CODETELEPHONE_NUMBER_3LOV query:$column$.region_1REGION_1TELEPHONE_NUMBER_3LOV query:$column$.region_2REGION_2TELEPHONE_NUMBER_3LOV query:$column$.region_3REGION_3TELEPHONE_NUMBER_3LOV query:$column$.telephone_number_1TELEPHONE_NUMBER_1TELEPHONE_NUMBER_3LOV query:$column$.telephone_number_2TELEPHONE_NUMBER_2TELEPHONE_NUMBER_3LOV query:$column$.telephone_number_3TELEPHONE_NUMBER_3TELEPHONE_NUMBER_3LOV query:$column$.town_or_cityTOWN_OR_CITYTELEPHONE_NUMBER_3LOV query:$column$.address_line_1ADDRESS_LINE_1TOWN_OR_CITYLOV query:$column$.address_line_2ADDRESS_LINE_2TOWN_OR_CITYLOV query:$column$.address_line_3ADDRESS_LINE_3TOWN_OR_CITYLOV query:$column$.address_styleADDRESS_STYLETOWN_OR_CITYLOV query:$column$.countryCOUNTRYTOWN_OR_CITYLOV query:$column$.loc_information13LOC_INFORMATION13TOWN_OR_CITYLOV query:$column$.loc_information14LOC_INFORMATION14TOWN_OR_CITYLOV query:$column$.loc_information15LOC_INFORMATION15TOWN_OR_CITYLOV query:$column$.loc_information16LOC_INFORMATION16TOWN_OR_CITYLOV query:$column$.loc_information17LOC_INFORMATION17TOWN_OR_CITYLOV query:$column$.loc_information18LOC_INFORMATION18TOWN_OR_CITYLOV query:$column$.loc_information19LOC_INFORMATION19TOWN_OR_CITYLOV query:$column$.loc_information20LOC_INFORMATION20TOWN_OR_CITYLOV query:$column$.postal_codePOSTAL_CODETOWN_OR_CITYLOV query:$column$.region_1REGION_1TOWN_OR_CITYLOV query:$column$.region_2REGION_2TOWN_OR_CITYLOV query:$column$.region_3REGION_3TOWN_OR_CITYLOV query:$column$.telephone_number_1TELEPHONE_NUMBER_1TOWN_OR_CITYLOV query:$column$.telephone_number_2TELEPHONE_NUMBER_2TOWN_OR_CITYLOV query:$column$.telephone_number_3TELEPHONE_NUMBER_3TOWN_OR_CITYLOV query:$column$.town_or_cityTOWN_OR_CITYTOWN_OR_CITYValue to id query:$column$.business_groupBUSINESS_GROUPp_ship_to_location_id