APPS.POA_EDW_TRD_PNTR_M_SIZE dependencies on HZ_CUST_ACCOUNTS

Line 25: HZ_CUST_ACCOUNTS hzca,

21: union all
22: select count(*) cnt
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

Line 41: FROM hz_cust_accounts hzca,

37: po_vendors
38: where last_update_date between p_from_date and p_to_date
39: union all
40: select count(*) cnt
41: FROM hz_cust_accounts hzca,
42: hz_parties parties
43: WHERE hzca.party_id = parties.party_id
44: and greatest(parties.last_update_date, hzca.last_update_date)
45: between p_from_date and p_to_date

Line 231: from hz_cust_accounts where last_update_date

227: avg(nvl(vsize(ship_via),0)),
228: avg(nvl(vsize(tax_header_level_flag),0)),
229: avg(nvl(vsize(tax_rounding_rule),0)),
230: avg(nvl(vsize(party_id),0))
231: from hz_cust_accounts where last_update_date
232: between p_from_date and p_to_date;
233:
234: cursor c4 is
235: select avg(nvl(vsize(party_name),0)),