APPS.HZ_PURGE_GEN dependencies on HZ_CUST_ACCT_SITES_ALL

Line 280: (select 'Y' from HZ_CUST_ACCT_SITES_ALL

276: or exists (select 'Y' from HZ_PARTY_SITES
277: xx where xx.PARTY_ID = temp.party_id
278: and (nvl(STATUS, 'A') in ('A','I'))
279: and exists
280: (select 'Y' from HZ_CUST_ACCT_SITES_ALL
281: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
282: and nvl(STATUS, 'A') in ('A','I')))
283:
284: or exists (select 'Y' from HZ_CUST_ACCOUNTS xx where xx.SELLING_PARTY_ID = temp.party_id

Line 311: (select 'Y' from HZ_CUST_ACCT_SITES_ALL

307: or exists (select 'Y' from HZ_PARTY_SITES
308: xx where xx.PARTY_ID = temp.party_id
309: and (nvl(STATUS, 'A') in ('A','I'))
310: and exists
311: (select 'Y' from HZ_CUST_ACCT_SITES_ALL
312: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
313: and nvl(STATUS, 'A') in ('A','I')))
314:
315: or exists (select 'Y' from HZ_CUST_ACCOUNTS xx where xx.SELLING_PARTY_ID = temp.party_id

Line 1916: (select 'Y' from HZ_CUST_ACCT_SITES_ALL

1912: or exists (select 'Y' from HZ_PARTY_SITES
1913: xx where xx.PARTY_ID = temp.party_id
1914: and (nvl(STATUS, 'A') in ('A','I'))
1915: and exists
1916: (select 'Y' from HZ_CUST_ACCT_SITES_ALL
1917: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1918: and nvl(STATUS, 'A') in ('A','I')
1919: and exists
1920: (select 'Y' from OKL_TRX_AR_INVOICES_B zz where zz.IBT_ID = yy.CUST_ACCT_SITE_ID )))

Line 1926: (select 'Y' from HZ_CUST_ACCT_SITES_ALL

1922: or exists (select 'Y' from HZ_PARTY_SITES
1923: xx where xx.PARTY_ID = temp.party_id
1924: and (nvl(STATUS, 'A') in ('A','I'))
1925: and exists
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 )))

Line 1993: (select 'Y' from HZ_CUST_ACCT_SITES_ALL

1989: or exists (select 'Y' from HZ_PARTY_SITES
1990: xx where xx.PARTY_ID = temp.party_id
1991: and (nvl(STATUS, 'A') in ('A','I'))
1992: and exists
1993: (select 'Y' from HZ_CUST_ACCT_SITES_ALL
1994: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1995: and nvl(STATUS, 'A') in ('A','I')
1996: and exists
1997: (select 'Y' from OKL_TRX_AR_INVOICES_B zz where zz.IBT_ID = yy.CUST_ACCT_SITE_ID )))

Line 2003: (select 'Y' from HZ_CUST_ACCT_SITES_ALL

1999: or exists (select 'Y' from HZ_PARTY_SITES
2000: xx where xx.PARTY_ID = temp.party_id
2001: and (nvl(STATUS, 'A') in ('A','I'))
2002: and exists
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 )))