ENGINATICS
SYSTEM_ADMINISTRATOR
SYSADMIN
AE8D7268AD3904D2E0530100007F2786
FND Audit Additional Info Table (audit table dependent)
Y
select distinct
y.table_name value,
null description
from
(
select
ft.table_name,
fpkc.primary_key_id,
fc.column_name,
max(nvl2(x.column_name,null,'Y')) over (partition by fpkc.primary_key_id) column_missing
from
fnd_tables ft,
fnd_primary_key_columns fpkc,
fnd_columns fc,
(
select
fc0.column_name
from
fnd_tables ft0,
fnd_audit_columns fac,
fnd_columns fc0
where
ft0.table_name=:$flex$.audit_table and
ft0.table_id=fac.table_id and
ft0.application_id=fac.table_app_id and
fac.schema_id=-1 and
fac.table_app_id=fc0.application_id and
fac.table_id=fc0.table_id and
fac.column_id=fc0.column_id
) x
where
ft.table_name<>:$flex$.audit_table and
ft.application_id=fpkc.application_id and
ft.table_id=fpkc.table_id and
fpkc.application_id=fc.application_id and
fpkc.table_id=fc.table_id and
fpkc.column_id=fc.column_id and
fc.column_name=x.column_name(+)
) y
where
y.column_missing is null
order by
y.table_name
US
A790D197B7482C46E0530100007F95AF
FND Audit Table
Y
select distinct
ft.table_name value,
ft.user_table_name description
from
fnd_tables ft,
fnd_audit_tables fat,
fnd_audit_groups fag
where
ft.table_id=fat.table_id and
ft.application_id=fat.table_app_id and
fat.audit_group_app_id=fag.application_id and
fat.audit_group_id=fag.audit_group_id and
fat.state in ('E','G','N') and
fag.state in ('E','G','N')
order by
ft.table_name
AR
تم تمكين جداول FND حاليًا للتدقيق
D
FND-Tabellen, die derzeit für das Auditing freigegeben sind
E
Tablas FND actualmente habilitadas para la auditoría
F
Tableaux FND actuellement habilités pour l'audit
I
Tabelle FND attualmente abilitate all'auditing
JA
現在、監査のために使用されているFNDテーブル
KO
현재 감사를 위해 활성화 된 FND 테이블
PTB
Tabelas FND atualmente preparadas para auditoria
RU
Таблицы ФНД, позволяющие в настоящее время проводить одитинг
S
FND-tabeller som för närvarande är godkända för granskning
TR
Şu anda denetim için etkinleştirilen FND tabloları
US
FND tables currently enabed for auditing
ZHS
目前用于审计的FND表。
A7C8F6C7920C192AE053B46B6358451C
FND Audit Table Column (audit table dependent)
Y
select distinct
fc.column_name value,
fc.user_column_name description
from
fnd_tables ft,
fnd_audit_tables fat,
fnd_audit_groups fag,
fnd_audit_columns fac,
fnd_columns fc
where
ft.table_name=:$flex$.audit_table and
ft.application_id=fat.table_app_id and
ft.table_id=fat.table_id and
fat.state in ('E','G','N') and
fat.audit_group_id=fag.audit_group_id and
fat.audit_group_app_id=fag.application_id and
fag.state in ('E','G','N') and
fat.table_app_id=fac.table_app_id and
fat.table_id=fac.table_id and
fac.state='N' and
fac.sequence_id>=0 and
fac.table_app_id=fc.application_id and
fac.table_id=fc.table_id and
fac.column_id=fc.column_id
order by
fc.column_name
AR
أعمدة جدول التدقيق FND - تعتمد على جدول التدقيق المحدد
D
FND-Audit-Tabellenspalten - abhängig von der angegebenen Audit-Tabelle
E
Columnas de la tabla de auditoría FND - dependientes de la tabla de auditoría especificada
F
Colonnes du tableau d'audit du FND - en fonction du tableau d'audit spécifié
I
Colonne della tabella di audit FND - dipendenti dalla tabella di audit specificata
JA
FND 監査テーブルの列 - 指定された監査テーブルに依存します。
KO
FND 감사 테이블 열-지정된 감사 테이블에 따라 다름
PTB
Colunas da tabela de auditoria FND - dependendo da tabela de auditoria especificada
RU
столбцы таблицы аудита ФНД - в зависимости от указанной таблицы аудита
S
FND-granskningstabellkolumner - beroende på den angivna granskningstabellen
TR
FND denetim tablosu sütunları - belirtilen denetim tablosuna bağlıdır
US
FND audit table columns - dependent on the specified audit table
ZHS
FND审计表列--取决于指定的审计表。
AE999C5FFF4A756BE0530100007FE9B7
FND Columns (audit info table dependent)
Y
select distinct
fc.column_name value,
fc.user_column_name description
from
fnd_tables ft,
fnd_columns fc
where
ft.table_name=:$flex$.additional_info_table and
ft.application_id=fc.application_id and
ft.table_id=fc.table_id
order by
fc.column_name
US
AE999A20C5877767E0530100007F7707
FND Columns (audit table dependent)
Y
select distinct
fc.column_name value,
fc.user_column_name description
from
fnd_tables ft,
fnd_columns fc
where
ft.table_name=:$flex$.audit_table and
ft.application_id=fc.application_id and
ft.table_id=fc.table_id
order by
fc.column_name
US
8E2FF36EDE8479D2E0530100007F1FF2
FND User Name
Y
Y
select
fu.user_name value,
trim(coalesce(
trim(papf.first_name||' '||papf.last_name),
fu.description,
fu.email_address,
papf.email_address
)||fu.inactive) description
from
(select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu,
(select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf,
(
select distinct
furg.user_id,
count(*) over (partition by furg.user_id) resp_count,
max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key
from
fnd_responsibility fr,
fnd_user_resp_groups_direct furg
where
fr.responsibility_id=furg.responsibility_id and
fr.application_id=furg.responsibility_application_id
) furg
where
fu.employee_id=papf.person_id(+) and
fu.user_id=furg.user_id(+) and
not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE')
order by
fu.inactive desc,
fu.user_name
US
FND user names, excluding iRecruitment candidates.
A8F11A0C50DC7CCDE0530100007FD1E1
select
q2.*
from
(
select
:audit_table audit_table,
xxen_util.client_time(q1.audit_timestamp) audit_timestamp,
xxen_util.meaning(q1.audit_transaction_type,'FND_AUDIT_TRANS_TYPE',0) audit_transaction_type,
xxen_util.user_name(q1.audit_user_name) audit_transaction_user,
&sel_xinfo_table_user_cols
&sel_base_table_user_cols
&sel_audit_key_cols
q1.audit_column audit_column,
case when q1.a_val is null and q1.true_null='N' then null else q1.a_val end old_value,
case q1.audit_transaction_type when 'D' then null when 'I' then q1.ac1_val else case when q1.a_val is null and q1.true_null='N' then null else q1.ac1_val end end new_value,
to_char(q1.row_key) row_key,
q1.audit_session_id,
q1.audit_sequence_id,
q1.audit_commit_id,
q1.column_sequence_id,
q1.audit_transaction_type audit_trx_type
from
(
select
aud_a.*,
col.column_name audit_column,
col.sequence_id column_sequence_id,
nvl(substr(aud_a.audit_true_nulls,col.sequence_id+1,1),'N') true_null,
case col.column_name
&sel_audit_cols_old_vals
end a_val,
case col.column_name
&sel_audit_cols_new_vals
end ac1_val
from
&from_audit_tables
(
select distinct
fc.column_name,
fac.sequence_id
from
fnd_tables ft,
fnd_audit_columns fac,
fnd_columns fc
where
1=1 and
ft.table_name=:audit_table and
ft.application_id=fac.table_app_id and
ft.table_id=fac.table_id and
fac.state='N' and
fac.sequence_id>=0 and
fac.table_app_id=fc.application_id and
fac.table_id=fc.table_id and
fac.column_id=fc.column_id
order by
fac.sequence_id,
fc.column_name
) col
where
2=2 and
&join_audit_tab_key_cols
aud_a.row_key=aud_ac1.row_key
) q1,
&from_tables
where
&join_base_table_key_cols
&join_xinfo_table_key_cols
3=3
) q2
where
4=4
order by
q2.audit_table,
q2.row_key desc,
q2.column_sequence_id
/*&dummy*/
Y
AR
FND Audit Table Changes by Column
الإبلاغ عن جميع التغييرات على جدول تطبيق مدقق.
يحتوي التقرير على صف واحد لكل معاملة تدقيق وعمود مدقق يعرض قيمة عمود التدقيق القديم والجديد.
D
FND Audit Table Changes by Column
Meldet alle Änderungen an einer geprüften Anwendungstabelle.
Der Bericht enthält eine Zeile pro Audit-Transaktion und geprüfter Spalte, die den alten und neuen Audit-Spaltenwert anzeigt.
E
FND Audit Table Changes by Column
Informa de todos los cambios en una tabla de aplicación auditada.
El informe tiene una fila por transacción de auditoría y columna auditada que muestra el valor de la columna de auditoría antigua y nueva.
F
FND Audit Table Changes by Column
Rapporte tous les changements à un tableau de demande vérifié.
Le rapport comporte une ligne par opération de vérification et une colonne vérifiée indiquant la valeur de l'ancienne et de la nouvelle colonne de vérification.
I
FND Audit Table Changes by Column
Riporta tutte le modifiche a una tabella di applicazione controllata.
Il rapporto ha una riga per ogni transazione di revisione e colonna revisionata che mostra il vecchio e il nuovo valore della colonna di revisione.
JA
FND Audit Table Changes by Column
監査されたアプリケーションテーブルへのすべての変更をレポートします。
レポートには、監査トランザクションごとに1行の行があり、新旧の監査欄の値を表示する監査欄があります。
KO
FND Audit Table Changes by Column
감사 된 애플리케이션 테이블에 대한 모든 변경 사항을보고합니다.
보고서에는 감사 트랜잭션 당 하나의 행과 이전 및 새 감사 열 값을 보여주는 감사 된 열이 있습니다.
PTB
FND Audit Table Changes by Column
Relata todas as mudanças em uma tabela de aplicação auditada.
O relatório tem uma linha por transação de auditoria e uma coluna auditada mostrando o valor da antiga e da nova coluna de auditoria.
RU
FND Audit Table Changes by Column
Сообщает обо всех изменениях в таблице проверенных приложений.
В отчете одна строка на каждую аудиторскую операцию и проверяемый столбец показывает значение старого и нового столбца аудита.
S
FND Audit Table Changes by Column
Rapporterar alla ändringar i en granskad applikationstabell.
Rapporten har en rad per granskningstransaktion och granskad kolumn som visar det gamla och nya granskningskolumnvärdet.
TR
FND Audit Table Changes by Column
Tüm değişiklikleri denetlenmiş bir uygulama tablosuna raporlar.
Rapor, denetim işlemi başına bir satıra ve eski ve yeni denetim sütunu değerini gösteren denetlenmiş sütuna sahiptir.
US
FND Audit Table Changes by Column
Reports all changes to an audited application table.
The report has one row per audit transaction and audited column showing the old and new audit column value.
ZHS
FND Audit Table Changes by Column
报告经审核的申请表格的所有变化。
报表每笔审计事务有一行，审计栏显示新旧审计栏值。
Enginatics
&dummy
&from_audit_tables
&from_tables
&join_audit_tab_key_cols
&join_base_table_key_cols
&join_xinfo_table_key_cols
&sel_audit_cols_new_vals
&sel_audit_cols_old_vals
&sel_audit_key_cols
&sel_base_table_user_cols
&sel_xinfo_table_user_cols
1=1
2=2
3=3
4=4
:audit_table
1
10
:audit_table
LOV
FND Audit Table
A790D197B7482C46E0530100007F95AF
Y
select distinct
ft.table_name value,
ft.user_table_name description
from
fnd_tables ft,
fnd_audit_tables fat,
fnd_audit_groups fag
where
ft.table_id=fat.table_id and
ft.application_id=fat.table_app_id and
fat.audit_group_app_id=fag.application_id and
fat.audit_group_id=fag.audit_group_id and
fat.state in ('E','G','N') and
fag.state in ('E','G','N')
order by
ft.table_name
Y
F
Table d'audit
US
Audit Table
2
&from_audit_tables
select
lower(
substr(:audit_table,1,24)||'_a aud_a,'||chr(10)||
substr(:audit_table,1,24)||'_ac1 aud_ac1,'
) text
from dual
F
Table d'audit
US
Audit Table
3
&from_tables
select lower(:audit_table||' tab') text from dual
F
Table d'audit
US
Audit Table
4
&join_audit_tab_key_cols
select
case when fc.null_allowed_flag='Y' and fc.primary_key_sequence>1 then
'nvl(aud_a.'||fc.column_name||','||decode(fc.column_type,'D','sysdate','N','-99','''x''')||')=nvl(aud_ac1.'||fc.column_name||','||decode(fc.column_type,'D','sysdate','N','-99','''x''')||') and' else
'aud_a.'||fc.column_name||'=aud_ac1.'||fc.column_name||' and' end text
from (
select distinct
lower(fc.column_name) column_name,
fac.sequence_id,
fc.column_type,
fc.null_allowed_flag,
fpkc.primary_key_sequence
from
fnd_tables ft,
fnd_audit_tables fat,
fnd_audit_columns fac,
fnd_columns fc,
fnd_primary_key_columns fpkc
where
ft.table_name=:audit_table and
ft.application_id=fat.table_app_id and
ft.table_id=fat.table_id and
fat.state in('E','G','N') and
fat.table_id=fac.table_id and
fat.table_app_id=fac.table_app_id and
fac.state='K' and
fac.sequence_id>=0 and
fac.table_app_id=fc.application_id and
fac.table_id=fc.table_id and
fac.column_id=fc.column_id and
fc.application_id=fpkc.application_id and
fc.table_id=fpkc.table_id and
fc.column_id=fpkc.column_id
order by
fac.sequence_id
) fc
F
Table d'audit
US
Audit Table
5
&join_base_table_key_cols
select
case when fc.null_allowed_flag='Y' and fc.primary_key_sequence>1 then
'nvl(q1.'||fc.column_name||','||decode(fc.column_type,'D','sysdate','N','-99','''x''')||')=nvl(tab.'||fc.column_name||'(+),'||decode(fc.column_type,'D','sysdate','N','-99','''x''')||') and' else
'q1.'||fc.column_name||'=tab.'||fc.column_name||'(+) and' end text
from (
select distinct
lower(fc.column_name) column_name,
fac.sequence_id,
fc.column_type,
fc.null_allowed_flag,
fpkc.primary_key_sequence
from
fnd_tables ft,
fnd_audit_tables fat,
fnd_audit_columns fac,
fnd_columns fc,
fnd_primary_key_columns fpkc
where
ft.table_name=:audit_table and
ft.application_id=fat.table_app_id and
ft.table_id=fat.table_id and
fat.state in('E','G','N') and
fat.table_id=fac.table_id and
fat.table_app_id=fac.table_app_id and
fac.state='K' and
fac.sequence_id>=0 and
fac.table_app_id=fc.application_id and
fac.table_id=fc.table_id and
fac.column_id=fc.column_id and
fc.application_id=fpkc.application_id and
fc.table_id=fpkc.table_id and
fc.column_id=fpkc.column_id
order by
fac.sequence_id
) fc
F
Table d'audit
US
Audit Table
6
&sel_audit_cols_new_vals
select
x.columns
from
(
select distinct
'when '''||fc.column_name||''' then to_char(aud_ac1.'||lower(fc.column_name)||')' columns,
fac.sequence_id
from
fnd_tables ft,
fnd_audit_tables fat,
fnd_audit_columns fac,
fnd_columns fc
where
ft.table_name=:audit_table and
ft.application_id=fat.table_app_id and
ft.table_id=fat.table_id and
fat.state in('E','G','N') and
fat.table_app_id=fac.table_app_id and
fat.table_id=fac.table_id and
fac.state='N' and
fac.sequence_id>=0 and
fac.table_app_id=fc.application_id and
fac.table_id=fc.table_id and
fac.column_id=fc.column_id
order by fac.sequence_id
) x
F
Table d'audit
US
Audit Table
7
&sel_audit_cols_old_vals
select
x.columns
from
(
select distinct
'when '''||fc.column_name||''' then to_char(aud_a.'||lower(fc.column_name)||')' columns,
fac.sequence_id
from
fnd_tables ft,
fnd_audit_tables fat,
fnd_audit_columns fac,
fnd_columns fc
where
ft.table_name=:audit_table and
ft.application_id=fat.table_app_id and
ft.table_id=fat.table_id and
fat.state in('E','G','N') and
fat.table_app_id=fac.table_app_id and
fat.table_id=fac.table_id and
fac.state='N' and
fac.sequence_id>=0 and
fac.table_app_id=fc.application_id and
fac.table_id=fc.table_id and
fac.column_id=fc.column_id
order by fac.sequence_id
) x
F
Table d'audit
US
Audit Table
8
&sel_audit_key_cols
select
x.column_name
from
(
select distinct
'q1.'||lower(fc.column_name)||',' column_name,
fac.sequence_id
from
fnd_tables ft,
fnd_audit_tables fat,
fnd_audit_columns fac,
fnd_columns fc
where
ft.table_name=:audit_table and
ft.application_id=fat.table_app_id and
ft.table_id=fat.table_id and
fat.state in('E','G','N') and
fat.table_app_id=fac.table_app_id and
fat.table_id=fac.table_id and
fac.state='K' and
fac.sequence_id>=0 and
fac.table_app_id=fc.application_id and
fac.table_id=fc.table_id and
fac.column_id=fc.column_id
order by
fac.sequence_id
) x
F
Table d'audit
US
Audit Table
9
&sel_base_table_user_cols
select distinct
'tab.'||lower(fc.column_name)||','
from
xxen_report_parameters_tl xrpt,
xxen_report_run_param_values xrrpv,
fnd_tables ft,
fnd_columns fc
where
xrpt.parameter_name='Informational Audit Table Columns' and
xrpt.language='US' and
xrpt.parameter_id=xrrpv.parameter_id and
xrrpv.run_id=:run_id and
xrrpv.value is not null and
ft.table_name=:audit_table and
ft.application_id=fc.application_id and
ft.table_id=fc.table_id and
not exists (select null from fnd_audit_columns fac where fc.application_id=fac.table_app_id and fc.table_id=fac.table_id and fc.column_id=fac.column_id and fac.state='K') and --exclude key columns. these are always displayed anyway
instr(':'||translate(replace(replace(xrrpv.value,'<multiple_values>',null),chr(10),':'),',;:|','::::')||':',':'||fc.column_name ||':')>0
F
Table d'audit
US
Audit Table
10
20
2=2
aud_a.audit_timestamp>=:date_from
DateTime
F
Date de l'audit Du
US
Audit Date From
11
30
2=2
aud_a.audit_timestamp<=:date_to
DateTime
F
Date de l'audit au
US
Audit Date To
12
40
2=2
aud_a.audit_user_name=:audited_user
LOV
FND User Name
8E2FF36EDE8479D2E0530100007F1FF2
Y
Y
select
fu.user_name value,
trim(coalesce(
trim(papf.first_name||' '||papf.last_name),
fu.description,
fu.email_address,
papf.email_address
)||fu.inactive) description
from
(select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu,
(select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf,
(
select distinct
furg.user_id,
count(*) over (partition by furg.user_id) resp_count,
max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key
from
fnd_responsibility fr,
fnd_user_resp_groups_direct furg
where
fr.responsibility_id=furg.responsibility_id and
fr.application_id=furg.responsibility_application_id
) furg
where
fu.employee_id=papf.person_id(+) and
fu.user_id=furg.user_id(+) and
not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE')
order by
fu.inactive desc,
fu.user_name
F
Utilisateurs contrôlés
US
Audited Users
13
50
1=1
fc.column_name=:audit_column
LOV
FND Audit Table Column (audit table dependent)
A7C8F6C7920C192AE053B46B6358451C
Y
select distinct
fc.column_name value,
fc.user_column_name description
from
fnd_tables ft,
fnd_audit_tables fat,
fnd_audit_groups fag,
fnd_audit_columns fac,
fnd_columns fc
where
ft.table_name=:$flex$.audit_table and
ft.application_id=fat.table_app_id and
ft.table_id=fat.table_id and
fat.state in ('E','G','N') and
fat.audit_group_id=fag.audit_group_id and
fat.audit_group_app_id=fag.application_id and
fag.state in ('E','G','N') and
fat.table_app_id=fac.table_app_id and
fat.table_id=fac.table_id and
fac.state='N' and
fac.sequence_id>=0 and
fac.table_app_id=fc.application_id and
fac.table_id=fc.table_id and
fac.column_id=fc.column_id
order by
fc.column_name
F
Inclure les colonnes d'audit
US
Include Audit Columns
14
60
&dummy
x=:dummy1
LOV
FND Columns (audit table dependent)
AE999A20C5877767E0530100007F7707
Y
select distinct
fc.column_name value,
fc.user_column_name description
from
fnd_tables ft,
fnd_columns fc
where
ft.table_name=:$flex$.audit_table and
ft.application_id=fc.application_id and
ft.table_id=fc.table_id
order by
fc.column_name
F
Colonnes du tableau d'audit informatif
US
Informational Audit Table Columns
15
70
:additional_info_table
LOV
FND Audit Additional Info Table (audit table dependent)
AE8D7268AD3904D2E0530100007F2786
Y
select distinct
y.table_name value,
null description
from
(
select
ft.table_name,
fpkc.primary_key_id,
fc.column_name,
max(nvl2(x.column_name,null,'Y')) over (partition by fpkc.primary_key_id) column_missing
from
fnd_tables ft,
fnd_primary_key_columns fpkc,
fnd_columns fc,
(
select
fc0.column_name
from
fnd_tables ft0,
fnd_audit_columns fac,
fnd_columns fc0
where
ft0.table_name=:$flex$.audit_table and
ft0.table_id=fac.table_id and
ft0.application_id=fac.table_app_id and
fac.schema_id=-1 and
fac.table_app_id=fc0.application_id and
fac.table_id=fc0.table_id and
fac.column_id=fc0.column_id
) x
where
ft.table_name<>:$flex$.audit_table and
ft.application_id=fpkc.application_id and
ft.table_id=fpkc.table_id and
fpkc.application_id=fc.application_id and
fpkc.table_id=fc.table_id and
fpkc.column_id=fc.column_id and
fc.column_name=x.column_name(+)
) y
where
y.column_missing is null
order by
y.table_name
F
Tableau d'informations supplémentaires
US
Additional Info Table
16
&from_tables
select ','||chr(10)||lower(:additional_info_table)||' xtab' from dual
F
Tableau d'informations supplémentaires
US
Additional Info Table
17
&join_xinfo_table_key_cols
select
z.text
from
(
select
min(y.primary_key_id) over () min_primary_key_id,
y.primary_key_id,
y.primary_key_sequence,
' '||chr(10)||lower(y.text) text
from
(
select
ft.table_name,
fpkc.primary_key_id,
fpkc.primary_key_sequence,
case when fc.null_allowed_flag='Y' and fpkc.primary_key_sequence>1 then
'nvl(tab.'||fc.column_name||','||decode(fc.column_type,'D','sysdate','N','-99','''x''')||')=nvl(xtab.'||fc.column_name||'(+)'||','||decode(fc.column_type,'D','sysdate','N','-99','''x''')||') and' else
'tab.'||fc.column_name||'=xtab.'||fc.column_name||'(+) and'
end text,
max(nvl2(x.column_name,null,'Y')) over (partition by fpkc.primary_key_id) column_missing
from
fnd_tables ft,
fnd_primary_key_columns fpkc,
fnd_columns fc,
(
select
fc0.column_name
from
fnd_tables ft0,
fnd_audit_columns fac,
fnd_columns fc0
where
ft0.table_name=:audit_table and
ft0.table_id=fac.table_id and
ft0.application_id=fac.table_app_id and
fac.schema_id=-1 and
fac.table_app_id=fc0.application_id and
fac.table_id=fc0.table_id and
fac.column_id=fc0.column_id
) x
where
ft.table_name=:additional_info_table and
ft.application_id=fpkc.application_id and
ft.table_id=fpkc.table_id and
fpkc.application_id=fc.application_id and
fpkc.table_id=fc.table_id and
fpkc.column_id=fc.column_id and
fc.column_name=x.column_name(+)
) y
where
y.column_missing is null
) z
where
z.primary_key_id=z.min_primary_key_id
order by
z.primary_key_sequence
F
Tableau d'informations supplémentaires
US
Additional Info Table
18
&sel_xinfo_table_user_cols
select distinct
'xtab.'||lower(fc.column_name)||' "'||substr(:additional_info_table||'.'||fc.column_name,1,xxen_report.max_column_length)||'",'
from
xxen_report_parameters_tl xrpt,
xxen_report_run_param_values xrrpv,
fnd_tables ft,
fnd_columns fc
where
xrpt.parameter_name='Additional Info Table Columns' and
xrpt.language='US' and
xrpt.parameter_id=xrrpv.parameter_id and
xrrpv.run_id=:run_id and
xrrpv.value is not null and
ft.table_name=:additional_info_table and
ft.application_id=fc.application_id and
ft.table_id=fc.table_id and
instr(':'||translate(replace(replace(xrrpv.value,'<multiple_values>',null),chr(10),':'),',;:|','::::')||':',':'||fc.column_name ||':')>0
F
Tableau d'informations supplémentaires
US
Additional Info Table
19
80
&dummy
x=:dummy2
LOV
FND Columns (audit info table dependent)
AE999C5FFF4A756BE0530100007FE9B7
Y
select distinct
fc.column_name value,
fc.user_column_name description
from
fnd_tables ft,
fnd_columns fc
where
ft.table_name=:$flex$.additional_info_table and
ft.application_id=fc.application_id and
ft.table_id=fc.table_id
order by
fc.column_name
F
Colonnes du tableau d'informations supplémentaires
US
Additional Info Table Columns
20
90
4=4
nvl(q2.old_value,'#ISNULL')!=nvl(q2.new_value,'#ISNULL') or q2.audit_trx_type='I'
LOV custom
Y
select 'changed or inserted' value, null description from dual union all
select 'changed only' value, null description from dual
changed or inserted
changed or inserted
F
Filtre d'enregistrement
US
Record Filter
21
4=4
nvl(q2.old_value,'#ISNULL')!=nvl(q2.new_value,'#ISNULL')
changed only
F
Filtre d'enregistrement
US
Record Filter
:$flex$.additional_info_table
Additional Info Table
Additional Info Table Columns
:$flex$.audit_table
Audit Table
Additional Info Table
:$flex$.audit_table
Audit Table
Include Audit Columns
:$flex$.audit_table
Audit Table
Informational Audit Table Columns