DBA Data[Home] [Help]

APPS.OKS_CT_EVENTS_WFA dependencies on CSC_HZ_PARTIES_V

Line 342: from csc_hz_parties_v chpv,

338: chcpv.contact_point_id contact_point_id,
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'

Line 362: from csc_hz_parties_v chpv,

358: chcpv.CONTACT_POINT_TYPE CONTACT_POINT_TYPE,
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