APPS.HZ_DUP_PVT dependencies on HZ_PARTY_SITES

Line 101: from HZ_PARTY_SITES PS,HZ_PARTIES PARTY,

97: SELECT
98: ps.party_id party_id, party.party_name party_name,
99: count(*) over (partition by ps.party_id) as cnt,
100: ps.last_update_date
101: from HZ_PARTY_SITES PS,HZ_PARTIES PARTY,
102: HZ_DUP_SETS DS, HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB
103: WHERE PS.PARTY_ID =DSP.DUP_PARTY_ID
104: AND DB.DUP_BATCH_ID = DS.DUP_BATCH_ID
105: AND DS.DUP_SET_ID = DSP.DUP_SET_ID