APPS.IGS_SS_ENR_DETAILS dependencies on IGS_AD_LOCATION

Line 30: igs_ad_location d

26: NVL(b.location_cd,'-')||'
'||NVL(b.building_cd,'-')||'
'||NVL(c.room_cd,'-') location_cd
27: FROM igs_ps_usec_occurs a,
28: igs_ad_building b,
29: igs_ad_room c,
30: igs_ad_location d
31: WHERE
32: a.building_code = b.building_id(+) AND
33: a.room_code = c.room_id(+) AND
34: b.location_cd = d.location_cd(+) AND

Line 175: igs_ad_location d,

171: LTRIM(f.person_last_name||', '||f.person_first_name||' '||f.person_middle_name) location
172: FROM igs_ps_usec_occurs a,
173: igs_ad_building b,
174: igs_ad_room c,
175: igs_ad_location d,
176: hz_parties f
177: WHERE
178: a.building_code = b.building_id(+) AND
179: a.room_code = c.room_id(+) AND