DBA Data[Home] [Help]

APPS.HZ_PURGE_GEN dependencies on OKL_TRX_AR_INVOICES_B

Line 2001: or exists (select 'Y' from OKL_TRX_AR_INVOICES_B xx where xx.IBT_ID = temp.party_id

1997: and nvl(STATUS, 'A') in ('A','I')
1998: and exists
1999: (select 'Y' from OKL_RELOCATE_ASSETS_B zz where zz.IST_ID = yy.PARTY_SITE_USE_ID )))
2000:
2001: or exists (select 'Y' from OKL_TRX_AR_INVOICES_B xx where xx.IBT_ID = temp.party_id
2002: )
2003:
2004: or exists (select 'Y' from OKL_CNSLD_AR_HDRS_B xx where xx.IBT_ID = temp.party_id
2005: )

Line 2050: or exists (select 'Y' from OKL_TRX_AR_INVOICES_B xx where xx.IBT_ID = temp.party_id

2046: and nvl(STATUS, 'A') in ('A','I')
2047: and exists
2048: (select 'Y' from OKL_RELOCATE_ASSETS_B zz where zz.IST_ID = yy.PARTY_SITE_USE_ID )))
2049:
2050: or exists (select 'Y' from OKL_TRX_AR_INVOICES_B xx where xx.IBT_ID = temp.party_id
2051: )
2052:
2053: or exists (select 'Y' from OKL_CNSLD_AR_HDRS_B xx where xx.IBT_ID = temp.party_id
2054: )