DBA Data[Home] [Help]

APPS.IBE_ORD_ONECLICK_PVT dependencies on HZ_RELATIONSHIPS

Line 1236: WHERE party_id = (SELECT subject_id from HZ_RELATIONSHIPS

1232: SELECT substr(party_name,1,50) from HZ_PARTIES
1233: WHERE party_type = 'PERSON' and party_id = c_party_id
1234: UNION
1235: SELECT substr(party_name,1,50) from HZ_PARTIES
1236: WHERE party_id = (SELECT subject_id from HZ_RELATIONSHIPS
1237: WHERE party_id = c_party_id
1238: and subject_type = 'PERSON'
1239: and object_type = 'ORGANIZATION');
1240: