VIEW: APPS.QA_CHARS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'