The following lines contain the word 'select', 'insert', 'update' or 'delete':
delete from po_lines_all_ext_tl T
where not exists
(select NULL
from po_lines_all_ext_b B
where B.EXTENSION_ID = T.EXTENSION_ID);
INSERT INTO PO_LINES_ALL_EXT_TL
(EXTENSION_ID
,ATTR_GROUP_ID
,PO_LINE_ID
,DATA_LEVEL_ID
,PK1_VALUE
,PK2_VALUE
,PK3_VALUE
,PK4_VALUE
,PK5_VALUE
,LANGUAGE
,SOURCE_LANG
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_LOGIN
,CREATED_BY
,CREATION_DATE
,TL_EXT_ATTR1
,TL_EXT_ATTR2
,TL_EXT_ATTR3
,TL_EXT_ATTR4
,TL_EXT_ATTR5
,TL_EXT_ATTR6
,TL_EXT_ATTR7
,TL_EXT_ATTR8
,TL_EXT_ATTR9
,TL_EXT_ATTR10
,TL_EXT_ATTR11
,TL_EXT_ATTR12
,TL_EXT_ATTR13
,TL_EXT_ATTR14
,TL_EXT_ATTR15
,TL_EXT_ATTR16
,TL_EXT_ATTR17
,TL_EXT_ATTR18
,TL_EXT_ATTR19
,TL_EXT_ATTR20
,TL_EXT_ATTR21
,TL_EXT_ATTR22
,TL_EXT_ATTR23
,TL_EXT_ATTR24
,TL_EXT_ATTR25
,TL_EXT_ATTR26
,TL_EXT_ATTR27
,TL_EXT_ATTR28
,TL_EXT_ATTR29
,TL_EXT_ATTR30
,TL_EXT_ATTR31
,TL_EXT_ATTR32
,TL_EXT_ATTR33
,TL_EXT_ATTR34
,TL_EXT_ATTR35
,TL_EXT_ATTR36
,TL_EXT_ATTR37
,TL_EXT_ATTR38
,TL_EXT_ATTR39
,TL_EXT_ATTR40
,UDA_TEMPLATE_ID
,DRAFT_ID
)
select
B.EXTENSION_ID
,B.ATTR_GROUP_ID
,B.PO_LINE_ID
,B.DATA_LEVEL_ID
,B.PK1_VALUE
,B.PK2_VALUE
,B.PK3_VALUE
,B.PK4_VALUE
,B.PK5_VALUE
,l.language_code
,B.SOURCE_LANG
,B.LAST_UPDATE_DATE
,B.LAST_UPDATED_BY
,B.LAST_UPDATE_LOGIN
,B.CREATED_BY
,B.CREATION_DATE
,B.TL_EXT_ATTR1
,B.TL_EXT_ATTR2
,B.TL_EXT_ATTR3
,B.TL_EXT_ATTR4
,B.TL_EXT_ATTR5
,B.TL_EXT_ATTR6
,B.TL_EXT_ATTR7
,B.TL_EXT_ATTR8
,B.TL_EXT_ATTR9
,B.TL_EXT_ATTR10
,B.TL_EXT_ATTR11
,B.TL_EXT_ATTR12
,B.TL_EXT_ATTR13
,B.TL_EXT_ATTR14
,B.TL_EXT_ATTR15
,B.TL_EXT_ATTR16
,B.TL_EXT_ATTR17
,B.TL_EXT_ATTR18
,B.TL_EXT_ATTR19
,B.TL_EXT_ATTR20
,B.TL_EXT_ATTR21
,B.TL_EXT_ATTR22
,B.TL_EXT_ATTR23
,B.TL_EXT_ATTR24
,B.TL_EXT_ATTR25
,B.TL_EXT_ATTR26
,B.TL_EXT_ATTR27
,B.TL_EXT_ATTR28
,B.TL_EXT_ATTR29
,B.TL_EXT_ATTR30
,B.TL_EXT_ATTR31
,B.TL_EXT_ATTR32
,B.TL_EXT_ATTR33
,B.TL_EXT_ATTR34
,B.TL_EXT_ATTR35
,B.TL_EXT_ATTR36
,B.TL_EXT_ATTR37
,B.TL_EXT_ATTR38
,B.TL_EXT_ATTR39
,B.TL_EXT_ATTR40
,B.UDA_TEMPLATE_ID
,B.DRAFT_ID
from fnd_languages l, po_lines_all_ext_tl B
where l.installed_flag in ('I', 'B')
and B.LANGUAGE = userenv('LANG')
and not exists
(select null
from po_lines_all_ext_tl t
where t.language = l.language_code
and t.extension_id = B.extension_id);