DBA Data[Home] [Help]

APPS.FTE_COMP_CONSTRAINT_UTIL dependencies on WSH_CARRIERS_V

Line 117: wsh_carriers_v wc,

113: 'CARRIER' company_type,
114: nvl(nvl(flp.facility_code,wl.location_code),to_char(wl.wsh_location_id)) facility_code,
115: nvl(flp.description,wl.ui_location_code) description
116: from hz_party_sites hps,
117: wsh_carriers_v wc,
118: wsh_locations wl,
119: fte_location_parameters flp
120: where hps.party_id = wc.carrier_id
121: AND hps.location_id = wl.source_location_id

Line 436: from wsh_locations wl, hz_party_sites hps, wsh_carriers_v wc

432: cursor c_hz_details (p_locid VARCHAR2) is
433: select wc.carrier_id company_id, wc.carrier_name company_name,
434: wc.carrier_name||'/'||nvl(hps.party_site_name,hps.party_site_number)
435: site, 'CARRIER' company_type
436: from wsh_locations wl, hz_party_sites hps, wsh_carriers_v wc
437: where wl.source_location_id=hps.location_id
438: and hps.party_id=wc.carrier_id
439: and wl.location_source_code='HZ'
440: and wc.active='A'