[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT p.PERSON_TITLE per_title,
p.PERSON_LAST_NAME per_surname,
NVL(P.KNOWN_AS,p.PERSON_FIRST_NAME) per_first_name,
NVL(P.KNOWN_AS, SUBSTR (P.PERSON_FIRST_NAME, 1, DECODE(INSTR(P.PERSON_FIRST_NAME, ' '), 0, LENGTH(P.PERSON_FIRST_NAME), (INSTR(P.PERSON_FIRST_NAME, ' ')-1)))) || ' ' || P.PERSON_LAST_NAME per_preferred_name ,
P.PERSON_TITLE || ' ' || p.PERSON_FIRST_NAME || ' ' || P.PERSON_LAST_NAME per_title_name ,
p.PERSON_LAST_NAME || ', ' || p.PERSON_TITLE || ' ' || NVL(p.KNOWN_AS,p.PERSON_FIRST_NAME) per_context_block_name
FROM hz_parties p
WHERE p.party_id = cp_person_id;
SELECT padv.party_id padv_person_id,
hpsu.site_use_type padv_addr_type,
padv.address1 padv_addr_line_1,
padv.address2 padv_addr_line_2,
padv.address3 padv_addr_line_3,
padv.address4 padv_addr_line_4,
padv.city padv_city,
-- # 2382471 Added for Country ,State and Zip Code
padv.state padv_state,
padv.postal_code padv_postal_code,
fnd.TERRITORY_SHORT_NAME padv_country_desc
FROM
hz_parties padv,
hz_party_sites hps,
hz_party_site_uses hpsu,
fnd_territories_vl fnd
WHERE padv.party_id = cp_person_id AND
padv.party_type = 'PERSON' AND
padv.country = fnd.territory_code AND
hps.party_id = padv.party_id AND
hps.identifying_address_flag ='Y' AND
hps.party_site_id = hpsu.party_site_id (+) ;
SELECT padv.person_id padv_person_id,
padv.addr_type padv_addr_type,
padv.addr_line_1 padv_addr_line_1,
padv.addr_line_2 padv_addr_line_2,
padv.addr_line_3 padv_addr_line_3,
padv.addr_line_4 padv_addr_line_4,
padv.city padv_city,
-- # 2382471 Added for Country ,State and Zip Code
padv.state padv_state,
padv.postal_code padv_postal_code,
padv.country_desc padv_country_desc
FROM IGS_PE_PERSON_ADDR_V padv
WHERE padv.person_id = cp_person_id AND
padv.addr_type = cp_addr_type;
SELECT SUBSTR(igs_ge_gen_002.genp_get_initials(person_first_name), 1, 10) || ' ' || person_last_name
FROM hz_parties
WHERE party_id = cp_person_id;
SELECT RTRIM(DECODE(person_last_name,null,'',DECODE(person_first_name,null,person_last_name,person_last_name
|| ', ' ) ) || NVL(person_first_name,'')|| ' '||person_middle_name,' ')
FROM hz_parties
WHERE party_id = cp_person_id;
SELECT ou.description ou_description
FROM IGS_OR_UNIT ou
WHERE ou.org_unit_cd = cp_org_unit_cd;
SELECT oadv.org_unit_cd oadv_org_unit_cd,
oadv.addr_type oadv_addr_type,
oadv.addr_line_1 oadv_addr_line_1,
oadv.addr_line_2 oadv_addr_line_2,
oadv.addr_line_3 oadv_addr_line_3,
oadv.addr_line_4 oadv_addr_line_4,
oadv.city oadv_city
FROM IGS_OR_ADDR oadv
WHERE oadv.org_unit_cd = cp_org_unit_cd AND
oadv.correspondence_ind = 'Y';
SELECT oadv.org_unit_cd oadv_org_unit_cd,
oadv.addr_type oadv_addr_type,
oadv.addr_line_1 oadv_addr_line_1,
oadv.addr_line_2 oadv_addr_line_2,
oadv.addr_line_3 oadv_addr_line_3,
oadv.addr_line_4 oadv_addr_line_4,
oadv.city oadv_city
FROM IGS_OR_ADDR oadv
WHERE oadv.org_unit_cd = cp_org_unit_cd AND
oadv.addr_type = cp_addr_type;
SELECT loc.description loc_description
FROM IGS_AD_LOCATION loc
WHERE loc.location_cd = cp_location_cd;
SELECT
LA.LOCATION_VENUE_CD ladv_location_cd,
HL.ADDRESS1 ladv_addr_line_1,
HL.ADDRESS2 ladv_addr_line_2,
HL.ADDRESS3 ladv_addr_line_3,
HL.ADDRESS4 ladv_addr_line_4,
HL.CITY ladv_city
FROM
HZ_LOCATIONS HL,
IGS_AD_LOCVENUE_ADDR LA
WHERE
HL.LOCATION_ID = LA.LOCATION_ID
AND LA.SOURCE_TYPE = 'L'
AND LA.LOCATION_VENUE_CD = cp_location_cd
AND LA.IDENTIFYING_ADDRESS_FLAG = 'Y' ;
SELECT
LA.LOCATION_VENUE_CD ladv_location_cd,
HL.ADDRESS1 ladv_addr_line_1,
HL.ADDRESS2 ladv_addr_line_2,
HL.ADDRESS3 ladv_addr_line_3,
HL.ADDRESS4 ladv_addr_line_4,
HL.CITY ladv_city
FROM
HZ_LOCATIONS HL,
IGS_AD_LOCVENUE_ADDR LA ,
IGS_PE_LOCVENUE_USE PLU
WHERE
HL.LOCATION_ID = LA.LOCATION_ID
AND LA.LOCATION_VENUE_ADDR_ID = PLU.LOC_VENUE_ADDR_ID
AND LA.SOURCE_TYPE = 'L'
AND LA.LOCATION_VENUE_CD = cp_location_cd
AND PLU.SITE_USE_CODE = cp_addr_type;
SELECT inst.name inst_name
FROM IGS_OR_INSTITUTION inst
WHERE inst.institution_cd = cp_institution_cd;
SELECT iadv.institution_cd iadv_institution_cd,
iadv.addr_type iadv_addr_type,
iadv.addr_line_1 iadv_addr_line_1,
iadv.addr_line_2 iadv_addr_line_2,
iadv.addr_line_3 iadv_addr_line_3,
iadv.addr_line_4 iadv_addr_line_4,
iadv.city iadv_city
FROM IGS_OR_INST_ADDR iadv
WHERE iadv.institution_cd = cp_institution_cd AND
iadv.correspondence_ind = 'Y';
SELECT iadv.institution_cd iadv_institution_cd,
iadv.addr_type iadv_addr_type,
iadv.addr_line_1 iadv_addr_line_1,
iadv.addr_line_2 iadv_addr_line_2,
iadv.addr_line_3 iadv_addr_line_3,
iadv.addr_line_4 iadv_addr_line_4,
iadv.city iadv_city
FROM IGS_OR_INST_ADDR iadv
WHERE iadv.institution_cd = cp_institution_cd AND
iadv.addr_type = cp_addr_type;
SELECT IGS_PE_PERSON_PE_ID_S.nextval
FROM DUAL;
SELECT 'x'
FROM IGS_PE_PERSON_BASE_V
WHERE person_id = cp_person_id;
SELECT DECODE(
UPPER(p_field_name),
'SURNAME', p.PERSON_LAST_NAME ,
'GIVEN_NAMES', P.PERSON_FIRST_NAME ,
'PREFERRED_GIVEN_NAME', P.KNOWN_AS ,
'CONTEXT_BLOCK_NAME', p.PERSON_LAST_NAME || ', ' || p.PERSON_TITLE || ' ' || NVL(p.KNOWN_AS,p.PERSON_FIRST_NAME),
NULL)
FROM hz_parties p
WHERE p.party_id = cp_person_id;
SELECT RTRIM(DECODE(person_last_name,null,'',DECODE(person_first_name,null,person_last_name,person_last_name
|| ', ' ) ) || NVL(person_first_name,'')|| ' '||person_middle_name,' ')
FROM hz_parties
WHERE party_id = cp_person_id;
SELECT *
FROM IGS_PE_PERSON_BASE_V -- IGS_PE_API_ALT_PERS_API_ID_V
WHERE person_id = p_person_id;
SELECT pdv. EMAIL_ADDRESS email_addr
FROM HZ_PARTIES pdv -- IGS_PE_PERSON_V pdv
WHERE pdv.party_id = p_person_id;
SELECT p.last_name surname,
p.first_name given_names,
p.title,
null oracle_username,
p.known_as preferred_given_name,
p.full_name,
NVL(P.KNOWN_AS, SUBSTR (P.FIRST_NAME, 1, DECODE(INSTR(P.FIRST_NAME, ' '), 0, LENGTH(P.FIRST_NAME), (INSTR(P.FIRST_NAME, ' ')-1)))) || ' ' || P.LAST_NAME PREFERRED_NAME,
null title_name,
p.LAST_NAME || ', ' || p.TITLE || ' ' || NVL(p.KNOWN_AS,p.FIRST_NAME) CONTEXT_BLOCK_NAME
FROM igs_pe_person_base_v p
WHERE person_id = p_person_id;