APPS.AS_OSI_LEAD_PUB dependencies on AS_PARTY_ADDRESSES_V

Line 49: ,as_party_addresses_v addr

45: select substr(addr.address1||' '||addr.city||','||addr.state,1,50) site_name,
46: substr(cust.party_name,1,50) cust_name, substr(oppy.description,1,50) oppy_name
47: from as_leads_all oppy
48: ,hz_parties cust
49: ,as_party_addresses_v addr
50: where oppy.lead_id = lead_id_in
51: and cust.party_id = oppy.customer_id
52: and addr.address_id = oppy.address_id;
53: l_osi_rec OSI_REC_TYPE := G_MISS_OSI_REC;