DBA Data[Home] [Help]

APPS.IGS_GE_GEN_002 dependencies on HZ_LOCATIONS

Line 567: HZ_LOCATIONS HL,

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'

Line 589: HZ_LOCATIONS HL,

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