DBA Data[Home] [Help]

APPS.IBE_ORD_ONECLICK_PVT dependencies on HZ_RELATIONSHIPS

Line 1229: WHERE party_id = (SELECT subject_id from HZ_RELATIONSHIPS

1225: SELECT substr(party_name,1,50) from HZ_PARTIES
1226: WHERE party_type = 'PERSON' and party_id = c_party_id
1227: UNION
1228: SELECT substr(party_name,1,50) from HZ_PARTIES
1229: WHERE party_id = (SELECT subject_id from HZ_RELATIONSHIPS
1230: WHERE party_id = c_party_id
1231: and subject_type = 'PERSON'
1232: and object_type = 'ORGANIZATION');
1233: