DBA Data[Home] [Help]

APPS.POS_EXCELASN_PVT dependencies on HZ_PARTY_SITE_USES

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

2898: select pht.line_number,pht.ship_from_location_code
2899: from pos_exasn_headers pht
2900: where pht.ship_from_location_code is not null
2901: and not exists (
2902: select 1 from hz_party_sites ps,hz_party_site_uses psu,po_vendors pov
2903: where ps.party_site_id = psu.party_site_id
2904: and psu.site_use_type = 'SUPPLIER_SHIP_FROM'
2905: and ps.party_id = pov.party_id
2906: and pov.vendor_id= pht.vendor_id