eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_PURGE_GEN dependencies on OKL_RELOCATE_ASSETS_B

Line 1989: (select 'Y' from OKL_RELOCATE_ASSETS_B zz where zz.IST_ID = yy.PARTY_SITE_USE_ID )))

1985: (select 'Y' from HZ_PARTY_SITE_USES
1986: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1987: and nvl(STATUS, 'A') in ('A','I')
1988: and exists
1989: (select 'Y' from OKL_RELOCATE_ASSETS_B zz where zz.IST_ID = yy.PARTY_SITE_USE_ID )))
1990:
1991: or exists (select 'Y' from HZ_PARTY_SITES
1992: xx where xx.PARTY_ID = temp.party_id
1993: and (nvl(STATUS, 'A') in ('A','I'))

Line 1999: (select 'Y' from OKL_RELOCATE_ASSETS_B zz where zz.IST_ID = yy.PARTY_SITE_USE_ID )))

1995: (select 'Y' from HZ_PARTY_SITE_USES
1996: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_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:

Line 2014: (select 'Y' from OKL_RELOCATE_ASSETS_B

2010: or exists (select 'Y' from HZ_CONTACT_POINTS
2011: xx where xx.OWNER_TABLE_ID = temp.party_id
2012: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
2013: and exists
2014: (select 'Y' from OKL_RELOCATE_ASSETS_B
2015: yy where yy.PAC_ID=xx.CONTACT_POINT_ID
2016: ))
2017: or exists (select 'Y' from HZ_PARTY_SITES
2018: xx where xx.PARTY_ID = temp.party_id

Line 2025: (select 'Y' from OKL_RELOCATE_ASSETS_B zz where zz.PAC_ID = yy.CONTACT_POINT_ID )));

2021: (select 'Y' from HZ_CONTACT_POINTS
2022: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
2023: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
2024: and exists
2025: (select 'Y' from OKL_RELOCATE_ASSETS_B zz where zz.PAC_ID = yy.CONTACT_POINT_ID )));
2026: else
2027: delete from hz_purge_gt temp where
2028:
2029:

Line 2038: (select 'Y' from OKL_RELOCATE_ASSETS_B zz where zz.IST_ID = yy.PARTY_SITE_USE_ID )))

2034: (select 'Y' from HZ_PARTY_SITE_USES
2035: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
2036: and nvl(STATUS, 'A') in ('A','I')
2037: and exists
2038: (select 'Y' from OKL_RELOCATE_ASSETS_B zz where zz.IST_ID = yy.PARTY_SITE_USE_ID )))
2039:
2040: or exists (select 'Y' from HZ_PARTY_SITES
2041: xx where xx.PARTY_ID = temp.party_id
2042: and (nvl(STATUS, 'A') in ('A','I'))

Line 2048: (select 'Y' from OKL_RELOCATE_ASSETS_B zz where zz.IST_ID = yy.PARTY_SITE_USE_ID )))

2044: (select 'Y' from HZ_PARTY_SITE_USES
2045: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_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:

Line 2063: (select 'Y' from OKL_RELOCATE_ASSETS_B

2059: or exists (select 'Y' from HZ_CONTACT_POINTS
2060: xx where xx.OWNER_TABLE_ID = temp.party_id
2061: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
2062: and exists
2063: (select 'Y' from OKL_RELOCATE_ASSETS_B
2064: yy where yy.PAC_ID=xx.CONTACT_POINT_ID
2065: ))
2066: or exists (select 'Y' from HZ_PARTY_SITES
2067: xx where xx.PARTY_ID = temp.party_id

Line 2074: (select 'Y' from OKL_RELOCATE_ASSETS_B zz where zz.PAC_ID = yy.CONTACT_POINT_ID )));

2070: (select 'Y' from HZ_CONTACT_POINTS
2071: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
2072: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
2073: and exists
2074: (select 'Y' from OKL_RELOCATE_ASSETS_B zz where zz.PAC_ID = yy.CONTACT_POINT_ID )));
2075: end if;
2076:
2077:
2078: --delete and insert records into hz_purge_gt for an application