[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT party_id
FROM hz_cust_accounts
WHERE account_number = anum;
SELECT customer_id
FROM ra_customer_trx_all
WHERE invoice_number = p_contract_number;
SELECT party_id
FROM hz_party_sites
WHERE party_site_number = snum;
SELECT inc.customer_id
FROM csd_repairs rep,
cs_incidents_v inc
WHERE rep.repair_number = repnum
AND rep.incident_id = inc.incident_id;
SELECT inc.incident_Id
FROM css_def_defects_all_v def,
cs_incident_links inl,
cs_incidents_v inc
WHERE def.defect_number = defnum
AND def.defect_id = inl.link_id
AND inl.from_incident_id = inc.incident_id;
/* Enhancement: 1685717 Parties are queried by ordering last_update_date on *//* hz_contact_points in descending order, so that active parties are selected first */
/*
CURSOR c_party_id (p_country VARCHAR2,
p_area VARCHAR2,
p_phone VARCHAR2,
p_ext VARCHAR2) IS
SELECT party.party_id
FROM HZ_PARTIES party,
hz_contact_points cp
WHERE cp.phone_number = p_phone AND
cp.phone_country_code = p_country AND
cp.phone_area_code = p_area AND
cp.phone_extension = p_ext AND
cp.owner_table_name = 'HZ_PARTIES' AND
cp.owner_table_id = party.party_id ;
SELECT cp.owner_table_id party_id
FROM hz_contact_points cp
WHERE cp.phone_number = p_phone AND
cp.phone_country_code = p_country AND
cp.phone_area_code = p_area AND
cp.phone_extension = p_ext AND
cp.owner_table_name = 'HZ_PARTIES'
ORDER BY cp.last_update_date DESC;
SELECT party.party_id
FROM HZ_PARTIES party,
hz_contact_points cp
WHERE cp.phone_number = p_phone AND
cp.phone_extension = p_ext AND
cp.owner_table_name = 'HZ_PARTIES' AND
cp.owner_table_id = party.party_id ;
SELECT cp.owner_table_id party_id
FROM hz_contact_points cp
WHERE cp.phone_number = p_phone AND
cp.phone_extension = p_ext AND
cp.owner_table_name = 'HZ_PARTIES'
ORDER BY cp.last_update_date DESC;
SELECT party.party_id
FROM HZ_PARTIES party,
hz_contact_points cp
WHERE cp.phone_number = p_phone AND
cp.phone_area_code = p_area AND
cp.owner_table_name = 'HZ_PARTIES' AND
cp.owner_table_id = party.party_id ;
SELECT cp.owner_table_id party_id
FROM hz_contact_points cp
WHERE cp.phone_number = p_phone AND
cp.phone_area_code = p_area AND
cp.owner_table_name = 'HZ_PARTIES'
ORDER BY cp.last_update_date DESC;
SELECT party.party_id
FROM HZ_PARTIES party,
hz_contact_points cp
WHERE cp.phone_number = p_phone AND
cp.phone_area_code = p_area AND
cp.phone_country_code = p_country AND
cp.owner_table_name = 'HZ_PARTIES' AND
cp.owner_table_id = party.party_id;
SELECT cp.owner_table_id party_id
FROM hz_contact_points cp
WHERE cp.phone_number = p_phone AND
cp.phone_area_code = p_area AND
cp.phone_country_code = p_country AND
cp.owner_table_name = 'HZ_PARTIES'
ORDER BY cp.last_update_date DESC;
SELECT party.party_id
FROM HZ_PARTIES party,
hz_contact_points cp
WHERE cp.phone_number = p_phone AND
cp.owner_table_name = 'HZ_PARTIES' AND
cp.owner_table_id = party.party_id ;
SELECT cp.owner_table_id party_id
FROM hz_contact_points cp
WHERE cp.phone_number = p_phone AND
cp.owner_table_name = 'HZ_PARTIES'
ORDER BY cp.last_update_date DESC;
SELECT party_id
FROM hz_parties
WHERE party_number = pnum;
SELECT ship_to_customer_id, bill_to_customer_id
FROM ra_customer_trx_all
WHERE trx_number = invnum;
SELECT party_name
FROM hz_parties
WHERE party_id = pid;
SELECT status
FROM hz_parties
WHERE party_iD = pid;
SELECT customer_product_id
FROM cs_customer_products_all
WHERE customer_product_id = prodid;
SELECT party_id
FROM hz_parties
WHERE party_id = custid;
SELECT customer_product_id
FROM cs_customer_products_all
WHERE reference_number = refnum;
SELECT inventory_item_id
FROM cs_customer_products_all
WHERE reference_number = refnum;
SELECT description
FROM mtl_system_items
WHERE inventory_item_id = invid AND
organization_id = orgid;
SELECT party_id
FROM JTF_CONTACT_POINTS_V
WHERE Upper(email_address) = Upper(email) ;
/* Enhancement: 1685717 Parties are queried by ordering last_update_date on *//* hz_contact_points in descending order, so that active parties are selected first */
CURSOR c_party_id (email VARCHAR2) IS
SELECT owner_table_id party_id
FROM hz_contact_points
WHERE owner_table_name = 'HZ_PARTIES'
AND contact_point_type = 'EMAIL'
AND UPPER(email_address) = UPPER(email)
ORDER BY last_update_date DESC;
SELECT p.party_id
FROM hz_parties p,
hz_relationships r,
hz_org_contacts c
WHERE c.contact_number = connum
AND c.party_relationship_id = r.relationship_id
AND r.object_id = p.party_id
AND r.subject_table_name = 'HZ_PARTIES'
AND r.object_table_name = 'HZ_PARTIES'
AND r.directional_flag = 'F';
select decode(upper(l_filtered_number),'A','2','B','2','C','2',
'D','3','E','3','F','3',
'G','4','H','4','I','4',
'J','5','K','5','L','5',
'M','6','N','6','O','6',
'P','7','Q','7','R','7','S','7',
'T','8','U','8','V','8',
'W','9','X','9','Y','9','Z','9',l_filtered_number) into l_filtered_number from dual;
SELECT transposed_phone_number, owner_table_id, contact_point_id
FROM hz_contact_points
WHERE transposed_phone_number LIKE l_rANI
AND owner_table_name = 'HZ_PARTIES'
ORDER BY last_update_date DESC;
x_last_update_date OUT NOCOPY DATE) IS
CURSOR c_party_id (anum VARCHAR2) IS
SELECT party_id,cust_account_id,last_update_date
FROM hz_cust_accounts
WHERE account_number = anum;
FETCH c_party_id INTO x_party_id,x_cust_account_id,x_last_update_date;
SELECT party_name
INTO x_party_name
FROM hz_parties
WHERE party_id = p_party_id;
l_acct_last_update_date date;
x_last_update_date => l_acct_last_update_date);
IF l_acct_last_update_date IS NOT NULL THEN
l_put_result := CCT_COLLECTION_UTIL_PUB.PUT(p_media_data,'uwq_last_update_date',l_acct_last_update_date);