VIEW: APPS.QA_PLAN_CHARS_V

Source

View Text - Preformatted

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 , NVL(QPC.DEVICE_FLAG,2) , ML11.MEANING , QPC.DEVICE_ID , DECODE(QPC.DEVICE_FLAG, 1, QDI.DEVICE_NAME || '-' || QDI.SENSOR_ALIAS, NULL) DEVICE , NVL(QPC.OVERRIDE_FLAG, 2) , ML12.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, MFG_LOOKUPS ML11, MFG_LOOKUPS ML12, QA_DEVICE_INFO QDI 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' AND QPC.DEVICE_ID = QDI.DEVICE_ID (+) AND NVL(QPC.DEVICE_FLAG, 2) = ML11.LOOKUP_CODE AND ML11.LOOKUP_TYPE = 'SYS_YES_NO' AND NVL(QPC.OVERRIDE_FLAG, 2) = ML12.LOOKUP_CODE AND ML12.LOOKUP_TYPE = 'SYS_YES_NO'

View Text - HTML Formatted

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
, NVL(QPC.DEVICE_FLAG
, 2)
, ML11.MEANING
, QPC.DEVICE_ID
, DECODE(QPC.DEVICE_FLAG
, 1
, QDI.DEVICE_NAME || '-' || QDI.SENSOR_ALIAS
, NULL) DEVICE
, NVL(QPC.OVERRIDE_FLAG
, 2)
, ML12.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
, MFG_LOOKUPS ML11
, MFG_LOOKUPS ML12
, QA_DEVICE_INFO QDI
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'
AND QPC.DEVICE_ID = QDI.DEVICE_ID (+)
AND NVL(QPC.DEVICE_FLAG
, 2) = ML11.LOOKUP_CODE
AND ML11.LOOKUP_TYPE = 'SYS_YES_NO'
AND NVL(QPC.OVERRIDE_FLAG
, 2) = ML12.LOOKUP_CODE
AND ML12.LOOKUP_TYPE = 'SYS_YES_NO'