SQL*Plus Report

SYS @ PRD0541 >
SYS @ PRD0541 > select sql_id,sql_text from gv$sql where sql_id in (
2 select sql_id from gv$session where status='INACTIVE' and machine='ttraflonrh885.global.trafigura.com'
3 union
4 select prev_sql_id from gv$session where status='INACTIVE' and machine='ttraflonrh885.global.trafigura.com'
5 );

SQL_ID SQL_TEXT

0f0q8upxu03hr Select FieldName as AttributeName, VariableScope, Scope, VariableType as Type, 1 024 as Length, unbounded, SystemDefinedName, VarPrecision,WFSearchVariableTable. VariableId from WFSearchVariableTable LEFT OUTER JOIN VarMappingTable ON UPPE R(RTRIM(WFSearchVariableTable.FieldName) ) = UPPER(RTRIM(VarMappingTable.UserDef inedName) ) and VarMappingTable.ProcessDefID = WFSearchVariableTable.ProcessDefI D where WFSearchVariableTable.ProcessDefID = :1 and WFSearchVariableTable.activ ityID = :2 and Scope in (N'R') and VarMappingTable.variableType != 11 and VarMa ppingTable.unbounded = 'N' order by Scope asc, OrderId asc

9zzftgdch8hgw select sum(MYCOUNT) from(select count(*) AS MYCOUNT from v_traf_kyc_search where upper(counter_party_name) LIKE upper('%Axiz%Bulk%Carriers%') union all select c ount(*) AS MYCOUNT from V_TRAF_KYC_SEARCH_OTHERNAME where upper(counter_party_na me) LIKE upper('%Axiz%Bulk%Carriers%') union all select count(*) AS MYCOUNT from V_TRAF_KYC_SEARCH_APPROVED_KYC where upper(counter_party_name) LIKE upper('%Axi z%Bulk%Carriers%') union all select count(*) AS MYCOUNT from V_TRAF_KYC_APPROVED _OTHERNAME where upper(counter_party_name) LIKE upper('%Axiz%Bulk%Carriers%'))

9zg9qd9bm4spu update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1

9zg9qd9bm4spu update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1

15pw1uykt8qda INSERT INTO TRAF_CA_NAVDATA_EXCEL (ENTITY,COUNTERPARTY_ID,COUNTERPARTY_NAME,OPER ATION_TYPE,BLANKET_NO,CONTRACT_NO,INCOTERM,PAYMENT_TERM,PRICE,TRANSACTION_TYPE,C URRENCY,OPERATION_START_DATE,OPERATION_END_DATE,LOCATION_CODE,LOCATION_DESC,ITEM _NO,ITEM_DESC,VOLUME_NGAL,VOLUME_BRL,UPLOADED_BY,STATUS,FILE_NAME ) VALUES (:1 , :2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:12 ,:13 ,:14 ,:15 ,:16 ,:17 ,:18 ,:19 ,:20 ,:21 ,:22 )

dp5j9gaxkcrmp SELECT LOWER(USERNAME) AS USERNAME FROM PDBUSER WHERE USERINDEX IN (SELECT DISTI NCT USERINDEX FROM (SELECT USERINDEX FROM PDBGROUPMEMBER WHERE GROUPINDEX IN (SE LECT USERID FROM QUEUEUSERTABLE WHERE QUEUEID IN (SELECT DISTINCT QUEUEID FROM Q UEUEDEFTABLE WHERE QUEUENAME = 'CA_Manage_Contract') AND ASSOCIATIONTYPE=1) UNIO N ALL SELECT USERID FROM QUEUEUSERTABLE WHERE QUEUEID IN (SELECT DISTINCT QUEUE ID FROM QUEUEDEFTABLE WHERE QUEUENAME = 'CA_Manage_Contract') AND ASSOCIATIONTYP E=0))

9zg9qd9bm4spu update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1

9zg9qd9bm4spu update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1

9zg9qd9bm4spu update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1

9zg9qd9bm4spu update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1

9zg9qd9bm4spu update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1

9zg9qd9bm4spu update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1

9zg9qd9bm4spu update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1

9zg9qd9bm4spu update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1

SQL_ID SQL_TEXT

9zg9qd9bm4spu update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1

f36ufwj70j31y select sum(MYCOUNT) from(select count(*) AS MYCOUNT from v_traf_kyc_search where upper(counter_party_name) LIKE upper('%???????%') union all select count(*) AS MYCOUNT from V_TRAF_KYC_SEARCH_OTHERNAME where upper(counter_party_name) LIKE up per('%???????%') union all select count(*) AS MYCOUNT from V_TRAF_KYC_SEARCH_APP ROVED_KYC where upper(counter_party_name) LIKE upper('%???????%') union all sele ct count(*) AS MYCOUNT from V_TRAF_KYC_APPROVED_OTHERNAME where upper(counter_pa rty_name) LIKE upper('%???????%'))

c1ap8zwdpx1dw select sum(MYCOUNT) from(select count(*) AS MYCOUNT from v_traf_kyc_search where upper(counter_party_name) LIKE upper('%Axis%Bulk%Carriers%') union all select c ount(*) AS MYCOUNT from V_TRAF_KYC_SEARCH_OTHERNAME where upper(counter_party_na me) LIKE upper('%Axis%Bulk%Carriers%') union all select count(*) AS MYCOUNT from V_TRAF_KYC_SEARCH_APPROVED_KYC where upper(counter_party_name) LIKE upper('%Axi s%Bulk%Carriers%') union all select count(*) AS MYCOUNT from V_TRAF_KYC_APPROVED _OTHERNAME where upper(counter_party_name) LIKE upper('%Axis%Bulk%Carriers%'))

6nrr3a3qqtnsk select 1 from DUAL

c3w9sq7t159cv SELECT ID,NAME FROM TRAF_KYC_COMPLIANT_MASTER WHERE ENTITY='Trafigura' and ACTIV ITY='Trading' and status='Y' and (select Constantvalue from Constantdeftable whe re Constantname='CONST_CompliantFlag' and Processdefid=(select PROCESSDEFID from processdeftable where processname='KYC'))='Y' ORDER BY ID

4vs91dcv7u1p6 insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,t erminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, n ew$owner,new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,co mment$text,spare1,spare2, priv$used,clientid,sessioncpu,proxy$sid,user$guid, in stance#,process#,xid,scn,auditid, sqlbind,sqltext,obj$edition,dbid) values(:1, :2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10,:11,:12, :13,:14,:15,:16,:17, :18,:19,:20,:21,:22, :23,:24,:25,:26,:27, :28, :29,:30,:31,:32, :33,:34,:35,:36)

4vs91dcv7u1p6 insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,t erminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, n ew$owner,new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,co mment$text,spare1,spare2, priv$used,clientid,sessioncpu,proxy$sid,user$guid, in stance#,process#,xid,scn,auditid, sqlbind,sqltext,obj$edition,dbid) values(:1, :2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10,:11,:12, :13,:14,:15,:16,:17, :18,:19,:20,:21,:22, :23,:24,:25,:26,:27, :28, :29,:30,:31,:32, :33,:34,:35,:36)

4vs91dcv7u1p6 insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,t erminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, n ew$owner,new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,co mment$text,spare1,spare2, priv$used,clientid,sessioncpu,proxy$sid,user$guid, in stance#,process#,xid,scn,auditid, sqlbind,sqltext,obj$edition,dbid) values(:1, :2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10,:11,:12, :13,:14,:15,:16,:17, :18,:19,:20,:21,:22, :23,:24,:25,:26,:27, :28, :29,:30,:31,:32, :33,:34,:35,:36)

6nrr3a3qqtnsk select 1 from DUAL

6nrr3a3qqtnsk select 1 from DUAL

6nrr3a3qqtnsk select 1 from DUAL

4vs91dcv7u1p6 insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,t erminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, n ew$owner,new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,co mment$text,spare1,spare2, priv$used,clientid,sessioncpu,proxy$sid,user$guid, in stance#,process#,xid,scn,auditid, sqlbind,sqltext,obj$edition,dbid) values(:1, :2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10,:11,:12, :13,:14,:15,:16,:17, :18,:19,:20,:21,:22, :23,:24,:25,:26,:27, :28, :29,:30,:31,:32, :33,:34,:35,:36)

4vs91dcv7u1p6 insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,t erminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, n ew$owner,new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,co mment$text,spare1,spare2, priv$used,clientid,sessioncpu,proxy$sid,user$guid, in stance#,process#,xid,scn,auditid, sqlbind,sqltext,obj$edition,dbid) values(:1, :2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10,:11,:12, :13,:14,:15,:16,:17, :18,:19,:20,:21,:22, :23,:24,:25,:26,:27, :28, :29,:30,:31,:32, :33,:34,:35,:36)

4vs91dcv7u1p6 insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,t erminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, n ew$owner,new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,co mment$text,spare1,spare2, priv$used,clientid,sessioncpu,proxy$sid,user$guid, in stance#,process#,xid,scn,auditid, sqlbind,sqltext,obj$edition,dbid) values(:1, :2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10,:11,:12, :13,:14,:15,:16,:17, :18,:19,:20,:21,:22, :23,:24,:25,:26,:27, :28, :29,:30,:31,:32, :33,:34,:35,:36)

SQL_ID SQL_TEXT

4vs91dcv7u1p6 insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,t erminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, n ew$owner,new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,co mment$text,spare1,spare2, priv$used,clientid,sessioncpu,proxy$sid,user$guid, in stance#,process#,xid,scn,auditid, sqlbind,sqltext,obj$edition,dbid) values(:1, :2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10,:11,:12, :13,:14,:15,:16,:17, :18,:19,:20,:21,:22, :23,:24,:25,:26,:27, :28, :29,:30,:31,:32, :33,:34,:35,:36)

gbqx72vwsu1r3 SELECT COUNT(1) AS COUNT FROM TRAF_SPOC_EDIT_MASTER WHERE PROCESS_NAME='APR' AND PROCESS_STATUS='E'

d8f1fzsjn2sjv BEGIN ISOraDocPkg.DBGetDocument(:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:1 2 ,:13 ,:14 ,:15 ,:16 ,:17 ,:18 ,:19 ,:20 ,:21 ,:22 ,:23 ,:24 ); END;

4vs91dcv7u1p6 insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,t erminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, n ew$owner,new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,co mment$text,spare1,spare2, priv$used,clientid,sessioncpu,proxy$sid,user$guid, in stance#,process#,xid,scn,auditid, sqlbind,sqltext,obj$edition,dbid) values(:1, :2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10,:11,:12, :13,:14,:15,:16,:17, :18,:19,:20,:21,:22, :23,:24,:25,:26,:27, :28, :29,:30,:31,:32, :33,:34,:35,:36)

4vs91dcv7u1p6 insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,t erminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, n ew$owner,new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,co mment$text,spare1,spare2, priv$used,clientid,sessioncpu,proxy$sid,user$guid, in stance#,process#,xid,scn,auditid, sqlbind,sqltext,obj$edition,dbid) values(:1, :2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10,:11,:12, :13,:14,:15,:16,:17, :18,:19,:20,:21,:22, :23,:24,:25,:26,:27, :28, :29,:30,:31,:32, :33,:34,:35,:36)

4vs91dcv7u1p6 insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,t erminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, n ew$owner,new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,co mment$text,spare1,spare2, priv$used,clientid,sessioncpu,proxy$sid,user$guid, in stance#,process#,xid,scn,auditid, sqlbind,sqltext,obj$edition,dbid) values(:1, :2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10,:11,:12, :13,:14,:15,:16,:17, :18,:19,:20,:21,:22, :23,:24,:25,:26,:27, :28, :29,:30,:31,:32, :33,:34,:35,:36)

33qp6t0c0azym BEGIN PRTIsAdmin(:1 ,:2 ,:3 ,:4 ); END;

d6w4sdxfs6n51 Select ObjectId, ObjectName , ObjectType , NotifyByEmail , Data from UserPrefere ncesTable where UserID = :1 and ObjectType in (N'Q',N'A')

d6w4sdxfs6n51 Select ObjectId, ObjectName , ObjectType , NotifyByEmail , Data from UserPrefere ncesTable where UserID = :1 and ObjectType in (N'Q',N'A')

d8f1fzsjn2sjv BEGIN ISOraDocPkg.DBGetDocument(:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:1 2 ,:13 ,:14 ,:15 ,:16 ,:17 ,:18 ,:19 ,:20 ,:21 ,:22 ,:23 ,:24 ); END;

bavzm0zy6ggar BEGIN TRAF_NFAP_INSERT_APPROVAL ('424109','RM_TITAN-000000000000328241','Invoice _PreEntry','2021-02-05 12:21:02','1'); END;

d8f1fzsjn2sjv BEGIN ISOraDocPkg.DBGetDocument(:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:1 2 ,:13 ,:14 ,:15 ,:16 ,:17 ,:18 ,:19 ,:20 ,:21 ,:22 ,:23 ,:24 ); END;

0jh87vkbtuvwp SELECT APP_UNIQUE_ID,S_C_URL,S_I_URL,C_L_URL,C_D_URL,C_D_PRM,C_CUSTOM_JS FROM OA _APPCONFIG WHERE APP_ID = 2

0cmsnf4qvkzj1 BEGIN ISOraDocPkg.DBAddDocument(:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:1 2 ,:13 ,:14 ,:15 ,:16 ,:17 ,:18 ,:19 ,:20 ); END;

SQL_ID SQL_TEXT

d8f1fzsjn2sjv BEGIN ISOraDocPkg.DBGetDocument(:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:1 2 ,:13 ,:14 ,:15 ,:16 ,:17 ,:18 ,:19 ,:20 ,:21 ,:22 ,:23 ,:24 ); END;

d9fk4m4wrru4z INSERT INTO TRAF_CC_CASHINDATA_EXCEL (Company,COUNTERPARTY_NAME,CASH_IN_AMOUNT,C urrency,TRANSACTION_DATE,BANK_TRANSACTION_ID,COUNTERPARTY_BANK,COUNTERPARTY_ACCO UNT,TRAF_BANK_NAME,TRAF_BANK_ACCOUNT,ABSTRACT_INFO,Purpose,Remark,UPLOADED_BY,ST ATUS,FILE_NAME ) VALUES (:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:12 ,:13 ,:14 ,:15 ,:16 )

d9fk4m4wrru4z INSERT INTO TRAF_CC_CASHINDATA_EXCEL (Company,COUNTERPARTY_NAME,CASH_IN_AMOUNT,C urrency,TRANSACTION_DATE,BANK_TRANSACTION_ID,COUNTERPARTY_BANK,COUNTERPARTY_ACCO UNT,TRAF_BANK_NAME,TRAF_BANK_ACCOUNT,ABSTRACT_INFO,Purpose,Remark,UPLOADED_BY,ST ATUS,FILE_NAME ) VALUES (:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:12 ,:13 ,:14 ,:15 ,:16 )

bfry39zkv7bhn SELECT USERNAME FROM PDBUSER WHERE USERINDEX IN (SELECT USERINDEX FROM PDBGROUPM EMBER WHERE GROUPINDEX= (SELECT GROUPINDEX FROM PDBGROUP WHERE UPPER(GROUPNAME)I N (SELECT GROUP_NAME FROM TRAF_CATITAN_GROUP_STREAM_MAP WHERE UPPER(STREAM) = UP PER('Refined Metals') ) ) )

85k0fxk0zgb4z SELECT USERINDEX FROM PDBGROUPMEMBER WHERE GROUPINDEX=(SELECT GROUPINDEX FROM PD BGROUP WHERE UPPER(GROUPNAME)=UPPER('Manage_Contract_Grp')) AND USERINDEX=99

crjrhkhtcbrk5 SELECT PRODUCT_NAME FROM TRAF_CA_PRODUCT_MASTER

4tsh7m4f27vjq SELECT CONTRACT_RESP FROM TRAF_CATITAN_CONTRACT_RESP_M WHERE ISACTIVE='Y' ORDER BY ORDER_BY ASC

gby9qh9gmguju SELECT TAT_FLAG,ALERT_FLAG,ALERT_FLAG_PARENT FROM TRAF_CA_EXT WHERE WORKITEM_NAM E ='CA-000000000001926009'

SQL_ID	SQL_TEXT
0f0q8upxu03hr	Select FieldName as AttributeName, VariableScope, Scope, VariableType as Type, 1 024 as Length, unbounded, SystemDefinedName, VarPrecision,WFSearchVariableTable. VariableId from WFSearchVariableTable LEFT OUTER JOIN VarMappingTable ON UPPE R(RTRIM(WFSearchVariableTable.FieldName) ) = UPPER(RTRIM(VarMappingTable.UserDef inedName) ) and VarMappingTable.ProcessDefID = WFSearchVariableTable.ProcessDefI D where WFSearchVariableTable.ProcessDefID = :1 and WFSearchVariableTable.activ ityID = :2 and Scope in (N'R') and VarMappingTable.variableType != 11 and VarMa ppingTable.unbounded = 'N' order by Scope asc, OrderId asc
9zzftgdch8hgw	select sum(MYCOUNT) from(select count() AS MYCOUNT from v_traf_kyc_search where upper(counter_party_name) LIKE upper('%Axiz%Bulk%Carriers%') union all select c ount() AS MYCOUNT from V_TRAF_KYC_SEARCH_OTHERNAME where upper(counter_party_na me) LIKE upper('%Axiz%Bulk%Carriers%') union all select count() AS MYCOUNT from V_TRAF_KYC_SEARCH_APPROVED_KYC where upper(counter_party_name) LIKE upper('%Axi z%Bulk%Carriers%') union all select count() AS MYCOUNT from V_TRAF_KYC_APPROVED _OTHERNAME where upper(counter_party_name) LIKE upper('%Axiz%Bulk%Carriers%'))
9zg9qd9bm4spu	update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1
9zg9qd9bm4spu	update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1
15pw1uykt8qda	INSERT INTO TRAF_CA_NAVDATA_EXCEL (ENTITY,COUNTERPARTY_ID,COUNTERPARTY_NAME,OPER ATION_TYPE,BLANKET_NO,CONTRACT_NO,INCOTERM,PAYMENT_TERM,PRICE,TRANSACTION_TYPE,C URRENCY,OPERATION_START_DATE,OPERATION_END_DATE,LOCATION_CODE,LOCATION_DESC,ITEM _NO,ITEM_DESC,VOLUME_NGAL,VOLUME_BRL,UPLOADED_BY,STATUS,FILE_NAME ) VALUES (:1 , :2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:12 ,:13 ,:14 ,:15 ,:16 ,:17 ,:18 ,:19 ,:20 ,:21 ,:22 )
dp5j9gaxkcrmp	SELECT LOWER(USERNAME) AS USERNAME FROM PDBUSER WHERE USERINDEX IN (SELECT DISTI NCT USERINDEX FROM (SELECT USERINDEX FROM PDBGROUPMEMBER WHERE GROUPINDEX IN (SE LECT USERID FROM QUEUEUSERTABLE WHERE QUEUEID IN (SELECT DISTINCT QUEUEID FROM Q UEUEDEFTABLE WHERE QUEUENAME = 'CA_Manage_Contract') AND ASSOCIATIONTYPE=1) UNIO N ALL SELECT USERID FROM QUEUEUSERTABLE WHERE QUEUEID IN (SELECT DISTINCT QUEUE ID FROM QUEUEDEFTABLE WHERE QUEUENAME = 'CA_Manage_Contract') AND ASSOCIATIONTYP E=0))
9zg9qd9bm4spu	update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1
9zg9qd9bm4spu	update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1
9zg9qd9bm4spu	update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1
9zg9qd9bm4spu	update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1
9zg9qd9bm4spu	update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1
9zg9qd9bm4spu	update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1
9zg9qd9bm4spu	update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1
9zg9qd9bm4spu	update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1
SQL_ID	SQL_TEXT
9zg9qd9bm4spu	update user$ set spare6=DECODE(to_char(:2, 'YYYY-MM-DD'), '0000-00-00', to_date( NULL), :2) where user#=:1
f36ufwj70j31y	select sum(MYCOUNT) from(select count() AS MYCOUNT from v_traf_kyc_search where upper(counter_party_name) LIKE upper('%???????%') union all select count() AS MYCOUNT from V_TRAF_KYC_SEARCH_OTHERNAME where upper(counter_party_name) LIKE up per('%???????%') union all select count() AS MYCOUNT from V_TRAF_KYC_SEARCH_APP ROVED_KYC where upper(counter_party_name) LIKE upper('%???????%') union all sele ct count() AS MYCOUNT from V_TRAF_KYC_APPROVED_OTHERNAME where upper(counter_pa rty_name) LIKE upper('%???????%'))
c1ap8zwdpx1dw	select sum(MYCOUNT) from(select count() AS MYCOUNT from v_traf_kyc_search where upper(counter_party_name) LIKE upper('%Axis%Bulk%Carriers%') union all select c ount() AS MYCOUNT from V_TRAF_KYC_SEARCH_OTHERNAME where upper(counter_party_na me) LIKE upper('%Axis%Bulk%Carriers%') union all select count() AS MYCOUNT from V_TRAF_KYC_SEARCH_APPROVED_KYC where upper(counter_party_name) LIKE upper('%Axi s%Bulk%Carriers%') union all select count() AS MYCOUNT from V_TRAF_KYC_APPROVED _OTHERNAME where upper(counter_party_name) LIKE upper('%Axis%Bulk%Carriers%'))
6nrr3a3qqtnsk	select 1 from DUAL
c3w9sq7t159cv	SELECT ID,NAME FROM TRAF_KYC_COMPLIANT_MASTER WHERE ENTITY='Trafigura' and ACTIV ITY='Trading' and status='Y' and (select Constantvalue from Constantdeftable whe re Constantname='CONST_CompliantFlag' and Processdefid=(select PROCESSDEFID from processdeftable where processname='KYC'))='Y' ORDER BY ID
4vs91dcv7u1p6	insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,t erminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, n ew$owner,new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,co mment$text,spare1,spare2, priv$used,clientid,sessioncpu,proxy$sid,user$guid, in stance#,process#,xid,scn,auditid, sqlbind,sqltext,obj$edition,dbid) values(:1, :2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10,:11,:12, :13,:14,:15,:16,:17, :18,:19,:20,:21,:22, :23,:24,:25,:26,:27, :28, :29,:30,:31,:32, :33,:34,:35,:36)
4vs91dcv7u1p6	insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,t erminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, n ew$owner,new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,co mment$text,spare1,spare2, priv$used,clientid,sessioncpu,proxy$sid,user$guid, in stance#,process#,xid,scn,auditid, sqlbind,sqltext,obj$edition,dbid) values(:1, :2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10,:11,:12, :13,:14,:15,:16,:17, :18,:19,:20,:21,:22, :23,:24,:25,:26,:27, :28, :29,:30,:31,:32, :33,:34,:35,:36)
4vs91dcv7u1p6	insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,t erminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, n ew$owner,new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,co mment$text,spare1,spare2, priv$used,clientid,sessioncpu,proxy$sid,user$guid, in stance#,process#,xid,scn,auditid, sqlbind,sqltext,obj$edition,dbid) values(:1, :2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10,:11,:12, :13,:14,:15,:16,:17, :18,:19,:20,:21,:22, :23,:24,:25,:26,:27, :28, :29,:30,:31,:32, :33,:34,:35,:36)
6nrr3a3qqtnsk	select 1 from DUAL
6nrr3a3qqtnsk	select 1 from DUAL
6nrr3a3qqtnsk	select 1 from DUAL
4vs91dcv7u1p6	insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,t erminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, n ew$owner,new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,co mment$text,spare1,spare2, priv$used,clientid,sessioncpu,proxy$sid,user$guid, in stance#,process#,xid,scn,auditid, sqlbind,sqltext,obj$edition,dbid) values(:1, :2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10,:11,:12, :13,:14,:15,:16,:17, :18,:19,:20,:21,:22, :23,:24,:25,:26,:27, :28, :29,:30,:31,:32, :33,:34,:35,:36)
4vs91dcv7u1p6	insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,t erminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, n ew$owner,new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,co mment$text,spare1,spare2, priv$used,clientid,sessioncpu,proxy$sid,user$guid, in stance#,process#,xid,scn,auditid, sqlbind,sqltext,obj$edition,dbid) values(:1, :2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10,:11,:12, :13,:14,:15,:16,:17, :18,:19,:20,:21,:22, :23,:24,:25,:26,:27, :28, :29,:30,:31,:32, :33,:34,:35,:36)
4vs91dcv7u1p6	insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,t erminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, n ew$owner,new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,co mment$text,spare1,spare2, priv$used,clientid,sessioncpu,proxy$sid,user$guid, in stance#,process#,xid,scn,auditid, sqlbind,sqltext,obj$edition,dbid) values(:1, :2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10,:11,:12, :13,:14,:15,:16,:17, :18,:19,:20,:21,:22, :23,:24,:25,:26,:27, :28, :29,:30,:31,:32, :33,:34,:35,:36)
SQL_ID	SQL_TEXT
4vs91dcv7u1p6	insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,t erminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, n ew$owner,new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,co mment$text,spare1,spare2, priv$used,clientid,sessioncpu,proxy$sid,user$guid, in stance#,process#,xid,scn,auditid, sqlbind,sqltext,obj$edition,dbid) values(:1, :2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10,:11,:12, :13,:14,:15,:16,:17, :18,:19,:20,:21,:22, :23,:24,:25,:26,:27, :28, :29,:30,:31,:32, :33,:34,:35,:36)
gbqx72vwsu1r3	SELECT COUNT(1) AS COUNT FROM TRAF_SPOC_EDIT_MASTER WHERE PROCESS_NAME='APR' AND PROCESS_STATUS='E'
d8f1fzsjn2sjv	BEGIN ISOraDocPkg.DBGetDocument(:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:1 2 ,:13 ,:14 ,:15 ,:16 ,:17 ,:18 ,:19 ,:20 ,:21 ,:22 ,:23 ,:24 ); END;
4vs91dcv7u1p6	insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,t erminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, n ew$owner,new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,co mment$text,spare1,spare2, priv$used,clientid,sessioncpu,proxy$sid,user$guid, in stance#,process#,xid,scn,auditid, sqlbind,sqltext,obj$edition,dbid) values(:1, :2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10,:11,:12, :13,:14,:15,:16,:17, :18,:19,:20,:21,:22, :23,:24,:25,:26,:27, :28, :29,:30,:31,:32, :33,:34,:35,:36)
4vs91dcv7u1p6	insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,t erminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, n ew$owner,new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,co mment$text,spare1,spare2, priv$used,clientid,sessioncpu,proxy$sid,user$guid, in stance#,process#,xid,scn,auditid, sqlbind,sqltext,obj$edition,dbid) values(:1, :2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10,:11,:12, :13,:14,:15,:16,:17, :18,:19,:20,:21,:22, :23,:24,:25,:26,:27, :28, :29,:30,:31,:32, :33,:34,:35,:36)
4vs91dcv7u1p6	insert into sys.aud$( sessionid,entryid,statement,ntimestamp#, userid,userhost,t erminal,action#,returncode, obj$creator,obj$name,auth$privileges,auth$grantee, n ew$owner,new$name,ses$actions,ses$tid,logoff$pread, logoff$lwrite,logoff$dead,co mment$text,spare1,spare2, priv$used,clientid,sessioncpu,proxy$sid,user$guid, in stance#,process#,xid,scn,auditid, sqlbind,sqltext,obj$edition,dbid) values(:1, :2,:3,SYS_EXTRACT_UTC(SYSTIMESTAMP), :4,:5,:6,:7,:8, :9,:10,:11,:12, :13,:14,:15,:16,:17, :18,:19,:20,:21,:22, :23,:24,:25,:26,:27, :28, :29,:30,:31,:32, :33,:34,:35,:36)
33qp6t0c0azym	BEGIN PRTIsAdmin(:1 ,:2 ,:3 ,:4 ); END;
d6w4sdxfs6n51	Select ObjectId, ObjectName , ObjectType , NotifyByEmail , Data from UserPrefere ncesTable where UserID = :1 and ObjectType in (N'Q',N'A')
d6w4sdxfs6n51	Select ObjectId, ObjectName , ObjectType , NotifyByEmail , Data from UserPrefere ncesTable where UserID = :1 and ObjectType in (N'Q',N'A')
d8f1fzsjn2sjv	BEGIN ISOraDocPkg.DBGetDocument(:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:1 2 ,:13 ,:14 ,:15 ,:16 ,:17 ,:18 ,:19 ,:20 ,:21 ,:22 ,:23 ,:24 ); END;
bavzm0zy6ggar	BEGIN TRAF_NFAP_INSERT_APPROVAL ('424109','RM_TITAN-000000000000328241','Invoice _PreEntry','2021-02-05 12:21:02','1'); END;
d8f1fzsjn2sjv	BEGIN ISOraDocPkg.DBGetDocument(:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:1 2 ,:13 ,:14 ,:15 ,:16 ,:17 ,:18 ,:19 ,:20 ,:21 ,:22 ,:23 ,:24 ); END;
0jh87vkbtuvwp	SELECT APP_UNIQUE_ID,S_C_URL,S_I_URL,C_L_URL,C_D_URL,C_D_PRM,C_CUSTOM_JS FROM OA _APPCONFIG WHERE APP_ID = 2
0cmsnf4qvkzj1	BEGIN ISOraDocPkg.DBAddDocument(:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:1 2 ,:13 ,:14 ,:15 ,:16 ,:17 ,:18 ,:19 ,:20 ); END;
SQL_ID	SQL_TEXT
d8f1fzsjn2sjv	BEGIN ISOraDocPkg.DBGetDocument(:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:1 2 ,:13 ,:14 ,:15 ,:16 ,:17 ,:18 ,:19 ,:20 ,:21 ,:22 ,:23 ,:24 ); END;
d9fk4m4wrru4z	INSERT INTO TRAF_CC_CASHINDATA_EXCEL (Company,COUNTERPARTY_NAME,CASH_IN_AMOUNT,C urrency,TRANSACTION_DATE,BANK_TRANSACTION_ID,COUNTERPARTY_BANK,COUNTERPARTY_ACCO UNT,TRAF_BANK_NAME,TRAF_BANK_ACCOUNT,ABSTRACT_INFO,Purpose,Remark,UPLOADED_BY,ST ATUS,FILE_NAME ) VALUES (:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:12 ,:13 ,:14 ,:15 ,:16 )
d9fk4m4wrru4z	INSERT INTO TRAF_CC_CASHINDATA_EXCEL (Company,COUNTERPARTY_NAME,CASH_IN_AMOUNT,C urrency,TRANSACTION_DATE,BANK_TRANSACTION_ID,COUNTERPARTY_BANK,COUNTERPARTY_ACCO UNT,TRAF_BANK_NAME,TRAF_BANK_ACCOUNT,ABSTRACT_INFO,Purpose,Remark,UPLOADED_BY,ST ATUS,FILE_NAME ) VALUES (:1 ,:2 ,:3 ,:4 ,:5 ,:6 ,:7 ,:8 ,:9 ,:10 ,:11 ,:12 ,:13 ,:14 ,:15 ,:16 )
bfry39zkv7bhn	SELECT USERNAME FROM PDBUSER WHERE USERINDEX IN (SELECT USERINDEX FROM PDBGROUPM EMBER WHERE GROUPINDEX= (SELECT GROUPINDEX FROM PDBGROUP WHERE UPPER(GROUPNAME)I N (SELECT GROUP_NAME FROM TRAF_CATITAN_GROUP_STREAM_MAP WHERE UPPER(STREAM) = UP PER('Refined Metals') ) ) )
85k0fxk0zgb4z	SELECT USERINDEX FROM PDBGROUPMEMBER WHERE GROUPINDEX=(SELECT GROUPINDEX FROM PD BGROUP WHERE UPPER(GROUPNAME)=UPPER('Manage_Contract_Grp')) AND USERINDEX=99
crjrhkhtcbrk5	SELECT PRODUCT_NAME FROM TRAF_CA_PRODUCT_MASTER
4tsh7m4f27vjq	SELECT CONTRACT_RESP FROM TRAF_CATITAN_CONTRACT_RESP_M WHERE ISACTIVE='Y' ORDER BY ORDER_BY ASC
gby9qh9gmguju	SELECT TAT_FLAG,ALERT_FLAG,ALERT_FLAG_PARENT FROM TRAF_CA_EXT WHERE WORKITEM_NAM E ='CA-000000000001926009'

50 rows selected.

SYS @ PRD0541 >
SYS @ PRD0541 >
SYS @ PRD0541 >
SYS @ PRD0541 >
SYS @ PRD0541 >
SYS @ PRD0541 > spool off