DBA Data[Home] [Help]

APPS.FTE_LOCATION_PARAMETERS_PKG dependencies on WSH_CARRIERS_V

Line 231: wsh_carriers_v wc

227: wc.carrier_name||'_'||nvl(hps.party_site_name,hps.party_site_number) Site,
228: hps.creation_date Cdate,
229: 'CARRIER' Company_Type
230: FROM wsh_locations wl, hz_party_sites hps,
231: wsh_carriers_v wc
232: WHERE wl.source_location_id = p_location_id
233: AND wl.location_source_code = 'HZ'
234: AND wl.source_location_id = hps.location_id
235: AND hps.party_id = wc.carrier_id

Line 369: FROM wsh_locations wl, hz_party_sites hps, wsh_carriers_v wc,

365: wl.wsh_location_id LocId,
366: wc.carrier_name||'_'||nvl(hps.party_site_name,hps.party_site_number) Site,
367: hps.creation_date cdate,
368: 'CARRIER' company_type
369: FROM wsh_locations wl, hz_party_sites hps, wsh_carriers_v wc,
370: fte_location_parameters flp
371: WHERE wl.wsh_location_id = flp.location_id(+)
372: AND flp.location_id IS NULL
373: AND wl.location_source_code = 'HZ'