DBA Data[Home] [Help]

APPS.PO_POXRQRCO_XMLP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 30

	select description
	into l_message1
	from po_lookup_codes
	where lookup_type = 'SRW MESSAGE'
	and lookup_code = 'CANNOT RUN PROGRAM' ;
Line: 44

	select description
	into l_message1
	from po_lookup_codes
	where lookup_type = 'SRW MESSAGE'
	and lookup_code = 'FAILURE TO GET STATUS' ;
Line: 118

        select structure_id
        into l_p_struct_num
        from mtl_default_sets_view
        where functional_area_id = 2 ;
Line: 163

select meaning
  into w_meaning
  from fnd_lookups
 where lookup_type = p_lookup_type
   and lookup_code = p_lookup_code ;