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_PARTIES_GT

Line 3429: -- Cursor for getting matched party_id from hz_matched_parties_gt

3425: -- SOLIN, BUG 3528579 end
3426:
3427: --l_restrict_sql VARCHAR2(4000);
3428:
3429: -- Cursor for getting matched party_id from hz_matched_parties_gt
3430: CURSOR C_matched_party(p_party_type VARCHAR2)
3431: IS
3432: SELECT HZMP.party_id, score, hzp.creation_date
3433: FROM HZ_MATCHED_PARTIES_GT hzmp, HZ_PARTIES hzp

Line 3433: FROM HZ_MATCHED_PARTIES_GT hzmp, HZ_PARTIES hzp

3429: -- Cursor for getting matched party_id from hz_matched_parties_gt
3430: CURSOR C_matched_party(p_party_type VARCHAR2)
3431: IS
3432: SELECT HZMP.party_id, score, hzp.creation_date
3433: FROM HZ_MATCHED_PARTIES_GT hzmp, HZ_PARTIES hzp
3434: WHERE search_context_id = l_search_context_id
3435: AND hzp.party_id = hzmp.party_id
3436: AND hzp.party_type = p_party_type
3437: AND nvl(hzp.status,'A') = 'A' --bug# 3319259

Line 3446: FROM HZ_MATCHED_PARTIES_GT hzmp, HZ_PARTIES hzp

3442: CURSOR C_matched_party2(p_party_type VARCHAR2)
3443: IS
3444: SELECT HZMP.party_id, score, hzp.creation_date, hzp.status
3445: , hzp.object_version_number
3446: FROM HZ_MATCHED_PARTIES_GT hzmp, HZ_PARTIES hzp
3447: WHERE search_context_id = l_search_context_id
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;