APPS.ASO_WORKFLOW_PVT SQL Statements

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

Line: 16

  Select Meaning
  from   oe_ship_methods_v
  Where  Lookup_code = pCode;

Line: 21

	SELECT 	org_id,party_id, quote_name,quote_number, quote_version,
               	quote_password,cust_account_id,invoice_to_party_id,
                invoice_to_party_site_id,quote_header_id,ordered_date,
               	order_id, total_list_price,total_shipping_charge,total_tax,
        	total_quote_price,invoice_to_cust_account_id,
        	total_adjusted_amount,currency_code
	FROM aso_quote_headers_all
	WHERE  quote_header_id = p_quote_id;

Line: 33

	SELECT 	Inventory_item_id, Organization_id, Quantity,
		Line_quote_price,currency_code
        FROM Aso_quote_lines_all
	WHERE  quote_header_id = p_quote_id
	ORDER BY line_number;

Line: 42

	SELECT Payment_type_code
      	FROM   Aso_Payments
	WHERE  quote_header_id = p_quote_id;

Line: 47

	SELECT	Party_Name,Person_First_Name,Person_Middle_Name,
		Person_Last_name,party_type
	FROM	hz_parties
	WHERE	party_id = p_party_id;

Line: 53

	SELECT 	Contact_Point_type,Primary_flag, Phone_line_type,
		Phone_Country_code, Phone_area_code, Phone_number, Email_address
	FROM	hz_contact_points
	WHERE	owner_table_name = 'HZ_PARTIES'
	AND	owner_table_id = p_party_id;

Line: 61

   SELECT fc.symbol FROM FND_CURRENCIES fc
   WHERE fc.currency_code = p_currCode;

Line: 115

		select name
		from wf_users
		where orig_system = 'WF_LOCAL_USERS'
		and name = 'ASOORDERADMIN'
		and status = 'ACTIVE';

Line: 301

SELECT	rtrim(address1) || ' ' || rtrim(address2) || ' ' || rtrim(address3) || ' ' || rtrim(address4) loc_address,
	rtrim(city) loc_city,
        rtrim(state)||'/' || rtrim(province) loc_state,
        rtrim(postal_code) loc_zip,
        rtrim(country) loc_country
	FROM		hz_locations
	WHERE 		location_id = (	SELECT 	location_id
					FROM   	hz_party_sites
					WHERE	party_site_id = p_loc_site_id);

Line: 311

SELECT 	ship_to_cust_account_id, ship_to_party_site_id, ship_to_party_id, ship_method_code
	FROM	aso_shipments
	WHERE   quote_header_id = p_quote_id
	AND	quote_line_id IS NULL
	AND	rownum = 1;

Line: 319

 SELECT hc.party_id,hp.Party_Name,hp.Person_First_Name,hp.Person_Middle_Name,hp.Person_Last_name,hp.party_type
 FROM	hz_cust_accounts hc, hz_parties hp
 WHERE  cust_account_id = p_cust_account_id
 AND    hc.party_id = hp.party_id;

Line: 729

PROCEDURE Selector(
	itemtype	IN	VARCHAR2,
	itemkey		IN	VARCHAR2,
	actid		IN	NUMBER,
	funcmode	IN	VARCHAR2,
	result	 OUT NOCOPY /* file.sql.39 change */  VARCHAR2
) IS

l_event_type		VARCHAR2(50);

Line: 748

		   ASO_DEBUG_PUB.add('Selector - Inside  RUN- '||l_event_type,1,'Y');

Line: 753

			   ASO_DEBUG_PUB.add('Selector - Inside  order confirmation selection ',1,'Y');

Line: 761

END Selector;