DBA Data[Home] [Help]

APPS.PO_COMMODITIES_UTIL_PKG SQL Statements

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

Line: 13

	SELECT   commodity_id
	  FROM   po_commodities_b
	  WHERE  commodity_id <> p_comm_id
	  AND    upper(commodity_code) = upper(p_comm_code);
Line: 45

	SELECT   commodity_id
	  FROM   po_commodities_vl
	  WHERE  commodity_id <> p_comm_id
	  AND    upper(name) = upper(p_comm_name);