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
SQL 21 lines
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 |
Parameters 3
| Parameter | Type | List of values SQL |
|---|---|---|
| Sequence Collection Element | LOV Oracle | |
| From Date | Date | |
| To Date | Date |