DBA Data[Home] [Help]

APPS.OE_OE_FORM_LINE dependencies on HZ_PARTY_SITES

Line 4547: hz_party_sites ps,

4543: x_line_val_rec.intmed_ship_to_address3,
4544: x_line_val_rec.intmed_ship_to_address4,
4545: x_line_val_rec.intmed_ship_to_address5
4546: from hz_locations loc,
4547: hz_party_sites ps,
4548: hz_cust_acct_sites cas
4549: where cas.cust_acct_site_id = l_address_id
4550: and cas.party_site_id = ps.party_site_id
4551: and ps.location_id = loc.location_id;

Line 4612: hz_party_sites party_site,

4608: x_line_val_rec.deliver_to_address5
4609: FROM
4610: hz_cust_site_uses_all cust_site,
4611: hz_cust_acct_sites_all cust_acct_site,
4612: hz_party_sites party_site,
4613: hz_parties party,
4614: hz_cust_accounts cust_acct,
4615: hz_locations location
4616: WHERE