DBA Data[Home] [Help]

APPS.POA_EDW_TRD_PNTR_M_SIZE dependencies on HZ_CUST_ACCT_SITES_ALL

Line 26: HZ_CUST_ACCT_SITES_ALL hcas,

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
30: AND hzca.party_id = parties.party_id