VIEW: APPS.QA_SEQ_AUDIT_HISTORY_V

Source

View Text - Preformatted

SELECT qash.plan_id, qp.name plan_name, qp.description plan_description, qp.organization_id, mp.organization_code, qash.collection_id, qash.occurrence, qash.char_id, qc.name char_name, qash.sequence_value, qash.txn_header_id, qash.user_id, fu.user_name, qash.source_code, qash.source_id, qash.audit_type, ql.meaning audit_meaning, ql.description audit_description, qash.audit_date, qash.last_update_date, qash.last_updated_by, qash.creation_date, qash.created_by, qash.last_update_login FROM qa_seq_audit_history qash, qa_plans qp, qa_chars qc, fnd_user fu, qa_lookups ql, mtl_parameters mp WHERE qash.plan_id = qp.plan_id AND qp.organization_id = mp.organization_id AND qash.char_id = qc.char_id AND qash.user_id = fu.user_id AND qash.audit_type = ql.lookup_code AND ql.lookup_type = 'QA_SEQ_AUDIT_TYPE'

View Text - HTML Formatted

SELECT QASH.PLAN_ID
, QP.NAME PLAN_NAME
, QP.DESCRIPTION PLAN_DESCRIPTION
, QP.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, QASH.COLLECTION_ID
, QASH.OCCURRENCE
, QASH.CHAR_ID
, QC.NAME CHAR_NAME
, QASH.SEQUENCE_VALUE
, QASH.TXN_HEADER_ID
, QASH.USER_ID
, FU.USER_NAME
, QASH.SOURCE_CODE
, QASH.SOURCE_ID
, QASH.AUDIT_TYPE
, QL.MEANING AUDIT_MEANING
, QL.DESCRIPTION AUDIT_DESCRIPTION
, QASH.AUDIT_DATE
, QASH.LAST_UPDATE_DATE
, QASH.LAST_UPDATED_BY
, QASH.CREATION_DATE
, QASH.CREATED_BY
, QASH.LAST_UPDATE_LOGIN
FROM QA_SEQ_AUDIT_HISTORY QASH
, QA_PLANS QP
, QA_CHARS QC
, FND_USER FU
, QA_LOOKUPS QL
, MTL_PARAMETERS MP
WHERE QASH.PLAN_ID = QP.PLAN_ID
AND QP.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND QASH.CHAR_ID = QC.CHAR_ID
AND QASH.USER_ID = FU.USER_ID
AND QASH.AUDIT_TYPE = QL.LOOKUP_CODE
AND QL.LOOKUP_TYPE = 'QA_SEQ_AUDIT_TYPE'