APPS.WSH_TPA_SELECTOR_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 60

  WSH_TPA_SELECTOR_PKG.DeliveryDetailTP (
  			l_del_detail_id,
			x_customer_number,
			x_ship_to_ece_locn_code,
			x_inter_ship_to_ece_locn_code,
			x_bill_to_ece_locn_code,
			x_tp_group_code);

Line: 103

SELECT delivery_detail_id
FROM wsh_delivery_assignments_v
WHERE parent_delivery_detail_id = p_container_instance_id
AND rownum < 2;

Line: 139

  WSH_TPA_SELECTOR_PKG.DeliveryDetailTP (
  			p_container_instance_id,
			x_customer_number,
			x_ship_to_ece_locn_code,
			x_inter_ship_to_ece_locn_code,
			x_bill_to_ece_locn_code,
			x_tp_group_code);

Line: 182

SELECT ship_to_org_id, invoice_to_org_id, intmed_ship_to_org_id
FROM OE_ORDER_LINES_ALL
WHERE line_id = v_line_id;

Line: 187

SELECT source_line_id, customer_id
FROM WSH_DELIVERY_DETAILS
WHERE delivery_detail_id = p_delivery_detail_id
AND source_code = 'OE';

Line: 193

SELECT Acct_site.Ece_tp_location_code,
	   Acct_site.Tp_header_id /* TP_HEADER_ID */
FROM hz_cust_acct_sites_all acct_site ,
	hz_cust_site_uses_all site_uses
WHERE site_uses.site_use_id = v_site_use_id AND
	  acct_site.cust_acct_site_id/*address-id*/ = site_uses.cust_acct_site_id; -- TCA View Removal ends

Line: 203

SELECT etg.tp_group_code
FROM ece_tp_group etg,
     ece_tp_headers eth,
     hz_cust_acct_sites_all acct_site
WHERE acct_site.tp_header_id = v_tp_hdr_id
  AND acct_site.tp_header_id = eth.tp_header_id
  AND eth.tp_group_id = etg.tp_group_id;		-- -- TCA View Removal ends

Line: 214

SELECT account_number /* customer number */
FROM  hz_cust_accounts
WHERE cust_account_id /*customer_id*/ = v_cust_id; -- TCA View Removal ends

Line: 437

	WSH_TPA_SELECTOR_PKG.DeliveryTP (
  			p_delivery_id,
			x_customer_number,
			x_ship_to_ece_locn_code,
			x_inter_ship_to_ece_locn_code,
			x_bill_to_ece_locn_code,
			x_tp_group_code);

Line: 448

  	WSH_TPA_SELECTOR_PKG.ContainerTP (
  			p_container_instance_id,
			x_customer_number,
			x_ship_to_ece_locn_code,
			x_inter_ship_to_ece_locn_code,
			x_bill_to_ece_locn_code,
			x_tp_group_code);

Line: 507

		WSH_TPA_SELECTOR_PKG.DeliveryTP (
  				p_entity_id,
				x_customer_number,
				x_ship_to_ece_locn_code,
				x_inter_ship_to_ece_locn_code,
				x_bill_to_ece_locn_code,
				x_tp_group_code);