563: HL.ADDRESS3 ladv_addr_line_3,
564: HL.ADDRESS4 ladv_addr_line_4,
565: HL.CITY ladv_city
566: FROM
567: HZ_LOCATIONS HL,
568: IGS_AD_LOCVENUE_ADDR LA
569: WHERE
570: HL.LOCATION_ID = LA.LOCATION_ID
571: AND LA.SOURCE_TYPE = 'L'
585: HL.ADDRESS3 ladv_addr_line_3,
586: HL.ADDRESS4 ladv_addr_line_4,
587: HL.CITY ladv_city
588: FROM
589: HZ_LOCATIONS HL,
590: IGS_AD_LOCVENUE_ADDR LA ,
591: IGS_PE_LOCVENUE_USE PLU
592: WHERE
593: HL.LOCATION_ID = LA.LOCATION_ID