APPS.POA_EDW_SUP_PERF_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_line_locations_all		pll,
	po_lines_all			pol,
	po_headers_all			poh
    WHERE     pll.approved_flag           = 'Y'
      AND     pll.shipment_type in ('BLANKET', 'SCHEDULED', 'STANDARD')
      AND     pll.po_line_id              = pol.po_line_id
      AND     pll.po_header_id            = poh.po_header_id
      and greatest(pol.last_update_date, poh.last_update_date,
                   pll.last_update_date)
           between p_from_date and p_to_date;

Line: 105

 x_LAST_UPDATE_DATE                         NUMBER :=0;

Line: 125

        SELECT  avg(nvl(vsize(vendor_product_num), 0)),
        avg(nvl(vsize(item_id), 0)),
        avg(nvl(vsize(ITEM_REVISION), 0)),
        avg(nvl(vsize(item_description), 0)),
        avg(nvl(vsize(category_id), 0)),
        avg(nvl(vsize(price_type_lookup_code), 0)),
        avg(nvl(vsize(contract_num), 0))
        from po_lines_all
        where last_update_date between
        p_from_date  and  p_to_date;

Line: 137

        SELECT  avg(nvl(vsize(line_location_id), 0)),
        avg(nvl(vsize(ship_to_organization_id), 0)),
        avg(nvl(vsize(ship_to_location_id), 0)),
        avg(nvl(vsize(closed_code), 0)),
        avg(nvl(vsize(receive_close_tolerance), 0))
        from po_line_locations_all
        where last_update_date between
        p_from_date  and  p_to_date;

Line: 147

        SELECT avg(nvl(vsize(agent_id), 0)),
        avg(nvl(vsize(vendor_site_id), 0)),
        avg(nvl(vsize(org_id), 0)),
        avg(nvl(vsize(terms_id), 0)),
        avg(nvl(vsize(currency_code), 0)),
        avg(nvl(vsize(segment1), 0))
        from po_headers_all
        where last_update_date between
        p_from_date  and  p_to_date;

Line: 158

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

Line: 164

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

Line: 170

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

Line: 176

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

Line: 182

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