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_QUOTE_PARTIES

Line 1906: or exists (select 'Y' from OKL_QUOTE_PARTIES xx where xx.CONTACT_OBJECT1_ID1 = to_char(temp.party_id)

1902:
1903: or exists (select 'Y' from OKL_LEASE_OPPS_ALL_B xx where xx.PROSPECT_ID = temp.party_id
1904: )
1905:
1906: or exists (select 'Y' from OKL_QUOTE_PARTIES xx where xx.CONTACT_OBJECT1_ID1 = to_char(temp.party_id)
1907: and (CONTACT_JTOT_OBJECT1_CODE = 'OKX_PARTY'))
1908:
1909: or exists (select 'Y' from OKL_QUOTE_PARTIES xx where xx.PARTY_OBJECT1_ID1 = to_char(temp.party_id)
1910: and (PARTY_JTOT_OBJECT1_CODE = 'OKX_PARTY'))

Line 1909: or exists (select 'Y' from OKL_QUOTE_PARTIES xx where xx.PARTY_OBJECT1_ID1 = to_char(temp.party_id)

1905:
1906: or exists (select 'Y' from OKL_QUOTE_PARTIES xx where xx.CONTACT_OBJECT1_ID1 = to_char(temp.party_id)
1907: and (CONTACT_JTOT_OBJECT1_CODE = 'OKX_PARTY'))
1908:
1909: or exists (select 'Y' from OKL_QUOTE_PARTIES xx where xx.PARTY_OBJECT1_ID1 = to_char(temp.party_id)
1910: and (PARTY_JTOT_OBJECT1_CODE = 'OKX_PARTY'))
1911:
1912: or exists (select 'Y' from HZ_PARTY_SITES
1913: xx where xx.PARTY_ID = temp.party_id

Line 1983: or exists (select 'Y' from OKL_QUOTE_PARTIES xx where xx.CONTACT_OBJECT1_ID1 = to_char(temp.party_id)

1979:
1980: or exists (select 'Y' from OKL_LEASE_OPPS_ALL_B xx where xx.PROSPECT_ID = temp.party_id
1981: )
1982:
1983: or exists (select 'Y' from OKL_QUOTE_PARTIES xx where xx.CONTACT_OBJECT1_ID1 = to_char(temp.party_id)
1984: and (CONTACT_JTOT_OBJECT1_CODE = 'OKX_PARTY'))
1985:
1986: or exists (select 'Y' from OKL_QUOTE_PARTIES xx where xx.PARTY_OBJECT1_ID1 = to_char(temp.party_id)
1987: and (PARTY_JTOT_OBJECT1_CODE = 'OKX_PARTY'))

Line 1986: or exists (select 'Y' from OKL_QUOTE_PARTIES xx where xx.PARTY_OBJECT1_ID1 = to_char(temp.party_id)

1982:
1983: or exists (select 'Y' from OKL_QUOTE_PARTIES xx where xx.CONTACT_OBJECT1_ID1 = to_char(temp.party_id)
1984: and (CONTACT_JTOT_OBJECT1_CODE = 'OKX_PARTY'))
1985:
1986: or exists (select 'Y' from OKL_QUOTE_PARTIES xx where xx.PARTY_OBJECT1_ID1 = to_char(temp.party_id)
1987: and (PARTY_JTOT_OBJECT1_CODE = 'OKX_PARTY'))
1988:
1989: or exists (select 'Y' from HZ_PARTY_SITES
1990: xx where xx.PARTY_ID = temp.party_id