Changing the Order by of LOV of KFF using fnd_key_flex.define
I am trying to change the order by of list of value for Key Flex Filed colume.
I have defined View:
create or replace view xx_mtl_item_locations_qty_v as
select l."INVENTORY_LOCATION_ID",l."ORGANIZATION_ID",l."LAST_UPDATE_DATE",l."LAST_UPDATED_BY",l."CREATION_DATE",l."CREATED_BY",l."LAST_UPDATE_LOGIN",l."DESCRIPTION",l."DESCRIPTIVE_TEXT",l."DISABLE_DATE",l."INVENTORY_LOCATION_TYPE",l."PICKING_ORDER",l."PHYSICAL_LOCATION_CODE",l."LOCATION_MAXIMUM_UNITS",l."SUBINVENTORY_CODE",l."LOCATION_WEIGHT_UOM_CODE",l."MAX_WEIGHT",l."VOLUME_UOM_CODE",l."MAX_CUBIC_AREA",l."X_COORDINATE",l."Y_COORDINATE",l."Z_COORDINATE",l."INVENTORY_ACCOUNT_ID",l."SEGMENT1",l."SEGMENT2",l."SEGMENT3",l."SEGMENT4",l."SEGMENT5",l."SEGMENT6",l."SEGMENT7",l."SEGMENT8",l."SEGMENT9",l."SEGMENT10",l."SEGMENT11",l."SEGMENT12",l."SEGMENT13",l."SEGMENT14",l."SEGMENT15",l."SEGMENT16",l."SEGMENT17",l."SEGMENT18",l."SEGMENT19",l."SEGMENT20",l."SUMMARY_FLAG",l."ENABLED_FLAG",l."START_DATE_ACTIVE",l."END_DATE_ACTIVE",l."ATTRIBUTE_CATEGORY",l."ATTRIBUTE1",l."ATTRIBUTE2",l."ATTRIBUTE3",l."ATTRIBUTE4",l."ATTRIBUTE5",l."ATTRIBUTE6",l."ATTRIBUTE7",l."ATTRIBUTE8",l."ATTRIBUTE9",l."ATTRIBUTE10",l."ATTRIBUTE11",l."ATTRIBUTE12",l."ATTRIBUTE13",l."ATTRIBUTE14",l."ATTRIBUTE15",l."REQUEST_ID",l."PROGRAM_APPLICATION_ID",l."PROGRAM_ID",l."PROGRAM_UPDATE_DATE",l."PROJECT_ID",l."TASK_ID",l."PHYSICAL_LOCATION_ID",l."PICK_UOM_CODE",l."DIMENSION_UOM_CODE",l."LENGTH",l."WIDTH",l."HEIGHT",l."LOCATOR_STATUS",l."STATUS_ID",l."CURRENT_CUBIC_AREA",l."AVAILABLE_CUBIC_AREA",l."CURRENT_WEIGHT",l."AVAILABLE_WEIGHT",l."LOCATION_CURRENT_UNITS",l."LOCATION_AVAILABLE_UNITS",l."INVENTORY_ITEM_ID",l."SUGGESTED_CUBIC_AREA",l."SUGGESTED_WEIGHT",l."LOCATION_SUGGESTED_UNITS",l."EMPTY_FLAG",l."MIXED_ITEMS_FLAG",l."DROPPING_ORDER",