DBA Data[Home] [Help]

APPS.PV_WORKFLOW_PUB dependencies on HZ_RELATIONSHIPS

Line 3081: from hz_relationships hzr, hz_parties hzp

3077: select
3078: case
3079: when a.vendor_user_id is null then
3080: (select hzp.party_name
3081: from hz_relationships hzr, hz_parties hzp
3082: where hzr.party_id=g.source_id and hzr.subject_type='PERSON' and
3083: hzr.subject_id=hzp.party_id and hzr.object_type= 'ORGANIZATION' )
3084: else (g.source_first_name || ' ' || g.source_last_name)
3085: end person_name