680: HL.ADDRESS3 ladv_addr_line_3,
681: HL.ADDRESS4 ladv_addr_line_4,
682: HL.CITY ladv_city
683: FROM
684: HZ_LOCATIONS HL,
685: IGS_AD_LOCVENUE_ADDR LA
686: WHERE
687: HL.LOCATION_ID = LA.LOCATION_ID
688: AND LA.SOURCE_TYPE = 'L'
702: HL.ADDRESS3 ladv_addr_line_3,
703: HL.ADDRESS4 ladv_addr_line_4,
704: HL.CITY ladv_city
705: FROM
706: HZ_LOCATIONS HL,
707: IGS_AD_LOCVENUE_ADDR LA ,
708: IGS_PE_LOCVENUE_USE PLU
709: WHERE
710: HL.LOCATION_ID = LA.LOCATION_ID