APPS.POA_EDW_RCV_TXNS_F_SIZE SQL Statements

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

Line: 11

    select count(*) into p_num_rows
      from
           PO_HEADERS_ALL               POH,
           PO_LINES_ALL                 POL,
           PO_LINE_LOCATIONS_ALL        PLL,
           RCV_SHIPMENT_HEADERS         RSH,
           RCV_SHIPMENT_LINES           RSL,
           RCV_TRANSACTIONS             RCV
     WHERE
           RCV.SHIPMENT_HEADER_ID = RSH.SHIPMENT_HEADER_ID
       AND RCV.SHIPMENT_LINE_ID   = RSL.SHIPMENT_LINE_ID
       AND RCV.PO_LINE_LOCATION_ID   = PLL.LINE_LOCATION_ID
       AND PLL.PO_HEADER_ID = POH.PO_HEADER_ID
       AND PLL.PO_LINE_ID   = POL.PO_LINE_ID
       and greatest(pol.last_update_date, poh.last_update_date,
                    pll.last_update_date, rsh.last_update_date,
                    rsl.last_update_date, rcv.last_update_date)
             between p_from_date and p_to_date;

Line: 115

 x_LAST_UPDATE_DATE                         NUMBER := 0;

Line: 126

        SELECT  avg(nvl(vsize(TRANSACTION_ID), 0)),
        avg(nvl(vsize(TRANSACTION_TYPE), 0)),
        avg(nvl(vsize(DESTINATION_TYPE_CODE), 0)),
        avg(nvl(vsize(location_id), 0)),
        avg(nvl(vsize(deliver_to_location_id), 0)),
        avg(nvl(vsize(locator_id), 0)),
        avg(nvl(vsize(organization_id), 0)),
        avg(nvl(vsize(subinventory), 0)),
        avg(nvl(vsize(DELIVER_TO_PERSON_ID), 0)),
        avg(nvl(vsize(SUBSTITUTE_UNORDERED_CODE), 0)),
        avg(nvl(vsize(INSPECTION_STATUS_CODE), 0)),
        avg(nvl(vsize(INSPECTION_QUALITY_CODE), 0)),
        avg(nvl(vsize(RECEIPT_EXCEPTION_FLAG), 0)),
        avg(nvl(vsize(USER_ENTERED_FLAG), 0)),
        avg(nvl(vsize(REASON_ID), 0)),
        avg(nvl(vsize(VENDOR_LOT_NUM), 0)),
        avg(nvl(vsize(RMA_REFERENCE), 0)),
        avg(nvl(vsize(COMMENTS), 0))
        from RCV_TRANSACTIONS
        where last_update_date between
        p_from_date  and  p_to_date;

Line: 149

        SELECT avg(nvl(vsize(ITEM_REVISION), 0)),
        avg(nvl(vsize(PACKING_SLIP), 0))
        from RCV_SHIPMENT_LINES
        where last_update_date between
        p_from_date  and  p_to_date;

Line: 156

        SELECT avg(nvl(vsize(RECEIPT_SOURCE_CODE), 0)),
        avg(nvl(vsize(PAYMENT_TERMS_ID), 0)),
        avg(nvl(vsize(FREIGHT_CARRIER_CODE), 0)),
        avg(nvl(vsize(SHIPMENT_NUM), 0)),
        avg(nvl(vsize(RECEIPT_NUM), 0)),
        avg(nvl(vsize(COMMENTS), 0)),
        avg(nvl(vsize(WAYBILL_AIRBILL_NUM), 0)),
        avg(nvl(vsize(BILL_OF_LADING), 0))
        from RCV_SHIPMENT_HEADERS
        where last_update_date between
        p_from_date  and  p_to_date;

Line: 170

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

Line: 179

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

Line: 185

        SELECT avg(nvl(vsize(vendor_site_id), 0)),
        avg(nvl(vsize(org_id), 0)),
        avg(nvl(vsize(agent_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: 195

        SELECT  avg(nvl(vsize(routing_name), 0))
        from rcv_routing_headers;

Line: 199

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

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

Line: 211

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

Line: 217

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

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