[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select distinct named_account_id
from jtf_tty_terr_grp_accts
where terr_group_id = p_terr_group_id;
select distinct TG.terr_group_name
, TER.name parent_territory
from jtf_tty_terr_grp_accts TGA
,jtf_tty_terr_groups TG
,jtf_terr_all TER
where TGA.named_account_id = c_named_account_id
and TGA.terr_group_id = TG.terr_group_id
and TG.parent_terr_id = TER.terr_id
and trunc(TG.active_from_date) <= trunc(sysdate)
and trunc(nvl(TG.active_to_date, sysdate)) >= trunc(sysdate) ;
select distinct named_account_id
from jtf_tty_named_accts NA
,hz_parties HZP
where HZP.party_id = NA.party_id
and HZP.duns_number_c = p_DUNS;
delete from JTF_TTY_WEBADI_INTERFACES
where user_id = to_number(p_userid)
and sysdate - creation_date >2;
select jtf_tty_interface_s.nextval into l_seq from dual;
insert into JTF_TTY_WEBADI_INTERFACES
( user_sequence
,user_id
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,attribute21
,attribute22
,created_by
,creation_date
,last_updated_by
,last_update_date
,ATTRIBUTE25
,ATTRIBUTE26
,ATTRIBUTE27
,ATTRIBUTE28
,ATTRIBUTE29
,ATTRIBUTE30
,ATTRIBUTE31
,ATTRIBUTE32
,ATTRIBUTE33
,ATTRIBUTE34
,ATTRIBUTE35
,ATTRIBUTE36
,ATTRIBUTE37
,ATTRIBUTE38
,ATTRIBUTE39
,ATTRIBUTE40
,ATTRIBUTE41
,ATTRIBUTE42
,ATTRIBUTE43
,ATTRIBUTE44
,ATTRIBUTE45
,ATTRIBUTE46
,ATTRIBUTE47
,ATTRIBUTE48
,ATTRIBUTE49
,ATTRIBUTE50
,ATTRIBUTE51
,ATTRIBUTE52
,ATTRIBUTE53
,ATTRIBUTE54
,ATTRIBUTE55
) select
l_seq
, p_userid
, HZP.party_name
, LKP.meaning site_type
, HZP.party_number
, HZP.duns_number_c site_duns
, HZP.known_as trade_name
, null
, null
, null
, null
, HZP.city
, HZP.state
, HZP.postal_code
, l_TG1
, l_PARENT1
, l_TG2
, l_PARENT2
, l_TG3
, l_PARENT3
, l_TG4
, l_PARENT4
, l_TG5
, l_PARENT5
, G_USER
, SYSDATE
, G_USER
, SYSDATE
, NA.PARTY_SITE_ID
, l_TG6
, l_PARENT6
, l_TG7
, l_PARENT7
, l_TG8
, l_PARENT8
, l_TG9
, l_PARENT9
, l_TG10
, l_PARENT10
, l_TG11
, l_PARENT11
, l_TG12
, l_PARENT12
, l_TG13
, l_PARENT13
, l_TG14
, l_PARENT14
, l_TG15
, l_PARENT15
, l_TG16
, l_PARENT16
, l_TG17
, l_PARENT17
, l_TG18
, l_PARENT18
, l_TG19
, l_PARENT19
, l_TG20
, l_PARENT20
from
jtf_tty_named_Accts NA
,hz_parties HZP
,fnd_lookups LKP
where NA.named_account_id = NA_rec.named_Account_id
and NA.party_id = HZP.party_id
and NA.site_type_code = LKP.lookup_code
and LKP.lookup_type = 'JTF_TTY_SITE_TYPE_CODE';
insert into JTF_TTY_WEBADI_INTERFACES
( user_sequence
,user_id
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,attribute21
,attribute22
,created_by
,creation_date
,last_updated_by
,last_update_date
,ATTRIBUTE25
,ATTRIBUTE26
,ATTRIBUTE27
,ATTRIBUTE28
,ATTRIBUTE29
,ATTRIBUTE30
,ATTRIBUTE31
,ATTRIBUTE32
,ATTRIBUTE33
,ATTRIBUTE34
,ATTRIBUTE35
,ATTRIBUTE36
,ATTRIBUTE37
,ATTRIBUTE38
,ATTRIBUTE39
,ATTRIBUTE40
,ATTRIBUTE41
,ATTRIBUTE42
,ATTRIBUTE43
,ATTRIBUTE44
,ATTRIBUTE45
,ATTRIBUTE46
,ATTRIBUTE47
,ATTRIBUTE48
,ATTRIBUTE49
,ATTRIBUTE50
,ATTRIBUTE51
,ATTRIBUTE52
,ATTRIBUTE53
,ATTRIBUTE54
,ATTRIBUTE55
) select
l_seq
, p_userid
, HZP.party_name
, LKP.meaning site_type
, HZP.party_number
, HZP.duns_number_c site_duns
, HZP.known_as trade_name
, null
, null
, null
, null
, HZP.city
, HZP.state
, HZP.postal_code
, l_TG1
, l_PARENT1
, l_TG2
, l_PARENT2
, l_TG3
, l_PARENT3
, l_TG4
, l_PARENT4
, l_TG5
, l_PARENT5
, G_USER
, SYSDATE
, G_USER
, SYSDATE
, NA.PARTY_SITE_ID
, l_TG6
, l_PARENT6
, l_TG7
, l_PARENT7
, l_TG8
, l_PARENT8
, l_TG9
, l_PARENT9
, l_TG10
, l_PARENT10
, l_TG11
, l_PARENT11
, l_TG12
, l_PARENT12
, l_TG13
, l_PARENT13
, l_TG14
, l_PARENT14
, l_TG15
, l_PARENT15
, l_TG16
, l_PARENT16
, l_TG17
, l_PARENT17
, l_TG18
, l_PARENT18
, l_TG19
, l_PARENT19
, l_TG20
, l_PARENT20
from
jtf_tty_named_Accts NA
,hz_parties HZP
,fnd_lookups LKP
where NA.named_account_id = p_named_account_id
and NA.party_id = HZP.party_id
and NA.site_type_code = LKP.lookup_code
and LKP.lookup_type = 'JTF_TTY_SITE_TYPE_CODE';
insert into JTF_TTY_WEBADI_INTERFACES
( user_sequence
,user_id
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,attribute16
,attribute17
,attribute18
,attribute19
,attribute20
,attribute21
,attribute22
,created_by
,creation_date
,last_updated_by
,last_update_date
,ATTRIBUTE25
,ATTRIBUTE26
,ATTRIBUTE27
,ATTRIBUTE28
,ATTRIBUTE29
,ATTRIBUTE30
,ATTRIBUTE31
,ATTRIBUTE32
,ATTRIBUTE33
,ATTRIBUTE34
,ATTRIBUTE35
,ATTRIBUTE36
,ATTRIBUTE37
,ATTRIBUTE38
,ATTRIBUTE39
,ATTRIBUTE40
,ATTRIBUTE41
,ATTRIBUTE42
,ATTRIBUTE43
,ATTRIBUTE44
,ATTRIBUTE45
,ATTRIBUTE46
,ATTRIBUTE47
,ATTRIBUTE48
,ATTRIBUTE49
,ATTRIBUTE50
,ATTRIBUTE51
,ATTRIBUTE52
,ATTRIBUTE53
,ATTRIBUTE54
,ATTRIBUTE55
) select
l_seq
, p_userid
, HZP.party_name
, LKP.meaning site_type
, HZP.party_number
, HZP.duns_number_c site_duns
, HZP.known_as trade_name
, null
, null
, null
, null
, HZP.city
, HZP.state
, HZP.postal_code
, l_TG1
, l_PARENT1
, l_TG2
, l_PARENT2
, l_TG3
, l_PARENT3
, l_TG4
, l_PARENT4
, l_TG5
, l_PARENT5
, G_USER
, SYSDATE
, G_USER
, SYSDATE
,NA.PARTY_SITE_ID
, l_TG6
, l_PARENT6
, l_TG7
, l_PARENT7
, l_TG8
, l_PARENT8
, l_TG9
, l_PARENT9
, l_TG10
, l_PARENT10
, l_TG11
, l_PARENT11
, l_TG12
, l_PARENT12
, l_TG13
, l_PARENT13
, l_TG14
, l_PARENT14
, l_TG15
, l_PARENT15
, l_TG16
, l_PARENT16
, l_TG17
, l_PARENT17
, l_TG18
, l_PARENT18
, l_TG19
, l_PARENT19
, l_TG20
, l_PARENT20
from
jtf_tty_named_Accts NA
,hz_parties HZP
,fnd_lookups LKP
where NA.named_account_id = DUNS_NA_rec.named_account_id
and NA.party_id = HZP.party_id
and NA.site_type_code = LKP.lookup_code
and LKP.lookup_type = 'JTF_TTY_SITE_TYPE_CODE';