APPS.PO_POXPRREQ_XMLP_PKG SQL Statements

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

Line: 55

        select structure_id
        into l_p_struct_num
        from mtl_default_sets_view
        where functional_area_id = 2 ;

Line: 73

        select gsob.chart_of_accounts_id
        into l_chart_of_accounts_id
        from gl_sets_of_books gsob,
        financials_system_parameters fsp
        where  fsp.set_of_books_id = gsob.set_of_books_id ;

Line: 135

    select short_text
      into short_note
      from fnd_documents_short_text
     where media_id = line_note_media_id;

Line: 141

    select long_text
      into long_note
      from fnd_documents_long_text
     where media_id = line_note_media_id;

Line: 157

    select short_text
      into short_note
      from fnd_documents_short_text
     where media_id = item_note_media_id;

Line: 163

    select long_text
      into long_note
      from fnd_documents_long_text
     where media_id = item_note_media_id;

Line: 180

      select short_text
        into short_note
        from fnd_documents_short_text
        where media_id = header_note_media_id;

Line: 188

      select long_text
        into long_note
        from fnd_documents_long_text
        where media_id = header_note_media_id;