Skip to main content

Posts

Showing posts from July, 2015

Query to find the Supplier and Supplier Site Information

SELECT   * FROM     ( SELECT   PoVendors . vendor_id                 AS                        SUPPLIER_ID ,                 PoVendorSitesAll . vendor_site_id                 AS                        SUPPLIER_SITE_ID ,                 PoVendorContacts . vendor_contact_id                 AS                        SUPPLIER_CONTACT_ID ,                 PoVendors . vendor_name                 AS                        SUPPLIER_NAME ,                 Decode ( PoVendorContacts . first_name ,   NULL ,                 PoVendorContacts . last_name , PoVendorContacts . last_name || ', ' || PoVendorContacts . first_name )   AS SUPPLIER_CONTACT_NAME , PoVendorSitesAll . address_line1 ||  ' ' ||  PoVendorSitesAll . address_line2 ||  ' ' || PoVendorSitesAll . address_line3 ||  ' ' ||  PoVendorSitesAll . city ||  ' ' ||  PoVendorSitesAll . state ||  ' ' || PoVendorSitesAll . zip ||  ' ' ||  PoVendorSitesAll . co