APPS.PO_POXRQSIN_XMLP_PKG SQL Statements

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

Line: 15

    select displayed_field
    into l_status
    from po_lookup_codes
    where lookup_code = P_status
    and lookup_type = 'AUTHORIZATION STATUS';

Line: 32

    select displayed_field
    into l_sort
    from po_lookup_codes
    where lookup_code = P_orderby
    and lookup_type = 'SRS ORDER BY';

Line: 63

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

Line: 75

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

Line: 152

        select structure_id
        into l_p_struct_num
        from mtl_default_sets_view
        where functional_area_id = 2 ;

Line: 205

(select 1 from oe_headers_iface_all OEI
WHERE OEI.orig_sys_document_ref = PRH.requisition_header_id
AND   OEI.order_source_id = 10)');

Line: 253

       SELECT  psp.manual_req_num_type        manual_req_num_type
       into    P_req_num_type
       FROM    po_system_parameters psp;