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
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 |