DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_CONTACTS_PVT dependencies on HZ_ORG_CONTACTS

Line 47: HZ_ORG_CONTACTS ORG_CONT

43: FROM HZ_CONTACT_POINTS CONT_POINT,
44: HZ_PARTIES PARTY,
45: HZ_PARTIES PARTY2,
46: HZ_PARTY_RELATIONSHIPS REL,
47: HZ_ORG_CONTACTS ORG_CONT
48: WHERE ORG_CONT.PARTY_RELATIONSHIP_ID = REL.PARTY_RELATIONSHIP_ID
49: AND REL.OBJECT_ID = PARTY.PARTY_ID
50: AND REL.PARTY_ID = PARTY2.PARTY_ID
51: AND CONT_POINT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'

Line 66: HZ_ORG_CONTACTS ORG_CONT

62: FROM -- HZ_CONTACT_POINTS CONT_POINT,
63: HZ_PARTIES PARTY,
64: HZ_PARTIES PARTY2,
65: HZ_RELATIONSHIPS REL,
66: HZ_ORG_CONTACTS ORG_CONT
67: WHERE ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
68: AND REL.OBJECT_ID = PARTY.PARTY_ID AND REL.PARTY_ID = PARTY2.PARTY_ID
69: -- AND CONT_POINT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
70: -- AND CONT_POINT.OWNER_TABLE_ID(+) = PARTY.PARTY_ID