View: QA_PLAN_CHARS_V

Product:	QA - Quality
Description:	Shows collection plan and collection elements
Implementation/DBA Data:	APPS.QA_PLAN_CHARS_V

View Text

SELECT QPC.ROWID ROW_ID
, QPC.PLAN_ID
, QPC.CHAR_ID
, QPC.LAST_UPDATE_DATE
, QPC.LAST_UPDATED_BY
, QPC.CREATION_DATE
, QPC.CREATED_BY
, QPC.LAST_UPDATE_LOGIN
, QPC.PROMPT_SEQUENCE
, QC.CHAR_TYPE_CODE
, QP.ORGANIZATION_ID
, FL.MEANING CHAR_TYPE_MEANING
, FL.DESCRIPTION CHAR_TYPE_DESCRIPTION
, QPC.PROMPT
, QPC.ENABLED_FLAG
, ML.MEANING ENABLED_MEANING
, QPC.MANDATORY_FLAG
, ML2.MEANING MANDATORY_MEANING
, QPC.DEFAULT_VALUE
, QPC.DEFAULT_VALUE_ID
, QPC.RESULT_COLUMN_NAME
, QPC.VALUES_EXIST_FLAG
, DECODE(QC.SQL_VALIDATION_STRING
, NULL
, 'N'
, 'Y') SQL_STRING_FLAG
, ML4.MEANING VALUES_EXIST_MEANING
, QC.VALUES_EXIST_FLAG MASTER_CHAR_VALUES_EXIST_FLAG
, QPC.DISPLAYED_FLAG
, ML5.MEANING DISPLAYED_MEANING
, QP.NAME PLAN_NAME
, QP.DESCRIPTION PLAN_DESCRIPTION
, QC.NAME CHAR_NAME
, QC.CHAR_CONTEXT_FLAG
, ML6.MEANING CHAR_CONTEXT_MEANING
, QC.DATATYPE
, ML7.MEANING DATATYPE_MEANING
, QC.DISPLAY_LENGTH
, NVL(QPC.DECIMAL_PRECISION
, QC.DECIMAL_PRECISION) DECIMAL_PRECISION
, NVL(QPC.UOM_CODE
, QC.UOM_CODE) UOM_CODE
, NVL(UOM1.UNIT_OF_MEASURE
, UOM.UNIT_OF_MEASURE) UNIT_OF_MEASURE
, QC.DATA_ENTRY_HINT
, QC.HARDCODED_COLUMN
, QC.DEVELOPER_NAME
, QC.FK_LOOKUP_TYPE
, QC.FK_TABLE_NAME
, QC.FK_TABLE_SHORT_NAME
, QC.FK_ID
, QC.FK_ID2
, QC.FK_ID3
, QC.PK_ID
, QC.PK_ID2
, QC.PK_ID3
, QC.FK_MEANING
, QC.FK_DESCRIPTION
, QC.FK_ADD_WHERE
, QPC.ATTRIBUTE_CATEGORY
, QPC.ATTRIBUTE1
, QPC.ATTRIBUTE2
, QPC.ATTRIBUTE3
, QPC.ATTRIBUTE4
, QPC.ATTRIBUTE5
, QPC.ATTRIBUTE6
, QPC.ATTRIBUTE7
, QPC.ATTRIBUTE8
, QPC.ATTRIBUTE9
, QPC.ATTRIBUTE10
, QPC.ATTRIBUTE11
, QPC.ATTRIBUTE12
, QPC.ATTRIBUTE13
, QPC.ATTRIBUTE14
, QPC.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
, QPC.DECIMAL_PRECISION QPC_DECIMAL_PRECISION
, QPC.UOM_CODE QPC_UOM_CODE
, NVL(QPC.READ_ONLY_FLAG
, 2)
, ML8.MEANING
, NVL(QPC.SS_POPLIST_FLAG
, 2)
, ML9.MEANING
, NVL(QPC.INFORMATION_FLAG
, 2)
, ML10.MEANING
FROM QA_PLANS QP
, QA_CHARS QC
, FND_COMMON_LOOKUPS FL
, MFG_LOOKUPS ML
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML4
, MFG_LOOKUPS ML5
, MFG_LOOKUPS ML6
, MFG_LOOKUPS ML7
, MFG_LOOKUPS ML8
, MFG_LOOKUPS ML9
, MFG_LOOKUPS ML10
, QA_LOOKUPS QL
, MTL_UNITS_OF_MEASURE UOM
, MTL_UNITS_OF_MEASURE UOM1
, QA_PLAN_CHARS QPC
WHERE QPC.PLAN_ID = QP.PLAN_ID
AND QPC.CHAR_ID = QC.CHAR_ID
AND QC.CHAR_TYPE_CODE = FL.LOOKUP_CODE
AND FL.LOOKUP_TYPE = 'ELEMENT_TYPE'
AND FL.APPLICATION_ID = 250
AND QPC.ENABLED_FLAG = ML.LOOKUP_CODE
AND ML.LOOKUP_TYPE = 'SYS_YES_NO'
AND QPC.MANDATORY_FLAG = ML2.LOOKUP_CODE
AND ML2.LOOKUP_TYPE = 'SYS_YES_NO'
AND QPC.VALUES_EXIST_FLAG = ML4.LOOKUP_CODE
AND ML4.LOOKUP_TYPE = 'SYS_YES_NO'
AND QPC.DISPLAYED_FLAG = ML5.LOOKUP_CODE
AND ML5.LOOKUP_TYPE = 'SYS_YES_NO'
AND QC.CHAR_CONTEXT_FLAG = ML6.LOOKUP_CODE
AND ML6.LOOKUP_TYPE = 'QA_CHAR_CONTEXT_FLAG'
AND QC.DATATYPE = ML7.LOOKUP_CODE
AND ML7.LOOKUP_TYPE = 'QA_CHAR_DATATYPE'
AND NVL(QPC.READ_ONLY_FLAG
, 2) = ML8.LOOKUP_CODE
AND ML8.LOOKUP_TYPE = 'SYS_YES_NO'
AND NVL(QPC.SS_POPLIST_FLAG
, 2) = ML9.LOOKUP_CODE
AND ML9.LOOKUP_TYPE = 'SYS_YES_NO'
AND NVL(QPC.INFORMATION_FLAG
, 2) = ML10.LOOKUP_CODE
AND ML10.LOOKUP_TYPE = 'SYS_YES_NO'
AND QC.UOM_CODE = UOM.UOM_CODE (+)
AND QPC.UOM_CODE = UOM1.UOM_CODE (+)
AND QC.SEQUENCE_NUMBER = QL.LOOKUP_CODE (+)
AND QL.LOOKUP_TYPE (+) = 'QA_SEQUENCE_NAME'

Columns