DBA Data[Home] [Help]

APPS.IGS_GE_GEN_001 dependencies on HZ_LOCATIONS

Line 684: HZ_LOCATIONS HL,

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'

Line 706: HZ_LOCATIONS HL,

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