DBA Data[Home] [Help]

APPS.PO_POXRVOVS_XMLP_PKG SQL Statements

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

Line: 16

    select displayed_field
    into l_sort
    from po_lookup_codes
    where lookup_code = P_sort
    and lookup_type = 'SRS ORDER BY';
Line: 32

    select organization_name
    into l_org_displayed
    from org_organization_definitions
    where organization_id = P_org_id ;
Line: 120

        select structure_id
        into l_p_struct_num
        from mtl_default_sets_view
        where functional_area_id = 2 ;