SELECT DISTINCT L.HEADER_ID , nvl(L.CHARGE_PERIODICITY_CODE,'ONE') , H.TRANSACTIONAL_CURR_CODE FROM OE_ORDER_HEADERS_ALL H , OE_ORDER_LINES_ALL L WHERE L.HEADER_ID = H.HEADER_ID
View Text - HTML Formatted
SELECT DISTINCT L.HEADER_ID , NVL(L.CHARGE_PERIODICITY_CODE , 'ONE') , H.TRANSACTIONAL_CURR_CODE FROM OE_ORDER_HEADERS_ALL H , OE_ORDER_LINES_ALL L WHERE L.HEADER_ID = H.HEADER_ID