DBA Data[Home] [Help]

APPS.PO_POXRVRTN_XMLP_PKG SQL Statements

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

Line: 22

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

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

        select structure_id
        into l_p_struct_num
        from mtl_default_sets_view
        where functional_area_id = 2 ;