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_TXL_RCPT_APPS_ALL_B

Line 1936: (select 'Y' from OKL_TXL_RCPT_APPS_ALL_B

1932: or exists (select 'Y' from HZ_CUST_ACCOUNTS
1933: xx where xx.PARTY_ID = temp.party_id
1934: and (nvl(STATUS, 'A') in ('A','I'))
1935: and exists
1936: (select 'Y' from OKL_TXL_RCPT_APPS_ALL_B
1937: yy where yy.ILE_ID=xx.CUST_ACCOUNT_ID
1938: ))
1939: or exists (select 'Y' from HZ_CUST_ACCOUNTS
1940: xx where xx.SELLING_PARTY_ID = temp.party_id

Line 1943: (select 'Y' from OKL_TXL_RCPT_APPS_ALL_B

1939: or exists (select 'Y' from HZ_CUST_ACCOUNTS
1940: xx where xx.SELLING_PARTY_ID = temp.party_id
1941: and (nvl(STATUS, 'A') in ('A','I'))
1942: and exists
1943: (select 'Y' from OKL_TXL_RCPT_APPS_ALL_B
1944: yy where yy.ILE_ID=xx.CUST_ACCOUNT_ID
1945: ))
1946:
1947: or exists (select 'Y' from HZ_CONTACT_POINTS

Line 2013: (select 'Y' from OKL_TXL_RCPT_APPS_ALL_B

2009: or exists (select 'Y' from HZ_CUST_ACCOUNTS
2010: xx where xx.PARTY_ID = temp.party_id
2011: and (nvl(STATUS, 'A') in ('A','I'))
2012: and exists
2013: (select 'Y' from OKL_TXL_RCPT_APPS_ALL_B
2014: yy where yy.ILE_ID=xx.CUST_ACCOUNT_ID
2015: ))
2016: or exists (select 'Y' from HZ_CUST_ACCOUNTS
2017: xx where xx.SELLING_PARTY_ID = temp.party_id

Line 2020: (select 'Y' from OKL_TXL_RCPT_APPS_ALL_B

2016: or exists (select 'Y' from HZ_CUST_ACCOUNTS
2017: xx where xx.SELLING_PARTY_ID = temp.party_id
2018: and (nvl(STATUS, 'A') in ('A','I'))
2019: and exists
2020: (select 'Y' from OKL_TXL_RCPT_APPS_ALL_B
2021: yy where yy.ILE_ID=xx.CUST_ACCOUNT_ID
2022: ))
2023:
2024: or exists (select 'Y' from HZ_CONTACT_POINTS