[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select sum(cnt) into p_num_rows
from (
select count(*) cnt
from
po_vendors vnd,
po_vendor_sites_all vns
WHERE vns.vendor_id = vnd.vendor_id
and greatest(vns.last_update_date, vnd.last_update_date)
between p_from_date and p_to_date
union all
select count(*) cnt
from
HZ_PARTIES parties,
HZ_CUST_ACCOUNTS hzca,
HZ_CUST_ACCT_SITES_ALL hcas,
HZ_CUST_SITE_USES_ALL hcss
WHERE hcss.CUST_ACCT_SITE_ID = hcas.CUST_ACCT_SITE_ID
AND hcas.CUST_ACCOUNT_ID = hzca.CUST_ACCOUNT_ID
AND hzca.party_id = parties.party_id
and greatest(hcss.last_update_date, hzca.last_update_date,
hcas.last_update_date, parties.last_update_date)
between p_from_date and p_to_date
union all
select count(*) cnt
from
po_vendors
where last_update_date between p_from_date and p_to_date
union all
select count(*) cnt
FROM hz_cust_accounts hzca,
hz_parties parties
WHERE hzca.party_id = parties.party_id
and greatest(parties.last_update_date, hzca.last_update_date)
between p_from_date and p_to_date
union all
select count(*) cnt
from hz_parties
where last_update_date between p_from_date and p_to_date);
x_LAST_UPDATE_DATE NUMBER := 0;
select avg(nvl(vsize(vendor_id), 0)),
avg(nvl(vsize(parent_vendor_id), 0)),
avg(nvl(vsize(vendor_name), 0)),
avg(nvl(vsize(vendor_name_alt), 0)),
avg(nvl(vsize(standard_industry_class), 0)),
avg(nvl(vsize(vat_registration_num),0)),
avg(nvl(vsize(num_1099),0)),
avg(nvl(vsize(terms_id),0)),
avg(nvl(vsize(segment1),0)),
avg(nvl(vsize(vendor_type_lookup_code),0)),
avg(nvl(vsize(one_time_flag),0)),
avg(nvl(vsize(minority_group_lookup_code),0)),
avg(nvl(vsize(women_owned_flag),0)),
avg(nvl(vsize(small_business_flag),0)),
avg(nvl(vsize(hold_flag),0)),
avg(nvl(vsize(inspection_required_flag),0)),
avg(nvl(vsize(receipt_required_flag),0)),
avg(nvl(vsize(allow_substitute_receipts_flag),0)),
avg(nvl(vsize(allow_unordered_receipts_flag),0))
from po_vendors where last_update_date
between p_from_date and p_to_date;
select avg(nvl(vsize(instance_code),0))
from edw_local_instance;
select avg(nvl(vsize(cust_account_id),0)),
avg(nvl(vsize(account_number),0)),
avg(nvl(vsize(orig_system_reference),0)),
avg(nvl(vsize(status),0)),
avg(nvl(vsize(customer_type),0)),
avg(nvl(vsize(customer_class_code),0)),
avg(nvl(vsize(sales_channel_code),0)),
avg(nvl(vsize(tax_code),0)),
avg(nvl(vsize(coterminate_day_month),0)),
avg(nvl(vsize(fob_point),0)),
avg(nvl(vsize(freight_term),0)),
avg(nvl(vsize(ship_partial),0)),
avg(nvl(vsize(ship_via),0)),
avg(nvl(vsize(tax_header_level_flag),0)),
avg(nvl(vsize(tax_rounding_rule),0)),
avg(nvl(vsize(party_id),0))
from hz_cust_accounts where last_update_date
between p_from_date and p_to_date;
select avg(nvl(vsize(party_name),0)),
avg(nvl(vsize(organization_name_phonetic),0)),
avg(nvl(vsize(sic_code),0)),
avg(nvl(vsize(tax_reference),0)),
avg(nvl(vsize(jgzz_fiscal_code),0)),
avg(nvl(vsize(party_number),0)),
avg(nvl(vsize(party_type),0)),
avg(nvl(vsize(analysis_fy),0)),
avg(nvl(vsize(customer_key),0)),
avg(nvl(vsize(fiscal_yearend_month),0)),
avg(nvl(vsize(employees_total),0)),
avg(nvl(vsize(curr_fy_potential_revenue),0)),
avg(nvl(vsize(next_fy_potential_revenue),0)),
avg(nvl(vsize(year_established),0)),
avg(nvl(vsize(gsa_indicator_flag),0)),
avg(nvl(vsize(do_not_mail_flag),0))
from hz_parties;
select avg(nvl(vsize(name),0))
from ap_terms_tl;
select avg(nvl(vsize(name),0))
from oe_transaction_types_tl;
select avg(nvl(vsize(name),0))
from qp_list_headers_tl;
select avg(nvl(vsize(vendor_site_id), 0)),
avg(nvl(vsize(address_line1),0)),
avg(nvl(vsize(address_line2),0)),
avg(nvl(vsize(address_line3),0)),
avg(nvl(vsize(city),0)),
avg(nvl(vsize(county),0)),
avg(nvl(vsize(state),0)),
avg(nvl(vsize(zip),0)),
avg(nvl(vsize(province),0)),
avg(nvl(vsize(country),0)),
avg(nvl(vsize(vendor_site_code),0)),
avg(nvl(vsize(purchasing_site_flag),0)),
avg(nvl(vsize(rfq_only_site_flag),0)),
avg(nvl(vsize(pay_site_flag),0))
from po_vendor_sites_all where last_update_date
between p_from_date and p_to_date;
select avg(nvl(vsize(site_use_code),0)),
avg(nvl(vsize(location),0)),
avg(nvl(vsize(primary_flag),0)),
avg(nvl(vsize(status),0)),
avg(nvl(vsize(orig_system_reference),0)),
avg(nvl(vsize(sic_code),0)),
avg(nvl(vsize(gsa_indicator),0)),
avg(nvl(vsize(ship_partial),0)),
avg(nvl(vsize(ship_via),0)),
avg(nvl(vsize(fob_point),0)),
avg(nvl(vsize(freight_term),0)),
avg(nvl(vsize(tax_reference),0)),
avg(nvl(vsize(sort_priority),0)),
avg(nvl(vsize(tax_code),0)),
avg(nvl(vsize(demand_class_code),0)),
avg(nvl(vsize(tax_header_level_flag),0)),
avg(nvl(vsize(tax_rounding_rule),0))
from HZ_CUST_SITE_USES_ALL where last_update_date
between p_from_date and p_to_date;
select avg(nvl(vsize(name), 0))
from ra_territories where last_update_date
between p_from_date and p_to_date;
select avg(nvl(vsize(name), 0))
from ra_salesreps_all where last_update_date
between p_from_date and p_to_date;
x_last_update_date := x_date;
(x_last_update_date + 1) + NVL (ceil(x_NAME + 1), 0) +
(x_START_ACTIVE_DATE + 1) + (x_END_ACTIVE_DATE + 1);
x_last_update_date := x_date;
NVL (ceil(x_cust_tax_round + 1), 0) + (x_last_update_date + 1) +
(x_creation_date + 1) + NVL (ceil(x_customer_id + 1), 0)
+ NVL (ceil(x_trade_partner_dp + 1), 0) +
NVL (ceil(x_alternate_name + 1), 0) +
NVL (ceil(x_sic_code + 1), 0) + NVL (ceil(x_tax_reg_num + 1), 0) +
NVL (ceil(x_taxpayer_id + 1), 0) +
NVL (ceil(x_cust_prospect + 1), 0) +
NVL (ceil(x_cust_analysis_fy + 1), 0) + NVL (ceil(x_cust_key + 1), 0) +
NVL (ceil(x_cust_fiscal_end + 1), 0) + NVL (ceil(x_cust_num_emp + 1), 0) +
NVL (ceil(x_cust_revenue_curr + 1), 0) + NVL (ceil(x_cust_revenue_next + 1), 0) +
NVL (ceil(x_cust_year_est + 1), 0) + NVL (ceil(x_cust_gsa_ind + 1), 0) +
NVL (ceil(x_cust_do_not_mail + 1), 0) + NVL (ceil(x_name + 1), 0));
x_LAST_UPDATE_DATE := x_date;
NVL (ceil(x_LAST_UPDATE_DATE + 1), 0) + NVL (ceil(x_CREATION_DATE + 1), 0) +
NVL (ceil(x_LEVEL_NAME + 1), 0));