VIEW: APPS.QA_SPEC_CHARS_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)