APPS.POA_EDW_ALINES_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_lines_all			pol,
           po_headers_all		poh
     WHERE poh.type_lookup_code 		= 'BLANKET'
       and poh.approved_flag		= 'Y'
       and poh.po_header_id		= pol.po_header_id
       and greatest(pol.last_update_date, poh.last_update_date)
             between p_from_date and p_to_date;

Line: 72

 x_LAST_UPDATE_DATE                     NUMBER;

Line: 123

        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(confirming_order_flag), 0)),
        avg(nvl(vsize(supply_agreement_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: 154

        SELECT  avg(nvl(vsize(po_line_id), 0)),
        avg(nvl(vsize(ITEM_REVISION), 0)),
        avg(nvl(vsize(item_id), 0)),
        avg(nvl(vsize(item_description), 0)),
        avg(nvl(vsize(category_id), 0)),
        avg(nvl(vsize(transaction_reason_code), 0)),
        avg(nvl(vsize(price_type_lookup_code), 0)),
        avg(nvl(vsize(price_break_lookup_code), 0)),
        avg(nvl(vsize(negotiated_by_preparer_flag), 0)),
        avg(nvl(vsize(cancel_flag), 0)),
        avg(nvl(vsize(closed_flag), 0)),
        avg(nvl(vsize(VENDOR_PRODUCT_NUM), 0)),
        avg(nvl(vsize(po_header_id), 0)),
        avg(nvl(vsize(po_line_id), 0)),
        avg(nvl(vsize(note_to_vendor), 0)),
        avg(nvl(vsize(cancel_reason), 0))
        from PO_LINES_ALL
        where last_update_date between
              p_from_date  and  p_to_date;

Line: 177

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

Line: 184

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

Line: 191

        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: 197

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

Line: 203

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