ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 22FFB94618DB3DA4E0630100007FD7CF AR Registry Status Y select 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 value US E811F942597A2075E0530100007FF4F2 Blitz Upload Mode Y select 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 US 8E2FF36EDE8379D2E0530100007F1FF2 Country Y select ftv.territory_short_name value, ftv.territory_code||': '||ftv.description description from fnd_territories_vl ftv order by ftv.territory_short_name US 0087D0A1D042F831E0630100007F0109 HR Location Y select 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_code US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 4F288F94CCB109E3E0630100007FECF2Y select 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(+) U A xxen_per_upload.create_update_location US PER Location Upload Upload 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. Enginatics R12 only Upload 1=1 1 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 Y select 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,U Y US Upload Mode 2 20 1=1 :default_address_style=:default_address_style LOV custom Y select 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 2 select 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') Y US Default Address Style 3 30 1=1 hla.location_code=:location_name LOV HR Location 0087D0A1D042F831E0630100007F0109 Y select 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_code US Location Name 4 40 1=1 lower(hla.location_code) like lower(:location_name_like) Char US Location Name Like 5 50 1=1 nvl(hla.inactive_date,trunc(sysdate))>=trunc(sysdate) LOV AR Registry Status 22FFB94618DB3DA4E0630100007FD7CF Y select 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 value A US Location Status 6 1=1 hla.inactive_date<trunc(sysdate) I US Location Status 7 60 1=1 hla.country=(select ftv.territory_code from fnd_territories_vl ftv where ftv.territory_short_name=:country) LOV Country 8E2FF36EDE8379D2E0530100007F1FF2 Y select ftv.territory_short_name value, ftv.territory_code||': '||ftv.description description from fnd_territories_vl ftv order by ftv.territory_short_name US Country 8 70 1=1 hla.business_group_id is null LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y US Global 9 1=1 hla.business_group_id=fnd_profile.value('PER_BUSINESS_GROUP_ID') N US Global 10 80 1=1 hla.legal_address_flag='Y' LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y US Legal Address 11 1=1 nvl(hla.legal_address_flag,'N')='N' N US Legal Address 12 90 1=1 hla.bill_to_site_flag=:bill_to_site LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Bill To Site 13 100 1=1 hla.ship_to_site_flag=:ship_to_site LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Ship To Site 14 110 1=1 hla.receiving_site_flag=:receiving_site LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Receiving Site 15 120 1=1 hla.in_organization_flag=:internal_site LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Internal Site 16 130 1=1 hla.office_site_flag=:office_site LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US Office Site 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 REQUEST_ID_ Char varchar2 Y 5 MODIFIED_COLUMNS_ Char varchar2 Y 6 LOCATION_ID Number number Y 7 LOCATION_CODE Char varchar2 60 Required. Unique identifier for the location. Used as the business key for matching existing locations on update. Y 8 DESCRIPTION Char varchar2 240 9 INACTIVE_DATE Date date Date the location becomes inactive. Cannot be set on locations flagged as Legal Address. 10 DELETE_LOCATION LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Set 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. 11 BUSINESS_GROUP LOV custom varchar2 240 Y select 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.name Read-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. Y 12 LEGAL_ADDRESS_FLAG LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Read-only. Set by the legal entity assignment process, not directly editable. When set to Yes, the Inactive Date field is protected. Y 13 ADDRESS_STYLE LOV custom varchar2 Y select 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 2 select 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_Style Determines the country-specific address format and which address fields are active and validated. Defaults from the Default Address Style report parameter. 14 ADDRESS_LINE_1 LOV custom varchar2 Y select 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 value select 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' 15 ADDRESS_LINE_2 LOV custom varchar2 Y select 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 value select 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' 16 ADDRESS_LINE_3 LOV custom varchar2 Y select 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 value select 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' 17 TOWN_OR_CITY LOV custom varchar2 Y select 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 value select 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' 18 REGION_1 LOV custom varchar2 Y select 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 value select 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' 19 REGION_2 LOV custom varchar2 Y select 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 value select 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' 20 REGION_3 LOV custom varchar2 Y select 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 value select 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' 21 POSTAL_CODE LOV custom varchar2 Y select 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 value select 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' 22 COUNTRY LOV custom varchar2 Y select 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 value select 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' 23 TELEPHONE_NUMBER_1 LOV custom varchar2 Y select 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 value select 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' 24 TELEPHONE_NUMBER_2 LOV custom varchar2 Y select 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 value select 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' 25 TELEPHONE_NUMBER_3 LOV custom varchar2 Y select 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 value select 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' 26 LOC_INFORMATION13 LOV custom varchar2 Y select 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 value select 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' 27 LOC_INFORMATION14 LOV custom varchar2 Y select 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 value select 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' 28 LOC_INFORMATION15 LOV custom varchar2 Y select 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 value select 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' 29 LOC_INFORMATION16 LOV custom varchar2 Y select 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 value select 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' 30 LOC_INFORMATION17 LOV custom varchar2 Y select 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 value select 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' 31 LOC_INFORMATION18 LOV custom varchar2 Y select 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 value select 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' 32 LOC_INFORMATION19 LOV custom varchar2 Y select 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 value select 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' 33 LOC_INFORMATION20 LOV custom varchar2 Y select 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 value select 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' 34 SHIP_TO_LOCATION LOV custom varchar2 60 Y select 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_code The ship-to location for this location. If left blank, defaults to the location itself (self-referencing). 35 SHIP_TO_SITE_FLAG LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Auto-corrected: automatically set to Yes when Ship To Location is self-referencing (blank or same as location), and No when pointing to another location. 36 RECEIVING_SITE_FLAG LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Auto-corrected: automatically set to Yes when Ship To Site Flag is Yes. 37 BILL_TO_SITE_FLAG LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 38 OFFICE_SITE_FLAG LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 39 IN_ORGANIZATION_FLAG LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 40 INVENTORY_ORGANIZATION LOV custom varchar2 3 Y select 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 2 41 CONTACT LOV custom varchar2 240 Y Y select 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_name The 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. 42 TIMEZONE_CODE LOV custom varchar2 80 Y select ftv.timezone_code id, ftv.name value, ftv.timezone_code description from fnd_timezones_vl ftv where ftv.enabled_flag='Y' order by 1 43 ECE_TP_LOCATION_CODE Char varchar2 35 44 LOC_ATTRIBUTE_CATEGORY LOV custom varchar2 Y select 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 2 45 LOC_ATTRIBUTE1 LOV custom varchar2 Y select 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 value select 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' 46 LOC_ATTRIBUTE2 LOV custom varchar2 Y select 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 value select 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' 47 LOC_ATTRIBUTE3 LOV custom varchar2 Y select 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 value select 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' 48 LOC_ATTRIBUTE4 LOV custom varchar2 Y select 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 value select 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' 49 LOC_ATTRIBUTE5 LOV custom varchar2 Y select 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 value select 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' 50 LOC_ATTRIBUTE6 LOV custom varchar2 Y select 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 value select 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' 51 LOC_ATTRIBUTE7 LOV custom varchar2 Y select 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 value select 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' 52 LOC_ATTRIBUTE8 LOV custom varchar2 Y select 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 value select 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' 53 LOC_ATTRIBUTE9 LOV custom varchar2 Y select 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 value select 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' 54 LOC_ATTRIBUTE10 LOV custom varchar2 Y select 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 value select 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' 55 LOC_ATTRIBUTE11 LOV custom varchar2 Y select 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 value select 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' 56 LOC_ATTRIBUTE12 LOV custom varchar2 Y select 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 value select 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' 57 LOC_ATTRIBUTE13 LOV custom varchar2 Y select 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 value select 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' 58 LOC_ATTRIBUTE14 LOV custom varchar2 Y select 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 value select 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' 59 LOC_ATTRIBUTE15 LOV custom varchar2 Y select 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 value select 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' 60 LOC_ATTRIBUTE16 LOV custom varchar2 Y select 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 value select 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' 61 LOC_ATTRIBUTE17 LOV custom varchar2 Y select 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 value select 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' 62 LOC_ATTRIBUTE18 LOV custom varchar2 Y select 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 value select 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' 63 LOC_ATTRIBUTE19 LOV custom varchar2 Y select 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 value select 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' 64 LOC_ATTRIBUTE20 LOV custom varchar2 Y select 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 value select 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' 65 UPLOAD_ROW Number number Y U 1 action_ in Char ACTION_CODE_ U 2 p_location_id in Number Y LOCATION_ID U 3 p_location_code in Char LOCATION_CODE U 4 p_description in Char Y DESCRIPTION U 5 p_inactive_date in Date Y INACTIVE_DATE U 6 p_delete_location in Char Y DELETE_LOCATION U 7 p_business_group_id in Number Y BUSINESS_GROUP U 8 p_address_style in Char Y ADDRESS_STYLE U 9 p_address_line_1 in Char Y ADDRESS_LINE_1 U 10 p_address_line_2 in Char Y ADDRESS_LINE_2 U 11 p_address_line_3 in Char Y ADDRESS_LINE_3 U 12 p_town_or_city in Char Y TOWN_OR_CITY U 13 p_region_1 in Char Y REGION_1 U 14 p_region_2 in Char Y REGION_2 U 15 p_region_3 in Char Y REGION_3 U 16 p_postal_code in Char Y POSTAL_CODE U 17 p_country in Char Y COUNTRY U 18 p_telephone_number_1 in Char Y TELEPHONE_NUMBER_1 U 19 p_telephone_number_2 in Char Y TELEPHONE_NUMBER_2 U 20 p_telephone_number_3 in Char Y TELEPHONE_NUMBER_3 U 21 p_loc_information13 in Char Y LOC_INFORMATION13 U 22 p_loc_information14 in Char Y LOC_INFORMATION14 U 23 p_loc_information15 in Char Y LOC_INFORMATION15 U 24 p_loc_information16 in Char Y LOC_INFORMATION16 U 25 p_loc_information17 in Char Y LOC_INFORMATION17 U 26 p_loc_information18 in Char Y LOC_INFORMATION18 U 27 p_loc_information19 in Char Y LOC_INFORMATION19 U 28 p_loc_information20 in Char Y LOC_INFORMATION20 U 29 p_ship_to_location_id in Number Y SHIP_TO_LOCATION U 30 p_ship_to_site_flag in Char Y SHIP_TO_SITE_FLAG U 31 p_receiving_site_flag in Char Y RECEIVING_SITE_FLAG U 32 p_bill_to_site_flag in Char Y BILL_TO_SITE_FLAG U 33 p_office_site_flag in Char Y OFFICE_SITE_FLAG U 34 p_in_organization_flag in Char Y IN_ORGANIZATION_FLAG U 35 p_inventory_organization_id in Number Y INVENTORY_ORGANIZATION U 36 p_designated_receiver_id in Number Y U 37 p_timezone_code in Char Y TIMEZONE_CODE U 38 p_ece_tp_location_code in Char Y ECE_TP_LOCATION_CODE U 39 p_loc_attribute_category in Char Y LOC_ATTRIBUTE_CATEGORY U 40 p_loc_attribute1 in Char Y LOC_ATTRIBUTE1 U 41 p_loc_attribute2 in Char Y LOC_ATTRIBUTE2 U 42 p_loc_attribute3 in Char Y LOC_ATTRIBUTE3 U 43 p_loc_attribute4 in Char Y LOC_ATTRIBUTE4 U 44 p_loc_attribute5 in Char Y LOC_ATTRIBUTE5 U 45 p_loc_attribute6 in Char Y LOC_ATTRIBUTE6 U 46 p_loc_attribute7 in Char Y LOC_ATTRIBUTE7 U 47 p_loc_attribute8 in Char Y LOC_ATTRIBUTE8 U 48 p_loc_attribute9 in Char Y LOC_ATTRIBUTE9 U 49 p_loc_attribute10 in Char Y LOC_ATTRIBUTE10 U 50 p_loc_attribute11 in Char Y LOC_ATTRIBUTE11 U 51 p_loc_attribute12 in Char Y LOC_ATTRIBUTE12 U 52 p_loc_attribute13 in Char Y LOC_ATTRIBUTE13 U 53 p_loc_attribute14 in Char Y LOC_ATTRIBUTE14 U 54 p_loc_attribute15 in Char Y LOC_ATTRIBUTE15 U 55 p_loc_attribute16 in Char Y LOC_ATTRIBUTE16 U 56 p_loc_attribute17 in Char Y LOC_ATTRIBUTE17 U 57 p_loc_attribute18 in Char Y LOC_ATTRIBUTE18 U 58 p_loc_attribute19 in Char Y LOC_ATTRIBUTE19 U 59 p_loc_attribute20 in Char Y LOC_ATTRIBUTE20 U 60 status_ out Char STATUS_CODE_ U 61 message_ out Char MESSAGE_ Error SQL Order By upload_row, location_code Success SQL select 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(+)