[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select count(*) into p_num_rows
from
po_distributions_all pod,
po_line_locations_all pll,
po_lines_all pol,
po_headers_all poh
WHERE pll.shipment_type in ('BLANKET', 'SCHEDULED', 'STANDARD')
and pll.approved_flag = 'Y'
and pll.line_location_id = pod.line_location_id
and pod.po_line_id = pol.po_line_id
and pod.po_header_id = poh.po_header_id
and greatest(pol.last_update_date, poh.last_update_date,
pll.last_update_date, pod.last_update_date)
between p_from_date and p_to_date;
SELECT avg(nvl(vsize(po_distribution_id), 0)),
avg(nvl(vsize(deliver_to_person_id), 0)),
avg(nvl(vsize(destination_organization_id), 0)),
avg(nvl(vsize(set_of_books_id), 0)),
avg(nvl(vsize(deliver_to_location_id), 0)),
avg(nvl(vsize(task_id), 0)),
avg(nvl(vsize(project_id), 0)),
avg(nvl(vsize(destination_type_code), 0)),
avg(nvl(vsize(accrued_flag), 0)),
avg(nvl(vsize(encumbered_flag), 0)),
avg(nvl(vsize(req_distribution_id), 0)),
avg(nvl(vsize(line_location_id), 0)),
avg(nvl(vsize(po_header_id), 0)),
avg(nvl(vsize(po_line_id), 0)),
avg(nvl(vsize(po_release_id), 0)),
avg(nvl(vsize(source_distribution_id), 0))
from po_distributions_all
where last_update_date between
p_from_date and p_to_date;
SELECT avg(nvl(vsize(vendor_product_num), 0)),
avg(nvl(vsize(item_id), 0)),
avg(nvl(vsize(ITEM_REVISION), 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(item_description), 0)),
avg(nvl(vsize(note_to_vendor), 0)),
avg(nvl(vsize(contract_num), 0))
from po_lines_all
where last_update_date between
p_from_date and p_to_date;
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(shipment_type), 0)),
avg(nvl(vsize(closed_code), 0)),
avg(nvl(vsize(allow_substitute_receipts_flag), 0)),
avg(nvl(vsize(approved_flag), 0)),
avg(nvl(vsize(cancel_flag), 0)),
avg(nvl(vsize(inspection_required_flag), 0)),
avg(nvl(vsize(receipt_required_flag), 0)),
avg(nvl(vsize(taxable_flag), 0)),
avg(nvl(vsize(cancel_reason), 0)),
avg(nvl(vsize(closed_reason), 0)),
avg(nvl(vsize(source_shipment_id), 0))
from po_line_locations_all
where last_update_date between
p_from_date and p_to_date;
SELECT avg(nvl(vsize(agent_id), 0)),
avg(nvl(vsize(vendor_site_id), 0)),
avg(nvl(vsize(org_id), 0)),
avg(nvl(vsize(bill_to_location_id), 0)),
avg(nvl(vsize(terms_id), 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(user_hold_flag), 0)),
avg(nvl(vsize(confirming_order_flag), 0)),
avg(nvl(vsize(edi_processed_flag), 0)),
avg(nvl(vsize(pcard_id), 0)),
avg(nvl(vsize(currency_code), 0)),
avg(nvl(vsize(note_to_vendor), 0)),
avg(nvl(vsize(comments), 0)),
avg(nvl(vsize(note_to_receiver), 0)),
avg(nvl(vsize(revision_num), 0)),
avg(nvl(vsize(segment1), 0))
from po_headers_all
where last_update_date between
p_from_date and p_to_date;
SELECT avg(nvl(vsize(routing_name), 0))
from rcv_routing_headers;
SELECT avg(nvl(vsize(uom_code), 0))
from mtl_units_of_measure
where last_update_date between
p_from_date and p_to_date;
SELECT avg(nvl(vsize(line_type), 0))
from po_line_types
where last_update_date between
p_from_date and p_to_date;
SELECT avg(nvl(vsize(release_num), 0))
from po_releases_all
where last_update_date between
p_from_date and p_to_date;
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;
SELECT avg(nvl(vsize(vendor_name), 0))
from PO_VENDORS
where last_update_date between
p_from_date and p_to_date;