APPS.WSH_ECE_VIEWS_DEF dependencies on ECE_TP_HEADERS

Line 666: FROM wsh_customer_locations_v CL , ece_tp_headers ECH

662: CL.state,
663: CL.province,
664: CL.county,
665: CL.address_id
666: FROM wsh_customer_locations_v CL , ece_tp_headers ECH
667: WHERE CL.tp_header_id = ECH.tp_header_id (+) AND
668: CL.wsh_location_id = p_location_id AND
669: CL.site_use_status = 'A' AND
670: CL.site_use_code = 'SHIP_TO';