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.HZ_MATCH_RULE_41 dependencies on HZ_ORGANIZATION_PROFILES

Line 352: FROM HZ_ORGANIZATION_PROFILES

348: FROM HZ_PARTIES
349: WHERE party_id = p_record_id;
350: IF l_party_type = 'ORGANIZATION' THEN
351: SELECT TAX_REFERENCE INTO l_matched_value
352: FROM HZ_ORGANIZATION_PROFILES
353: WHERE party_id = p_record_id
354: and effective_end_date is null
355: and rownum = 1;
356: ELSIF l_party_type = 'PERSON' THEN

Line 5726: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')

5722: END IF;
5723: IF l_party_type = 'ORGANIZATION' THEN
5724: SELECT
5725: translate(HZ_PARTIES.PARTY_NAME, '%',' ')
5726: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
5727: INTO
5728: x_party_search_rec.PARTY_NAME
5729: ,x_party_search_rec.TAX_REFERENCE
5730: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

Line 5730: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES

5726: ,translate(HZ_ORGANIZATION_PROFILES.TAX_REFERENCE, '%',' ')
5727: INTO
5728: x_party_search_rec.PARTY_NAME
5729: ,x_party_search_rec.TAX_REFERENCE
5730: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5731: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5732: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5733: AND HZ_PARTIES.party_id = p_party_id;
5734: ELSIF l_party_type = 'PERSON' THEN

Line 5731: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id

5727: INTO
5728: x_party_search_rec.PARTY_NAME
5729: ,x_party_search_rec.TAX_REFERENCE
5730: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5731: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5732: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5733: AND HZ_PARTIES.party_id = p_party_id;
5734: ELSIF l_party_type = 'PERSON' THEN
5735: SELECT

Line 5732: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL

5728: x_party_search_rec.PARTY_NAME
5729: ,x_party_search_rec.TAX_REFERENCE
5730: FROM HZ_PARTIES, HZ_ORGANIZATION_PROFILES
5731: WHERE HZ_PARTIES.party_id = HZ_ORGANIZATION_PROFILES.party_id
5732: AND HZ_ORGANIZATION_PROFILES.effective_end_date is NULL
5733: AND HZ_PARTIES.party_id = p_party_id;
5734: ELSIF l_party_type = 'PERSON' THEN
5735: SELECT
5736: translate(HZ_PARTIES.PARTY_NAME, '%',' ')