Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.
SELECT C.Cust_Name AS CUST_NAME, C.Cust_Add1 AS CUST_ADD1, C.Cust_add2 AS CUST_ADD2, Z.ZIP_CITY AS CUST_CITY, Z.STATE_CODE AS CUST_PROV, C.zip_code AS CUST_POSTAL FROM E_ORD_H E left JOIN M_CUST_H C on C.CUST_CODE = E.CUST_CODE and C.COMP_CODE = E.COMP_CODE left JOIN M_ZIP Z on Z.ZIP_CODE = C.ZIP_CODE and Z.COUNTRY_CODE = C.COUNTRY_CODE and Z.ZIP_STAT = 'A' WHERE E.ORD_NUM = ( select min(D4.ord_num) from E_FRT_ORD_D4 D4 where D4.load_num = :p_load_num and D4.comp_code_Actual = E.Comp_Code) AND E.COMP_CODE = :p_comp_code
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.