DBA Data[Home] [Help]

APPS.POS_EXCELASN_PVT dependencies on PO_VENDORS

Line 1053: po_vendors pv,

1049: from
1050: po_headers_all pha,
1051: po_lines_all pla,
1052: po_line_locations_all plla,
1053: po_vendors pv,
1054: po_vendor_sites_all pvs,
1055: hr_locations_all_tl hrl,
1056: hz_locations hz
1057: where pha.segment1 = plnt.po_number

Line 1138: po_vendors pv,

1134: po_headers_all pha,
1135: po_releases_all pra,
1136: po_lines_all pla,
1137: po_line_locations_all plla,
1138: po_vendors pv,
1139: po_vendor_sites_all pvs,
1140: hr_locations_all_tl hrl,
1141: hz_locations hz
1142: where pha.segment1 = plnt.po_number

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