APPS.POA_EDW_TRD_PNTR_M_SIZE dependencies on HZ_PARTIES

Line 24: HZ_PARTIES parties,

20: between p_from_date and p_to_date
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

Line 42: hz_parties parties

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
46: union all

Line 48: from hz_parties

44: and greatest(parties.last_update_date, hzca.last_update_date)
45: between p_from_date and p_to_date
46: union all
47: select count(*) cnt
48: from hz_parties
49: where last_update_date between p_from_date and p_to_date);
50:
51: -- dbms_output.put_line('The number of rows for trading partner is: '
52: -- || to_char(p_num_rows));

Line 251: from hz_parties;

247: avg(nvl(vsize(next_fy_potential_revenue),0)),
248: avg(nvl(vsize(year_established),0)),
249: avg(nvl(vsize(gsa_indicator_flag),0)),
250: avg(nvl(vsize(do_not_mail_flag),0))
251: from hz_parties;
252:
253: cursor c5 is
254: select avg(nvl(vsize(name),0))
255: from ap_terms_tl;

Line 452: -- extra part for tp_loc from hz_customer_accounts, hz_parties, etc...

448:
449:
450: ----------------- For TP_LOC -----------------
451:
452: -- extra part for tp_loc from hz_customer_accounts, hz_parties, etc...
453:
454: x_total6 := x_total6 + 3
455: + NVL (ceil(x_TPARTNER_DP + 1), 0)
456: + NVL (ceil(x_cust_ship_partial + 1), 0)