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 3433: -- Cursor for getting matched party_site from hz_matched_party_sites_gt

3429: AND hzp.party_id = hzmp.party_id
3430: AND hzp.party_type = p_party_type
3431: ORDER BY score desc, hzp.creation_date desc;
3432:
3433: -- Cursor for getting matched party_site from hz_matched_party_sites_gt
3434: CURSOR C_matched_party_sites
3435: IS
3436: SELECT hzmps.party_id, hzmps.party_site_id, score , hzps.creation_date
3437: FROM hz_matched_party_sites_gt hzmps, hz_party_sites hzps

Line 3437: FROM hz_matched_party_sites_gt hzmps, hz_party_sites hzps

3433: -- Cursor for getting matched party_site from hz_matched_party_sites_gt
3434: CURSOR C_matched_party_sites
3435: IS
3436: SELECT hzmps.party_id, hzmps.party_site_id, score , hzps.creation_date
3437: FROM hz_matched_party_sites_gt hzmps, hz_party_sites hzps
3438: WHERE search_context_id = l_search_context_id
3439: AND hzps.party_site_id = hzmps.party_site_id
3440: AND hzps.party_id = hzmps.party_id
3441: AND nvl(hzps.status,'A') = 'A' --bug# 3319259