It is the standard CRM query to search by customer number but here it is. select * from ( select /*+ FIRST_ROWS(100) */ a.*, rownum r from ( SELECT vmo_company.idCUS col0, 'vmo_company' idTbl, vmo_company.CustNo col2, vmo_company.PhSwitch col3, TRIM(NVL(USR_59.FIRSTNAME,'') || ' ' || USR_59.LASTNAME) col4, TRIM(NVL(USR_58.FIRSTNAME,'') || ' ' || USR_58.LASTNAME) col5, vmo_company.Name col6, vmo_company.Address1 col7, vmo_company.Address2 col8, vmo_company.City col9, OPT_53.CODEDESC col10, vmo_company.ZipCode col11, vmo_company.County col12, OPT_50.CODEDESC col13, vmo_company.VisitAddress1 col14, vmo_company.VisitAddress2 col15, vmo_company.VisitCity col16, OPT_46.CODEDESC col17, vmo_company.VisitZipCode col18, vmo_company.VisitCounty col19, OPT_43.CODEDESC col20, vmo_company.HomePhone col21, vmo_company.CellPhone col22, vmo_company.PhFax col23, vmo_company.www col24, vmo_company.EMail col25, OPT_37.CODEDESC col26, OPT_36.CODEDESC col27, OPT_35.CODEDESC col28, OPT_34.CODEDESC col2
Thank you so much for these responses. We are at that cross road again so this is helpful.
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.