The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select Meaning
from oe_ship_methods_v
Where Lookup_code = pCode;
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;
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;
SELECT Payment_type_code
FROM Aso_Payments
WHERE quote_header_id = p_quote_id;
SELECT Party_Name,Person_First_Name,Person_Middle_Name,
Person_Last_name,party_type
FROM hz_parties
WHERE party_id = p_party_id;
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;
SELECT fc.symbol FROM FND_CURRENCIES fc
WHERE fc.currency_code = p_currCode;
select name
from wf_users
where orig_system = 'WF_LOCAL_USERS'
and name = 'ASOORDERADMIN'
and status = 'ACTIVE';
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);
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;
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;
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);
ASO_DEBUG_PUB.add('Selector - Inside RUN- '||l_event_type,1,'Y');
ASO_DEBUG_PUB.add('Selector - Inside order confirmation selection ',1,'Y');
END Selector;