APPS.POA_EDW_TRD_PNTR_M_SIZE dependencies on HZ_CUST_SITE_USES_ALL

Line 27: HZ_CUST_SITE_USES_ALL hcss

23: from
24: HZ_PARTIES parties,
25: HZ_CUST_ACCOUNTS hzca,
26: HZ_CUST_ACCT_SITES_ALL hcas,
27: HZ_CUST_SITE_USES_ALL hcss
28: WHERE hcss.CUST_ACCT_SITE_ID = hcas.CUST_ACCT_SITE_ID
29: AND hcas.CUST_ACCOUNT_ID = hzca.CUST_ACCOUNT_ID
30: AND hzca.party_id = parties.party_id
31: and greatest(hcss.last_update_date, hzca.last_update_date,

Line 302: from HZ_CUST_SITE_USES_ALL where last_update_date

298: avg(nvl(vsize(tax_code),0)),
299: avg(nvl(vsize(demand_class_code),0)),
300: avg(nvl(vsize(tax_header_level_flag),0)),
301: avg(nvl(vsize(tax_rounding_rule),0))
302: from HZ_CUST_SITE_USES_ALL where last_update_date
303: between p_from_date and p_to_date;
304:
305: cursor c10 is
306: select avg(nvl(vsize(name), 0))