Product: | QA - Quality |
---|---|
Description: | Shows specification and collection elements |
Implementation/DBA Data: | APPS.QA_SPEC_CHARS_V |
SELECT QSC.ROWID ROW_ID
, QS.SPEC_ID
, QSC.CHAR_ID
, QSC.LAST_UPDATE_DATE
, QSC.LAST_UPDATED_BY
, QSC.CREATION_DATE
, QSC.CREATED_BY
, QSC.LAST_UPDATE_LOGIN
, QSC.TARGET_VALUE
, QSC.UPPER_SPEC_LIMIT
, QSC.LOWER_SPEC_LIMIT
, QSC.UPPER_REASONABLE_LIMIT
, QSC.LOWER_REASONABLE_LIMIT
, QSC.UPPER_USER_DEFINED_LIMIT
, QSC.LOWER_USER_DEFINED_LIMIT
, QS.SPEC_NAME
, QC.NAME CHAR_NAME
, NVL(QSC.UOM_CODE
, QC.UOM_CODE) UOM_CODE
, QS.EFFECTIVE_FROM
, QS.EFFECTIVE_TO
, QC.DATATYPE
, QC.DECIMAL_PRECISION
, QSC.ENABLED_FLAG SPEC_CHAR_ENABLED
, ML2.MEANING SPEC_CHAR_ENABLED_MEANING
, QSC.ATTRIBUTE_CATEGORY
, QSC.ATTRIBUTE1
, QSC.ATTRIBUTE2
, QSC.ATTRIBUTE3
, QSC.ATTRIBUTE4
, QSC.ATTRIBUTE5
, QSC.ATTRIBUTE6
, QSC.ATTRIBUTE7
, QSC.ATTRIBUTE8
, QSC.ATTRIBUTE9
, QSC.ATTRIBUTE10
, QSC.ATTRIBUTE11
, QSC.ATTRIBUTE12
, QSC.ATTRIBUTE13
, QSC.ATTRIBUTE14
, QSC.ATTRIBUTE15
, QSC.UOM_CODE QSC_UOM_CODE
, QS.SPEC_STATUS
, ML3.MEANING
FROM QA_CHARS QC
, QA_SPECS QS
, QA_SPEC_CHARS QSC
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
WHERE QSC.CHAR_ID = QC.CHAR_ID
AND QSC.SPEC_ID = QS.COMMON_SPEC_ID
AND DECODE(QSC.ENABLED_FLAG
, 1
, 1
, 2) = ML2.LOOKUP_CODE
AND ML2.LOOKUP_TYPE = 'SYS_YES_NO'
AND ML3.LOOKUP_TYPE (+) = 'QA_ERES_SPEC_STATUS'
AND QS.SPEC_STATUS = ML3.LOOKUP_CODE (+)