View: QA_CHARS_V

Product:	QA - Quality
Description:	This view shows the Collection elements information.
Implementation/DBA Data:	APPS.QA_CHARS_V

View Text

SELECT QC.ROWID ROW_ID
, QC.CHAR_ID
, QC.LAST_UPDATE_DATE
, QC.LAST_UPDATED_BY
, QC.CREATION_DATE
, QC.CREATED_BY
, QC.LAST_UPDATE_LOGIN
, QC.NAME
, QC.CHAR_TYPE_CODE
, FL.MEANING CHAR_TYPE_MEANING
, FL.DESCRIPTION CHAR_TYPE_DESCRIPTION
, QC.CHAR_CONTEXT_FLAG
, ML3.MEANING CHAR_CONTEXT_MEANING
, DECODE(QC.CHAR_CONTEXT_FLAG
, 1
, 2
, 1) CHAR_CONTEXT_CHECKBOX
, QC.PROMPT
, QC.DATA_ENTRY_HINT
, QC.DATATYPE
, ML4.MEANING DATATYPE_MEANING
, QC.DISPLAY_LENGTH
, QC.DECIMAL_PRECISION
, QC.DEFAULT_VALUE
, QC.DEFAULT_VALUE_ID
, QC.MANDATORY_FLAG
, ML.MEANING MANDATORY_MEANING
, QC.UOM_CODE
, UOM.UNIT_OF_MEASURE
, QC.TARGET_VALUE
, QC.UPPER_SPEC_LIMIT
, QC.LOWER_SPEC_LIMIT
, QC.UPPER_REASONABLE_LIMIT
, QC.LOWER_REASONABLE_LIMIT
, QC.UPPER_USER_DEFINED_LIMIT
, QC.LOWER_USER_DEFINED_LIMIT
, QC.HARDCODED_COLUMN
, QC.ENABLED_FLAG
, QC.DEVELOPER_NAME
, QC.SQL_VALIDATION_STRING
, DECODE(QC.SQL_VALIDATION_STRING
, NULL
, 'N'
, 'Y') SQL_STRING_FLAG
, ML6.MEANING ENABLED_MEANING
, QC.VALUES_EXIST_FLAG
, ML7.MEANING VALUES_EXIST_MEANING
, QC.DEPENDENT_CHAR_ID
, QC.FK_LOOKUP_TYPE
, QC.FK_TABLE_NAME
, QC.FK_TABLE_SHORT_NAME
, QC.PK_ID
, QC.FK_ID
, QC.PK_ID2
, QC.FK_ID2
, QC.PK_ID3
, QC.FK_ID3
, QC.FK_MEANING
, QC.FK_DESCRIPTION
, QC.FK_ADD_WHERE
, QC.ATTRIBUTE_CATEGORY
, QC.ATTRIBUTE1
, QC.ATTRIBUTE2
, QC.ATTRIBUTE3
, QC.ATTRIBUTE4
, QC.ATTRIBUTE5
, QC.ATTRIBUTE6
, QC.ATTRIBUTE7
, QC.ATTRIBUTE8
, QC.ATTRIBUTE9
, QC.ATTRIBUTE10
, QC.ATTRIBUTE11
, QC.ATTRIBUTE12
, QC.ATTRIBUTE13
, QC.ATTRIBUTE14
, QC.ATTRIBUTE15
, QC.SEQUENCE_NUMBER
, QC.SEQUENCE_PREFIX
, QC.SEQUENCE_SUFFIX
, QC.SEQUENCE_SEPARATOR
, QC.SEQUENCE_START
, QC.SEQUENCE_LENGTH
, QC.SEQUENCE_INCREMENT
, QC.SEQUENCE_NEXTVAL
, QC.SEQUENCE_ZERO_PAD
, QL.MEANING
FROM MTL_UNITS_OF_MEASURE UOM
, MFG_LOOKUPS ML
, MFG_LOOKUPS ML3
, MFG_LOOKUPS ML4
, MFG_LOOKUPS ML6
, MFG_LOOKUPS ML7
, FND_COMMON_LOOKUPS FL
, QA_LOOKUPS QL
, QA_CHARS QC
WHERE QC.UOM_CODE = UOM.UOM_CODE (+)
AND DECODE(QC.MANDATORY_FLAG
, 1
, 1
, 2) = ML.LOOKUP_CODE
AND ML.LOOKUP_TYPE = 'SYS_YES_NO'
AND QC.CHAR_CONTEXT_FLAG = ML3.LOOKUP_CODE
AND ML3.LOOKUP_TYPE = 'QA_CHAR_CONTEXT_FLAG'
AND QC.DATATYPE = ML4.LOOKUP_CODE
AND ML4.LOOKUP_TYPE = 'QA_CHAR_DATATYPE'
AND DECODE(QC.ENABLED_FLAG
, 1
, 1
, 2) = ML6.LOOKUP_CODE
AND ML6.LOOKUP_TYPE = 'SYS_YES_NO'
AND DECODE(QC.VALUES_EXIST_FLAG
, 1
, 1
, 2) = ML7.LOOKUP_CODE
AND ML7.LOOKUP_TYPE = 'SYS_YES_NO'
AND QC.CHAR_TYPE_CODE = FL.LOOKUP_CODE
AND FL.LOOKUP_TYPE = 'ELEMENT_TYPE'
AND FL.APPLICATION_ID = 250
AND QC.SEQUENCE_NUMBER = QL.LOOKUP_CODE (+)
AND QL.LOOKUP_TYPE (+) = 'QA_SEQUENCE_NAME'

Columns