DBA Data[Home] [Help]

APPS.POS_ASN_XML dependencies on HZ_CUST_ACCT_SITES_ALL

Line 437: hz_cust_acct_sites_all cust

433: INTO l_loc_count
434: FROM
435: hz_locations loc,
436: hz_party_sites party,
437: hz_cust_acct_sites_all cust
438: WHERE
439: cust.ece_tp_location_code = p_ship_to_partner_id
440: and cust.org_id = p_org_id
441: and cust.party_site_id = party.party_site_id

Line 454: hz_cust_acct_sites_all cust

450: INTO p_ship_to_location_id
451: FROM
452: hz_locations loc,
453: hz_party_sites party,
454: hz_cust_acct_sites_all cust
455: WHERE
456: cust.ece_tp_location_code = p_ship_to_partner_id
457: and cust.org_id = p_org_id
458: and cust.party_site_id = party.party_site_id