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.AS_IMPORT_SL_PVT dependencies on HZ_MATCHED_PARTY_SITES_GT

Line 3452: -- Cursor for getting matched party_site from hz_matched_party_sites_gt

3448: AND hzp.party_id = hzmp.party_id
3449: AND hzp.party_type = p_party_type
3450: ORDER BY score desc, hzp.creation_date desc;
3451:
3452: -- Cursor for getting matched party_site from hz_matched_party_sites_gt
3453: CURSOR C_matched_party_sites
3454: IS
3455: SELECT hzmps.party_id, hzmps.party_site_id, score , hzps.creation_date
3456: FROM hz_matched_party_sites_gt hzmps, hz_party_sites hzps

Line 3456: FROM hz_matched_party_sites_gt hzmps, hz_party_sites hzps

3452: -- Cursor for getting matched party_site from hz_matched_party_sites_gt
3453: CURSOR C_matched_party_sites
3454: IS
3455: SELECT hzmps.party_id, hzmps.party_site_id, score , hzps.creation_date
3456: FROM hz_matched_party_sites_gt hzmps, hz_party_sites hzps
3457: WHERE search_context_id = l_search_context_id
3458: AND hzps.party_site_id = hzmps.party_site_id
3459: AND hzps.party_id = hzmps.party_id
3460: AND nvl(hzps.status,'A') = 'A' --bug# 3319259