1926: (select 'Y' from HZ_CUST_ACCT_SITES_ALL
1927: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1928: and nvl(STATUS, 'A') in ('A','I')
1929: and exists
1930: (select 'Y' from OKL_CNSLD_AR_HDRS_ALL_B zz where zz.IBT_ID = yy.CUST_ACCT_SITE_ID )))
1931:
1932: or exists (select 'Y' from HZ_CUST_ACCOUNTS
1933: xx where xx.PARTY_ID = temp.party_id
1934: and (nvl(STATUS, 'A') in ('A','I'))
2003: (select 'Y' from HZ_CUST_ACCT_SITES_ALL
2004: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
2005: and nvl(STATUS, 'A') in ('A','I')
2006: and exists
2007: (select 'Y' from OKL_CNSLD_AR_HDRS_ALL_B zz where zz.IBT_ID = yy.CUST_ACCT_SITE_ID )))
2008:
2009: or exists (select 'Y' from HZ_CUST_ACCOUNTS
2010: xx where xx.PARTY_ID = temp.party_id
2011: and (nvl(STATUS, 'A') in ('A','I'))