DBA Data[Home] [Help]

VIEW: APPS.POS_ACK_SITE_LOV_V

Source

View Text - Preformatted

SELECT VENDOR_ID, VENDOR_SITE_ID, VENDOR_ID, VENDOR_SITE_ID, VENDOR_SITE_CODE, ADDRESS_LINE1 || ' ' || ADDRESS_LINE2 || ' ' || ADDRESS_LINE3 || ' ' || CITY || ', ' || STATE || ' ' || ZIP || ', ' || COUNTRY || '.' FROM PO_VENDOR_SITES
View Text - HTML Formatted

SELECT VENDOR_ID
, VENDOR_SITE_ID
, VENDOR_ID
, VENDOR_SITE_ID
, VENDOR_SITE_CODE
, ADDRESS_LINE1 || ' ' || ADDRESS_LINE2 || ' ' || ADDRESS_LINE3 || ' ' || CITY || '
, ' || STATE || ' ' || ZIP || '
, ' || COUNTRY || '.'
FROM PO_VENDOR_SITES