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 3410: -- Cursor for getting matched party_id from hz_matched_parties_gt

3406: -- SOLIN, BUG 3528579 end
3407:
3408: --l_restrict_sql VARCHAR2(4000);
3409:
3410: -- Cursor for getting matched party_id from hz_matched_parties_gt
3411: CURSOR C_matched_party(p_party_type VARCHAR2)
3412: IS
3413: SELECT HZMP.party_id, score, hzp.creation_date
3414: FROM HZ_MATCHED_PARTIES_GT hzmp, HZ_PARTIES hzp

Line 3414: FROM HZ_MATCHED_PARTIES_GT hzmp, HZ_PARTIES hzp

3410: -- Cursor for getting matched party_id from hz_matched_parties_gt
3411: CURSOR C_matched_party(p_party_type VARCHAR2)
3412: IS
3413: SELECT HZMP.party_id, score, hzp.creation_date
3414: FROM HZ_MATCHED_PARTIES_GT hzmp, HZ_PARTIES hzp
3415: WHERE search_context_id = l_search_context_id
3416: AND hzp.party_id = hzmp.party_id
3417: AND hzp.party_type = p_party_type
3418: AND nvl(hzp.status,'A') = 'A' --bug# 3319259

Line 3427: FROM HZ_MATCHED_PARTIES_GT hzmp, HZ_PARTIES hzp

3423: CURSOR C_matched_party2(p_party_type VARCHAR2)
3424: IS
3425: SELECT HZMP.party_id, score, hzp.creation_date, hzp.status
3426: , hzp.object_version_number
3427: FROM HZ_MATCHED_PARTIES_GT hzmp, HZ_PARTIES hzp
3428: WHERE search_context_id = l_search_context_id
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;