APEX

I am trying to implement Denes Kubicek's example of cascading lovs in a tabular form. My tabular form is slightly different in that I have one LOV (species, c013) that, if changed, will impact three other LOVs. I have simplified the code to have it modify only one lov (unit of measure, c016).

When the species is changed, the unit of measure LOV comes up blank. Can anyone help me on this?

Also, I would like all of my LOVs to have the format of select desc, code from x...for example (select common_name, species_code from species), so that that LOV has the actual descriptor, but the value is populated with code. I know this is possible, but does it impact the cascading LOV.

my code is as follows:

select
apex_item.hidden(11,seq_id) seq,
apex_item.hidden (12,seq_id)||
apex_item.select_list_from_query_XL(13,c013,'select distinct s.common_name , s.species_itis
from species s, species_qc c
where partner_id = '||:F200_issuing_agency||' and
c.species_itis = s.species_itis order by s.common_name',
'style="width:220px" '
|| 'onchange="f_set_casc_sel_list_item(html_SelectValue(this),'
|| 'f16_'
|| LPAD (seq_id, 4, '0')
|| ')"',
'YES',
'0',
'- Select Species -',
'f13_' || LPAD (seq_id,4, '0'),
NULL,
'NO'
) SPECIES_ITIS,
apex_item.select_list_from_query(14,c014,'select disposition_desc d, disposition_code r
from dispositions
where displayed = 1 order by disposition_desc') DISPOSITION_CODE,
apex_item.text(15,c015) reported_quantity,
apex_item.select_list_from_query(16,c016,'SELECT DISTINCT unit_of_measure
FROM species_Qc s, units_of_measure u
WHERE s.unit_of_measure = u.unit_measure
AND partner_id = '||:F200_ISSUING_AGENCY||' and species_itis = '|| c013 ,
'style="width:220px"',
'YES',
'0',
'- Select Unit -',
'f16_' || LPAD (seq_id, 4, '0'),
NULL,
'NO' ) UNIT_MEASURE,
apex_item.SELECT_LIST_FROM_LOV(17,c017,'SALE_DISPOSITION') SALE_DISPOSITION_FLAG,
apex_item.text(18,c018) PRICE,
apex_item.text(19,c019) PERMIT_ID,
apex_item.text(20,c020) MARKET_CODE,
apex_item.text(21,c021) GRADE_CODE,
apex_item.text(22,c022) trip_id
from apex_collections c
where collection_name = 'CATCH_C' and
c.c022 = :F200_CURRENT_TRIP_ID
UNION ALL
select
apex_item.hidden(11,null) seq,
apex_item.hidden (12,null)||
apex_item.select_list_from_query_XL(13,0,'select distinct s.common_name , s.species_itis
from species s, species_qc c
where partner_id = '||:f200_issuing_agency||' and
c.species_itis = s.species_itis order by s.common_name',
'style="width:220px" '
|| 'onchange="f_set_casc_sel_list_item(html_SelectValue(this),'
|| 'f16_'
|| LPAD (9900 + LEVEL, 4, '0')
|| ')"',
'YES',
'0',
'- Select Species -',
'f13_' || LPAD (9900 + LEVEL,4, '0'),
NULL,
'NO'
) SPECIES_ITIS,
apex_item.select_list_from_query(14,null,'select disposition_desc d, disposition_code r
from dispositions
where displayed = 1 order by disposition_desc') DISPOSITION_CODE,
apex_item.text(15,null) reported_quantity,
apex_item.select_list_from_query(16,null,'SELECT DISTINCT unit_of_measure
FROM species_Qc s, units_of_measure u
WHERE s.unit_of_measure = u.unit_measure
AND partner_id = '||:F200_ISSUING_AGENCY||' and species_itis = '||0,
'style="width:220px"',
'YES',
'0',
'- Select Unit -',
'f16_' || LPAD (9900 + LEVEL, 4, '0'),
NULL,
'NO' ) UNIT_MEASURE,
apex_item.SELECT_LIST_FROM_LOV(17,null,'SALE_DISPOSITION') SALE_DISPOSITION_FLAG,
apex_item.text(18,null) PRICE,
apex_item.text(19,null) PERMIT_ID,
apex_item.text(20,null) MARKET_CODE,
apex_item.text(21,null) GRADE_CODE,
apex_item.text(22,null) trip_id
FROM DUAL
WHERE :request = 'ADD'
CONNECT BY LEVEL = 2