APPS.POA_EDW_CONTRACT_F_SIZE SQL Statements

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

Line: 12

    select count(*) into p_num_rows
      from po_headers_all
     WHERE type_lookup_code            in ('CONTRACT', 'BLANKET')
       and approved_flag		= 'Y'
       and last_update_date between p_from_date and p_to_date;

Line: 90

 x_LAST_UPDATE_DATE                     NUMBER;

Line: 96

        SELECT  avg(nvl(vsize(agent_id), 0)),
        avg(nvl(vsize(po_header_id), 0)),
        avg(nvl(vsize(vendor_site_id), 0)),
        avg(nvl(vsize(org_id), 0)),
        avg(nvl(vsize(terms_id), 0)),
        avg(nvl(vsize(closed_code), 0)),
        avg(nvl(vsize(type_lookup_code), 0)),
        avg(nvl(vsize(ship_via_lookup_code), 0)),
        avg(nvl(vsize(fob_lookup_code), 0)),
        avg(nvl(vsize(freight_terms_lookup_code), 0)),
        avg(nvl(vsize(acceptance_required_flag), 0)),
        avg(nvl(vsize(frozen_flag), 0)),
        avg(nvl(vsize(bill_to_location_id), 0)),
        avg(nvl(vsize(ship_to_location_id), 0)),
        avg(nvl(vsize(vendor_site_id), 0)),
        avg(nvl(vsize(currency_code), 0)),
        avg(nvl(vsize(comments), 0)),
        avg(nvl(vsize(note_to_receiver), 0)),
        avg(nvl(vsize(note_to_vendor), 0)),
        avg(nvl(vsize(approved_flag), 0)),
        avg(nvl(vsize(user_hold_flag), 0)),
        avg(nvl(vsize(revision_num), 0)),
        avg(nvl(vsize(segment1), 0)),
        avg(nvl(vsize(rate), 0)),
        avg(nvl(vsize(confirming_order_flag), 0)),
        avg(nvl(vsize(edi_processed_flag), 0))
        from PO_HEADERS_ALL
        where last_update_date between
                  p_from_date  and  p_to_date;

Line: 129

        SELECT  avg(nvl(vsize(currency_code), 0))
        from gl_sets_of_books
        where last_update_date between
                   p_from_date  and  p_to_date;