[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 hr_locations_all
where last_update_date between p_from_date and p_to_date
union all
select count(*) cnt
from
HZ_LOCATIONS hzl,
HZ_PARTIES hzp,
HZ_PARTY_SITES hzps
WHERE hzps.location_id = hzl.location_id
AND hzps.party_id = hzp.party_id
AND greatest(hzl.last_update_date, hzp.last_update_date,
hzps.last_update_date)
between p_from_date and p_to_date);
x_last_update_date NUMBER := x_date;
select avg(nvl(vsize(instance_code),0))
from edw_local_instance;
select avg(nvl(vsize(vendor_site_id), 0)),
avg(nvl(vsize(org_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))
from po_vendor_sites_all where last_update_date
between p_from_date and p_to_date;
select avg(nvl(vsize(location_id),0)),
avg(nvl(vsize(town_or_city),0)),
avg(nvl(vsize(postal_code),0)),
avg(nvl(vsize(region_2),0)),
avg(nvl(vsize(country),0)),
avg(nvl(vsize(address_line_1),0)),
avg(nvl(vsize(address_line_2),0)),
avg(nvl(vsize(address_line_3),0)),
avg(nvl(vsize(location_code),0))
from HR_LOCATIONS_ALL where last_update_date
between p_from_date and p_to_date;
select avg(nvl(vsize(city),0)),
avg(nvl(vsize(postal_code),0)),
avg(nvl(vsize(state),0)),
avg(nvl(vsize(province),0)),
avg(nvl(vsize(country),0)),
avg(nvl(vsize(address1),0)),
avg(nvl(vsize(address2),0)),
avg(nvl(vsize(address3),0)),
avg(nvl(vsize(address4),0))
from HZ_LOCATIONS where last_update_date
between p_from_date and p_to_date;
select avg(nvl(vsize(party_site_id),0)),
avg(nvl(vsize(party_site_name),0))
from HZ_PARTY_SITES where last_update_date
between p_from_date and p_to_date;
select avg(nvl(vsize(DESCRIPTION),0)),
avg(nvl(vsize(TERRITORY_SHORT_NAME),0))
from fnd_territories_tl 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;
+ NVL (ceil(x_INSTANCE + 1), 0) + NVL (ceil(x_last_update_date + 1), 0)
+ NVL (ceil(x_creation_date + 1), 0)
+ NVL (ceil(x_LOCATION_PK + 1), 0)
+ NVL (ceil(x_LOCATION_DP + 1), 0)
+ NVL (ceil(x_NAME + 1), 0)
+ NVL (ceil(x_ADDRESS_LINE_1 + 1), 0)
+ NVL (ceil(x_ADDRESS_LINE_2 + 1), 0)
+ NVL (ceil(x_ADDRESS_LINE_3 + 1), 0)
+ NVL (ceil(x_POSTCODE_CITY_FK + 1), 0);
+ NVL (ceil(x_INSTANCE + 1), 0) + NVL (ceil(x_last_update_date + 1), 0)
+ NVL (ceil(x_creation_date + 1), 0)
+ NVL (ceil(x_POSTCODE_CITY_PK + 1), 0)
+ NVL (ceil(x_POSTCODE_CITY_DP + 1), 0)
+ NVL (ceil(x_NAME + 1), 0)
+ NVL (ceil(x_CITY_FK + 1), 0)
+ NVL (ceil(x_POSTCODE_FK + 1), 0);
+ NVL (ceil(x_INSTANCE + 1), 0) + NVL (ceil(x_last_update_date + 1), 0)
+ NVL (ceil(x_creation_date + 1), 0)
+ NVL (ceil(x_CITY_PK + 1), 0)
+ NVL (ceil(x_CITY_DP + 1), 0)
+ NVL (ceil(x_NAME + 1), 0)
+ NVL (ceil(x_STATE_REGION_FK + 1), 0);
+ NVL (ceil(x_INSTANCE + 1), 0) + NVL (ceil(x_last_update_date + 1), 0)
+ NVL (ceil(x_creation_date + 1), 0)
+ NVL (ceil(x_POSTCODE_PK + 1), 0)
+ NVL (ceil(x_POSTCODE_DP + 1), 0)
+ NVL (ceil(x_NAME + 1), 0)
+ NVL (ceil(x_STATE_REGION_FK + 1), 0);
+ NVL (ceil(x_INSTANCE + 1), 0) + NVL (ceil(x_last_update_date + 1), 0)
+ NVL (ceil(x_creation_date + 1), 0)
+ NVL (ceil(x_STATE_REGION_PK + 1), 0)
+ NVL (ceil(x_STATE_REGION_DP + 1), 0)
+ NVL (ceil(x_NAME + 1), 0)
+ NVL (ceil(x_STATE_FK + 1), 0);
+ NVL (ceil(x_INSTANCE + 1), 0) + NVL (ceil(x_last_update_date + 1), 0)
+ NVL (ceil(x_creation_date + 1), 0)
+ NVL (ceil(x_STATE_PK + 1), 0)
+ NVL (ceil(x_STATE_DP + 1), 0)
+ NVL (ceil(x_NAME + 1), 0)
+ NVL (ceil(x_REGION_FK + 1), 0);
+ NVL (ceil(x_INSTANCE + 1), 0) + NVL (ceil(x_last_update_date + 1), 0)
+ NVL (ceil(x_creation_date + 1), 0)
+ NVL (ceil(x_REGION_PK + 1), 0)
+ NVL (ceil(x_REGION_DP + 1), 0)
+ NVL (ceil(x_NAME + 1), 0)
+ NVL (ceil(x_COUNTRY_FK + 1), 0);
+ NVL (ceil(x_INSTANCE + 1), 0) + NVL (ceil(x_last_update_date + 1), 0)
+ NVL (ceil(x_creation_date + 1), 0)
+ NVL (ceil(x_COUNTRY_PK + 1), 0)
+ NVL (ceil(x_COUNTRY_DP + 1), 0)
+ NVL (ceil(x_NAME + 1), 0)
+ NVL (ceil(x_AREA2_FK + 1), 0);