I want to get PHONE from this query but still not found exact joint between
743277Jan 11 2010 — edited Jan 11 2010Hi,
I white this query but this condition is joining the 2 table hz_parties, hz_contact_points is
hc1.owner_table_id(+) is "6408" = hp.party_id is '3094'
" PARTY ID AND OWNER_TABLE_ID IS DEFRENRENT" SO I AM UNABLE TO JOiN THESE TABLES
Query Written here.
SELECT HP.PARTY_NAME,hc1.RAW_PHONE_NUMBER, hc1.OWNER_TABLE_NAME,hp.party_id,hc1.owner_table_id --,HCA1.RAW_PHONE_NUMBER
FROM
hz_parties hp,
hz_contact_points hc1
WHERE
hc1.owner_table_name(+) = 'HZ_PARTIES'
AND hc1.primary_flag(+) = 'Y'
AND hc1.status(+) = 'A'
and hc1.PHONE_LINE_TYPE(+) = 'GEN'
and hc1.PRIMARY_FLAG(+) = 'Y'
AND hc1.owner_table_id(+) = hp.party_id --" PARTY ID AND OWNER_TABLE_ID IS DEFRENRENT"
AND hc1.contact_point_type(+) = 'PHONE'
and hp.party_name like '3A%'
I am waiting for ur response . please help me.
thanks