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_ASTS_ALL_B

Line 1898: (select 'Y' from OKL_RELOCATE_ASTS_ALL_B zz where zz.IST_ID = yy.PARTY_SITE_USE_ID )))

1894: (select 'Y' from HZ_PARTY_SITE_USES
1895: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1896: and nvl(STATUS, 'A') in ('A','I')
1897: and exists
1898: (select 'Y' from OKL_RELOCATE_ASTS_ALL_B zz where zz.IST_ID = yy.PARTY_SITE_USE_ID )))
1899:
1900: or exists (select 'Y' from OKL_LEASE_APPS_ALL_B xx where xx.PROSPECT_ID = temp.party_id
1901: )
1902:

Line 1951: (select 'Y' from OKL_RELOCATE_ASTS_ALL_B

1947: or exists (select 'Y' from HZ_CONTACT_POINTS
1948: xx where xx.OWNER_TABLE_ID = temp.party_id
1949: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
1950: and exists
1951: (select 'Y' from OKL_RELOCATE_ASTS_ALL_B
1952: yy where yy.PAC_ID=xx.CONTACT_POINT_ID
1953: ))
1954: or exists (select 'Y' from HZ_PARTY_SITES
1955: xx where xx.PARTY_ID = temp.party_id

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

1958: (select 'Y' from HZ_CONTACT_POINTS
1959: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
1960: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
1961: and exists
1962: (select 'Y' from OKL_RELOCATE_ASTS_ALL_B zz where zz.PAC_ID = yy.CONTACT_POINT_ID )));
1963: else
1964: delete from hz_purge_gt temp where
1965:
1966:

Line 1975: (select 'Y' from OKL_RELOCATE_ASTS_ALL_B zz where zz.IST_ID = yy.PARTY_SITE_USE_ID )))

1971: (select 'Y' from HZ_PARTY_SITE_USES
1972: yy where yy.PARTY_SITE_ID=xx.PARTY_SITE_ID
1973: and nvl(STATUS, 'A') in ('A','I')
1974: and exists
1975: (select 'Y' from OKL_RELOCATE_ASTS_ALL_B zz where zz.IST_ID = yy.PARTY_SITE_USE_ID )))
1976:
1977: or exists (select 'Y' from OKL_LEASE_APPS_ALL_B xx where xx.PROSPECT_ID = temp.party_id
1978: )
1979:

Line 2028: (select 'Y' from OKL_RELOCATE_ASTS_ALL_B

2024: or exists (select 'Y' from HZ_CONTACT_POINTS
2025: xx where xx.OWNER_TABLE_ID = temp.party_id
2026: and (OWNER_TABLE_NAME='HZ_PARTIES' AND nvl(STATUS, 'A') in ('A','I'))
2027: and exists
2028: (select 'Y' from OKL_RELOCATE_ASTS_ALL_B
2029: yy where yy.PAC_ID=xx.CONTACT_POINT_ID
2030: ))
2031: or exists (select 'Y' from HZ_PARTY_SITES
2032: xx where xx.PARTY_ID = temp.party_id

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

2035: (select 'Y' from HZ_CONTACT_POINTS
2036: yy where yy.OWNER_TABLE_ID=xx.PARTY_SITE_ID
2037: and OWNER_TABLE_NAME='HZ_PARTY_SITES' AND nvl(STATUS, 'A') in ('A','I')
2038: and exists
2039: (select 'Y' from OKL_RELOCATE_ASTS_ALL_B zz where zz.PAC_ID = yy.CONTACT_POINT_ID )));
2040: end if;
2041:
2042:
2043: --delete and insert records into hz_purge_gt for an application