DBA Data[Home] [Help]

APPS.ARH_DQM_TREE dependencies on HZ_MATCHED_PARTY_SITES_GT

Line 212: FROM hz_matched_party_sites_gt gs,

208: l.city,
209: l.state,
210: l.postal_code,
211: s.identifying_address_flag
212: FROM hz_matched_party_sites_gt gs,
213: hz_party_sites s,
214: hz_locations l
215: WHERE gs.search_context_id = i_ctx_id
216: AND gs.party_id = i_party_id

Line 923: FROM hz_matched_party_sites_gt gs,

919: l.city,
920: l.state,
921: l.postal_code,
922: ps.identifying_address_flag
923: FROM hz_matched_party_sites_gt gs,
924: hz_cust_acct_sites_all a,
925: hz_party_sites ps,
926: hz_locations l
927: WHERE gs.search_context_id = p_ctx_id

Line 948: FROM hz_matched_party_sites_gt gs,

944: l.city,
945: l.state,
946: l.postal_code,
947: ps.identifying_address_flag
948: FROM hz_matched_party_sites_gt gs,
949: hz_cust_acct_sites a,
950: hz_party_sites ps,
951: hz_locations l
952: WHERE gs.search_context_id = p_ctx_id