QA Sequence Element Audit
Description
Categories: BI Publisher
Application: Quality
Source: Sequence Element Audit Report (XML)
Short Name: QASEQAUD_XML
DB package: QA_QASEQAUD_XMLP_PKG
Source: Sequence Element Audit Report (XML)
Short Name: QASEQAUD_XML
DB package: QA_QASEQAUD_XMLP_PKG
Run
QA Sequence Element Audit and other Oracle EBS reports with Blitz Report™ on our demo environment
select qv.organization_code Org_Code, qv.plan_name Plan_Name, qv.collection_id Collection, qv.occurrence Occurrence, qc.name Element_Name, qc.prompt Prompt, qv.sequence_value Sequence_Value, qv.audit_type_meaning Audit_Type_Meaning, qv.source_code Source_Code, qv.source_id Source_Id, qv.audit_date audit_Date, qv.user_name User_Name from qa_seq_audit_history_v qv, qa_chars qc where qv.char_id = qc.char_id &P_char_limiter &P_audit_date_limiter order by qc.name |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Sequence Collection Element |
|
LOV Oracle | |
From Date |
|
Date | |
To Date |
|
Date |