Declare
	
	m_cnt1 NUMBER;
	lov_id lov;
	a_value_chosen Boolean;
	V_QUERY VARCHAR2(5000) := NULL;
	
Begin
select q.uqmt_qry_txt||''''||:LC_REQ_HDR_TAB.LRHT_VENDR_CD||'''' ||' and plht_release_dt >= '||''''||:global.fy_st_dt||''''||')  order by 1' into v_query 
from unit_qry_mst1_tab q 
where q.uqmt_unit_cd = :LC_REQ_HDR_TAB.LRHT_UNIT_CD 
and q.uqmt_qry_sr = '9'  ;

m_cnt1 := POPULATE_GROUP_WITH_QUERY('LV_CTRCT', v_query );                                  
lov_id := FIND_LOV   ('LV_CTRCT'); 
a_value_chosen  := show_lov(lov_id);
IF NOT  a_value_chosen then
	 Message('you have not selected a value');
END IF;	  
end;

select distinct plht_cntrct_cd from mrp2.po_lcl_hdr3_tab@mrp_rab_ora10g_link where plht_vmt_vndr_cd = 

SELECT DISTINCT plht_cntrct_cd 
from
MRP2.po_lcl_hdr3_tab@MRP_RAB_ORA10G_LINK a 
where 
a.plht_vmt_vndr_cd = :LC_REQ_HDR_TAB.LRHT_VENDR_CD and
a.plht_release_dt >=  '01-APR-2010'