Include all address lines

[countable]

Example generated query,

SELECT /*+ ORDERED */ LAST_NME AS SURNAME,

       FIRST_NME AS "FIRST NAME",

       MIDDLE_NME AS "MIDDLE NAME",

       C.SHORT_DESC AS "OFFICE HELD",

       TO_CHAR(APPOINTMENT_DT, 'YYYY-MM-DD') AS APPOINTMENT,

       TO_CHAR(CESSATION_DT, 'YYYY-MM-DD') AS CEASED,

       D.CORP_NME AS "COMPANY NAME",

       B.CORP_NUM AS "INC/REG #",

       B.START_EVENT_ID AS "FILING #"

  FROM ADDRESS A

       INNER JOIN CORP_PARTY B

          ON B.DELIVERY_ADDR_ID = A.ADDR_ID

       INNER JOIN PARTY_TYPE C

          ON B.PARTY_TYP_CD = C.PARTY_TYP_CD

       INNER JOIN CORP_NAME D

          ON B.CORP_NUM = D.CORP_NUM

 WHERE B.PARTY_TYP_CD <> 'OFF'

   AND D.END_EVENT_ID IS NULL

   AND CORP_NAME_TYP_CD IN ('CO', 'NB')

   AND (0 < CONTAINS(ADDR_LINE_1, :ORA_ADDR1) --%MARINE VIEW%

         OR 0 < CONTAINS(ADDR_LINE_2, :ORA_ADDR2)--%MARINE VIEW%

         OR 0 < CONTAINS(ADDR_LINE_3, :ORA_ADDR3)) --%MARINE VIEW%

ORDER BY LAST_NME, FIRST_NME