APPS.PO_POXDETIT_XMLP_PKG SQL Statements

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

Line: 14

    select displayed_field
    into l_active_inactive
    from po_lookup_codes
    where lookup_code = P_active_inactive
    and lookup_type = 'ACTIVE_INACTIVE';

Line: 42

   select gsb.chart_of_accounts_id into p_chart_of_accounts_id
   from gl_sets_of_books gsb, financials_system_parameters fsp
   where gsb.set_of_books_id = fsp.set_of_books_id;

Line: 121

 select count(*), max(category_flex_structure)
 into   P_FA_INSTALLED, P_acat_struct_num
 from fa_system_controls;

Line: 187

        select structure_id
        into l_p_struct_num
        from mtl_default_sets_view
        where functional_area_id = 2 ;

Line: 217

function C_CST_SELECTFormula return VARCHAR2 is
begin

IF (P_CST_STATUS = 'I') THEN
RETURN(',CIC.UNBURDENED_COST    standard_cost') ;

Line: 263

    select short_text
      into short_note
      from fnd_documents_short_text
     where media_id = item_note_media_id;

Line: 269

    select long_text
      into long_note
      from fnd_documents_long_text
     where media_id = item_note_media_id;