ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 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 8E2FF36EDEF279D2E0530100007F1FF2 INV Locator Type Y select flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='MTL_LOCATOR_TYPES' and flvv.view_application_id=700 and flvv.security_group_id=0 order by flvv.meaning US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 51606A566CE95385E0630100007FE296 select to_char(null) action_, to_char(null) status_, to_char(null) message_, null modified_columns_, milk.inventory_location_id, mp.organization_code, milk.subinventory_code subinventory, fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'ALL','N','VALUE','ALL_ENABLED') concatenated_segments, case when 1<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'1','N','VALUE','ALL_ENABLED') end loc_segment_dsp1, case when 2<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'2','N','VALUE','ALL_ENABLED') end loc_segment_dsp2, case when 3<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'3','N','VALUE','ALL_ENABLED') end loc_segment_dsp3, case when 4<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'4','N','VALUE','ALL_ENABLED') end loc_segment_dsp4, case when 5<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'5','N','VALUE','ALL_ENABLED') end loc_segment_dsp5, case when 6<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'6','N','VALUE','ALL_ENABLED') end loc_segment_dsp6, case when 7<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'7','N','VALUE','ALL_ENABLED') end loc_segment_dsp7, case when 8<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'8','N','VALUE','ALL_ENABLED') end loc_segment_dsp8, case when 9<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'9','N','VALUE','ALL_ENABLED') end loc_segment_dsp9, case when 10<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'10','N','VALUE','ALL_ENABLED') end loc_segment_dsp10, case when 11<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'11','N','VALUE','ALL_ENABLED') end loc_segment_dsp11, case when 12<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'12','N','VALUE','ALL_ENABLED') end loc_segment_dsp12, case when 13<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'13','N','VALUE','ALL_ENABLED') end loc_segment_dsp13, case when 14<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'14','N','VALUE','ALL_ENABLED') end loc_segment_dsp14, case when 15<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'15','N','VALUE','ALL_ENABLED') end loc_segment_dsp15, case when 16<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'16','N','VALUE','ALL_ENABLED') end loc_segment_dsp16, case when 17<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'17','N','VALUE','ALL_ENABLED') end loc_segment_dsp17, case when 18<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'18','N','VALUE','ALL_ENABLED') end loc_segment_dsp18, case when 19<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'19','N','VALUE','ALL_ENABLED') end loc_segment_dsp19, case when 20<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'20','N','VALUE','ALL_ENABLED') end loc_segment_dsp20, milk.description, xxen_util.meaning(to_char(milk.inventory_location_type),'MTL_LOCATOR_TYPES',700) type, mmsv.status_code status, milk.picking_order, milk.dropping_order, milk.alias, milk.disable_date, milk.location_maximum_units maximum_units, milk.volume_uom_code volume_uom, milk.max_cubic_area maximum_volume, milk.location_weight_uom_code weight_uom, milk.max_weight maximum_weight, milk.pick_uom_code pick_uom, milk.dimension_uom_code dimension_uom, milk.length dimension_length, milk.width dimension_width, milk.height dimension_height, milk.x_coordinate, milk.y_coordinate, milk.z_coordinate, xxen_util.display_flexfield_context(401,'MTL_ITEM_LOCATIONS',milk.attribute_category) attribute_category, xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE1',milk.rowid,milk.attribute1) loc_attribute1, xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE2',milk.rowid,milk.attribute2) loc_attribute2, xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE3',milk.rowid,milk.attribute3) loc_attribute3, xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE4',milk.rowid,milk.attribute4) loc_attribute4, xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE5',milk.rowid,milk.attribute5) loc_attribute5, xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE6',milk.rowid,milk.attribute6) loc_attribute6, xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE7',milk.rowid,milk.attribute7) loc_attribute7, xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE8',milk.rowid,milk.attribute8) loc_attribute8, xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE9',milk.rowid,milk.attribute9) loc_attribute9, xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE10',milk.rowid,milk.attribute10) loc_attribute10, xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE11',milk.rowid,milk.attribute11) loc_attribute11, xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE12',milk.rowid,milk.attribute12) loc_attribute12, xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE13',milk.rowid,milk.attribute13) loc_attribute13, xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE14',milk.rowid,milk.attribute14) loc_attribute14, xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE15',milk.rowid,milk.attribute15) loc_attribute15, to_char(null) delete_locator, to_number(null) upload_row from mtl_item_locations_kfv milk, mtl_parameters mp, mtl_material_statuses_vl mmsv where 1=1 and mp.organization_id=milk.organization_id and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and mmsv.status_id(+)=milk.status_id Initial version: stock locator create/update via INV_LOC_WMS_PUB Y U A xxen_inv_upload.upload_stock_locator US INV Stock Locator Upload Create, update and delete Stock Locators. Note on entering a locator as a concatenated segment value: if a segment value contains the KFF delimiter character or a backslash (\), each such character must be preceded with a backslash. For example, with delimiter '.', the segment value '1\4\4.' must be written as '1\\4\\4\.' Enginatics R12 only Upload 1=1 :project_display_seq :segment_count :task_display_seq 1 -30 :task_display_seq Number select y.display_index from ( select row_number() over (order by fifsg.segment_num) display_index, ffvs.flex_value_set_name from fnd_id_flex_segments fifsg, fnd_flex_value_sets ffvs where fifsg.application_id=401 and fifsg.id_flex_code='MTLL' and fifsg.id_flex_num=101 and fifsg.enabled_flag='Y' and fifsg.flex_value_set_id=ffvs.flex_value_set_id ) y where y.flex_value_set_name='PJM_TASK' US Task Display Seq 2 -20 :project_display_seq Number select y.display_index from ( select row_number() over (order by fifsg.segment_num) display_index, ffvs.flex_value_set_name from fnd_id_flex_segments fifsg, fnd_flex_value_sets ffvs where fifsg.application_id=401 and fifsg.id_flex_code='MTLL' and fifsg.id_flex_num=101 and fifsg.enabled_flag='Y' and fifsg.flex_value_set_id=ffvs.flex_value_set_id ) y where y.flex_value_set_name='PJM_PROJECT' US Project Display Seq 3 -10 :segment_count Number select count(*) from fnd_id_flex_segments fifsg where fifsg.application_id=401 and fifsg.id_flex_code='MTLL' and fifsg.id_flex_num=101 and fifsg.enabled_flag='Y' US Segment Count 4 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 5 20 1=1 mp.organization_code=:organization_code LOV custom Y select mp.organization_code value, haouv.name description from mtl_parameters mp, hr_all_organization_units_vl haouv where mp.organization_id=haouv.organization_id and mp.organization_id<>mp.master_organization_id and mp.stock_locator_control_code<>1 and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and nvl(haouv.date_to,sysdate)>=sysdate order by mp.organization_code select mp.organization_code from mtl_parameters mp where mp.organization_id=fnd_profile.value('MFG_ORGANIZATION_ID') US Organization Code 6 30 1=1 milk.subinventory_code=:subinventory_code LOV custom Y select msi.secondary_inventory_name value, msi.description from mtl_secondary_inventories msi, mtl_parameters mp where msi.organization_id=mp.organization_id and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') and msi.locator_type<>1 order by msi.secondary_inventory_name US Subinventory 7 35 1=1 fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'ALL','N','VALUE','ALL_ENABLED')=:locator LOV custom Y select fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'ALL','N','VALUE','ALL_ENABLED') value, milk.description from mtl_item_locations_kfv milk, mtl_parameters mp where mp.organization_id=milk.organization_id and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') and (:$flex$.subinventory is null or xxen_util.contains(:$flex$.subinventory,milk.subinventory_code)='Y') order by value US Locator 8 40 1=1 fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'ALL','N','VALUE','ALL_ENABLED')>=:locator_from LOV custom select fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'ALL','N','VALUE','ALL_ENABLED') value, milk.description from mtl_item_locations_kfv milk, mtl_parameters mp where mp.organization_id=milk.organization_id and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') and (:$flex$.subinventory is null or xxen_util.contains(:$flex$.subinventory,milk.subinventory_code)='Y') order by value US Locator From 9 45 1=1 fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'ALL','N','VALUE','ALL_ENABLED')<=:locator_to LOV custom select fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'ALL','N','VALUE','ALL_ENABLED') value, milk.description from mtl_item_locations_kfv milk, mtl_parameters mp where mp.organization_id=milk.organization_id and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and (:$flex$.organization_code is null or xxen_util.contains(:$flex$.organization_code,mp.organization_code)='Y') and (:$flex$.subinventory is null or xxen_util.contains(:$flex$.subinventory,milk.subinventory_code)='Y') order by value :$flex$.locator_from US Locator To 10 50 1=1 milk.inventory_location_type=to_number(xxen_util.lookup_code(:locator_type,'MTL_LOCATOR_TYPES',700)) LOV INV Locator Type 8E2FF36EDEF279D2E0530100007F1FF2 Y select flvv.meaning value, null description from fnd_lookup_values_vl flvv where flvv.lookup_type='MTL_LOCATOR_TYPES' and flvv.view_application_id=700 and flvv.security_group_id=0 order by flvv.meaning US Locator Type 11 60 1=1 mmsv.status_code=:material_status LOV custom Y select mmsv.status_code value, mmsv.description from mtl_material_statuses_vl mmsv where mmsv.locator_control=1 and mmsv.enabled_flag=1 order by mmsv.status_code US Material Status :$flex$.locator_from Locator From Locator To :$flex$.organization_code Organization Code Locator :$flex$.organization_code Organization Code Locator From :$flex$.organization_code Organization Code Locator To :$flex$.organization_code Organization Code Subinventory :$flex$.subinventory Subinventory Locator :$flex$.subinventory Subinventory Locator From :$flex$.subinventory Subinventory Locator To 524FA67DAA684D77E0630100007F51E7 Locator by concatenated segment ERIC.CLEGG 9 ALIAS 25 ATTRIBUTE_CATEGORY 3 CONCATENATED_SEGMENTS 11 DELETE_LOCATOR 4 DESCRIPTION 21 DIMENSION_HEIGHT 19 DIMENSION_LENGTH 18 DIMENSION_UOM 20 DIMENSION_WIDTH 10 DISABLE_DATE 8 DROPPING_ORDER 26 LOC_ATTRIBUTE1 35 LOC_ATTRIBUTE10 36 LOC_ATTRIBUTE11 37 LOC_ATTRIBUTE12 38 LOC_ATTRIBUTE13 39 LOC_ATTRIBUTE14 40 LOC_ATTRIBUTE15 27 LOC_ATTRIBUTE2 28 LOC_ATTRIBUTE3 29 LOC_ATTRIBUTE4 30 LOC_ATTRIBUTE5 31 LOC_ATTRIBUTE6 32 LOC_ATTRIBUTE7 33 LOC_ATTRIBUTE8 34 LOC_ATTRIBUTE9 12 MAXIMUM_UNITS 14 MAXIMUM_VOLUME 16 MAXIMUM_WEIGHT 1 ORGANIZATION_CODE 7 PICKING_ORDER 17 PICK_UOM 6 STATUS 2 SUBINVENTORY 5 TYPE 13 VOLUME_UOM 15 WEIGHT_UOM 22 X_COORDINATE 23 Y_COORDINATE 24 Z_COORDINATE S Site 524FA67DAA694D77E0630100007F51E7 Locator by individual segments ERIC.CLEGG 28 ALIAS 44 ATTRIBUTE_CATEGORY 30 DELETE_LOCATOR 23 DESCRIPTION 40 DIMENSION_HEIGHT 38 DIMENSION_LENGTH 37 DIMENSION_UOM 39 DIMENSION_WIDTH 29 DISABLE_DATE 27 DROPPING_ORDER 45 LOC_ATTRIBUTE1 54 LOC_ATTRIBUTE10 55 LOC_ATTRIBUTE11 56 LOC_ATTRIBUTE12 57 LOC_ATTRIBUTE13 58 LOC_ATTRIBUTE14 59 LOC_ATTRIBUTE15 46 LOC_ATTRIBUTE2 47 LOC_ATTRIBUTE3 48 LOC_ATTRIBUTE4 49 LOC_ATTRIBUTE5 50 LOC_ATTRIBUTE6 51 LOC_ATTRIBUTE7 52 LOC_ATTRIBUTE8 53 LOC_ATTRIBUTE9 3 LOC_SEGMENT_DSP1 12 LOC_SEGMENT_DSP10 13 LOC_SEGMENT_DSP11 14 LOC_SEGMENT_DSP12 15 LOC_SEGMENT_DSP13 16 LOC_SEGMENT_DSP14 17 LOC_SEGMENT_DSP15 18 LOC_SEGMENT_DSP16 19 LOC_SEGMENT_DSP17 20 LOC_SEGMENT_DSP18 21 LOC_SEGMENT_DSP19 4 LOC_SEGMENT_DSP2 22 LOC_SEGMENT_DSP20 5 LOC_SEGMENT_DSP3 6 LOC_SEGMENT_DSP4 7 LOC_SEGMENT_DSP5 8 LOC_SEGMENT_DSP6 9 LOC_SEGMENT_DSP7 10 LOC_SEGMENT_DSP8 11 LOC_SEGMENT_DSP9 31 MAXIMUM_UNITS 33 MAXIMUM_VOLUME 35 MAXIMUM_WEIGHT 1 ORGANIZATION_CODE 26 PICKING_ORDER 36 PICK_UOM 25 STATUS 2 SUBINVENTORY 24 TYPE 32 VOLUME_UOM 34 WEIGHT_UOM 41 X_COORDINATE 42 Y_COORDINATE 43 Z_COORDINATE S Site 524FA67DAA684D77E0630100007F51E7 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 MODIFIED_COLUMNS_ Char varchar2 Y 5 INVENTORY_LOCATION_ID Number number Internal identifier of the locator. Populated by the download for existing rows so the upload can correlate an update to the original record even when the user changes parts of the logical key (organization, concatenated segments). Re-populated by the upload API after a successful create/update/delete. Hidden from the user. Y 6 ORGANIZATION_CODE LOV custom varchar2 Y select mp.organization_id id, mp.organization_code value, haouv.name description from mtl_parameters mp, hr_all_organization_units_vl haouv where mp.organization_id=haouv.organization_id and mp.organization_id<>mp.master_organization_id and mp.stock_locator_control_code<>1 and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and nvl(haouv.date_to,sysdate)>=sysdate order by mp.organization_code Y Y 7 SUBINVENTORY LOV custom varchar2 Y select msi.secondary_inventory_name value, msi.description from mtl_secondary_inventories msi, mtl_parameters mp where msi.organization_id=mp.organization_id and mp.organization_code=:$column$.organization_code and msi.locator_type<>1 and (msi.disable_date is null or msi.disable_date>sysdate) order by msi.secondary_inventory_name Required on Create. Cannot be changed on Update — the Subinventory of a Locator is immutable in Oracle Inventory. Y Y 8 CONCATENATED_SEGMENTS Char varchar2 Enter the locator as a concatenated segment string (delimited by the Stock Locators KFF delimiter), or leave blank and enter the individual segments below. Cannot be changed after creation. Note on entering a locator as a concatenated segment value: if a segment value contains the KFF delimiter character or a backslash (\), each such character must be preceded with a backslash. For example, with delimiter '.', the segment value '1\4\4.' must be written as '1\\4\\4\.' Y 9 LOC_SEGMENT_DSP1 LOV custom varchar2 select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_flex_values_vl ffvv where 1 not in (nvl(:$flex$.project_display_seq,-1),nvl(:$flex$.task_display_seq,-1)) and ffvv.flex_value_set_id=( select y.flex_value_set_id from ( select fifsgv.flex_value_set_id, row_number() over (order by fifsgv.segment_num) display_index from fnd_id_flex_segments_vl fifsgv where fifsgv.application_id=401 and fifsgv.id_flex_code='MTLL' and fifsgv.id_flex_num=101 and fifsgv.enabled_flag='Y' ) y where y.display_index=1 ) union all select ppav.project_number value, ppav.project_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav where 1=:$flex$.project_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id union all select pt.task_number value, pt.task_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav, pjm_tasks_mtll_v pt where 1=:$flex$.task_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id and ppav.project_id=pt.project_id and ppav.project_number=case :$flex$.project_display_seq when 1 then :$column$.loc_segment_dsp1 when 2 then :$column$.loc_segment_dsp2 when 3 then :$column$.loc_segment_dsp3 when 4 then :$column$.loc_segment_dsp4 when 5 then :$column$.loc_segment_dsp5 when 6 then :$column$.loc_segment_dsp6 when 7 then :$column$.loc_segment_dsp7 when 8 then :$column$.loc_segment_dsp8 when 9 then :$column$.loc_segment_dsp9 when 10 then :$column$.loc_segment_dsp10 when 11 then :$column$.loc_segment_dsp11 when 12 then :$column$.loc_segment_dsp12 when 13 then :$column$.loc_segment_dsp13 when 14 then :$column$.loc_segment_dsp14 when 15 then :$column$.loc_segment_dsp15 when 16 then :$column$.loc_segment_dsp16 when 17 then :$column$.loc_segment_dsp17 when 18 then :$column$.loc_segment_dsp18 when 19 then :$column$.loc_segment_dsp19 when 20 then :$column$.loc_segment_dsp20 end order by value select xxen_inv_upload.kff_segment_dsp(:$column$.concatenated_segments,(select fifsv.concatenated_segment_delimiter from fnd_id_flex_structures_vl fifsv where fifsv.application_id=401 and fifsv.id_flex_code='MTLL' and fifsv.id_flex_num=101),1) from dual Y 10 LOC_SEGMENT_DSP2 LOV custom varchar2 select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_flex_values_vl ffvv where 2 not in (nvl(:$flex$.project_display_seq,-1),nvl(:$flex$.task_display_seq,-1)) and ffvv.flex_value_set_id=( select y.flex_value_set_id from ( select fifsgv.flex_value_set_id, row_number() over (order by fifsgv.segment_num) display_index from fnd_id_flex_segments_vl fifsgv where fifsgv.application_id=401 and fifsgv.id_flex_code='MTLL' and fifsgv.id_flex_num=101 and fifsgv.enabled_flag='Y' ) y where y.display_index=2 ) union all select ppav.project_number value, ppav.project_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav where 2=:$flex$.project_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id union all select pt.task_number value, pt.task_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav, pjm_tasks_mtll_v pt where 2=:$flex$.task_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id and ppav.project_id=pt.project_id and ppav.project_number=case :$flex$.project_display_seq when 1 then :$column$.loc_segment_dsp1 when 2 then :$column$.loc_segment_dsp2 when 3 then :$column$.loc_segment_dsp3 when 4 then :$column$.loc_segment_dsp4 when 5 then :$column$.loc_segment_dsp5 when 6 then :$column$.loc_segment_dsp6 when 7 then :$column$.loc_segment_dsp7 when 8 then :$column$.loc_segment_dsp8 when 9 then :$column$.loc_segment_dsp9 when 10 then :$column$.loc_segment_dsp10 when 11 then :$column$.loc_segment_dsp11 when 12 then :$column$.loc_segment_dsp12 when 13 then :$column$.loc_segment_dsp13 when 14 then :$column$.loc_segment_dsp14 when 15 then :$column$.loc_segment_dsp15 when 16 then :$column$.loc_segment_dsp16 when 17 then :$column$.loc_segment_dsp17 when 18 then :$column$.loc_segment_dsp18 when 19 then :$column$.loc_segment_dsp19 when 20 then :$column$.loc_segment_dsp20 end order by value select xxen_inv_upload.kff_segment_dsp(:$column$.concatenated_segments,(select fifsv.concatenated_segment_delimiter from fnd_id_flex_structures_vl fifsv where fifsv.application_id=401 and fifsv.id_flex_code='MTLL' and fifsv.id_flex_num=101),2) from dual Y 11 LOC_SEGMENT_DSP3 LOV custom varchar2 select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_flex_values_vl ffvv where 3 not in (nvl(:$flex$.project_display_seq,-1),nvl(:$flex$.task_display_seq,-1)) and ffvv.flex_value_set_id=( select y.flex_value_set_id from ( select fifsgv.flex_value_set_id, row_number() over (order by fifsgv.segment_num) display_index from fnd_id_flex_segments_vl fifsgv where fifsgv.application_id=401 and fifsgv.id_flex_code='MTLL' and fifsgv.id_flex_num=101 and fifsgv.enabled_flag='Y' ) y where y.display_index=3 ) union all select ppav.project_number value, ppav.project_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav where 3=:$flex$.project_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id union all select pt.task_number value, pt.task_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav, pjm_tasks_mtll_v pt where 3=:$flex$.task_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id and ppav.project_id=pt.project_id and ppav.project_number=case :$flex$.project_display_seq when 1 then :$column$.loc_segment_dsp1 when 2 then :$column$.loc_segment_dsp2 when 3 then :$column$.loc_segment_dsp3 when 4 then :$column$.loc_segment_dsp4 when 5 then :$column$.loc_segment_dsp5 when 6 then :$column$.loc_segment_dsp6 when 7 then :$column$.loc_segment_dsp7 when 8 then :$column$.loc_segment_dsp8 when 9 then :$column$.loc_segment_dsp9 when 10 then :$column$.loc_segment_dsp10 when 11 then :$column$.loc_segment_dsp11 when 12 then :$column$.loc_segment_dsp12 when 13 then :$column$.loc_segment_dsp13 when 14 then :$column$.loc_segment_dsp14 when 15 then :$column$.loc_segment_dsp15 when 16 then :$column$.loc_segment_dsp16 when 17 then :$column$.loc_segment_dsp17 when 18 then :$column$.loc_segment_dsp18 when 19 then :$column$.loc_segment_dsp19 when 20 then :$column$.loc_segment_dsp20 end order by value select xxen_inv_upload.kff_segment_dsp(:$column$.concatenated_segments,(select fifsv.concatenated_segment_delimiter from fnd_id_flex_structures_vl fifsv where fifsv.application_id=401 and fifsv.id_flex_code='MTLL' and fifsv.id_flex_num=101),3) from dual Y 12 LOC_SEGMENT_DSP4 LOV custom varchar2 select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_flex_values_vl ffvv where 4 not in (nvl(:$flex$.project_display_seq,-1),nvl(:$flex$.task_display_seq,-1)) and ffvv.flex_value_set_id=( select y.flex_value_set_id from ( select fifsgv.flex_value_set_id, row_number() over (order by fifsgv.segment_num) display_index from fnd_id_flex_segments_vl fifsgv where fifsgv.application_id=401 and fifsgv.id_flex_code='MTLL' and fifsgv.id_flex_num=101 and fifsgv.enabled_flag='Y' ) y where y.display_index=4 ) union all select ppav.project_number value, ppav.project_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav where 4=:$flex$.project_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id union all select pt.task_number value, pt.task_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav, pjm_tasks_mtll_v pt where 4=:$flex$.task_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id and ppav.project_id=pt.project_id and ppav.project_number=case :$flex$.project_display_seq when 1 then :$column$.loc_segment_dsp1 when 2 then :$column$.loc_segment_dsp2 when 3 then :$column$.loc_segment_dsp3 when 4 then :$column$.loc_segment_dsp4 when 5 then :$column$.loc_segment_dsp5 when 6 then :$column$.loc_segment_dsp6 when 7 then :$column$.loc_segment_dsp7 when 8 then :$column$.loc_segment_dsp8 when 9 then :$column$.loc_segment_dsp9 when 10 then :$column$.loc_segment_dsp10 when 11 then :$column$.loc_segment_dsp11 when 12 then :$column$.loc_segment_dsp12 when 13 then :$column$.loc_segment_dsp13 when 14 then :$column$.loc_segment_dsp14 when 15 then :$column$.loc_segment_dsp15 when 16 then :$column$.loc_segment_dsp16 when 17 then :$column$.loc_segment_dsp17 when 18 then :$column$.loc_segment_dsp18 when 19 then :$column$.loc_segment_dsp19 when 20 then :$column$.loc_segment_dsp20 end order by value select xxen_inv_upload.kff_segment_dsp(:$column$.concatenated_segments,(select fifsv.concatenated_segment_delimiter from fnd_id_flex_structures_vl fifsv where fifsv.application_id=401 and fifsv.id_flex_code='MTLL' and fifsv.id_flex_num=101),4) from dual Y 13 LOC_SEGMENT_DSP5 LOV custom varchar2 select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_flex_values_vl ffvv where 5 not in (nvl(:$flex$.project_display_seq,-1),nvl(:$flex$.task_display_seq,-1)) and ffvv.flex_value_set_id=( select y.flex_value_set_id from ( select fifsgv.flex_value_set_id, row_number() over (order by fifsgv.segment_num) display_index from fnd_id_flex_segments_vl fifsgv where fifsgv.application_id=401 and fifsgv.id_flex_code='MTLL' and fifsgv.id_flex_num=101 and fifsgv.enabled_flag='Y' ) y where y.display_index=5 ) union all select ppav.project_number value, ppav.project_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav where 5=:$flex$.project_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id union all select pt.task_number value, pt.task_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav, pjm_tasks_mtll_v pt where 5=:$flex$.task_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id and ppav.project_id=pt.project_id and ppav.project_number=case :$flex$.project_display_seq when 1 then :$column$.loc_segment_dsp1 when 2 then :$column$.loc_segment_dsp2 when 3 then :$column$.loc_segment_dsp3 when 4 then :$column$.loc_segment_dsp4 when 5 then :$column$.loc_segment_dsp5 when 6 then :$column$.loc_segment_dsp6 when 7 then :$column$.loc_segment_dsp7 when 8 then :$column$.loc_segment_dsp8 when 9 then :$column$.loc_segment_dsp9 when 10 then :$column$.loc_segment_dsp10 when 11 then :$column$.loc_segment_dsp11 when 12 then :$column$.loc_segment_dsp12 when 13 then :$column$.loc_segment_dsp13 when 14 then :$column$.loc_segment_dsp14 when 15 then :$column$.loc_segment_dsp15 when 16 then :$column$.loc_segment_dsp16 when 17 then :$column$.loc_segment_dsp17 when 18 then :$column$.loc_segment_dsp18 when 19 then :$column$.loc_segment_dsp19 when 20 then :$column$.loc_segment_dsp20 end order by value select xxen_inv_upload.kff_segment_dsp(:$column$.concatenated_segments,(select fifsv.concatenated_segment_delimiter from fnd_id_flex_structures_vl fifsv where fifsv.application_id=401 and fifsv.id_flex_code='MTLL' and fifsv.id_flex_num=101),5) from dual Y 14 LOC_SEGMENT_DSP6 LOV custom varchar2 select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_flex_values_vl ffvv where 6 not in (nvl(:$flex$.project_display_seq,-1),nvl(:$flex$.task_display_seq,-1)) and ffvv.flex_value_set_id=( select y.flex_value_set_id from ( select fifsgv.flex_value_set_id, row_number() over (order by fifsgv.segment_num) display_index from fnd_id_flex_segments_vl fifsgv where fifsgv.application_id=401 and fifsgv.id_flex_code='MTLL' and fifsgv.id_flex_num=101 and fifsgv.enabled_flag='Y' ) y where y.display_index=6 ) union all select ppav.project_number value, ppav.project_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav where 6=:$flex$.project_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id union all select pt.task_number value, pt.task_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav, pjm_tasks_mtll_v pt where 6=:$flex$.task_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id and ppav.project_id=pt.project_id and ppav.project_number=case :$flex$.project_display_seq when 1 then :$column$.loc_segment_dsp1 when 2 then :$column$.loc_segment_dsp2 when 3 then :$column$.loc_segment_dsp3 when 4 then :$column$.loc_segment_dsp4 when 5 then :$column$.loc_segment_dsp5 when 6 then :$column$.loc_segment_dsp6 when 7 then :$column$.loc_segment_dsp7 when 8 then :$column$.loc_segment_dsp8 when 9 then :$column$.loc_segment_dsp9 when 10 then :$column$.loc_segment_dsp10 when 11 then :$column$.loc_segment_dsp11 when 12 then :$column$.loc_segment_dsp12 when 13 then :$column$.loc_segment_dsp13 when 14 then :$column$.loc_segment_dsp14 when 15 then :$column$.loc_segment_dsp15 when 16 then :$column$.loc_segment_dsp16 when 17 then :$column$.loc_segment_dsp17 when 18 then :$column$.loc_segment_dsp18 when 19 then :$column$.loc_segment_dsp19 when 20 then :$column$.loc_segment_dsp20 end order by value select xxen_inv_upload.kff_segment_dsp(:$column$.concatenated_segments,(select fifsv.concatenated_segment_delimiter from fnd_id_flex_structures_vl fifsv where fifsv.application_id=401 and fifsv.id_flex_code='MTLL' and fifsv.id_flex_num=101),6) from dual Y 15 LOC_SEGMENT_DSP7 LOV custom varchar2 select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_flex_values_vl ffvv where 7 not in (nvl(:$flex$.project_display_seq,-1),nvl(:$flex$.task_display_seq,-1)) and ffvv.flex_value_set_id=( select y.flex_value_set_id from ( select fifsgv.flex_value_set_id, row_number() over (order by fifsgv.segment_num) display_index from fnd_id_flex_segments_vl fifsgv where fifsgv.application_id=401 and fifsgv.id_flex_code='MTLL' and fifsgv.id_flex_num=101 and fifsgv.enabled_flag='Y' ) y where y.display_index=7 ) union all select ppav.project_number value, ppav.project_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav where 7=:$flex$.project_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id union all select pt.task_number value, pt.task_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav, pjm_tasks_mtll_v pt where 7=:$flex$.task_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id and ppav.project_id=pt.project_id and ppav.project_number=case :$flex$.project_display_seq when 1 then :$column$.loc_segment_dsp1 when 2 then :$column$.loc_segment_dsp2 when 3 then :$column$.loc_segment_dsp3 when 4 then :$column$.loc_segment_dsp4 when 5 then :$column$.loc_segment_dsp5 when 6 then :$column$.loc_segment_dsp6 when 7 then :$column$.loc_segment_dsp7 when 8 then :$column$.loc_segment_dsp8 when 9 then :$column$.loc_segment_dsp9 when 10 then :$column$.loc_segment_dsp10 when 11 then :$column$.loc_segment_dsp11 when 12 then :$column$.loc_segment_dsp12 when 13 then :$column$.loc_segment_dsp13 when 14 then :$column$.loc_segment_dsp14 when 15 then :$column$.loc_segment_dsp15 when 16 then :$column$.loc_segment_dsp16 when 17 then :$column$.loc_segment_dsp17 when 18 then :$column$.loc_segment_dsp18 when 19 then :$column$.loc_segment_dsp19 when 20 then :$column$.loc_segment_dsp20 end order by value select xxen_inv_upload.kff_segment_dsp(:$column$.concatenated_segments,(select fifsv.concatenated_segment_delimiter from fnd_id_flex_structures_vl fifsv where fifsv.application_id=401 and fifsv.id_flex_code='MTLL' and fifsv.id_flex_num=101),7) from dual Y 16 LOC_SEGMENT_DSP8 LOV custom varchar2 select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_flex_values_vl ffvv where 8 not in (nvl(:$flex$.project_display_seq,-1),nvl(:$flex$.task_display_seq,-1)) and ffvv.flex_value_set_id=( select y.flex_value_set_id from ( select fifsgv.flex_value_set_id, row_number() over (order by fifsgv.segment_num) display_index from fnd_id_flex_segments_vl fifsgv where fifsgv.application_id=401 and fifsgv.id_flex_code='MTLL' and fifsgv.id_flex_num=101 and fifsgv.enabled_flag='Y' ) y where y.display_index=8 ) union all select ppav.project_number value, ppav.project_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav where 8=:$flex$.project_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id union all select pt.task_number value, pt.task_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav, pjm_tasks_mtll_v pt where 8=:$flex$.task_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id and ppav.project_id=pt.project_id and ppav.project_number=case :$flex$.project_display_seq when 1 then :$column$.loc_segment_dsp1 when 2 then :$column$.loc_segment_dsp2 when 3 then :$column$.loc_segment_dsp3 when 4 then :$column$.loc_segment_dsp4 when 5 then :$column$.loc_segment_dsp5 when 6 then :$column$.loc_segment_dsp6 when 7 then :$column$.loc_segment_dsp7 when 8 then :$column$.loc_segment_dsp8 when 9 then :$column$.loc_segment_dsp9 when 10 then :$column$.loc_segment_dsp10 when 11 then :$column$.loc_segment_dsp11 when 12 then :$column$.loc_segment_dsp12 when 13 then :$column$.loc_segment_dsp13 when 14 then :$column$.loc_segment_dsp14 when 15 then :$column$.loc_segment_dsp15 when 16 then :$column$.loc_segment_dsp16 when 17 then :$column$.loc_segment_dsp17 when 18 then :$column$.loc_segment_dsp18 when 19 then :$column$.loc_segment_dsp19 when 20 then :$column$.loc_segment_dsp20 end order by value select xxen_inv_upload.kff_segment_dsp(:$column$.concatenated_segments,(select fifsv.concatenated_segment_delimiter from fnd_id_flex_structures_vl fifsv where fifsv.application_id=401 and fifsv.id_flex_code='MTLL' and fifsv.id_flex_num=101),8) from dual Y 17 LOC_SEGMENT_DSP9 LOV custom varchar2 select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_flex_values_vl ffvv where 9 not in (nvl(:$flex$.project_display_seq,-1),nvl(:$flex$.task_display_seq,-1)) and ffvv.flex_value_set_id=( select y.flex_value_set_id from ( select fifsgv.flex_value_set_id, row_number() over (order by fifsgv.segment_num) display_index from fnd_id_flex_segments_vl fifsgv where fifsgv.application_id=401 and fifsgv.id_flex_code='MTLL' and fifsgv.id_flex_num=101 and fifsgv.enabled_flag='Y' ) y where y.display_index=9 ) union all select ppav.project_number value, ppav.project_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav where 9=:$flex$.project_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id union all select pt.task_number value, pt.task_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav, pjm_tasks_mtll_v pt where 9=:$flex$.task_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id and ppav.project_id=pt.project_id and ppav.project_number=case :$flex$.project_display_seq when 1 then :$column$.loc_segment_dsp1 when 2 then :$column$.loc_segment_dsp2 when 3 then :$column$.loc_segment_dsp3 when 4 then :$column$.loc_segment_dsp4 when 5 then :$column$.loc_segment_dsp5 when 6 then :$column$.loc_segment_dsp6 when 7 then :$column$.loc_segment_dsp7 when 8 then :$column$.loc_segment_dsp8 when 9 then :$column$.loc_segment_dsp9 when 10 then :$column$.loc_segment_dsp10 when 11 then :$column$.loc_segment_dsp11 when 12 then :$column$.loc_segment_dsp12 when 13 then :$column$.loc_segment_dsp13 when 14 then :$column$.loc_segment_dsp14 when 15 then :$column$.loc_segment_dsp15 when 16 then :$column$.loc_segment_dsp16 when 17 then :$column$.loc_segment_dsp17 when 18 then :$column$.loc_segment_dsp18 when 19 then :$column$.loc_segment_dsp19 when 20 then :$column$.loc_segment_dsp20 end order by value select xxen_inv_upload.kff_segment_dsp(:$column$.concatenated_segments,(select fifsv.concatenated_segment_delimiter from fnd_id_flex_structures_vl fifsv where fifsv.application_id=401 and fifsv.id_flex_code='MTLL' and fifsv.id_flex_num=101),9) from dual Y 18 LOC_SEGMENT_DSP10 LOV custom varchar2 select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_flex_values_vl ffvv where 10 not in (nvl(:$flex$.project_display_seq,-1),nvl(:$flex$.task_display_seq,-1)) and ffvv.flex_value_set_id=( select y.flex_value_set_id from ( select fifsgv.flex_value_set_id, row_number() over (order by fifsgv.segment_num) display_index from fnd_id_flex_segments_vl fifsgv where fifsgv.application_id=401 and fifsgv.id_flex_code='MTLL' and fifsgv.id_flex_num=101 and fifsgv.enabled_flag='Y' ) y where y.display_index=10 ) union all select ppav.project_number value, ppav.project_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav where 10=:$flex$.project_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id union all select pt.task_number value, pt.task_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav, pjm_tasks_mtll_v pt where 10=:$flex$.task_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id and ppav.project_id=pt.project_id and ppav.project_number=case :$flex$.project_display_seq when 1 then :$column$.loc_segment_dsp1 when 2 then :$column$.loc_segment_dsp2 when 3 then :$column$.loc_segment_dsp3 when 4 then :$column$.loc_segment_dsp4 when 5 then :$column$.loc_segment_dsp5 when 6 then :$column$.loc_segment_dsp6 when 7 then :$column$.loc_segment_dsp7 when 8 then :$column$.loc_segment_dsp8 when 9 then :$column$.loc_segment_dsp9 when 10 then :$column$.loc_segment_dsp10 when 11 then :$column$.loc_segment_dsp11 when 12 then :$column$.loc_segment_dsp12 when 13 then :$column$.loc_segment_dsp13 when 14 then :$column$.loc_segment_dsp14 when 15 then :$column$.loc_segment_dsp15 when 16 then :$column$.loc_segment_dsp16 when 17 then :$column$.loc_segment_dsp17 when 18 then :$column$.loc_segment_dsp18 when 19 then :$column$.loc_segment_dsp19 when 20 then :$column$.loc_segment_dsp20 end order by value select xxen_inv_upload.kff_segment_dsp(:$column$.concatenated_segments,(select fifsv.concatenated_segment_delimiter from fnd_id_flex_structures_vl fifsv where fifsv.application_id=401 and fifsv.id_flex_code='MTLL' and fifsv.id_flex_num=101),10) from dual Y 19 LOC_SEGMENT_DSP11 LOV custom varchar2 select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_flex_values_vl ffvv where 11 not in (nvl(:$flex$.project_display_seq,-1),nvl(:$flex$.task_display_seq,-1)) and ffvv.flex_value_set_id=( select y.flex_value_set_id from ( select fifsgv.flex_value_set_id, row_number() over (order by fifsgv.segment_num) display_index from fnd_id_flex_segments_vl fifsgv where fifsgv.application_id=401 and fifsgv.id_flex_code='MTLL' and fifsgv.id_flex_num=101 and fifsgv.enabled_flag='Y' ) y where y.display_index=11 ) union all select ppav.project_number value, ppav.project_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav where 11=:$flex$.project_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id union all select pt.task_number value, pt.task_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav, pjm_tasks_mtll_v pt where 11=:$flex$.task_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id and ppav.project_id=pt.project_id and ppav.project_number=case :$flex$.project_display_seq when 1 then :$column$.loc_segment_dsp1 when 2 then :$column$.loc_segment_dsp2 when 3 then :$column$.loc_segment_dsp3 when 4 then :$column$.loc_segment_dsp4 when 5 then :$column$.loc_segment_dsp5 when 6 then :$column$.loc_segment_dsp6 when 7 then :$column$.loc_segment_dsp7 when 8 then :$column$.loc_segment_dsp8 when 9 then :$column$.loc_segment_dsp9 when 10 then :$column$.loc_segment_dsp10 when 11 then :$column$.loc_segment_dsp11 when 12 then :$column$.loc_segment_dsp12 when 13 then :$column$.loc_segment_dsp13 when 14 then :$column$.loc_segment_dsp14 when 15 then :$column$.loc_segment_dsp15 when 16 then :$column$.loc_segment_dsp16 when 17 then :$column$.loc_segment_dsp17 when 18 then :$column$.loc_segment_dsp18 when 19 then :$column$.loc_segment_dsp19 when 20 then :$column$.loc_segment_dsp20 end order by value select xxen_inv_upload.kff_segment_dsp(:$column$.concatenated_segments,(select fifsv.concatenated_segment_delimiter from fnd_id_flex_structures_vl fifsv where fifsv.application_id=401 and fifsv.id_flex_code='MTLL' and fifsv.id_flex_num=101),11) from dual Y 20 LOC_SEGMENT_DSP12 LOV custom varchar2 select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_flex_values_vl ffvv where 12 not in (nvl(:$flex$.project_display_seq,-1),nvl(:$flex$.task_display_seq,-1)) and ffvv.flex_value_set_id=( select y.flex_value_set_id from ( select fifsgv.flex_value_set_id, row_number() over (order by fifsgv.segment_num) display_index from fnd_id_flex_segments_vl fifsgv where fifsgv.application_id=401 and fifsgv.id_flex_code='MTLL' and fifsgv.id_flex_num=101 and fifsgv.enabled_flag='Y' ) y where y.display_index=12 ) union all select ppav.project_number value, ppav.project_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav where 12=:$flex$.project_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id union all select pt.task_number value, pt.task_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav, pjm_tasks_mtll_v pt where 12=:$flex$.task_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id and ppav.project_id=pt.project_id and ppav.project_number=case :$flex$.project_display_seq when 1 then :$column$.loc_segment_dsp1 when 2 then :$column$.loc_segment_dsp2 when 3 then :$column$.loc_segment_dsp3 when 4 then :$column$.loc_segment_dsp4 when 5 then :$column$.loc_segment_dsp5 when 6 then :$column$.loc_segment_dsp6 when 7 then :$column$.loc_segment_dsp7 when 8 then :$column$.loc_segment_dsp8 when 9 then :$column$.loc_segment_dsp9 when 10 then :$column$.loc_segment_dsp10 when 11 then :$column$.loc_segment_dsp11 when 12 then :$column$.loc_segment_dsp12 when 13 then :$column$.loc_segment_dsp13 when 14 then :$column$.loc_segment_dsp14 when 15 then :$column$.loc_segment_dsp15 when 16 then :$column$.loc_segment_dsp16 when 17 then :$column$.loc_segment_dsp17 when 18 then :$column$.loc_segment_dsp18 when 19 then :$column$.loc_segment_dsp19 when 20 then :$column$.loc_segment_dsp20 end order by value select xxen_inv_upload.kff_segment_dsp(:$column$.concatenated_segments,(select fifsv.concatenated_segment_delimiter from fnd_id_flex_structures_vl fifsv where fifsv.application_id=401 and fifsv.id_flex_code='MTLL' and fifsv.id_flex_num=101),12) from dual Y 21 LOC_SEGMENT_DSP13 LOV custom varchar2 select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_flex_values_vl ffvv where 13 not in (nvl(:$flex$.project_display_seq,-1),nvl(:$flex$.task_display_seq,-1)) and ffvv.flex_value_set_id=( select y.flex_value_set_id from ( select fifsgv.flex_value_set_id, row_number() over (order by fifsgv.segment_num) display_index from fnd_id_flex_segments_vl fifsgv where fifsgv.application_id=401 and fifsgv.id_flex_code='MTLL' and fifsgv.id_flex_num=101 and fifsgv.enabled_flag='Y' ) y where y.display_index=13 ) union all select ppav.project_number value, ppav.project_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav where 13=:$flex$.project_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id union all select pt.task_number value, pt.task_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav, pjm_tasks_mtll_v pt where 13=:$flex$.task_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id and ppav.project_id=pt.project_id and ppav.project_number=case :$flex$.project_display_seq when 1 then :$column$.loc_segment_dsp1 when 2 then :$column$.loc_segment_dsp2 when 3 then :$column$.loc_segment_dsp3 when 4 then :$column$.loc_segment_dsp4 when 5 then :$column$.loc_segment_dsp5 when 6 then :$column$.loc_segment_dsp6 when 7 then :$column$.loc_segment_dsp7 when 8 then :$column$.loc_segment_dsp8 when 9 then :$column$.loc_segment_dsp9 when 10 then :$column$.loc_segment_dsp10 when 11 then :$column$.loc_segment_dsp11 when 12 then :$column$.loc_segment_dsp12 when 13 then :$column$.loc_segment_dsp13 when 14 then :$column$.loc_segment_dsp14 when 15 then :$column$.loc_segment_dsp15 when 16 then :$column$.loc_segment_dsp16 when 17 then :$column$.loc_segment_dsp17 when 18 then :$column$.loc_segment_dsp18 when 19 then :$column$.loc_segment_dsp19 when 20 then :$column$.loc_segment_dsp20 end order by value select xxen_inv_upload.kff_segment_dsp(:$column$.concatenated_segments,(select fifsv.concatenated_segment_delimiter from fnd_id_flex_structures_vl fifsv where fifsv.application_id=401 and fifsv.id_flex_code='MTLL' and fifsv.id_flex_num=101),13) from dual Y 22 LOC_SEGMENT_DSP14 LOV custom varchar2 select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_flex_values_vl ffvv where 14 not in (nvl(:$flex$.project_display_seq,-1),nvl(:$flex$.task_display_seq,-1)) and ffvv.flex_value_set_id=( select y.flex_value_set_id from ( select fifsgv.flex_value_set_id, row_number() over (order by fifsgv.segment_num) display_index from fnd_id_flex_segments_vl fifsgv where fifsgv.application_id=401 and fifsgv.id_flex_code='MTLL' and fifsgv.id_flex_num=101 and fifsgv.enabled_flag='Y' ) y where y.display_index=14 ) union all select ppav.project_number value, ppav.project_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav where 14=:$flex$.project_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id union all select pt.task_number value, pt.task_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav, pjm_tasks_mtll_v pt where 14=:$flex$.task_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id and ppav.project_id=pt.project_id and ppav.project_number=case :$flex$.project_display_seq when 1 then :$column$.loc_segment_dsp1 when 2 then :$column$.loc_segment_dsp2 when 3 then :$column$.loc_segment_dsp3 when 4 then :$column$.loc_segment_dsp4 when 5 then :$column$.loc_segment_dsp5 when 6 then :$column$.loc_segment_dsp6 when 7 then :$column$.loc_segment_dsp7 when 8 then :$column$.loc_segment_dsp8 when 9 then :$column$.loc_segment_dsp9 when 10 then :$column$.loc_segment_dsp10 when 11 then :$column$.loc_segment_dsp11 when 12 then :$column$.loc_segment_dsp12 when 13 then :$column$.loc_segment_dsp13 when 14 then :$column$.loc_segment_dsp14 when 15 then :$column$.loc_segment_dsp15 when 16 then :$column$.loc_segment_dsp16 when 17 then :$column$.loc_segment_dsp17 when 18 then :$column$.loc_segment_dsp18 when 19 then :$column$.loc_segment_dsp19 when 20 then :$column$.loc_segment_dsp20 end order by value select xxen_inv_upload.kff_segment_dsp(:$column$.concatenated_segments,(select fifsv.concatenated_segment_delimiter from fnd_id_flex_structures_vl fifsv where fifsv.application_id=401 and fifsv.id_flex_code='MTLL' and fifsv.id_flex_num=101),14) from dual Y 23 LOC_SEGMENT_DSP15 LOV custom varchar2 select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_flex_values_vl ffvv where 15 not in (nvl(:$flex$.project_display_seq,-1),nvl(:$flex$.task_display_seq,-1)) and ffvv.flex_value_set_id=( select y.flex_value_set_id from ( select fifsgv.flex_value_set_id, row_number() over (order by fifsgv.segment_num) display_index from fnd_id_flex_segments_vl fifsgv where fifsgv.application_id=401 and fifsgv.id_flex_code='MTLL' and fifsgv.id_flex_num=101 and fifsgv.enabled_flag='Y' ) y where y.display_index=15 ) union all select ppav.project_number value, ppav.project_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav where 15=:$flex$.project_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id union all select pt.task_number value, pt.task_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav, pjm_tasks_mtll_v pt where 15=:$flex$.task_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id and ppav.project_id=pt.project_id and ppav.project_number=case :$flex$.project_display_seq when 1 then :$column$.loc_segment_dsp1 when 2 then :$column$.loc_segment_dsp2 when 3 then :$column$.loc_segment_dsp3 when 4 then :$column$.loc_segment_dsp4 when 5 then :$column$.loc_segment_dsp5 when 6 then :$column$.loc_segment_dsp6 when 7 then :$column$.loc_segment_dsp7 when 8 then :$column$.loc_segment_dsp8 when 9 then :$column$.loc_segment_dsp9 when 10 then :$column$.loc_segment_dsp10 when 11 then :$column$.loc_segment_dsp11 when 12 then :$column$.loc_segment_dsp12 when 13 then :$column$.loc_segment_dsp13 when 14 then :$column$.loc_segment_dsp14 when 15 then :$column$.loc_segment_dsp15 when 16 then :$column$.loc_segment_dsp16 when 17 then :$column$.loc_segment_dsp17 when 18 then :$column$.loc_segment_dsp18 when 19 then :$column$.loc_segment_dsp19 when 20 then :$column$.loc_segment_dsp20 end order by value select xxen_inv_upload.kff_segment_dsp(:$column$.concatenated_segments,(select fifsv.concatenated_segment_delimiter from fnd_id_flex_structures_vl fifsv where fifsv.application_id=401 and fifsv.id_flex_code='MTLL' and fifsv.id_flex_num=101),15) from dual Y 24 LOC_SEGMENT_DSP16 LOV custom varchar2 select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_flex_values_vl ffvv where 16 not in (nvl(:$flex$.project_display_seq,-1),nvl(:$flex$.task_display_seq,-1)) and ffvv.flex_value_set_id=( select y.flex_value_set_id from ( select fifsgv.flex_value_set_id, row_number() over (order by fifsgv.segment_num) display_index from fnd_id_flex_segments_vl fifsgv where fifsgv.application_id=401 and fifsgv.id_flex_code='MTLL' and fifsgv.id_flex_num=101 and fifsgv.enabled_flag='Y' ) y where y.display_index=16 ) union all select ppav.project_number value, ppav.project_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav where 16=:$flex$.project_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id union all select pt.task_number value, pt.task_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav, pjm_tasks_mtll_v pt where 16=:$flex$.task_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id and ppav.project_id=pt.project_id and ppav.project_number=case :$flex$.project_display_seq when 1 then :$column$.loc_segment_dsp1 when 2 then :$column$.loc_segment_dsp2 when 3 then :$column$.loc_segment_dsp3 when 4 then :$column$.loc_segment_dsp4 when 5 then :$column$.loc_segment_dsp5 when 6 then :$column$.loc_segment_dsp6 when 7 then :$column$.loc_segment_dsp7 when 8 then :$column$.loc_segment_dsp8 when 9 then :$column$.loc_segment_dsp9 when 10 then :$column$.loc_segment_dsp10 when 11 then :$column$.loc_segment_dsp11 when 12 then :$column$.loc_segment_dsp12 when 13 then :$column$.loc_segment_dsp13 when 14 then :$column$.loc_segment_dsp14 when 15 then :$column$.loc_segment_dsp15 when 16 then :$column$.loc_segment_dsp16 when 17 then :$column$.loc_segment_dsp17 when 18 then :$column$.loc_segment_dsp18 when 19 then :$column$.loc_segment_dsp19 when 20 then :$column$.loc_segment_dsp20 end order by value select xxen_inv_upload.kff_segment_dsp(:$column$.concatenated_segments,(select fifsv.concatenated_segment_delimiter from fnd_id_flex_structures_vl fifsv where fifsv.application_id=401 and fifsv.id_flex_code='MTLL' and fifsv.id_flex_num=101),16) from dual Y 25 LOC_SEGMENT_DSP17 LOV custom varchar2 select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_flex_values_vl ffvv where 17 not in (nvl(:$flex$.project_display_seq,-1),nvl(:$flex$.task_display_seq,-1)) and ffvv.flex_value_set_id=( select y.flex_value_set_id from ( select fifsgv.flex_value_set_id, row_number() over (order by fifsgv.segment_num) display_index from fnd_id_flex_segments_vl fifsgv where fifsgv.application_id=401 and fifsgv.id_flex_code='MTLL' and fifsgv.id_flex_num=101 and fifsgv.enabled_flag='Y' ) y where y.display_index=17 ) union all select ppav.project_number value, ppav.project_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav where 17=:$flex$.project_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id union all select pt.task_number value, pt.task_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav, pjm_tasks_mtll_v pt where 17=:$flex$.task_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id and ppav.project_id=pt.project_id and ppav.project_number=case :$flex$.project_display_seq when 1 then :$column$.loc_segment_dsp1 when 2 then :$column$.loc_segment_dsp2 when 3 then :$column$.loc_segment_dsp3 when 4 then :$column$.loc_segment_dsp4 when 5 then :$column$.loc_segment_dsp5 when 6 then :$column$.loc_segment_dsp6 when 7 then :$column$.loc_segment_dsp7 when 8 then :$column$.loc_segment_dsp8 when 9 then :$column$.loc_segment_dsp9 when 10 then :$column$.loc_segment_dsp10 when 11 then :$column$.loc_segment_dsp11 when 12 then :$column$.loc_segment_dsp12 when 13 then :$column$.loc_segment_dsp13 when 14 then :$column$.loc_segment_dsp14 when 15 then :$column$.loc_segment_dsp15 when 16 then :$column$.loc_segment_dsp16 when 17 then :$column$.loc_segment_dsp17 when 18 then :$column$.loc_segment_dsp18 when 19 then :$column$.loc_segment_dsp19 when 20 then :$column$.loc_segment_dsp20 end order by value select xxen_inv_upload.kff_segment_dsp(:$column$.concatenated_segments,(select fifsv.concatenated_segment_delimiter from fnd_id_flex_structures_vl fifsv where fifsv.application_id=401 and fifsv.id_flex_code='MTLL' and fifsv.id_flex_num=101),17) from dual Y 26 LOC_SEGMENT_DSP18 LOV custom varchar2 select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_flex_values_vl ffvv where 18 not in (nvl(:$flex$.project_display_seq,-1),nvl(:$flex$.task_display_seq,-1)) and ffvv.flex_value_set_id=( select y.flex_value_set_id from ( select fifsgv.flex_value_set_id, row_number() over (order by fifsgv.segment_num) display_index from fnd_id_flex_segments_vl fifsgv where fifsgv.application_id=401 and fifsgv.id_flex_code='MTLL' and fifsgv.id_flex_num=101 and fifsgv.enabled_flag='Y' ) y where y.display_index=18 ) union all select ppav.project_number value, ppav.project_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav where 18=:$flex$.project_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id union all select pt.task_number value, pt.task_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav, pjm_tasks_mtll_v pt where 18=:$flex$.task_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id and ppav.project_id=pt.project_id and ppav.project_number=case :$flex$.project_display_seq when 1 then :$column$.loc_segment_dsp1 when 2 then :$column$.loc_segment_dsp2 when 3 then :$column$.loc_segment_dsp3 when 4 then :$column$.loc_segment_dsp4 when 5 then :$column$.loc_segment_dsp5 when 6 then :$column$.loc_segment_dsp6 when 7 then :$column$.loc_segment_dsp7 when 8 then :$column$.loc_segment_dsp8 when 9 then :$column$.loc_segment_dsp9 when 10 then :$column$.loc_segment_dsp10 when 11 then :$column$.loc_segment_dsp11 when 12 then :$column$.loc_segment_dsp12 when 13 then :$column$.loc_segment_dsp13 when 14 then :$column$.loc_segment_dsp14 when 15 then :$column$.loc_segment_dsp15 when 16 then :$column$.loc_segment_dsp16 when 17 then :$column$.loc_segment_dsp17 when 18 then :$column$.loc_segment_dsp18 when 19 then :$column$.loc_segment_dsp19 when 20 then :$column$.loc_segment_dsp20 end order by value select xxen_inv_upload.kff_segment_dsp(:$column$.concatenated_segments,(select fifsv.concatenated_segment_delimiter from fnd_id_flex_structures_vl fifsv where fifsv.application_id=401 and fifsv.id_flex_code='MTLL' and fifsv.id_flex_num=101),18) from dual Y 27 LOC_SEGMENT_DSP19 LOV custom varchar2 select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_flex_values_vl ffvv where 19 not in (nvl(:$flex$.project_display_seq,-1),nvl(:$flex$.task_display_seq,-1)) and ffvv.flex_value_set_id=( select y.flex_value_set_id from ( select fifsgv.flex_value_set_id, row_number() over (order by fifsgv.segment_num) display_index from fnd_id_flex_segments_vl fifsgv where fifsgv.application_id=401 and fifsgv.id_flex_code='MTLL' and fifsgv.id_flex_num=101 and fifsgv.enabled_flag='Y' ) y where y.display_index=19 ) union all select ppav.project_number value, ppav.project_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav where 19=:$flex$.project_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id union all select pt.task_number value, pt.task_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav, pjm_tasks_mtll_v pt where 19=:$flex$.task_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id and ppav.project_id=pt.project_id and ppav.project_number=case :$flex$.project_display_seq when 1 then :$column$.loc_segment_dsp1 when 2 then :$column$.loc_segment_dsp2 when 3 then :$column$.loc_segment_dsp3 when 4 then :$column$.loc_segment_dsp4 when 5 then :$column$.loc_segment_dsp5 when 6 then :$column$.loc_segment_dsp6 when 7 then :$column$.loc_segment_dsp7 when 8 then :$column$.loc_segment_dsp8 when 9 then :$column$.loc_segment_dsp9 when 10 then :$column$.loc_segment_dsp10 when 11 then :$column$.loc_segment_dsp11 when 12 then :$column$.loc_segment_dsp12 when 13 then :$column$.loc_segment_dsp13 when 14 then :$column$.loc_segment_dsp14 when 15 then :$column$.loc_segment_dsp15 when 16 then :$column$.loc_segment_dsp16 when 17 then :$column$.loc_segment_dsp17 when 18 then :$column$.loc_segment_dsp18 when 19 then :$column$.loc_segment_dsp19 when 20 then :$column$.loc_segment_dsp20 end order by value select xxen_inv_upload.kff_segment_dsp(:$column$.concatenated_segments,(select fifsv.concatenated_segment_delimiter from fnd_id_flex_structures_vl fifsv where fifsv.application_id=401 and fifsv.id_flex_code='MTLL' and fifsv.id_flex_num=101),19) from dual Y 28 LOC_SEGMENT_DSP20 LOV custom varchar2 select ffvv.flex_value value, ffvv.description||case when ffvv.enabled_flag='Y' and sysdate between nvl(ffvv.start_date_active,sysdate) and nvl(ffvv.end_date_active,sysdate) then null else ' (inactive)' end description from fnd_flex_values_vl ffvv where 20 not in (nvl(:$flex$.project_display_seq,-1),nvl(:$flex$.task_display_seq,-1)) and ffvv.flex_value_set_id=( select y.flex_value_set_id from ( select fifsgv.flex_value_set_id, row_number() over (order by fifsgv.segment_num) display_index from fnd_id_flex_segments_vl fifsgv where fifsgv.application_id=401 and fifsgv.id_flex_code='MTLL' and fifsgv.id_flex_num=101 and fifsgv.enabled_flag='Y' ) y where y.display_index=20 ) union all select ppav.project_number value, ppav.project_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav where 20=:$flex$.project_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id union all select pt.task_number value, pt.task_name description from mtl_parameters mp, pjm_project_parameters ppp, pjm_projects_all_v ppav, pjm_tasks_mtll_v pt where 20=:$flex$.task_display_seq and mp.organization_code=:$column$.organization_code and mp.project_reference_enabled=1 and mp.organization_id=ppp.organization_id and ppp.project_id=ppav.project_id and ppav.project_id=pt.project_id and ppav.project_number=case :$flex$.project_display_seq when 1 then :$column$.loc_segment_dsp1 when 2 then :$column$.loc_segment_dsp2 when 3 then :$column$.loc_segment_dsp3 when 4 then :$column$.loc_segment_dsp4 when 5 then :$column$.loc_segment_dsp5 when 6 then :$column$.loc_segment_dsp6 when 7 then :$column$.loc_segment_dsp7 when 8 then :$column$.loc_segment_dsp8 when 9 then :$column$.loc_segment_dsp9 when 10 then :$column$.loc_segment_dsp10 when 11 then :$column$.loc_segment_dsp11 when 12 then :$column$.loc_segment_dsp12 when 13 then :$column$.loc_segment_dsp13 when 14 then :$column$.loc_segment_dsp14 when 15 then :$column$.loc_segment_dsp15 when 16 then :$column$.loc_segment_dsp16 when 17 then :$column$.loc_segment_dsp17 when 18 then :$column$.loc_segment_dsp18 when 19 then :$column$.loc_segment_dsp19 when 20 then :$column$.loc_segment_dsp20 end order by value select xxen_inv_upload.kff_segment_dsp(:$column$.concatenated_segments,(select fifsv.concatenated_segment_delimiter from fnd_id_flex_structures_vl fifsv where fifsv.application_id=401 and fifsv.id_flex_code='MTLL' and fifsv.id_flex_num=101),20) from dual Y 29 DESCRIPTION Char varchar2 30 TYPE LOV custom varchar2 Y select to_number(ml.lookup_code) id, ml.meaning value, ml.description from mfg_lookups ml, mtl_parameters mp, mtl_secondary_inventories msi where ml.lookup_type='MTL_LOCATOR_TYPES' and ml.enabled_flag='Y' and sysdate between nvl(ml.start_date_active,sysdate) and nvl(ml.end_date_active,sysdate) and mp.organization_code=:$column$.organization_code and msi.organization_id=mp.organization_id and msi.secondary_inventory_name=:$column$.subinventory and not (msi.subinventory_type=1 and ml.lookup_code in ('6','7')) and not (msi.subinventory_type=2 and ml.lookup_code='3') order by ml.lookup_code 31 STATUS LOV custom varchar2 Y select mmsv.status_id id, mmsv.status_code value, mmsv.description from mtl_material_statuses_vl mmsv where mmsv.locator_control=1 and mmsv.enabled_flag=1 order by mmsv.status_code select mmsv.status_code from mtl_material_statuses_vl mmsv where mmsv.status_id=1 Y 32 PICKING_ORDER Number number 33 DROPPING_ORDER Number number 34 ALIAS Char varchar2 35 DISABLE_DATE Date date Inactive On date. When set, the locator becomes disabled on the given date. Must be greater than or equal to yesterday. 36 MAXIMUM_UNITS Number number 37 VOLUME_UOM LOV custom varchar2 Y select muomv.uom_code value, muomv.unit_of_measure||' ('||muomv.uom_class||')' description from mtl_units_of_measure_vl muomv where muomv.disable_date is null or muomv.disable_date>sysdate order by muomv.uom_code 38 MAXIMUM_VOLUME Number number 39 WEIGHT_UOM LOV custom varchar2 Y select muomv.uom_code value, muomv.unit_of_measure||' ('||muomv.uom_class||')' description from mtl_units_of_measure_vl muomv where muomv.disable_date is null or muomv.disable_date>sysdate order by muomv.uom_code 40 MAXIMUM_WEIGHT Number number 41 PICK_UOM LOV custom varchar2 Y select muomv.uom_code value, muomv.unit_of_measure||' ('||muomv.uom_class||')' description from mtl_units_of_measure_vl muomv where muomv.disable_date is null or muomv.disable_date>sysdate order by muomv.uom_code Pick UOM applies only to WMS-enabled organizations. 42 DIMENSION_UOM LOV custom varchar2 Y select muomv.uom_code value, muomv.unit_of_measure||' ('||muomv.uom_class||')' description from mtl_units_of_measure_vl muomv where muomv.disable_date is null or muomv.disable_date>sysdate order by muomv.uom_code 43 DIMENSION_LENGTH Number number 44 DIMENSION_WIDTH Number number 45 DIMENSION_HEIGHT Number number 46 X_COORDINATE Number number 47 Y_COORDINATE Number number 48 Z_COORDINATE Number number 49 ATTRIBUTE_CATEGORY LOV custom varchar2 Y select fdfcv.descriptive_flex_context_name value, fdfcv.description from fnd_descr_flex_contexts_vl fdfcv where fdfcv.application_id=401 and fdfcv.descriptive_flexfield_name='MTL_ITEM_LOCATIONS' and fdfcv.descriptive_flex_context_code<>'Global Data Elements' and fdfcv.enabled_flag='Y' order by fdfcv.descriptive_flex_context_name Descriptive Flexfield context for MTL_ITEM_LOCATIONS. 50 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=>401, p_descriptive_flexfield_name=>'MTL_ITEM_LOCATIONS', p_context_name=>:$column$.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 ) ) lov 51 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=>401, p_descriptive_flexfield_name=>'MTL_ITEM_LOCATIONS', p_context_name=>:$column$.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 ) ) lov 52 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=>401, p_descriptive_flexfield_name=>'MTL_ITEM_LOCATIONS', p_context_name=>:$column$.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 ) ) lov 53 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=>401, p_descriptive_flexfield_name=>'MTL_ITEM_LOCATIONS', p_context_name=>:$column$.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 ) ) lov 54 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=>401, p_descriptive_flexfield_name=>'MTL_ITEM_LOCATIONS', p_context_name=>:$column$.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 ) ) lov 55 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=>401, p_descriptive_flexfield_name=>'MTL_ITEM_LOCATIONS', p_context_name=>:$column$.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 ) ) lov 56 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=>401, p_descriptive_flexfield_name=>'MTL_ITEM_LOCATIONS', p_context_name=>:$column$.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 ) ) lov 57 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=>401, p_descriptive_flexfield_name=>'MTL_ITEM_LOCATIONS', p_context_name=>:$column$.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 ) ) lov 58 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=>401, p_descriptive_flexfield_name=>'MTL_ITEM_LOCATIONS', p_context_name=>:$column$.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 ) ) lov 59 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=>401, p_descriptive_flexfield_name=>'MTL_ITEM_LOCATIONS', p_context_name=>:$column$.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 ) ) lov 60 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=>401, p_descriptive_flexfield_name=>'MTL_ITEM_LOCATIONS', p_context_name=>:$column$.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 ) ) lov 61 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=>401, p_descriptive_flexfield_name=>'MTL_ITEM_LOCATIONS', p_context_name=>:$column$.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 ) ) lov 62 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=>401, p_descriptive_flexfield_name=>'MTL_ITEM_LOCATIONS', p_context_name=>:$column$.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 ) ) lov 63 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=>401, p_descriptive_flexfield_name=>'MTL_ITEM_LOCATIONS', p_context_name=>:$column$.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 ) ) lov 64 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=>401, p_descriptive_flexfield_name=>'MTL_ITEM_LOCATIONS', p_context_name=>:$column$.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 ) ) lov 65 DELETE_LOCATOR 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 existing locator. Oracle will refuse the delete if the locator has dependent transactions. 66 UPLOAD_ROW Number number Y U 1 action_ in Char ACTION_CODE_ U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 4 p_inventory_location_id in Number Y INVENTORY_LOCATION_ID U 5 p_organization_id in Number ORGANIZATION_CODE U 6 p_concatenated_segments in Char CONCATENATED_SEGMENTS U 7 p_loc_segment_dsp1 in Char LOC_SEGMENT_DSP1 U 8 p_loc_segment_dsp2 in Char LOC_SEGMENT_DSP2 U 9 p_loc_segment_dsp3 in Char LOC_SEGMENT_DSP3 U 10 p_loc_segment_dsp4 in Char LOC_SEGMENT_DSP4 U 11 p_loc_segment_dsp5 in Char LOC_SEGMENT_DSP5 U 12 p_loc_segment_dsp6 in Char LOC_SEGMENT_DSP6 U 13 p_loc_segment_dsp7 in Char LOC_SEGMENT_DSP7 U 14 p_loc_segment_dsp8 in Char LOC_SEGMENT_DSP8 U 15 p_loc_segment_dsp9 in Char LOC_SEGMENT_DSP9 U 16 p_loc_segment_dsp10 in Char LOC_SEGMENT_DSP10 U 17 p_loc_segment_dsp11 in Char LOC_SEGMENT_DSP11 U 18 p_loc_segment_dsp12 in Char LOC_SEGMENT_DSP12 U 19 p_loc_segment_dsp13 in Char LOC_SEGMENT_DSP13 U 20 p_loc_segment_dsp14 in Char LOC_SEGMENT_DSP14 U 21 p_loc_segment_dsp15 in Char LOC_SEGMENT_DSP15 U 22 p_loc_segment_dsp16 in Char LOC_SEGMENT_DSP16 U 23 p_loc_segment_dsp17 in Char LOC_SEGMENT_DSP17 U 24 p_loc_segment_dsp18 in Char LOC_SEGMENT_DSP18 U 25 p_loc_segment_dsp19 in Char LOC_SEGMENT_DSP19 U 26 p_loc_segment_dsp20 in Char LOC_SEGMENT_DSP20 U 27 p_description in Char DESCRIPTION U 28 p_inventory_location_type in Number TYPE U 29 p_status_id in Number STATUS U 30 p_subinventory_code in Char SUBINVENTORY U 31 p_picking_order in Number PICKING_ORDER U 32 p_dropping_order in Number DROPPING_ORDER U 33 p_alias in Char ALIAS U 34 p_disable_date in Date DISABLE_DATE U 35 p_location_maximum_units in Number MAXIMUM_UNITS U 36 p_max_cubic_area in Number MAXIMUM_VOLUME U 37 p_volume_uom_code in Char VOLUME_UOM U 38 p_max_weight in Number MAXIMUM_WEIGHT U 39 p_location_weight_uom_code in Char WEIGHT_UOM U 40 p_pick_uom_code in Char PICK_UOM U 41 p_dimension_uom_code in Char DIMENSION_UOM U 42 p_length in Number DIMENSION_LENGTH U 43 p_width in Number DIMENSION_WIDTH U 44 p_height in Number DIMENSION_HEIGHT U 45 p_x_coordinate in Number X_COORDINATE U 46 p_y_coordinate in Number Y_COORDINATE U 47 p_z_coordinate in Number Z_COORDINATE U 48 p_attribute_category in Char ATTRIBUTE_CATEGORY U 49 p_loc_attribute1 in Char LOC_ATTRIBUTE1 U 50 p_loc_attribute2 in Char LOC_ATTRIBUTE2 U 51 p_loc_attribute3 in Char LOC_ATTRIBUTE3 U 52 p_loc_attribute4 in Char LOC_ATTRIBUTE4 U 53 p_loc_attribute5 in Char LOC_ATTRIBUTE5 U 54 p_loc_attribute6 in Char LOC_ATTRIBUTE6 U 55 p_loc_attribute7 in Char LOC_ATTRIBUTE7 U 56 p_loc_attribute8 in Char LOC_ATTRIBUTE8 U 57 p_loc_attribute9 in Char LOC_ATTRIBUTE9 U 58 p_loc_attribute10 in Char LOC_ATTRIBUTE10 U 59 p_loc_attribute11 in Char LOC_ATTRIBUTE11 U 60 p_loc_attribute12 in Char LOC_ATTRIBUTE12 U 61 p_loc_attribute13 in Char LOC_ATTRIBUTE13 U 62 p_loc_attribute14 in Char LOC_ATTRIBUTE14 U 63 p_loc_attribute15 in Char LOC_ATTRIBUTE15 U 64 p_delete_locator in Char DELETE_LOCATOR U 65 p_inventory_location_id_out out Number INVENTORY_LOCATION_ID Error SQL Order By upload_row, organization_code, subinventory, concatenated_segments Success SQL select xu.action_, xu.status_, xu.message_, xu.modified_columns_, nvl(milk.inventory_location_id,xu.inventory_location_id) inventory_location_id, nvl(mp.organization_code,xu.organization_code) organization_code, nvl(milk.subinventory_code,xu.subinventory) subinventory, nvl2(milk.inventory_location_id,fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'ALL','N','VALUE','ALL_ENABLED'),xu.concatenated_segments) concatenated_segments, nvl2(milk.inventory_location_id,case when 1<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'1','N','VALUE','ALL_ENABLED') end,xu.loc_segment_dsp1) loc_segment_dsp1, nvl2(milk.inventory_location_id,case when 2<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'2','N','VALUE','ALL_ENABLED') end,xu.loc_segment_dsp2) loc_segment_dsp2, nvl2(milk.inventory_location_id,case when 3<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'3','N','VALUE','ALL_ENABLED') end,xu.loc_segment_dsp3) loc_segment_dsp3, nvl2(milk.inventory_location_id,case when 4<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'4','N','VALUE','ALL_ENABLED') end,xu.loc_segment_dsp4) loc_segment_dsp4, nvl2(milk.inventory_location_id,case when 5<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'5','N','VALUE','ALL_ENABLED') end,xu.loc_segment_dsp5) loc_segment_dsp5, nvl2(milk.inventory_location_id,case when 6<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'6','N','VALUE','ALL_ENABLED') end,xu.loc_segment_dsp6) loc_segment_dsp6, nvl2(milk.inventory_location_id,case when 7<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'7','N','VALUE','ALL_ENABLED') end,xu.loc_segment_dsp7) loc_segment_dsp7, nvl2(milk.inventory_location_id,case when 8<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'8','N','VALUE','ALL_ENABLED') end,xu.loc_segment_dsp8) loc_segment_dsp8, nvl2(milk.inventory_location_id,case when 9<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'9','N','VALUE','ALL_ENABLED') end,xu.loc_segment_dsp9) loc_segment_dsp9, nvl2(milk.inventory_location_id,case when 10<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'10','N','VALUE','ALL_ENABLED') end,xu.loc_segment_dsp10) loc_segment_dsp10, nvl2(milk.inventory_location_id,case when 11<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'11','N','VALUE','ALL_ENABLED') end,xu.loc_segment_dsp11) loc_segment_dsp11, nvl2(milk.inventory_location_id,case when 12<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'12','N','VALUE','ALL_ENABLED') end,xu.loc_segment_dsp12) loc_segment_dsp12, nvl2(milk.inventory_location_id,case when 13<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'13','N','VALUE','ALL_ENABLED') end,xu.loc_segment_dsp13) loc_segment_dsp13, nvl2(milk.inventory_location_id,case when 14<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'14','N','VALUE','ALL_ENABLED') end,xu.loc_segment_dsp14) loc_segment_dsp14, nvl2(milk.inventory_location_id,case when 15<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'15','N','VALUE','ALL_ENABLED') end,xu.loc_segment_dsp15) loc_segment_dsp15, nvl2(milk.inventory_location_id,case when 16<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'16','N','VALUE','ALL_ENABLED') end,xu.loc_segment_dsp16) loc_segment_dsp16, nvl2(milk.inventory_location_id,case when 17<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'17','N','VALUE','ALL_ENABLED') end,xu.loc_segment_dsp17) loc_segment_dsp17, nvl2(milk.inventory_location_id,case when 18<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'18','N','VALUE','ALL_ENABLED') end,xu.loc_segment_dsp18) loc_segment_dsp18, nvl2(milk.inventory_location_id,case when 19<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'19','N','VALUE','ALL_ENABLED') end,xu.loc_segment_dsp19) loc_segment_dsp19, nvl2(milk.inventory_location_id,case when 20<=:segment_count then fnd_flex_xml_publisher_apis.process_kff_combination_1('lov','INV','MTLL',101,milk.organization_id,milk.inventory_location_id,'20','N','VALUE','ALL_ENABLED') end,xu.loc_segment_dsp20) loc_segment_dsp20, nvl(milk.description,xu.description) description, nvl(xxen_util.meaning(to_char(milk.inventory_location_type),'MTL_LOCATOR_TYPES',700),xu.type) type, nvl(mmsv.status_code,xu.status) status, nvl(milk.picking_order,xu.picking_order) picking_order, nvl(milk.dropping_order,xu.dropping_order) dropping_order, nvl(milk.alias,xu.alias) alias, nvl(milk.disable_date,xu.disable_date) disable_date, nvl(milk.location_maximum_units,xu.maximum_units) maximum_units, nvl(milk.volume_uom_code,xu.volume_uom) volume_uom, nvl(milk.max_cubic_area,xu.maximum_volume) maximum_volume, nvl(milk.location_weight_uom_code,xu.weight_uom) weight_uom, nvl(milk.max_weight,xu.maximum_weight) maximum_weight, nvl(milk.pick_uom_code,xu.pick_uom) pick_uom, nvl(milk.dimension_uom_code,xu.dimension_uom) dimension_uom, nvl(milk.length,xu.dimension_length) dimension_length, nvl(milk.width,xu.dimension_width) dimension_width, nvl(milk.height,xu.dimension_height) dimension_height, nvl(milk.x_coordinate,xu.x_coordinate) x_coordinate, nvl(milk.y_coordinate,xu.y_coordinate) y_coordinate, nvl(milk.z_coordinate,xu.z_coordinate) z_coordinate, nvl(xxen_util.display_flexfield_context(401,'MTL_ITEM_LOCATIONS',milk.attribute_category),xu.attribute_category) attribute_category, nvl(xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE1',milk.rowid,milk.attribute1),xu.loc_attribute1) loc_attribute1, nvl(xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE2',milk.rowid,milk.attribute2),xu.loc_attribute2) loc_attribute2, nvl(xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE3',milk.rowid,milk.attribute3),xu.loc_attribute3) loc_attribute3, nvl(xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE4',milk.rowid,milk.attribute4),xu.loc_attribute4) loc_attribute4, nvl(xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE5',milk.rowid,milk.attribute5),xu.loc_attribute5) loc_attribute5, nvl(xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE6',milk.rowid,milk.attribute6),xu.loc_attribute6) loc_attribute6, nvl(xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE7',milk.rowid,milk.attribute7),xu.loc_attribute7) loc_attribute7, nvl(xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE8',milk.rowid,milk.attribute8),xu.loc_attribute8) loc_attribute8, nvl(xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE9',milk.rowid,milk.attribute9),xu.loc_attribute9) loc_attribute9, nvl(xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE10',milk.rowid,milk.attribute10),xu.loc_attribute10) loc_attribute10, nvl(xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE11',milk.rowid,milk.attribute11),xu.loc_attribute11) loc_attribute11, nvl(xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE12',milk.rowid,milk.attribute12),xu.loc_attribute12) loc_attribute12, nvl(xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE13',milk.rowid,milk.attribute13),xu.loc_attribute13) loc_attribute13, nvl(xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE14',milk.rowid,milk.attribute14),xu.loc_attribute14) loc_attribute14, nvl(xxen_util.display_flexfield_value(401,'MTL_ITEM_LOCATIONS',milk.attribute_category,'ATTRIBUTE15',milk.rowid,milk.attribute15),xu.loc_attribute15) loc_attribute15, xu.delete_locator, xu.upload_row from xxen_inv_stock_locator_1469_u xu, mtl_item_locations_kfv milk, mtl_parameters mp, mtl_material_statuses_vl mmsv where xu.status_code_=xxen_upload.status_success and milk.inventory_location_id(+)=xu.inventory_location_id and mp.organization_id(+)=milk.organization_id and mmsv.status_id(+)=milk.status_id LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY LOC_ATTRIBUTE1 LOV query :$column$.loc_attribute1 LOC_ATTRIBUTE1 LOC_ATTRIBUTE1 LOV query :$column$.loc_attribute10 LOC_ATTRIBUTE10 LOC_ATTRIBUTE1 LOV query :$column$.loc_attribute11 LOC_ATTRIBUTE11 LOC_ATTRIBUTE1 LOV query :$column$.loc_attribute12 LOC_ATTRIBUTE12 LOC_ATTRIBUTE1 LOV query :$column$.loc_attribute13 LOC_ATTRIBUTE13 LOC_ATTRIBUTE1 LOV query :$column$.loc_attribute14 LOC_ATTRIBUTE14 LOC_ATTRIBUTE1 LOV query :$column$.loc_attribute15 LOC_ATTRIBUTE15 LOC_ATTRIBUTE1 LOV query :$column$.loc_attribute2 LOC_ATTRIBUTE2 LOC_ATTRIBUTE1 LOV query :$column$.loc_attribute3 LOC_ATTRIBUTE3 LOC_ATTRIBUTE1 LOV query :$column$.loc_attribute4 LOC_ATTRIBUTE4 LOC_ATTRIBUTE1 LOV query :$column$.loc_attribute5 LOC_ATTRIBUTE5 LOC_ATTRIBUTE1 LOV query :$column$.loc_attribute6 LOC_ATTRIBUTE6 LOC_ATTRIBUTE1 LOV query :$column$.loc_attribute7 LOC_ATTRIBUTE7 LOC_ATTRIBUTE1 LOV query :$column$.loc_attribute8 LOC_ATTRIBUTE8 LOC_ATTRIBUTE1 LOV query :$column$.loc_attribute9 LOC_ATTRIBUTE9 LOC_ATTRIBUTE1 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY LOC_ATTRIBUTE10 LOV query :$column$.loc_attribute1 LOC_ATTRIBUTE1 LOC_ATTRIBUTE10 LOV query :$column$.loc_attribute10 LOC_ATTRIBUTE10 LOC_ATTRIBUTE10 LOV query :$column$.loc_attribute11 LOC_ATTRIBUTE11 LOC_ATTRIBUTE10 LOV query :$column$.loc_attribute12 LOC_ATTRIBUTE12 LOC_ATTRIBUTE10 LOV query :$column$.loc_attribute13 LOC_ATTRIBUTE13 LOC_ATTRIBUTE10 LOV query :$column$.loc_attribute14 LOC_ATTRIBUTE14 LOC_ATTRIBUTE10 LOV query :$column$.loc_attribute15 LOC_ATTRIBUTE15 LOC_ATTRIBUTE10 LOV query :$column$.loc_attribute2 LOC_ATTRIBUTE2 LOC_ATTRIBUTE10 LOV query :$column$.loc_attribute3 LOC_ATTRIBUTE3 LOC_ATTRIBUTE10 LOV query :$column$.loc_attribute4 LOC_ATTRIBUTE4 LOC_ATTRIBUTE10 LOV query :$column$.loc_attribute5 LOC_ATTRIBUTE5 LOC_ATTRIBUTE10 LOV query :$column$.loc_attribute6 LOC_ATTRIBUTE6 LOC_ATTRIBUTE10 LOV query :$column$.loc_attribute7 LOC_ATTRIBUTE7 LOC_ATTRIBUTE10 LOV query :$column$.loc_attribute8 LOC_ATTRIBUTE8 LOC_ATTRIBUTE10 LOV query :$column$.loc_attribute9 LOC_ATTRIBUTE9 LOC_ATTRIBUTE10 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY LOC_ATTRIBUTE11 LOV query :$column$.loc_attribute1 LOC_ATTRIBUTE1 LOC_ATTRIBUTE11 LOV query :$column$.loc_attribute10 LOC_ATTRIBUTE10 LOC_ATTRIBUTE11 LOV query :$column$.loc_attribute11 LOC_ATTRIBUTE11 LOC_ATTRIBUTE11 LOV query :$column$.loc_attribute12 LOC_ATTRIBUTE12 LOC_ATTRIBUTE11 LOV query :$column$.loc_attribute13 LOC_ATTRIBUTE13 LOC_ATTRIBUTE11 LOV query :$column$.loc_attribute14 LOC_ATTRIBUTE14 LOC_ATTRIBUTE11 LOV query :$column$.loc_attribute15 LOC_ATTRIBUTE15 LOC_ATTRIBUTE11 LOV query :$column$.loc_attribute2 LOC_ATTRIBUTE2 LOC_ATTRIBUTE11 LOV query :$column$.loc_attribute3 LOC_ATTRIBUTE3 LOC_ATTRIBUTE11 LOV query :$column$.loc_attribute4 LOC_ATTRIBUTE4 LOC_ATTRIBUTE11 LOV query :$column$.loc_attribute5 LOC_ATTRIBUTE5 LOC_ATTRIBUTE11 LOV query :$column$.loc_attribute6 LOC_ATTRIBUTE6 LOC_ATTRIBUTE11 LOV query :$column$.loc_attribute7 LOC_ATTRIBUTE7 LOC_ATTRIBUTE11 LOV query :$column$.loc_attribute8 LOC_ATTRIBUTE8 LOC_ATTRIBUTE11 LOV query :$column$.loc_attribute9 LOC_ATTRIBUTE9 LOC_ATTRIBUTE11 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY LOC_ATTRIBUTE12 LOV query :$column$.loc_attribute1 LOC_ATTRIBUTE1 LOC_ATTRIBUTE12 LOV query :$column$.loc_attribute10 LOC_ATTRIBUTE10 LOC_ATTRIBUTE12 LOV query :$column$.loc_attribute11 LOC_ATTRIBUTE11 LOC_ATTRIBUTE12 LOV query :$column$.loc_attribute12 LOC_ATTRIBUTE12 LOC_ATTRIBUTE12 LOV query :$column$.loc_attribute13 LOC_ATTRIBUTE13 LOC_ATTRIBUTE12 LOV query :$column$.loc_attribute14 LOC_ATTRIBUTE14 LOC_ATTRIBUTE12 LOV query :$column$.loc_attribute15 LOC_ATTRIBUTE15 LOC_ATTRIBUTE12 LOV query :$column$.loc_attribute2 LOC_ATTRIBUTE2 LOC_ATTRIBUTE12 LOV query :$column$.loc_attribute3 LOC_ATTRIBUTE3 LOC_ATTRIBUTE12 LOV query :$column$.loc_attribute4 LOC_ATTRIBUTE4 LOC_ATTRIBUTE12 LOV query :$column$.loc_attribute5 LOC_ATTRIBUTE5 LOC_ATTRIBUTE12 LOV query :$column$.loc_attribute6 LOC_ATTRIBUTE6 LOC_ATTRIBUTE12 LOV query :$column$.loc_attribute7 LOC_ATTRIBUTE7 LOC_ATTRIBUTE12 LOV query :$column$.loc_attribute8 LOC_ATTRIBUTE8 LOC_ATTRIBUTE12 LOV query :$column$.loc_attribute9 LOC_ATTRIBUTE9 LOC_ATTRIBUTE12 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY LOC_ATTRIBUTE13 LOV query :$column$.loc_attribute1 LOC_ATTRIBUTE1 LOC_ATTRIBUTE13 LOV query :$column$.loc_attribute10 LOC_ATTRIBUTE10 LOC_ATTRIBUTE13 LOV query :$column$.loc_attribute11 LOC_ATTRIBUTE11 LOC_ATTRIBUTE13 LOV query :$column$.loc_attribute12 LOC_ATTRIBUTE12 LOC_ATTRIBUTE13 LOV query :$column$.loc_attribute13 LOC_ATTRIBUTE13 LOC_ATTRIBUTE13 LOV query :$column$.loc_attribute14 LOC_ATTRIBUTE14 LOC_ATTRIBUTE13 LOV query :$column$.loc_attribute15 LOC_ATTRIBUTE15 LOC_ATTRIBUTE13 LOV query :$column$.loc_attribute2 LOC_ATTRIBUTE2 LOC_ATTRIBUTE13 LOV query :$column$.loc_attribute3 LOC_ATTRIBUTE3 LOC_ATTRIBUTE13 LOV query :$column$.loc_attribute4 LOC_ATTRIBUTE4 LOC_ATTRIBUTE13 LOV query :$column$.loc_attribute5 LOC_ATTRIBUTE5 LOC_ATTRIBUTE13 LOV query :$column$.loc_attribute6 LOC_ATTRIBUTE6 LOC_ATTRIBUTE13 LOV query :$column$.loc_attribute7 LOC_ATTRIBUTE7 LOC_ATTRIBUTE13 LOV query :$column$.loc_attribute8 LOC_ATTRIBUTE8 LOC_ATTRIBUTE13 LOV query :$column$.loc_attribute9 LOC_ATTRIBUTE9 LOC_ATTRIBUTE13 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY LOC_ATTRIBUTE14 LOV query :$column$.loc_attribute1 LOC_ATTRIBUTE1 LOC_ATTRIBUTE14 LOV query :$column$.loc_attribute10 LOC_ATTRIBUTE10 LOC_ATTRIBUTE14 LOV query :$column$.loc_attribute11 LOC_ATTRIBUTE11 LOC_ATTRIBUTE14 LOV query :$column$.loc_attribute12 LOC_ATTRIBUTE12 LOC_ATTRIBUTE14 LOV query :$column$.loc_attribute13 LOC_ATTRIBUTE13 LOC_ATTRIBUTE14 LOV query :$column$.loc_attribute14 LOC_ATTRIBUTE14 LOC_ATTRIBUTE14 LOV query :$column$.loc_attribute15 LOC_ATTRIBUTE15 LOC_ATTRIBUTE14 LOV query :$column$.loc_attribute2 LOC_ATTRIBUTE2 LOC_ATTRIBUTE14 LOV query :$column$.loc_attribute3 LOC_ATTRIBUTE3 LOC_ATTRIBUTE14 LOV query :$column$.loc_attribute4 LOC_ATTRIBUTE4 LOC_ATTRIBUTE14 LOV query :$column$.loc_attribute5 LOC_ATTRIBUTE5 LOC_ATTRIBUTE14 LOV query :$column$.loc_attribute6 LOC_ATTRIBUTE6 LOC_ATTRIBUTE14 LOV query :$column$.loc_attribute7 LOC_ATTRIBUTE7 LOC_ATTRIBUTE14 LOV query :$column$.loc_attribute8 LOC_ATTRIBUTE8 LOC_ATTRIBUTE14 LOV query :$column$.loc_attribute9 LOC_ATTRIBUTE9 LOC_ATTRIBUTE14 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY LOC_ATTRIBUTE15 LOV query :$column$.loc_attribute1 LOC_ATTRIBUTE1 LOC_ATTRIBUTE15 LOV query :$column$.loc_attribute10 LOC_ATTRIBUTE10 LOC_ATTRIBUTE15 LOV query :$column$.loc_attribute11 LOC_ATTRIBUTE11 LOC_ATTRIBUTE15 LOV query :$column$.loc_attribute12 LOC_ATTRIBUTE12 LOC_ATTRIBUTE15 LOV query :$column$.loc_attribute13 LOC_ATTRIBUTE13 LOC_ATTRIBUTE15 LOV query :$column$.loc_attribute14 LOC_ATTRIBUTE14 LOC_ATTRIBUTE15 LOV query :$column$.loc_attribute15 LOC_ATTRIBUTE15 LOC_ATTRIBUTE15 LOV query :$column$.loc_attribute2 LOC_ATTRIBUTE2 LOC_ATTRIBUTE15 LOV query :$column$.loc_attribute3 LOC_ATTRIBUTE3 LOC_ATTRIBUTE15 LOV query :$column$.loc_attribute4 LOC_ATTRIBUTE4 LOC_ATTRIBUTE15 LOV query :$column$.loc_attribute5 LOC_ATTRIBUTE5 LOC_ATTRIBUTE15 LOV query :$column$.loc_attribute6 LOC_ATTRIBUTE6 LOC_ATTRIBUTE15 LOV query :$column$.loc_attribute7 LOC_ATTRIBUTE7 LOC_ATTRIBUTE15 LOV query :$column$.loc_attribute8 LOC_ATTRIBUTE8 LOC_ATTRIBUTE15 LOV query :$column$.loc_attribute9 LOC_ATTRIBUTE9 LOC_ATTRIBUTE15 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY LOC_ATTRIBUTE2 LOV query :$column$.loc_attribute1 LOC_ATTRIBUTE1 LOC_ATTRIBUTE2 LOV query :$column$.loc_attribute10 LOC_ATTRIBUTE10 LOC_ATTRIBUTE2 LOV query :$column$.loc_attribute11 LOC_ATTRIBUTE11 LOC_ATTRIBUTE2 LOV query :$column$.loc_attribute12 LOC_ATTRIBUTE12 LOC_ATTRIBUTE2 LOV query :$column$.loc_attribute13 LOC_ATTRIBUTE13 LOC_ATTRIBUTE2 LOV query :$column$.loc_attribute14 LOC_ATTRIBUTE14 LOC_ATTRIBUTE2 LOV query :$column$.loc_attribute15 LOC_ATTRIBUTE15 LOC_ATTRIBUTE2 LOV query :$column$.loc_attribute2 LOC_ATTRIBUTE2 LOC_ATTRIBUTE2 LOV query :$column$.loc_attribute3 LOC_ATTRIBUTE3 LOC_ATTRIBUTE2 LOV query :$column$.loc_attribute4 LOC_ATTRIBUTE4 LOC_ATTRIBUTE2 LOV query :$column$.loc_attribute5 LOC_ATTRIBUTE5 LOC_ATTRIBUTE2 LOV query :$column$.loc_attribute6 LOC_ATTRIBUTE6 LOC_ATTRIBUTE2 LOV query :$column$.loc_attribute7 LOC_ATTRIBUTE7 LOC_ATTRIBUTE2 LOV query :$column$.loc_attribute8 LOC_ATTRIBUTE8 LOC_ATTRIBUTE2 LOV query :$column$.loc_attribute9 LOC_ATTRIBUTE9 LOC_ATTRIBUTE2 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY LOC_ATTRIBUTE3 LOV query :$column$.loc_attribute1 LOC_ATTRIBUTE1 LOC_ATTRIBUTE3 LOV query :$column$.loc_attribute10 LOC_ATTRIBUTE10 LOC_ATTRIBUTE3 LOV query :$column$.loc_attribute11 LOC_ATTRIBUTE11 LOC_ATTRIBUTE3 LOV query :$column$.loc_attribute12 LOC_ATTRIBUTE12 LOC_ATTRIBUTE3 LOV query :$column$.loc_attribute13 LOC_ATTRIBUTE13 LOC_ATTRIBUTE3 LOV query :$column$.loc_attribute14 LOC_ATTRIBUTE14 LOC_ATTRIBUTE3 LOV query :$column$.loc_attribute15 LOC_ATTRIBUTE15 LOC_ATTRIBUTE3 LOV query :$column$.loc_attribute2 LOC_ATTRIBUTE2 LOC_ATTRIBUTE3 LOV query :$column$.loc_attribute3 LOC_ATTRIBUTE3 LOC_ATTRIBUTE3 LOV query :$column$.loc_attribute4 LOC_ATTRIBUTE4 LOC_ATTRIBUTE3 LOV query :$column$.loc_attribute5 LOC_ATTRIBUTE5 LOC_ATTRIBUTE3 LOV query :$column$.loc_attribute6 LOC_ATTRIBUTE6 LOC_ATTRIBUTE3 LOV query :$column$.loc_attribute7 LOC_ATTRIBUTE7 LOC_ATTRIBUTE3 LOV query :$column$.loc_attribute8 LOC_ATTRIBUTE8 LOC_ATTRIBUTE3 LOV query :$column$.loc_attribute9 LOC_ATTRIBUTE9 LOC_ATTRIBUTE3 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY LOC_ATTRIBUTE4 LOV query :$column$.loc_attribute1 LOC_ATTRIBUTE1 LOC_ATTRIBUTE4 LOV query :$column$.loc_attribute10 LOC_ATTRIBUTE10 LOC_ATTRIBUTE4 LOV query :$column$.loc_attribute11 LOC_ATTRIBUTE11 LOC_ATTRIBUTE4 LOV query :$column$.loc_attribute12 LOC_ATTRIBUTE12 LOC_ATTRIBUTE4 LOV query :$column$.loc_attribute13 LOC_ATTRIBUTE13 LOC_ATTRIBUTE4 LOV query :$column$.loc_attribute14 LOC_ATTRIBUTE14 LOC_ATTRIBUTE4 LOV query :$column$.loc_attribute15 LOC_ATTRIBUTE15 LOC_ATTRIBUTE4 LOV query :$column$.loc_attribute2 LOC_ATTRIBUTE2 LOC_ATTRIBUTE4 LOV query :$column$.loc_attribute3 LOC_ATTRIBUTE3 LOC_ATTRIBUTE4 LOV query :$column$.loc_attribute4 LOC_ATTRIBUTE4 LOC_ATTRIBUTE4 LOV query :$column$.loc_attribute5 LOC_ATTRIBUTE5 LOC_ATTRIBUTE4 LOV query :$column$.loc_attribute6 LOC_ATTRIBUTE6 LOC_ATTRIBUTE4 LOV query :$column$.loc_attribute7 LOC_ATTRIBUTE7 LOC_ATTRIBUTE4 LOV query :$column$.loc_attribute8 LOC_ATTRIBUTE8 LOC_ATTRIBUTE4 LOV query :$column$.loc_attribute9 LOC_ATTRIBUTE9 LOC_ATTRIBUTE4 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY LOC_ATTRIBUTE5 LOV query :$column$.loc_attribute1 LOC_ATTRIBUTE1 LOC_ATTRIBUTE5 LOV query :$column$.loc_attribute10 LOC_ATTRIBUTE10 LOC_ATTRIBUTE5 LOV query :$column$.loc_attribute11 LOC_ATTRIBUTE11 LOC_ATTRIBUTE5 LOV query :$column$.loc_attribute12 LOC_ATTRIBUTE12 LOC_ATTRIBUTE5 LOV query :$column$.loc_attribute13 LOC_ATTRIBUTE13 LOC_ATTRIBUTE5 LOV query :$column$.loc_attribute14 LOC_ATTRIBUTE14 LOC_ATTRIBUTE5 LOV query :$column$.loc_attribute15 LOC_ATTRIBUTE15 LOC_ATTRIBUTE5 LOV query :$column$.loc_attribute2 LOC_ATTRIBUTE2 LOC_ATTRIBUTE5 LOV query :$column$.loc_attribute3 LOC_ATTRIBUTE3 LOC_ATTRIBUTE5 LOV query :$column$.loc_attribute4 LOC_ATTRIBUTE4 LOC_ATTRIBUTE5 LOV query :$column$.loc_attribute5 LOC_ATTRIBUTE5 LOC_ATTRIBUTE5 LOV query :$column$.loc_attribute6 LOC_ATTRIBUTE6 LOC_ATTRIBUTE5 LOV query :$column$.loc_attribute7 LOC_ATTRIBUTE7 LOC_ATTRIBUTE5 LOV query :$column$.loc_attribute8 LOC_ATTRIBUTE8 LOC_ATTRIBUTE5 LOV query :$column$.loc_attribute9 LOC_ATTRIBUTE9 LOC_ATTRIBUTE5 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY LOC_ATTRIBUTE6 LOV query :$column$.loc_attribute1 LOC_ATTRIBUTE1 LOC_ATTRIBUTE6 LOV query :$column$.loc_attribute10 LOC_ATTRIBUTE10 LOC_ATTRIBUTE6 LOV query :$column$.loc_attribute11 LOC_ATTRIBUTE11 LOC_ATTRIBUTE6 LOV query :$column$.loc_attribute12 LOC_ATTRIBUTE12 LOC_ATTRIBUTE6 LOV query :$column$.loc_attribute13 LOC_ATTRIBUTE13 LOC_ATTRIBUTE6 LOV query :$column$.loc_attribute14 LOC_ATTRIBUTE14 LOC_ATTRIBUTE6 LOV query :$column$.loc_attribute15 LOC_ATTRIBUTE15 LOC_ATTRIBUTE6 LOV query :$column$.loc_attribute2 LOC_ATTRIBUTE2 LOC_ATTRIBUTE6 LOV query :$column$.loc_attribute3 LOC_ATTRIBUTE3 LOC_ATTRIBUTE6 LOV query :$column$.loc_attribute4 LOC_ATTRIBUTE4 LOC_ATTRIBUTE6 LOV query :$column$.loc_attribute5 LOC_ATTRIBUTE5 LOC_ATTRIBUTE6 LOV query :$column$.loc_attribute6 LOC_ATTRIBUTE6 LOC_ATTRIBUTE6 LOV query :$column$.loc_attribute7 LOC_ATTRIBUTE7 LOC_ATTRIBUTE6 LOV query :$column$.loc_attribute8 LOC_ATTRIBUTE8 LOC_ATTRIBUTE6 LOV query :$column$.loc_attribute9 LOC_ATTRIBUTE9 LOC_ATTRIBUTE6 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY LOC_ATTRIBUTE7 LOV query :$column$.loc_attribute1 LOC_ATTRIBUTE1 LOC_ATTRIBUTE7 LOV query :$column$.loc_attribute10 LOC_ATTRIBUTE10 LOC_ATTRIBUTE7 LOV query :$column$.loc_attribute11 LOC_ATTRIBUTE11 LOC_ATTRIBUTE7 LOV query :$column$.loc_attribute12 LOC_ATTRIBUTE12 LOC_ATTRIBUTE7 LOV query :$column$.loc_attribute13 LOC_ATTRIBUTE13 LOC_ATTRIBUTE7 LOV query :$column$.loc_attribute14 LOC_ATTRIBUTE14 LOC_ATTRIBUTE7 LOV query :$column$.loc_attribute15 LOC_ATTRIBUTE15 LOC_ATTRIBUTE7 LOV query :$column$.loc_attribute2 LOC_ATTRIBUTE2 LOC_ATTRIBUTE7 LOV query :$column$.loc_attribute3 LOC_ATTRIBUTE3 LOC_ATTRIBUTE7 LOV query :$column$.loc_attribute4 LOC_ATTRIBUTE4 LOC_ATTRIBUTE7 LOV query :$column$.loc_attribute5 LOC_ATTRIBUTE5 LOC_ATTRIBUTE7 LOV query :$column$.loc_attribute6 LOC_ATTRIBUTE6 LOC_ATTRIBUTE7 LOV query :$column$.loc_attribute7 LOC_ATTRIBUTE7 LOC_ATTRIBUTE7 LOV query :$column$.loc_attribute8 LOC_ATTRIBUTE8 LOC_ATTRIBUTE7 LOV query :$column$.loc_attribute9 LOC_ATTRIBUTE9 LOC_ATTRIBUTE7 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY LOC_ATTRIBUTE8 LOV query :$column$.loc_attribute1 LOC_ATTRIBUTE1 LOC_ATTRIBUTE8 LOV query :$column$.loc_attribute10 LOC_ATTRIBUTE10 LOC_ATTRIBUTE8 LOV query :$column$.loc_attribute11 LOC_ATTRIBUTE11 LOC_ATTRIBUTE8 LOV query :$column$.loc_attribute12 LOC_ATTRIBUTE12 LOC_ATTRIBUTE8 LOV query :$column$.loc_attribute13 LOC_ATTRIBUTE13 LOC_ATTRIBUTE8 LOV query :$column$.loc_attribute14 LOC_ATTRIBUTE14 LOC_ATTRIBUTE8 LOV query :$column$.loc_attribute15 LOC_ATTRIBUTE15 LOC_ATTRIBUTE8 LOV query :$column$.loc_attribute2 LOC_ATTRIBUTE2 LOC_ATTRIBUTE8 LOV query :$column$.loc_attribute3 LOC_ATTRIBUTE3 LOC_ATTRIBUTE8 LOV query :$column$.loc_attribute4 LOC_ATTRIBUTE4 LOC_ATTRIBUTE8 LOV query :$column$.loc_attribute5 LOC_ATTRIBUTE5 LOC_ATTRIBUTE8 LOV query :$column$.loc_attribute6 LOC_ATTRIBUTE6 LOC_ATTRIBUTE8 LOV query :$column$.loc_attribute7 LOC_ATTRIBUTE7 LOC_ATTRIBUTE8 LOV query :$column$.loc_attribute8 LOC_ATTRIBUTE8 LOC_ATTRIBUTE8 LOV query :$column$.loc_attribute9 LOC_ATTRIBUTE9 LOC_ATTRIBUTE8 LOV query :$column$.attribute_category ATTRIBUTE_CATEGORY LOC_ATTRIBUTE9 LOV query :$column$.loc_attribute1 LOC_ATTRIBUTE1 LOC_ATTRIBUTE9 LOV query :$column$.loc_attribute10 LOC_ATTRIBUTE10 LOC_ATTRIBUTE9 LOV query :$column$.loc_attribute11 LOC_ATTRIBUTE11 LOC_ATTRIBUTE9 LOV query :$column$.loc_attribute12 LOC_ATTRIBUTE12 LOC_ATTRIBUTE9 LOV query :$column$.loc_attribute13 LOC_ATTRIBUTE13 LOC_ATTRIBUTE9 LOV query :$column$.loc_attribute14 LOC_ATTRIBUTE14 LOC_ATTRIBUTE9 LOV query :$column$.loc_attribute15 LOC_ATTRIBUTE15 LOC_ATTRIBUTE9 LOV query :$column$.loc_attribute2 LOC_ATTRIBUTE2 LOC_ATTRIBUTE9 LOV query :$column$.loc_attribute3 LOC_ATTRIBUTE3 LOC_ATTRIBUTE9 LOV query :$column$.loc_attribute4 LOC_ATTRIBUTE4 LOC_ATTRIBUTE9 LOV query :$column$.loc_attribute5 LOC_ATTRIBUTE5 LOC_ATTRIBUTE9 LOV query :$column$.loc_attribute6 LOC_ATTRIBUTE6 LOC_ATTRIBUTE9 LOV query :$column$.loc_attribute7 LOC_ATTRIBUTE7 LOC_ATTRIBUTE9 LOV query :$column$.loc_attribute8 LOC_ATTRIBUTE8 LOC_ATTRIBUTE9 LOV query :$column$.loc_attribute9 LOC_ATTRIBUTE9 LOC_ATTRIBUTE9 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS LOC_SEGMENT_DSP1 LOV query :$column$.loc_segment_dsp1 LOC_SEGMENT_DSP1 LOC_SEGMENT_DSP1 LOV query :$column$.loc_segment_dsp10 LOC_SEGMENT_DSP10 LOC_SEGMENT_DSP1 LOV query :$column$.loc_segment_dsp11 LOC_SEGMENT_DSP11 LOC_SEGMENT_DSP1 LOV query :$column$.loc_segment_dsp12 LOC_SEGMENT_DSP12 LOC_SEGMENT_DSP1 LOV query :$column$.loc_segment_dsp13 LOC_SEGMENT_DSP13 LOC_SEGMENT_DSP1 LOV query :$column$.loc_segment_dsp14 LOC_SEGMENT_DSP14 LOC_SEGMENT_DSP1 LOV query :$column$.loc_segment_dsp15 LOC_SEGMENT_DSP15 LOC_SEGMENT_DSP1 LOV query :$column$.loc_segment_dsp16 LOC_SEGMENT_DSP16 LOC_SEGMENT_DSP1 LOV query :$column$.loc_segment_dsp17 LOC_SEGMENT_DSP17 LOC_SEGMENT_DSP1 LOV query :$column$.loc_segment_dsp18 LOC_SEGMENT_DSP18 LOC_SEGMENT_DSP1 LOV query :$column$.loc_segment_dsp19 LOC_SEGMENT_DSP19 LOC_SEGMENT_DSP1 LOV query :$column$.loc_segment_dsp2 LOC_SEGMENT_DSP2 LOC_SEGMENT_DSP1 LOV query :$column$.loc_segment_dsp20 LOC_SEGMENT_DSP20 LOC_SEGMENT_DSP1 LOV query :$column$.loc_segment_dsp3 LOC_SEGMENT_DSP3 LOC_SEGMENT_DSP1 LOV query :$column$.loc_segment_dsp4 LOC_SEGMENT_DSP4 LOC_SEGMENT_DSP1 LOV query :$column$.loc_segment_dsp5 LOC_SEGMENT_DSP5 LOC_SEGMENT_DSP1 LOV query :$column$.loc_segment_dsp6 LOC_SEGMENT_DSP6 LOC_SEGMENT_DSP1 LOV query :$column$.loc_segment_dsp7 LOC_SEGMENT_DSP7 LOC_SEGMENT_DSP1 LOV query :$column$.loc_segment_dsp8 LOC_SEGMENT_DSP8 LOC_SEGMENT_DSP1 LOV query :$column$.loc_segment_dsp9 LOC_SEGMENT_DSP9 LOC_SEGMENT_DSP1 LOV query :$column$.organization_code ORGANIZATION_CODE LOC_SEGMENT_DSP1 LOV query :$flex$.project_display_seq Project Display Seq|:project_display_seq| LOC_SEGMENT_DSP1 LOV query :$flex$.task_display_seq Task Display Seq|:task_display_seq| LOC_SEGMENT_DSP1 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS LOC_SEGMENT_DSP10 LOV query :$column$.loc_segment_dsp1 LOC_SEGMENT_DSP1 LOC_SEGMENT_DSP10 LOV query :$column$.loc_segment_dsp10 LOC_SEGMENT_DSP10 LOC_SEGMENT_DSP10 LOV query :$column$.loc_segment_dsp11 LOC_SEGMENT_DSP11 LOC_SEGMENT_DSP10 LOV query :$column$.loc_segment_dsp12 LOC_SEGMENT_DSP12 LOC_SEGMENT_DSP10 LOV query :$column$.loc_segment_dsp13 LOC_SEGMENT_DSP13 LOC_SEGMENT_DSP10 LOV query :$column$.loc_segment_dsp14 LOC_SEGMENT_DSP14 LOC_SEGMENT_DSP10 LOV query :$column$.loc_segment_dsp15 LOC_SEGMENT_DSP15 LOC_SEGMENT_DSP10 LOV query :$column$.loc_segment_dsp16 LOC_SEGMENT_DSP16 LOC_SEGMENT_DSP10 LOV query :$column$.loc_segment_dsp17 LOC_SEGMENT_DSP17 LOC_SEGMENT_DSP10 LOV query :$column$.loc_segment_dsp18 LOC_SEGMENT_DSP18 LOC_SEGMENT_DSP10 LOV query :$column$.loc_segment_dsp19 LOC_SEGMENT_DSP19 LOC_SEGMENT_DSP10 LOV query :$column$.loc_segment_dsp2 LOC_SEGMENT_DSP2 LOC_SEGMENT_DSP10 LOV query :$column$.loc_segment_dsp20 LOC_SEGMENT_DSP20 LOC_SEGMENT_DSP10 LOV query :$column$.loc_segment_dsp3 LOC_SEGMENT_DSP3 LOC_SEGMENT_DSP10 LOV query :$column$.loc_segment_dsp4 LOC_SEGMENT_DSP4 LOC_SEGMENT_DSP10 LOV query :$column$.loc_segment_dsp5 LOC_SEGMENT_DSP5 LOC_SEGMENT_DSP10 LOV query :$column$.loc_segment_dsp6 LOC_SEGMENT_DSP6 LOC_SEGMENT_DSP10 LOV query :$column$.loc_segment_dsp7 LOC_SEGMENT_DSP7 LOC_SEGMENT_DSP10 LOV query :$column$.loc_segment_dsp8 LOC_SEGMENT_DSP8 LOC_SEGMENT_DSP10 LOV query :$column$.loc_segment_dsp9 LOC_SEGMENT_DSP9 LOC_SEGMENT_DSP10 LOV query :$column$.organization_code ORGANIZATION_CODE LOC_SEGMENT_DSP10 LOV query :$flex$.project_display_seq Project Display Seq|:project_display_seq| LOC_SEGMENT_DSP10 LOV query :$flex$.task_display_seq Task Display Seq|:task_display_seq| LOC_SEGMENT_DSP10 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS LOC_SEGMENT_DSP11 LOV query :$column$.loc_segment_dsp1 LOC_SEGMENT_DSP1 LOC_SEGMENT_DSP11 LOV query :$column$.loc_segment_dsp10 LOC_SEGMENT_DSP10 LOC_SEGMENT_DSP11 LOV query :$column$.loc_segment_dsp11 LOC_SEGMENT_DSP11 LOC_SEGMENT_DSP11 LOV query :$column$.loc_segment_dsp12 LOC_SEGMENT_DSP12 LOC_SEGMENT_DSP11 LOV query :$column$.loc_segment_dsp13 LOC_SEGMENT_DSP13 LOC_SEGMENT_DSP11 LOV query :$column$.loc_segment_dsp14 LOC_SEGMENT_DSP14 LOC_SEGMENT_DSP11 LOV query :$column$.loc_segment_dsp15 LOC_SEGMENT_DSP15 LOC_SEGMENT_DSP11 LOV query :$column$.loc_segment_dsp16 LOC_SEGMENT_DSP16 LOC_SEGMENT_DSP11 LOV query :$column$.loc_segment_dsp17 LOC_SEGMENT_DSP17 LOC_SEGMENT_DSP11 LOV query :$column$.loc_segment_dsp18 LOC_SEGMENT_DSP18 LOC_SEGMENT_DSP11 LOV query :$column$.loc_segment_dsp19 LOC_SEGMENT_DSP19 LOC_SEGMENT_DSP11 LOV query :$column$.loc_segment_dsp2 LOC_SEGMENT_DSP2 LOC_SEGMENT_DSP11 LOV query :$column$.loc_segment_dsp20 LOC_SEGMENT_DSP20 LOC_SEGMENT_DSP11 LOV query :$column$.loc_segment_dsp3 LOC_SEGMENT_DSP3 LOC_SEGMENT_DSP11 LOV query :$column$.loc_segment_dsp4 LOC_SEGMENT_DSP4 LOC_SEGMENT_DSP11 LOV query :$column$.loc_segment_dsp5 LOC_SEGMENT_DSP5 LOC_SEGMENT_DSP11 LOV query :$column$.loc_segment_dsp6 LOC_SEGMENT_DSP6 LOC_SEGMENT_DSP11 LOV query :$column$.loc_segment_dsp7 LOC_SEGMENT_DSP7 LOC_SEGMENT_DSP11 LOV query :$column$.loc_segment_dsp8 LOC_SEGMENT_DSP8 LOC_SEGMENT_DSP11 LOV query :$column$.loc_segment_dsp9 LOC_SEGMENT_DSP9 LOC_SEGMENT_DSP11 LOV query :$column$.organization_code ORGANIZATION_CODE LOC_SEGMENT_DSP11 LOV query :$flex$.project_display_seq Project Display Seq|:project_display_seq| LOC_SEGMENT_DSP11 LOV query :$flex$.task_display_seq Task Display Seq|:task_display_seq| LOC_SEGMENT_DSP11 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS LOC_SEGMENT_DSP12 LOV query :$column$.loc_segment_dsp1 LOC_SEGMENT_DSP1 LOC_SEGMENT_DSP12 LOV query :$column$.loc_segment_dsp10 LOC_SEGMENT_DSP10 LOC_SEGMENT_DSP12 LOV query :$column$.loc_segment_dsp11 LOC_SEGMENT_DSP11 LOC_SEGMENT_DSP12 LOV query :$column$.loc_segment_dsp12 LOC_SEGMENT_DSP12 LOC_SEGMENT_DSP12 LOV query :$column$.loc_segment_dsp13 LOC_SEGMENT_DSP13 LOC_SEGMENT_DSP12 LOV query :$column$.loc_segment_dsp14 LOC_SEGMENT_DSP14 LOC_SEGMENT_DSP12 LOV query :$column$.loc_segment_dsp15 LOC_SEGMENT_DSP15 LOC_SEGMENT_DSP12 LOV query :$column$.loc_segment_dsp16 LOC_SEGMENT_DSP16 LOC_SEGMENT_DSP12 LOV query :$column$.loc_segment_dsp17 LOC_SEGMENT_DSP17 LOC_SEGMENT_DSP12 LOV query :$column$.loc_segment_dsp18 LOC_SEGMENT_DSP18 LOC_SEGMENT_DSP12 LOV query :$column$.loc_segment_dsp19 LOC_SEGMENT_DSP19 LOC_SEGMENT_DSP12 LOV query :$column$.loc_segment_dsp2 LOC_SEGMENT_DSP2 LOC_SEGMENT_DSP12 LOV query :$column$.loc_segment_dsp20 LOC_SEGMENT_DSP20 LOC_SEGMENT_DSP12 LOV query :$column$.loc_segment_dsp3 LOC_SEGMENT_DSP3 LOC_SEGMENT_DSP12 LOV query :$column$.loc_segment_dsp4 LOC_SEGMENT_DSP4 LOC_SEGMENT_DSP12 LOV query :$column$.loc_segment_dsp5 LOC_SEGMENT_DSP5 LOC_SEGMENT_DSP12 LOV query :$column$.loc_segment_dsp6 LOC_SEGMENT_DSP6 LOC_SEGMENT_DSP12 LOV query :$column$.loc_segment_dsp7 LOC_SEGMENT_DSP7 LOC_SEGMENT_DSP12 LOV query :$column$.loc_segment_dsp8 LOC_SEGMENT_DSP8 LOC_SEGMENT_DSP12 LOV query :$column$.loc_segment_dsp9 LOC_SEGMENT_DSP9 LOC_SEGMENT_DSP12 LOV query :$column$.organization_code ORGANIZATION_CODE LOC_SEGMENT_DSP12 LOV query :$flex$.project_display_seq Project Display Seq|:project_display_seq| LOC_SEGMENT_DSP12 LOV query :$flex$.task_display_seq Task Display Seq|:task_display_seq| LOC_SEGMENT_DSP12 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS LOC_SEGMENT_DSP13 LOV query :$column$.loc_segment_dsp1 LOC_SEGMENT_DSP1 LOC_SEGMENT_DSP13 LOV query :$column$.loc_segment_dsp10 LOC_SEGMENT_DSP10 LOC_SEGMENT_DSP13 LOV query :$column$.loc_segment_dsp11 LOC_SEGMENT_DSP11 LOC_SEGMENT_DSP13 LOV query :$column$.loc_segment_dsp12 LOC_SEGMENT_DSP12 LOC_SEGMENT_DSP13 LOV query :$column$.loc_segment_dsp13 LOC_SEGMENT_DSP13 LOC_SEGMENT_DSP13 LOV query :$column$.loc_segment_dsp14 LOC_SEGMENT_DSP14 LOC_SEGMENT_DSP13 LOV query :$column$.loc_segment_dsp15 LOC_SEGMENT_DSP15 LOC_SEGMENT_DSP13 LOV query :$column$.loc_segment_dsp16 LOC_SEGMENT_DSP16 LOC_SEGMENT_DSP13 LOV query :$column$.loc_segment_dsp17 LOC_SEGMENT_DSP17 LOC_SEGMENT_DSP13 LOV query :$column$.loc_segment_dsp18 LOC_SEGMENT_DSP18 LOC_SEGMENT_DSP13 LOV query :$column$.loc_segment_dsp19 LOC_SEGMENT_DSP19 LOC_SEGMENT_DSP13 LOV query :$column$.loc_segment_dsp2 LOC_SEGMENT_DSP2 LOC_SEGMENT_DSP13 LOV query :$column$.loc_segment_dsp20 LOC_SEGMENT_DSP20 LOC_SEGMENT_DSP13 LOV query :$column$.loc_segment_dsp3 LOC_SEGMENT_DSP3 LOC_SEGMENT_DSP13 LOV query :$column$.loc_segment_dsp4 LOC_SEGMENT_DSP4 LOC_SEGMENT_DSP13 LOV query :$column$.loc_segment_dsp5 LOC_SEGMENT_DSP5 LOC_SEGMENT_DSP13 LOV query :$column$.loc_segment_dsp6 LOC_SEGMENT_DSP6 LOC_SEGMENT_DSP13 LOV query :$column$.loc_segment_dsp7 LOC_SEGMENT_DSP7 LOC_SEGMENT_DSP13 LOV query :$column$.loc_segment_dsp8 LOC_SEGMENT_DSP8 LOC_SEGMENT_DSP13 LOV query :$column$.loc_segment_dsp9 LOC_SEGMENT_DSP9 LOC_SEGMENT_DSP13 LOV query :$column$.organization_code ORGANIZATION_CODE LOC_SEGMENT_DSP13 LOV query :$flex$.project_display_seq Project Display Seq|:project_display_seq| LOC_SEGMENT_DSP13 LOV query :$flex$.task_display_seq Task Display Seq|:task_display_seq| LOC_SEGMENT_DSP13 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS LOC_SEGMENT_DSP14 LOV query :$column$.loc_segment_dsp1 LOC_SEGMENT_DSP1 LOC_SEGMENT_DSP14 LOV query :$column$.loc_segment_dsp10 LOC_SEGMENT_DSP10 LOC_SEGMENT_DSP14 LOV query :$column$.loc_segment_dsp11 LOC_SEGMENT_DSP11 LOC_SEGMENT_DSP14 LOV query :$column$.loc_segment_dsp12 LOC_SEGMENT_DSP12 LOC_SEGMENT_DSP14 LOV query :$column$.loc_segment_dsp13 LOC_SEGMENT_DSP13 LOC_SEGMENT_DSP14 LOV query :$column$.loc_segment_dsp14 LOC_SEGMENT_DSP14 LOC_SEGMENT_DSP14 LOV query :$column$.loc_segment_dsp15 LOC_SEGMENT_DSP15 LOC_SEGMENT_DSP14 LOV query :$column$.loc_segment_dsp16 LOC_SEGMENT_DSP16 LOC_SEGMENT_DSP14 LOV query :$column$.loc_segment_dsp17 LOC_SEGMENT_DSP17 LOC_SEGMENT_DSP14 LOV query :$column$.loc_segment_dsp18 LOC_SEGMENT_DSP18 LOC_SEGMENT_DSP14 LOV query :$column$.loc_segment_dsp19 LOC_SEGMENT_DSP19 LOC_SEGMENT_DSP14 LOV query :$column$.loc_segment_dsp2 LOC_SEGMENT_DSP2 LOC_SEGMENT_DSP14 LOV query :$column$.loc_segment_dsp20 LOC_SEGMENT_DSP20 LOC_SEGMENT_DSP14 LOV query :$column$.loc_segment_dsp3 LOC_SEGMENT_DSP3 LOC_SEGMENT_DSP14 LOV query :$column$.loc_segment_dsp4 LOC_SEGMENT_DSP4 LOC_SEGMENT_DSP14 LOV query :$column$.loc_segment_dsp5 LOC_SEGMENT_DSP5 LOC_SEGMENT_DSP14 LOV query :$column$.loc_segment_dsp6 LOC_SEGMENT_DSP6 LOC_SEGMENT_DSP14 LOV query :$column$.loc_segment_dsp7 LOC_SEGMENT_DSP7 LOC_SEGMENT_DSP14 LOV query :$column$.loc_segment_dsp8 LOC_SEGMENT_DSP8 LOC_SEGMENT_DSP14 LOV query :$column$.loc_segment_dsp9 LOC_SEGMENT_DSP9 LOC_SEGMENT_DSP14 LOV query :$column$.organization_code ORGANIZATION_CODE LOC_SEGMENT_DSP14 LOV query :$flex$.project_display_seq Project Display Seq|:project_display_seq| LOC_SEGMENT_DSP14 LOV query :$flex$.task_display_seq Task Display Seq|:task_display_seq| LOC_SEGMENT_DSP14 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS LOC_SEGMENT_DSP15 LOV query :$column$.loc_segment_dsp1 LOC_SEGMENT_DSP1 LOC_SEGMENT_DSP15 LOV query :$column$.loc_segment_dsp10 LOC_SEGMENT_DSP10 LOC_SEGMENT_DSP15 LOV query :$column$.loc_segment_dsp11 LOC_SEGMENT_DSP11 LOC_SEGMENT_DSP15 LOV query :$column$.loc_segment_dsp12 LOC_SEGMENT_DSP12 LOC_SEGMENT_DSP15 LOV query :$column$.loc_segment_dsp13 LOC_SEGMENT_DSP13 LOC_SEGMENT_DSP15 LOV query :$column$.loc_segment_dsp14 LOC_SEGMENT_DSP14 LOC_SEGMENT_DSP15 LOV query :$column$.loc_segment_dsp15 LOC_SEGMENT_DSP15 LOC_SEGMENT_DSP15 LOV query :$column$.loc_segment_dsp16 LOC_SEGMENT_DSP16 LOC_SEGMENT_DSP15 LOV query :$column$.loc_segment_dsp17 LOC_SEGMENT_DSP17 LOC_SEGMENT_DSP15 LOV query :$column$.loc_segment_dsp18 LOC_SEGMENT_DSP18 LOC_SEGMENT_DSP15 LOV query :$column$.loc_segment_dsp19 LOC_SEGMENT_DSP19 LOC_SEGMENT_DSP15 LOV query :$column$.loc_segment_dsp2 LOC_SEGMENT_DSP2 LOC_SEGMENT_DSP15 LOV query :$column$.loc_segment_dsp20 LOC_SEGMENT_DSP20 LOC_SEGMENT_DSP15 LOV query :$column$.loc_segment_dsp3 LOC_SEGMENT_DSP3 LOC_SEGMENT_DSP15 LOV query :$column$.loc_segment_dsp4 LOC_SEGMENT_DSP4 LOC_SEGMENT_DSP15 LOV query :$column$.loc_segment_dsp5 LOC_SEGMENT_DSP5 LOC_SEGMENT_DSP15 LOV query :$column$.loc_segment_dsp6 LOC_SEGMENT_DSP6 LOC_SEGMENT_DSP15 LOV query :$column$.loc_segment_dsp7 LOC_SEGMENT_DSP7 LOC_SEGMENT_DSP15 LOV query :$column$.loc_segment_dsp8 LOC_SEGMENT_DSP8 LOC_SEGMENT_DSP15 LOV query :$column$.loc_segment_dsp9 LOC_SEGMENT_DSP9 LOC_SEGMENT_DSP15 LOV query :$column$.organization_code ORGANIZATION_CODE LOC_SEGMENT_DSP15 LOV query :$flex$.project_display_seq Project Display Seq|:project_display_seq| LOC_SEGMENT_DSP15 LOV query :$flex$.task_display_seq Task Display Seq|:task_display_seq| LOC_SEGMENT_DSP15 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS LOC_SEGMENT_DSP16 LOV query :$column$.loc_segment_dsp1 LOC_SEGMENT_DSP1 LOC_SEGMENT_DSP16 LOV query :$column$.loc_segment_dsp10 LOC_SEGMENT_DSP10 LOC_SEGMENT_DSP16 LOV query :$column$.loc_segment_dsp11 LOC_SEGMENT_DSP11 LOC_SEGMENT_DSP16 LOV query :$column$.loc_segment_dsp12 LOC_SEGMENT_DSP12 LOC_SEGMENT_DSP16 LOV query :$column$.loc_segment_dsp13 LOC_SEGMENT_DSP13 LOC_SEGMENT_DSP16 LOV query :$column$.loc_segment_dsp14 LOC_SEGMENT_DSP14 LOC_SEGMENT_DSP16 LOV query :$column$.loc_segment_dsp15 LOC_SEGMENT_DSP15 LOC_SEGMENT_DSP16 LOV query :$column$.loc_segment_dsp16 LOC_SEGMENT_DSP16 LOC_SEGMENT_DSP16 LOV query :$column$.loc_segment_dsp17 LOC_SEGMENT_DSP17 LOC_SEGMENT_DSP16 LOV query :$column$.loc_segment_dsp18 LOC_SEGMENT_DSP18 LOC_SEGMENT_DSP16 LOV query :$column$.loc_segment_dsp19 LOC_SEGMENT_DSP19 LOC_SEGMENT_DSP16 LOV query :$column$.loc_segment_dsp2 LOC_SEGMENT_DSP2 LOC_SEGMENT_DSP16 LOV query :$column$.loc_segment_dsp20 LOC_SEGMENT_DSP20 LOC_SEGMENT_DSP16 LOV query :$column$.loc_segment_dsp3 LOC_SEGMENT_DSP3 LOC_SEGMENT_DSP16 LOV query :$column$.loc_segment_dsp4 LOC_SEGMENT_DSP4 LOC_SEGMENT_DSP16 LOV query :$column$.loc_segment_dsp5 LOC_SEGMENT_DSP5 LOC_SEGMENT_DSP16 LOV query :$column$.loc_segment_dsp6 LOC_SEGMENT_DSP6 LOC_SEGMENT_DSP16 LOV query :$column$.loc_segment_dsp7 LOC_SEGMENT_DSP7 LOC_SEGMENT_DSP16 LOV query :$column$.loc_segment_dsp8 LOC_SEGMENT_DSP8 LOC_SEGMENT_DSP16 LOV query :$column$.loc_segment_dsp9 LOC_SEGMENT_DSP9 LOC_SEGMENT_DSP16 LOV query :$column$.organization_code ORGANIZATION_CODE LOC_SEGMENT_DSP16 LOV query :$flex$.project_display_seq Project Display Seq|:project_display_seq| LOC_SEGMENT_DSP16 LOV query :$flex$.task_display_seq Task Display Seq|:task_display_seq| LOC_SEGMENT_DSP16 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS LOC_SEGMENT_DSP17 LOV query :$column$.loc_segment_dsp1 LOC_SEGMENT_DSP1 LOC_SEGMENT_DSP17 LOV query :$column$.loc_segment_dsp10 LOC_SEGMENT_DSP10 LOC_SEGMENT_DSP17 LOV query :$column$.loc_segment_dsp11 LOC_SEGMENT_DSP11 LOC_SEGMENT_DSP17 LOV query :$column$.loc_segment_dsp12 LOC_SEGMENT_DSP12 LOC_SEGMENT_DSP17 LOV query :$column$.loc_segment_dsp13 LOC_SEGMENT_DSP13 LOC_SEGMENT_DSP17 LOV query :$column$.loc_segment_dsp14 LOC_SEGMENT_DSP14 LOC_SEGMENT_DSP17 LOV query :$column$.loc_segment_dsp15 LOC_SEGMENT_DSP15 LOC_SEGMENT_DSP17 LOV query :$column$.loc_segment_dsp16 LOC_SEGMENT_DSP16 LOC_SEGMENT_DSP17 LOV query :$column$.loc_segment_dsp17 LOC_SEGMENT_DSP17 LOC_SEGMENT_DSP17 LOV query :$column$.loc_segment_dsp18 LOC_SEGMENT_DSP18 LOC_SEGMENT_DSP17 LOV query :$column$.loc_segment_dsp19 LOC_SEGMENT_DSP19 LOC_SEGMENT_DSP17 LOV query :$column$.loc_segment_dsp2 LOC_SEGMENT_DSP2 LOC_SEGMENT_DSP17 LOV query :$column$.loc_segment_dsp20 LOC_SEGMENT_DSP20 LOC_SEGMENT_DSP17 LOV query :$column$.loc_segment_dsp3 LOC_SEGMENT_DSP3 LOC_SEGMENT_DSP17 LOV query :$column$.loc_segment_dsp4 LOC_SEGMENT_DSP4 LOC_SEGMENT_DSP17 LOV query :$column$.loc_segment_dsp5 LOC_SEGMENT_DSP5 LOC_SEGMENT_DSP17 LOV query :$column$.loc_segment_dsp6 LOC_SEGMENT_DSP6 LOC_SEGMENT_DSP17 LOV query :$column$.loc_segment_dsp7 LOC_SEGMENT_DSP7 LOC_SEGMENT_DSP17 LOV query :$column$.loc_segment_dsp8 LOC_SEGMENT_DSP8 LOC_SEGMENT_DSP17 LOV query :$column$.loc_segment_dsp9 LOC_SEGMENT_DSP9 LOC_SEGMENT_DSP17 LOV query :$column$.organization_code ORGANIZATION_CODE LOC_SEGMENT_DSP17 LOV query :$flex$.project_display_seq Project Display Seq|:project_display_seq| LOC_SEGMENT_DSP17 LOV query :$flex$.task_display_seq Task Display Seq|:task_display_seq| LOC_SEGMENT_DSP17 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS LOC_SEGMENT_DSP18 LOV query :$column$.loc_segment_dsp1 LOC_SEGMENT_DSP1 LOC_SEGMENT_DSP18 LOV query :$column$.loc_segment_dsp10 LOC_SEGMENT_DSP10 LOC_SEGMENT_DSP18 LOV query :$column$.loc_segment_dsp11 LOC_SEGMENT_DSP11 LOC_SEGMENT_DSP18 LOV query :$column$.loc_segment_dsp12 LOC_SEGMENT_DSP12 LOC_SEGMENT_DSP18 LOV query :$column$.loc_segment_dsp13 LOC_SEGMENT_DSP13 LOC_SEGMENT_DSP18 LOV query :$column$.loc_segment_dsp14 LOC_SEGMENT_DSP14 LOC_SEGMENT_DSP18 LOV query :$column$.loc_segment_dsp15 LOC_SEGMENT_DSP15 LOC_SEGMENT_DSP18 LOV query :$column$.loc_segment_dsp16 LOC_SEGMENT_DSP16 LOC_SEGMENT_DSP18 LOV query :$column$.loc_segment_dsp17 LOC_SEGMENT_DSP17 LOC_SEGMENT_DSP18 LOV query :$column$.loc_segment_dsp18 LOC_SEGMENT_DSP18 LOC_SEGMENT_DSP18 LOV query :$column$.loc_segment_dsp19 LOC_SEGMENT_DSP19 LOC_SEGMENT_DSP18 LOV query :$column$.loc_segment_dsp2 LOC_SEGMENT_DSP2 LOC_SEGMENT_DSP18 LOV query :$column$.loc_segment_dsp20 LOC_SEGMENT_DSP20 LOC_SEGMENT_DSP18 LOV query :$column$.loc_segment_dsp3 LOC_SEGMENT_DSP3 LOC_SEGMENT_DSP18 LOV query :$column$.loc_segment_dsp4 LOC_SEGMENT_DSP4 LOC_SEGMENT_DSP18 LOV query :$column$.loc_segment_dsp5 LOC_SEGMENT_DSP5 LOC_SEGMENT_DSP18 LOV query :$column$.loc_segment_dsp6 LOC_SEGMENT_DSP6 LOC_SEGMENT_DSP18 LOV query :$column$.loc_segment_dsp7 LOC_SEGMENT_DSP7 LOC_SEGMENT_DSP18 LOV query :$column$.loc_segment_dsp8 LOC_SEGMENT_DSP8 LOC_SEGMENT_DSP18 LOV query :$column$.loc_segment_dsp9 LOC_SEGMENT_DSP9 LOC_SEGMENT_DSP18 LOV query :$column$.organization_code ORGANIZATION_CODE LOC_SEGMENT_DSP18 LOV query :$flex$.project_display_seq Project Display Seq|:project_display_seq| LOC_SEGMENT_DSP18 LOV query :$flex$.task_display_seq Task Display Seq|:task_display_seq| LOC_SEGMENT_DSP18 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS LOC_SEGMENT_DSP19 LOV query :$column$.loc_segment_dsp1 LOC_SEGMENT_DSP1 LOC_SEGMENT_DSP19 LOV query :$column$.loc_segment_dsp10 LOC_SEGMENT_DSP10 LOC_SEGMENT_DSP19 LOV query :$column$.loc_segment_dsp11 LOC_SEGMENT_DSP11 LOC_SEGMENT_DSP19 LOV query :$column$.loc_segment_dsp12 LOC_SEGMENT_DSP12 LOC_SEGMENT_DSP19 LOV query :$column$.loc_segment_dsp13 LOC_SEGMENT_DSP13 LOC_SEGMENT_DSP19 LOV query :$column$.loc_segment_dsp14 LOC_SEGMENT_DSP14 LOC_SEGMENT_DSP19 LOV query :$column$.loc_segment_dsp15 LOC_SEGMENT_DSP15 LOC_SEGMENT_DSP19 LOV query :$column$.loc_segment_dsp16 LOC_SEGMENT_DSP16 LOC_SEGMENT_DSP19 LOV query :$column$.loc_segment_dsp17 LOC_SEGMENT_DSP17 LOC_SEGMENT_DSP19 LOV query :$column$.loc_segment_dsp18 LOC_SEGMENT_DSP18 LOC_SEGMENT_DSP19 LOV query :$column$.loc_segment_dsp19 LOC_SEGMENT_DSP19 LOC_SEGMENT_DSP19 LOV query :$column$.loc_segment_dsp2 LOC_SEGMENT_DSP2 LOC_SEGMENT_DSP19 LOV query :$column$.loc_segment_dsp20 LOC_SEGMENT_DSP20 LOC_SEGMENT_DSP19 LOV query :$column$.loc_segment_dsp3 LOC_SEGMENT_DSP3 LOC_SEGMENT_DSP19 LOV query :$column$.loc_segment_dsp4 LOC_SEGMENT_DSP4 LOC_SEGMENT_DSP19 LOV query :$column$.loc_segment_dsp5 LOC_SEGMENT_DSP5 LOC_SEGMENT_DSP19 LOV query :$column$.loc_segment_dsp6 LOC_SEGMENT_DSP6 LOC_SEGMENT_DSP19 LOV query :$column$.loc_segment_dsp7 LOC_SEGMENT_DSP7 LOC_SEGMENT_DSP19 LOV query :$column$.loc_segment_dsp8 LOC_SEGMENT_DSP8 LOC_SEGMENT_DSP19 LOV query :$column$.loc_segment_dsp9 LOC_SEGMENT_DSP9 LOC_SEGMENT_DSP19 LOV query :$column$.organization_code ORGANIZATION_CODE LOC_SEGMENT_DSP19 LOV query :$flex$.project_display_seq Project Display Seq|:project_display_seq| LOC_SEGMENT_DSP19 LOV query :$flex$.task_display_seq Task Display Seq|:task_display_seq| LOC_SEGMENT_DSP19 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS LOC_SEGMENT_DSP2 LOV query :$column$.loc_segment_dsp1 LOC_SEGMENT_DSP1 LOC_SEGMENT_DSP2 LOV query :$column$.loc_segment_dsp10 LOC_SEGMENT_DSP10 LOC_SEGMENT_DSP2 LOV query :$column$.loc_segment_dsp11 LOC_SEGMENT_DSP11 LOC_SEGMENT_DSP2 LOV query :$column$.loc_segment_dsp12 LOC_SEGMENT_DSP12 LOC_SEGMENT_DSP2 LOV query :$column$.loc_segment_dsp13 LOC_SEGMENT_DSP13 LOC_SEGMENT_DSP2 LOV query :$column$.loc_segment_dsp14 LOC_SEGMENT_DSP14 LOC_SEGMENT_DSP2 LOV query :$column$.loc_segment_dsp15 LOC_SEGMENT_DSP15 LOC_SEGMENT_DSP2 LOV query :$column$.loc_segment_dsp16 LOC_SEGMENT_DSP16 LOC_SEGMENT_DSP2 LOV query :$column$.loc_segment_dsp17 LOC_SEGMENT_DSP17 LOC_SEGMENT_DSP2 LOV query :$column$.loc_segment_dsp18 LOC_SEGMENT_DSP18 LOC_SEGMENT_DSP2 LOV query :$column$.loc_segment_dsp19 LOC_SEGMENT_DSP19 LOC_SEGMENT_DSP2 LOV query :$column$.loc_segment_dsp2 LOC_SEGMENT_DSP2 LOC_SEGMENT_DSP2 LOV query :$column$.loc_segment_dsp20 LOC_SEGMENT_DSP20 LOC_SEGMENT_DSP2 LOV query :$column$.loc_segment_dsp3 LOC_SEGMENT_DSP3 LOC_SEGMENT_DSP2 LOV query :$column$.loc_segment_dsp4 LOC_SEGMENT_DSP4 LOC_SEGMENT_DSP2 LOV query :$column$.loc_segment_dsp5 LOC_SEGMENT_DSP5 LOC_SEGMENT_DSP2 LOV query :$column$.loc_segment_dsp6 LOC_SEGMENT_DSP6 LOC_SEGMENT_DSP2 LOV query :$column$.loc_segment_dsp7 LOC_SEGMENT_DSP7 LOC_SEGMENT_DSP2 LOV query :$column$.loc_segment_dsp8 LOC_SEGMENT_DSP8 LOC_SEGMENT_DSP2 LOV query :$column$.loc_segment_dsp9 LOC_SEGMENT_DSP9 LOC_SEGMENT_DSP2 LOV query :$column$.organization_code ORGANIZATION_CODE LOC_SEGMENT_DSP2 LOV query :$flex$.project_display_seq Project Display Seq|:project_display_seq| LOC_SEGMENT_DSP2 LOV query :$flex$.task_display_seq Task Display Seq|:task_display_seq| LOC_SEGMENT_DSP2 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS LOC_SEGMENT_DSP20 LOV query :$column$.loc_segment_dsp1 LOC_SEGMENT_DSP1 LOC_SEGMENT_DSP20 LOV query :$column$.loc_segment_dsp10 LOC_SEGMENT_DSP10 LOC_SEGMENT_DSP20 LOV query :$column$.loc_segment_dsp11 LOC_SEGMENT_DSP11 LOC_SEGMENT_DSP20 LOV query :$column$.loc_segment_dsp12 LOC_SEGMENT_DSP12 LOC_SEGMENT_DSP20 LOV query :$column$.loc_segment_dsp13 LOC_SEGMENT_DSP13 LOC_SEGMENT_DSP20 LOV query :$column$.loc_segment_dsp14 LOC_SEGMENT_DSP14 LOC_SEGMENT_DSP20 LOV query :$column$.loc_segment_dsp15 LOC_SEGMENT_DSP15 LOC_SEGMENT_DSP20 LOV query :$column$.loc_segment_dsp16 LOC_SEGMENT_DSP16 LOC_SEGMENT_DSP20 LOV query :$column$.loc_segment_dsp17 LOC_SEGMENT_DSP17 LOC_SEGMENT_DSP20 LOV query :$column$.loc_segment_dsp18 LOC_SEGMENT_DSP18 LOC_SEGMENT_DSP20 LOV query :$column$.loc_segment_dsp19 LOC_SEGMENT_DSP19 LOC_SEGMENT_DSP20 LOV query :$column$.loc_segment_dsp2 LOC_SEGMENT_DSP2 LOC_SEGMENT_DSP20 LOV query :$column$.loc_segment_dsp20 LOC_SEGMENT_DSP20 LOC_SEGMENT_DSP20 LOV query :$column$.loc_segment_dsp3 LOC_SEGMENT_DSP3 LOC_SEGMENT_DSP20 LOV query :$column$.loc_segment_dsp4 LOC_SEGMENT_DSP4 LOC_SEGMENT_DSP20 LOV query :$column$.loc_segment_dsp5 LOC_SEGMENT_DSP5 LOC_SEGMENT_DSP20 LOV query :$column$.loc_segment_dsp6 LOC_SEGMENT_DSP6 LOC_SEGMENT_DSP20 LOV query :$column$.loc_segment_dsp7 LOC_SEGMENT_DSP7 LOC_SEGMENT_DSP20 LOV query :$column$.loc_segment_dsp8 LOC_SEGMENT_DSP8 LOC_SEGMENT_DSP20 LOV query :$column$.loc_segment_dsp9 LOC_SEGMENT_DSP9 LOC_SEGMENT_DSP20 LOV query :$column$.organization_code ORGANIZATION_CODE LOC_SEGMENT_DSP20 LOV query :$flex$.project_display_seq Project Display Seq|:project_display_seq| LOC_SEGMENT_DSP20 LOV query :$flex$.task_display_seq Task Display Seq|:task_display_seq| LOC_SEGMENT_DSP20 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS LOC_SEGMENT_DSP3 LOV query :$column$.loc_segment_dsp1 LOC_SEGMENT_DSP1 LOC_SEGMENT_DSP3 LOV query :$column$.loc_segment_dsp10 LOC_SEGMENT_DSP10 LOC_SEGMENT_DSP3 LOV query :$column$.loc_segment_dsp11 LOC_SEGMENT_DSP11 LOC_SEGMENT_DSP3 LOV query :$column$.loc_segment_dsp12 LOC_SEGMENT_DSP12 LOC_SEGMENT_DSP3 LOV query :$column$.loc_segment_dsp13 LOC_SEGMENT_DSP13 LOC_SEGMENT_DSP3 LOV query :$column$.loc_segment_dsp14 LOC_SEGMENT_DSP14 LOC_SEGMENT_DSP3 LOV query :$column$.loc_segment_dsp15 LOC_SEGMENT_DSP15 LOC_SEGMENT_DSP3 LOV query :$column$.loc_segment_dsp16 LOC_SEGMENT_DSP16 LOC_SEGMENT_DSP3 LOV query :$column$.loc_segment_dsp17 LOC_SEGMENT_DSP17 LOC_SEGMENT_DSP3 LOV query :$column$.loc_segment_dsp18 LOC_SEGMENT_DSP18 LOC_SEGMENT_DSP3 LOV query :$column$.loc_segment_dsp19 LOC_SEGMENT_DSP19 LOC_SEGMENT_DSP3 LOV query :$column$.loc_segment_dsp2 LOC_SEGMENT_DSP2 LOC_SEGMENT_DSP3 LOV query :$column$.loc_segment_dsp20 LOC_SEGMENT_DSP20 LOC_SEGMENT_DSP3 LOV query :$column$.loc_segment_dsp3 LOC_SEGMENT_DSP3 LOC_SEGMENT_DSP3 LOV query :$column$.loc_segment_dsp4 LOC_SEGMENT_DSP4 LOC_SEGMENT_DSP3 LOV query :$column$.loc_segment_dsp5 LOC_SEGMENT_DSP5 LOC_SEGMENT_DSP3 LOV query :$column$.loc_segment_dsp6 LOC_SEGMENT_DSP6 LOC_SEGMENT_DSP3 LOV query :$column$.loc_segment_dsp7 LOC_SEGMENT_DSP7 LOC_SEGMENT_DSP3 LOV query :$column$.loc_segment_dsp8 LOC_SEGMENT_DSP8 LOC_SEGMENT_DSP3 LOV query :$column$.loc_segment_dsp9 LOC_SEGMENT_DSP9 LOC_SEGMENT_DSP3 LOV query :$column$.organization_code ORGANIZATION_CODE LOC_SEGMENT_DSP3 LOV query :$flex$.project_display_seq Project Display Seq|:project_display_seq| LOC_SEGMENT_DSP3 LOV query :$flex$.task_display_seq Task Display Seq|:task_display_seq| LOC_SEGMENT_DSP3 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS LOC_SEGMENT_DSP4 LOV query :$column$.loc_segment_dsp1 LOC_SEGMENT_DSP1 LOC_SEGMENT_DSP4 LOV query :$column$.loc_segment_dsp10 LOC_SEGMENT_DSP10 LOC_SEGMENT_DSP4 LOV query :$column$.loc_segment_dsp11 LOC_SEGMENT_DSP11 LOC_SEGMENT_DSP4 LOV query :$column$.loc_segment_dsp12 LOC_SEGMENT_DSP12 LOC_SEGMENT_DSP4 LOV query :$column$.loc_segment_dsp13 LOC_SEGMENT_DSP13 LOC_SEGMENT_DSP4 LOV query :$column$.loc_segment_dsp14 LOC_SEGMENT_DSP14 LOC_SEGMENT_DSP4 LOV query :$column$.loc_segment_dsp15 LOC_SEGMENT_DSP15 LOC_SEGMENT_DSP4 LOV query :$column$.loc_segment_dsp16 LOC_SEGMENT_DSP16 LOC_SEGMENT_DSP4 LOV query :$column$.loc_segment_dsp17 LOC_SEGMENT_DSP17 LOC_SEGMENT_DSP4 LOV query :$column$.loc_segment_dsp18 LOC_SEGMENT_DSP18 LOC_SEGMENT_DSP4 LOV query :$column$.loc_segment_dsp19 LOC_SEGMENT_DSP19 LOC_SEGMENT_DSP4 LOV query :$column$.loc_segment_dsp2 LOC_SEGMENT_DSP2 LOC_SEGMENT_DSP4 LOV query :$column$.loc_segment_dsp20 LOC_SEGMENT_DSP20 LOC_SEGMENT_DSP4 LOV query :$column$.loc_segment_dsp3 LOC_SEGMENT_DSP3 LOC_SEGMENT_DSP4 LOV query :$column$.loc_segment_dsp4 LOC_SEGMENT_DSP4 LOC_SEGMENT_DSP4 LOV query :$column$.loc_segment_dsp5 LOC_SEGMENT_DSP5 LOC_SEGMENT_DSP4 LOV query :$column$.loc_segment_dsp6 LOC_SEGMENT_DSP6 LOC_SEGMENT_DSP4 LOV query :$column$.loc_segment_dsp7 LOC_SEGMENT_DSP7 LOC_SEGMENT_DSP4 LOV query :$column$.loc_segment_dsp8 LOC_SEGMENT_DSP8 LOC_SEGMENT_DSP4 LOV query :$column$.loc_segment_dsp9 LOC_SEGMENT_DSP9 LOC_SEGMENT_DSP4 LOV query :$column$.organization_code ORGANIZATION_CODE LOC_SEGMENT_DSP4 LOV query :$flex$.project_display_seq Project Display Seq|:project_display_seq| LOC_SEGMENT_DSP4 LOV query :$flex$.task_display_seq Task Display Seq|:task_display_seq| LOC_SEGMENT_DSP4 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS LOC_SEGMENT_DSP5 LOV query :$column$.loc_segment_dsp1 LOC_SEGMENT_DSP1 LOC_SEGMENT_DSP5 LOV query :$column$.loc_segment_dsp10 LOC_SEGMENT_DSP10 LOC_SEGMENT_DSP5 LOV query :$column$.loc_segment_dsp11 LOC_SEGMENT_DSP11 LOC_SEGMENT_DSP5 LOV query :$column$.loc_segment_dsp12 LOC_SEGMENT_DSP12 LOC_SEGMENT_DSP5 LOV query :$column$.loc_segment_dsp13 LOC_SEGMENT_DSP13 LOC_SEGMENT_DSP5 LOV query :$column$.loc_segment_dsp14 LOC_SEGMENT_DSP14 LOC_SEGMENT_DSP5 LOV query :$column$.loc_segment_dsp15 LOC_SEGMENT_DSP15 LOC_SEGMENT_DSP5 LOV query :$column$.loc_segment_dsp16 LOC_SEGMENT_DSP16 LOC_SEGMENT_DSP5 LOV query :$column$.loc_segment_dsp17 LOC_SEGMENT_DSP17 LOC_SEGMENT_DSP5 LOV query :$column$.loc_segment_dsp18 LOC_SEGMENT_DSP18 LOC_SEGMENT_DSP5 LOV query :$column$.loc_segment_dsp19 LOC_SEGMENT_DSP19 LOC_SEGMENT_DSP5 LOV query :$column$.loc_segment_dsp2 LOC_SEGMENT_DSP2 LOC_SEGMENT_DSP5 LOV query :$column$.loc_segment_dsp20 LOC_SEGMENT_DSP20 LOC_SEGMENT_DSP5 LOV query :$column$.loc_segment_dsp3 LOC_SEGMENT_DSP3 LOC_SEGMENT_DSP5 LOV query :$column$.loc_segment_dsp4 LOC_SEGMENT_DSP4 LOC_SEGMENT_DSP5 LOV query :$column$.loc_segment_dsp5 LOC_SEGMENT_DSP5 LOC_SEGMENT_DSP5 LOV query :$column$.loc_segment_dsp6 LOC_SEGMENT_DSP6 LOC_SEGMENT_DSP5 LOV query :$column$.loc_segment_dsp7 LOC_SEGMENT_DSP7 LOC_SEGMENT_DSP5 LOV query :$column$.loc_segment_dsp8 LOC_SEGMENT_DSP8 LOC_SEGMENT_DSP5 LOV query :$column$.loc_segment_dsp9 LOC_SEGMENT_DSP9 LOC_SEGMENT_DSP5 LOV query :$column$.organization_code ORGANIZATION_CODE LOC_SEGMENT_DSP5 LOV query :$flex$.project_display_seq Project Display Seq|:project_display_seq| LOC_SEGMENT_DSP5 LOV query :$flex$.task_display_seq Task Display Seq|:task_display_seq| LOC_SEGMENT_DSP5 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS LOC_SEGMENT_DSP6 LOV query :$column$.loc_segment_dsp1 LOC_SEGMENT_DSP1 LOC_SEGMENT_DSP6 LOV query :$column$.loc_segment_dsp10 LOC_SEGMENT_DSP10 LOC_SEGMENT_DSP6 LOV query :$column$.loc_segment_dsp11 LOC_SEGMENT_DSP11 LOC_SEGMENT_DSP6 LOV query :$column$.loc_segment_dsp12 LOC_SEGMENT_DSP12 LOC_SEGMENT_DSP6 LOV query :$column$.loc_segment_dsp13 LOC_SEGMENT_DSP13 LOC_SEGMENT_DSP6 LOV query :$column$.loc_segment_dsp14 LOC_SEGMENT_DSP14 LOC_SEGMENT_DSP6 LOV query :$column$.loc_segment_dsp15 LOC_SEGMENT_DSP15 LOC_SEGMENT_DSP6 LOV query :$column$.loc_segment_dsp16 LOC_SEGMENT_DSP16 LOC_SEGMENT_DSP6 LOV query :$column$.loc_segment_dsp17 LOC_SEGMENT_DSP17 LOC_SEGMENT_DSP6 LOV query :$column$.loc_segment_dsp18 LOC_SEGMENT_DSP18 LOC_SEGMENT_DSP6 LOV query :$column$.loc_segment_dsp19 LOC_SEGMENT_DSP19 LOC_SEGMENT_DSP6 LOV query :$column$.loc_segment_dsp2 LOC_SEGMENT_DSP2 LOC_SEGMENT_DSP6 LOV query :$column$.loc_segment_dsp20 LOC_SEGMENT_DSP20 LOC_SEGMENT_DSP6 LOV query :$column$.loc_segment_dsp3 LOC_SEGMENT_DSP3 LOC_SEGMENT_DSP6 LOV query :$column$.loc_segment_dsp4 LOC_SEGMENT_DSP4 LOC_SEGMENT_DSP6 LOV query :$column$.loc_segment_dsp5 LOC_SEGMENT_DSP5 LOC_SEGMENT_DSP6 LOV query :$column$.loc_segment_dsp6 LOC_SEGMENT_DSP6 LOC_SEGMENT_DSP6 LOV query :$column$.loc_segment_dsp7 LOC_SEGMENT_DSP7 LOC_SEGMENT_DSP6 LOV query :$column$.loc_segment_dsp8 LOC_SEGMENT_DSP8 LOC_SEGMENT_DSP6 LOV query :$column$.loc_segment_dsp9 LOC_SEGMENT_DSP9 LOC_SEGMENT_DSP6 LOV query :$column$.organization_code ORGANIZATION_CODE LOC_SEGMENT_DSP6 LOV query :$flex$.project_display_seq Project Display Seq|:project_display_seq| LOC_SEGMENT_DSP6 LOV query :$flex$.task_display_seq Task Display Seq|:task_display_seq| LOC_SEGMENT_DSP6 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS LOC_SEGMENT_DSP7 LOV query :$column$.loc_segment_dsp1 LOC_SEGMENT_DSP1 LOC_SEGMENT_DSP7 LOV query :$column$.loc_segment_dsp10 LOC_SEGMENT_DSP10 LOC_SEGMENT_DSP7 LOV query :$column$.loc_segment_dsp11 LOC_SEGMENT_DSP11 LOC_SEGMENT_DSP7 LOV query :$column$.loc_segment_dsp12 LOC_SEGMENT_DSP12 LOC_SEGMENT_DSP7 LOV query :$column$.loc_segment_dsp13 LOC_SEGMENT_DSP13 LOC_SEGMENT_DSP7 LOV query :$column$.loc_segment_dsp14 LOC_SEGMENT_DSP14 LOC_SEGMENT_DSP7 LOV query :$column$.loc_segment_dsp15 LOC_SEGMENT_DSP15 LOC_SEGMENT_DSP7 LOV query :$column$.loc_segment_dsp16 LOC_SEGMENT_DSP16 LOC_SEGMENT_DSP7 LOV query :$column$.loc_segment_dsp17 LOC_SEGMENT_DSP17 LOC_SEGMENT_DSP7 LOV query :$column$.loc_segment_dsp18 LOC_SEGMENT_DSP18 LOC_SEGMENT_DSP7 LOV query :$column$.loc_segment_dsp19 LOC_SEGMENT_DSP19 LOC_SEGMENT_DSP7 LOV query :$column$.loc_segment_dsp2 LOC_SEGMENT_DSP2 LOC_SEGMENT_DSP7 LOV query :$column$.loc_segment_dsp20 LOC_SEGMENT_DSP20 LOC_SEGMENT_DSP7 LOV query :$column$.loc_segment_dsp3 LOC_SEGMENT_DSP3 LOC_SEGMENT_DSP7 LOV query :$column$.loc_segment_dsp4 LOC_SEGMENT_DSP4 LOC_SEGMENT_DSP7 LOV query :$column$.loc_segment_dsp5 LOC_SEGMENT_DSP5 LOC_SEGMENT_DSP7 LOV query :$column$.loc_segment_dsp6 LOC_SEGMENT_DSP6 LOC_SEGMENT_DSP7 LOV query :$column$.loc_segment_dsp7 LOC_SEGMENT_DSP7 LOC_SEGMENT_DSP7 LOV query :$column$.loc_segment_dsp8 LOC_SEGMENT_DSP8 LOC_SEGMENT_DSP7 LOV query :$column$.loc_segment_dsp9 LOC_SEGMENT_DSP9 LOC_SEGMENT_DSP7 LOV query :$column$.organization_code ORGANIZATION_CODE LOC_SEGMENT_DSP7 LOV query :$flex$.project_display_seq Project Display Seq|:project_display_seq| LOC_SEGMENT_DSP7 LOV query :$flex$.task_display_seq Task Display Seq|:task_display_seq| LOC_SEGMENT_DSP7 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS LOC_SEGMENT_DSP8 LOV query :$column$.loc_segment_dsp1 LOC_SEGMENT_DSP1 LOC_SEGMENT_DSP8 LOV query :$column$.loc_segment_dsp10 LOC_SEGMENT_DSP10 LOC_SEGMENT_DSP8 LOV query :$column$.loc_segment_dsp11 LOC_SEGMENT_DSP11 LOC_SEGMENT_DSP8 LOV query :$column$.loc_segment_dsp12 LOC_SEGMENT_DSP12 LOC_SEGMENT_DSP8 LOV query :$column$.loc_segment_dsp13 LOC_SEGMENT_DSP13 LOC_SEGMENT_DSP8 LOV query :$column$.loc_segment_dsp14 LOC_SEGMENT_DSP14 LOC_SEGMENT_DSP8 LOV query :$column$.loc_segment_dsp15 LOC_SEGMENT_DSP15 LOC_SEGMENT_DSP8 LOV query :$column$.loc_segment_dsp16 LOC_SEGMENT_DSP16 LOC_SEGMENT_DSP8 LOV query :$column$.loc_segment_dsp17 LOC_SEGMENT_DSP17 LOC_SEGMENT_DSP8 LOV query :$column$.loc_segment_dsp18 LOC_SEGMENT_DSP18 LOC_SEGMENT_DSP8 LOV query :$column$.loc_segment_dsp19 LOC_SEGMENT_DSP19 LOC_SEGMENT_DSP8 LOV query :$column$.loc_segment_dsp2 LOC_SEGMENT_DSP2 LOC_SEGMENT_DSP8 LOV query :$column$.loc_segment_dsp20 LOC_SEGMENT_DSP20 LOC_SEGMENT_DSP8 LOV query :$column$.loc_segment_dsp3 LOC_SEGMENT_DSP3 LOC_SEGMENT_DSP8 LOV query :$column$.loc_segment_dsp4 LOC_SEGMENT_DSP4 LOC_SEGMENT_DSP8 LOV query :$column$.loc_segment_dsp5 LOC_SEGMENT_DSP5 LOC_SEGMENT_DSP8 LOV query :$column$.loc_segment_dsp6 LOC_SEGMENT_DSP6 LOC_SEGMENT_DSP8 LOV query :$column$.loc_segment_dsp7 LOC_SEGMENT_DSP7 LOC_SEGMENT_DSP8 LOV query :$column$.loc_segment_dsp8 LOC_SEGMENT_DSP8 LOC_SEGMENT_DSP8 LOV query :$column$.loc_segment_dsp9 LOC_SEGMENT_DSP9 LOC_SEGMENT_DSP8 LOV query :$column$.organization_code ORGANIZATION_CODE LOC_SEGMENT_DSP8 LOV query :$flex$.project_display_seq Project Display Seq|:project_display_seq| LOC_SEGMENT_DSP8 LOV query :$flex$.task_display_seq Task Display Seq|:task_display_seq| LOC_SEGMENT_DSP8 Default value :$column$.concatenated_segments CONCATENATED_SEGMENTS LOC_SEGMENT_DSP9 LOV query :$column$.loc_segment_dsp1 LOC_SEGMENT_DSP1 LOC_SEGMENT_DSP9 LOV query :$column$.loc_segment_dsp10 LOC_SEGMENT_DSP10 LOC_SEGMENT_DSP9 LOV query :$column$.loc_segment_dsp11 LOC_SEGMENT_DSP11 LOC_SEGMENT_DSP9 LOV query :$column$.loc_segment_dsp12 LOC_SEGMENT_DSP12 LOC_SEGMENT_DSP9 LOV query :$column$.loc_segment_dsp13 LOC_SEGMENT_DSP13 LOC_SEGMENT_DSP9 LOV query :$column$.loc_segment_dsp14 LOC_SEGMENT_DSP14 LOC_SEGMENT_DSP9 LOV query :$column$.loc_segment_dsp15 LOC_SEGMENT_DSP15 LOC_SEGMENT_DSP9 LOV query :$column$.loc_segment_dsp16 LOC_SEGMENT_DSP16 LOC_SEGMENT_DSP9 LOV query :$column$.loc_segment_dsp17 LOC_SEGMENT_DSP17 LOC_SEGMENT_DSP9 LOV query :$column$.loc_segment_dsp18 LOC_SEGMENT_DSP18 LOC_SEGMENT_DSP9 LOV query :$column$.loc_segment_dsp19 LOC_SEGMENT_DSP19 LOC_SEGMENT_DSP9 LOV query :$column$.loc_segment_dsp2 LOC_SEGMENT_DSP2 LOC_SEGMENT_DSP9 LOV query :$column$.loc_segment_dsp20 LOC_SEGMENT_DSP20 LOC_SEGMENT_DSP9 LOV query :$column$.loc_segment_dsp3 LOC_SEGMENT_DSP3 LOC_SEGMENT_DSP9 LOV query :$column$.loc_segment_dsp4 LOC_SEGMENT_DSP4 LOC_SEGMENT_DSP9 LOV query :$column$.loc_segment_dsp5 LOC_SEGMENT_DSP5 LOC_SEGMENT_DSP9 LOV query :$column$.loc_segment_dsp6 LOC_SEGMENT_DSP6 LOC_SEGMENT_DSP9 LOV query :$column$.loc_segment_dsp7 LOC_SEGMENT_DSP7 LOC_SEGMENT_DSP9 LOV query :$column$.loc_segment_dsp8 LOC_SEGMENT_DSP8 LOC_SEGMENT_DSP9 LOV query :$column$.loc_segment_dsp9 LOC_SEGMENT_DSP9 LOC_SEGMENT_DSP9 LOV query :$column$.organization_code ORGANIZATION_CODE LOC_SEGMENT_DSP9 LOV query :$flex$.project_display_seq Project Display Seq|:project_display_seq| LOC_SEGMENT_DSP9 LOV query :$flex$.task_display_seq Task Display Seq|:task_display_seq| LOC_SEGMENT_DSP9 LOV query :$column$.organization_code ORGANIZATION_CODE SUBINVENTORY LOV query :$column$.organization_code ORGANIZATION_CODE TYPE LOV query :$column$.subinventory SUBINVENTORY TYPE Value to id query :$column$.organization_code ORGANIZATION_CODE p_inventory_location_type Value to id query :$column$.subinventory SUBINVENTORY p_inventory_location_type