225: WHERE po_vendors.vendor_id = h.vendor_id)
226: , (SELECT po_vendors.segment1
227: FROM po_vendors
228: WHERE po_vendors.vendor_id = h.vendor_id)
229: , (SELECT ap_terms_tl.NAME
230: FROM ap_terms_tl
231: WHERE ap_terms_tl.term_id = h.terms_id AND
232: ap_terms_tl.LANGUAGE = userenv('LANG'))
233: , (SELECT po_lookup_codes.displayed_field
226: , (SELECT po_vendors.segment1
227: FROM po_vendors
228: WHERE po_vendors.vendor_id = h.vendor_id)
229: , (SELECT ap_terms_tl.NAME
230: FROM ap_terms_tl
231: WHERE ap_terms_tl.term_id = h.terms_id AND
232: ap_terms_tl.LANGUAGE = userenv('LANG'))
233: , (SELECT po_lookup_codes.displayed_field
234: FROM po_lookup_codes
227: FROM po_vendors
228: WHERE po_vendors.vendor_id = h.vendor_id)
229: , (SELECT ap_terms_tl.NAME
230: FROM ap_terms_tl
231: WHERE ap_terms_tl.term_id = h.terms_id AND
232: ap_terms_tl.LANGUAGE = userenv('LANG'))
233: , (SELECT po_lookup_codes.displayed_field
234: FROM po_lookup_codes
235: WHERE po_lookup_codes.lookup_type = 'FREIGHT TERMS' AND
228: WHERE po_vendors.vendor_id = h.vendor_id)
229: , (SELECT ap_terms_tl.NAME
230: FROM ap_terms_tl
231: WHERE ap_terms_tl.term_id = h.terms_id AND
232: ap_terms_tl.LANGUAGE = userenv('LANG'))
233: , (SELECT po_lookup_codes.displayed_field
234: FROM po_lookup_codes
235: WHERE po_lookup_codes.lookup_type = 'FREIGHT TERMS' AND
236: po_lookup_codes.lookup_code = h.freight_terms_lookup_code)