DBA Data[Home] [Help]

APPS.POS_EXCELASN_PVT dependencies on HZ_PARTY_SITE_USES

Line 2972: select 1 from hz_party_sites ps,hz_party_site_uses psu,po_vendors pov

2968: select pht.line_number,pht.ship_from_location_code
2969: from pos_exasn_headers pht
2970: where pht.ship_from_location_code is not null
2971: and not exists (
2972: select 1 from hz_party_sites ps,hz_party_site_uses psu,po_vendors pov
2973: where ps.party_site_id = psu.party_site_id
2974: and psu.site_use_type = 'SUPPLIER_SHIP_FROM'
2975: and ps.party_id = pov.party_id
2976: and pov.vendor_id= pht.vendor_id