SELECT OL.LINE_ID AS ORDER_LINE_ID , S.SITE_USE_ID AS CUST_ID , NVL(S.ATTRIBUTE1 , NVL(C.ATTRIBUTE1 , NULL)) CUSTGL_CLASS FROM HZ_CUST_ACCOUNTS C , HZ_CUST_SITE_USES_ALL S , HZ_CUST_ACCT_SITES_ALL A , HZ_PARTIES PR , OE_ORDER_LINES_ALL OL WHERE C.CUST_ACCOUNT_ID = A.CUST_ACCOUNT_ID AND S.CUST_ACCT_SITE_ID = A.CUST_ACCT_SITE_ID AND S.SITE_USE_CODE IN ('SHIP_TO') AND A.ORG_ID = S.ORG_ID AND C.PARTY_ID = PR.PARTY_ID AND S.SITE_USE_ID = OL.SHIP_TO_ORG_ID