DBA Data[Home] [Help]

APPS.HZ_DUP_PVT dependencies on HZ_CUST_ACCOUNTS

Line 78: HZ_CUST_ACCOUNTS CA,HZ_PARTIES PARTY, HZ_DUP_SETS DS,

74: ca.party_id party_id, party.party_name party_name,
75: count(*) over (partition by ca.party_id) as cnt,
76: ca.last_update_date
77: from
78: HZ_CUST_ACCOUNTS CA,HZ_PARTIES PARTY, HZ_DUP_SETS DS,
79: HZ_DUP_SET_PARTIES DSP, HZ_DUP_BATCH DB
80: WHERE CA.PARTY_ID =DSP.DUP_PARTY_ID
81: AND DB.DUP_BATCH_ID = DS.DUP_BATCH_ID
82: AND DS.DUP_SET_ID = DSP.DUP_SET_ID