DBA Data[Home] [Help]

APPS.OTA_RA_CON_API dependencies on HZ_RELATIONSHIPS

Line 114: HZ_RELATIONSHIPS REL,

110: where
111: PARTY_ID = (select PARTY.PARTY_ID
112: from HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
113: HZ_PARTIES PARTY,
114: HZ_RELATIONSHIPS REL,
115: HZ_ORG_CONTACTS ORG_CONT,
116: HZ_CUST_ACCOUNTS ROLE_ACCT
117: where ACCT_ROLE.PARTY_ID = REL.PARTY_ID
118: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'

Line 131: HZ_RELATIONSHIPS REL,

127: SELECT party.party_id, party.object_version_number
128: INTO x_party_id, x_party_object_version_number
129: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
130: HZ_PARTIES PARTY,
131: HZ_RELATIONSHIPS REL,
132: HZ_ORG_CONTACTS ORG_CONT,
133: HZ_CUST_ACCOUNTS ROLE_ACCT
134: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
135: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'