Product: | QA - Quality |
---|---|
Description: | sequence audit table |
Implementation/DBA Data: | APPS.QA_SEQ_AUDIT_HISTORY_V |
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'