DBA Data[Home] [Help]

APPS.WSH_ECE_VIEWS_DEF dependencies on WSH_CUSTOMER_LOCATIONS_V

Line 671: FROM wsh_customer_locations_v CL , ece_tp_headers ECH

667: CL.state,
668: CL.province,
669: CL.county,
670: CL.address_id
671: FROM wsh_customer_locations_v CL , ece_tp_headers ECH
672: WHERE CL.tp_header_id = ECH.tp_header_id (+) AND
673: CL.wsh_location_id = p_location_id AND
674: CL.site_use_status = 'A' AND
675: CL.site_use_code = 'SHIP_TO' AND