DBA Data[Home] [Help]

APPS.OKS_CT_EVENTS_WFA dependencies on CSC_HZ_CONTACT_POINTS_V

Line 343: csc_hz_contact_points_v chcpv

339: chcpv.CONTACT_POINT_TYPE CONTACT_POINT_TYPE,
340: chcpv.PRIMARY_FLAG PRIMARY_FLAG,
341: chcpv.party_type party_type
342: from csc_hz_parties_v chpv,
343: csc_hz_contact_points_v chcpv
344: where obj_party_type = 'ORGANIZATION'
345: and object_id = (select object1_id1 from okc_k_party_roles_v
346: where jtot_object1_code = 'OKX_PARTY'
347: and chr_id = (select chr_id from okc_k_lines_v where id = l_k_line_id)

Line 363: csc_hz_contact_points_v chcpv,

359: chcpv.PRIMARY_FLAG PRIMARY_FLAG,
360: chcpv.party_type party_type,
361: chpv.sub_status
362: from csc_hz_parties_v chpv,
363: csc_hz_contact_points_v chcpv,
364: hz_relationships r
365: where chpv.obj_party_type = 'ORGANIZATION'
366: and chpv.object_id = (select object1_id1 from okc_k_party_roles_v
367: where jtot_object1_code = 'OKX_PARTY'