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.OKL_CREDIT_DATAPOINTS_PVT dependencies on HZ_PARTY_SITES

Line 406: FROM HZ_PARTY_SITES PARTY_SITES, OKL_LEASE_APPLICATIONS_B LAP

402: x_resultout := FND_API.G_RET_STS_SUCCESS;
403: BEGIN
404: SELECT PARTY_SITES.PARTY_SITE_NUMBER
405: INTO l_prospect_address
406: FROM HZ_PARTY_SITES PARTY_SITES, OKL_LEASE_APPLICATIONS_B LAP
407: WHERE PARTY_SITES.PARTY_SITE_ID = LAP.PROSPECT_ADDRESS_ID
408: AND LAP.ID = l_lease_app_id;
409:
410: EXCEPTION

Line 948: FROM HZ_PARTY_SITES PARTY_SITE, OKL_LEASE_APPLICATIONS_B LAP,

944: l_install_site VARCHAR2(30);
945:
946: CURSOR cInstallSite IS
947: SELECT PARTY_SITE.PARTY_SITE_NUMBER PARTY_SITE_NUMBER
948: FROM HZ_PARTY_SITES PARTY_SITE, OKL_LEASE_APPLICATIONS_B LAP,
949: OKL_ASSETS_B ASSET, OKL_LEASE_QUOTES_B QUOTE
950: WHERE PARTY_SITE.PARTY_SITE_ID = ASSET.INSTALL_SITE_ID
951: AND ASSET.PARENT_OBJECT_ID = QUOTE.ID
952: AND QUOTE.PARENT_OBJECT_ID = LAP.ID