DBA Data[Home] [Help]

APPS.HZ_DUP_PVT dependencies on HZ_RELATIONSHIPS

Line 125: from HZ_RELATIONSHIPS R,HZ_PARTIES PARTY, HZ_DUP_SETS DS,

121: party.party_id party_id,
122: party.party_name party_name,
123: count(*) over (partition by party.party_id) as cnt,
124: party.last_update_date
125: from HZ_RELATIONSHIPS R,HZ_PARTIES PARTY, HZ_DUP_SETS DS,
126: HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB
127: WHERE PARTY.PARTY_ID =DSP.DUP_PARTY_ID
128: AND DB.DUP_BATCH_ID = DS.DUP_BATCH_ID
129: AND DS.DUP_SET_ID = DSP.DUP_SET_ID