Product: | QA - Quality |
---|---|
Description: | Shows chart and Quality Dynamic Reportwriter settings |
Implementation/DBA Data: | APPS.QA_CRITERIA_HEADERS_V |
SELECT QCRH.ROWID ROW_ID
, QCRH.CRITERIA_ID
, QCRH.LAST_UPDATE_DATE
, QCRH.LAST_UPDATED_BY
, QCRH.CREATION_DATE
, QCRH.CREATED_BY
, QCRH.LAST_UPDATE_LOGIN
, QCRH.ORGANIZATION_ID
, QCRH.NAME
, QCRH.PLAN_ID
, QP.NAME PLAN_NAME
, QCRH.OUTPUT_TYPE
, QCRH.TITLE
, QCRH.DESCRIPTION
, QCRH.CHART_TYPE
, QCRH.NUM_BARS
, QCRH.NUM_POINTS
, QCRH.X_AXIS_CHAR_ID
, QC1.NAME X_AXIS_CHAR_NAME
, QC1.HARDCODED_COLUMN X_AXIS_HARDCODED_COLUMN
, QPC1.RESULT_COLUMN_NAME X_AXIS_RESULT_COLUMN_NAME
, QC1.DATATYPE X_AXIS_DATATYPE
, QC1.DISPLAY_LENGTH X_AXIS_DISPLAY_LENGTH
, NVL(QPC1.PROMPT
, QC1.PROMPT) X_AXIS_PROMPT
, NVL(QPC1.DECIMAL_PRECISION
, QC1.DECIMAL_PRECISION) X_AXIS_DECIMAL_PRECISION
, QC1.FK_LOOKUP_TYPE X_AXIS_FK_LOOKUP_TYPE
, QC1.FK_TABLE_NAME X_AXIS_FK_TABLE_NAME
, QC1.FK_TABLE_SHORT_NAME X_AXIS_FK_TABLE_SHORT_NAME
, QC1.FK_ID X_AXIS_FK_ID
, QC1.FK_ID2 X_AXIS_FK_ID2
, QC1.FK_ID3 X_AXIS_FK_ID3
, QC1.PK_ID X_AXIS_PK_ID
, QC1.PK_ID2 X_AXIS_PK_ID2
, QC1.PK_ID3 X_AXIS_PK_ID3
, QC1.FK_MEANING X_AXIS_FK_MEANING
, QC1.FK_DESCRIPTION X_AXIS_FK_DESCRIPTION
, QC1.FK_ADD_WHERE X_AXIS_FK_ADD_WHERE
, NVL(QPC1.UOM_CODE
, QC1.UOM_CODE) X_AXIS_UOM_CODE
, NVL(MU1.UNIT_OF_MEASURE
, MU.UNIT_OF_MEASURE) X_AXIS_UNIT_OF_MEASURE
, QCRH.Y_AXIS_CHAR_ID
, QC2.NAME Y_AXIS_CHAR_NAME
, QC2.HARDCODED_COLUMN Y_AXIS_HARDCODED_COLUMN
, QPC2.RESULT_COLUMN_NAME Y_AXIS_RESULT_COLUMN_NAME
, QC2.DATATYPE Y_AXIS_DATATYPE
, QC2.DISPLAY_LENGTH Y_AXIS_DISPLAY_LENGTH
, NVL(QPC2.PROMPT
, QC2.PROMPT) Y_AXIS_PROMPT
, NVL(QPC2.DECIMAL_PRECISION
, QC2.DECIMAL_PRECISION) Y_AXIS_DECIMAL_PRECISION
, QC2.FK_LOOKUP_TYPE Y_AXIS_FK_LOOKUP_TYPE
, QC2.FK_TABLE_NAME Y_AXIS_FK_TABLE_NAME
, QC2.FK_TABLE_SHORT_NAME Y_AXIS_FK_TABLE_SHORT_NAME
, QC2.FK_ID Y_AXIS_FK_ID
, QC2.FK_ID2 Y_AXIS_FK_ID2
, QC2.FK_ID3 Y_AXIS_FK_ID3
, QC2.PK_ID Y_AXIS_PK_ID
, QC2.PK_ID2 Y_AXIS_PK_ID2
, QC2.PK_ID3 Y_AXIS_PK_ID3
, QC2.FK_MEANING Y_AXIS_FK_MEANING
, QC2.FK_DESCRIPTION Y_AXIS_FK_DESCRIPTION
, QC2.FK_ADD_WHERE Y_AXIS_FK_ADD_WHERE
, QCRH.Y_AXIS_FXN
, QCRH.TOP_N_GROUPS
, QCRH.X_AXIS_GROUP_BY_ID
, ML.MEANING X_AXIS_GROUP_BY_NAME
, QCRH.SPEC_ID
, QS.SPEC_NAME
, QSC.TARGET_VALUE
, QSC.LOWER_SPEC_LIMIT
, QSC.UPPER_SPEC_LIMIT
, QSC.LOWER_USER_DEFINED_LIMIT
, QSC.UPPER_USER_DEFINED_LIMIT
, QCRH.TARGET_VALUE_FLAG
, QCRH.SPEC_LIMIT_FLAG
, QCRH.USER_DEFINED_LIMIT_FLAG
FROM QA_PLANS QP
, QA_PLAN_CHARS QPC1
, QA_PLAN_CHARS QPC2
, QA_CHARS QC1
, QA_CHARS QC2
, QA_CRITERIA_HEADERS QCRH
, /* REPLACED QA_SPEC_CHARS_V QSCV */ QA_SPEC_CHARS QSC
, QA_SPECS QS
, /* REPLACED MTL_UNITS_MEASURE SYNONYMS */ MTL_UNITS_OF_MEASURE_TL MU
, MTL_UNITS_OF_MEASURE_TL MU1
, /* REPLACED MFG_LOOKUPS */ FND_LOOKUP_VALUES ML
WHERE QSC.SPEC_ID = QS.SPEC_ID (+)
AND QCRH.PLAN_ID = QP.PLAN_ID
AND ML.LOOKUP_CODE (+) = QCRH.X_AXIS_GROUP_BY_ID
AND ML.LOOKUP_TYPE (+) = 'QA_TIME_SERIES_AXIS'
AND ML.LANGUAGE (+) = USERENV('LANG')
AND ML.VIEW_APPLICATION_ID (+) = 700
AND ML.SECURITY_GROUP_ID (+) = 0
AND QCRH.PLAN_ID = QPC1.PLAN_ID (+)
AND QCRH.PLAN_ID = QPC2.PLAN_ID (+)
AND QCRH.X_AXIS_CHAR_ID = QC1.CHAR_ID (+)
AND QCRH.Y_AXIS_CHAR_ID = QC2.CHAR_ID (+)
AND QCRH.X_AXIS_CHAR_ID = QPC1.CHAR_ID (+)
AND QCRH.Y_AXIS_CHAR_ID = QPC2.CHAR_ID (+)
AND QC1.UOM_CODE = MU.UOM_CODE (+)
AND MU.LANGUAGE (+) = USERENV('LANG')
AND QPC1.UOM_CODE = MU1.UOM_CODE (+)
AND MU1.LANGUAGE (+) = USERENV('LANG')
AND QCRH.SPEC_ID = QSC.SPEC_ID (+)
AND DECODE(QCRH.OUTPUT_TYPE
, 2
, QCRH.Y_AXIS_CHAR_ID
, 4
, QCRH.X_AXIS_CHAR_ID
, 6
, QCRH.X_AXIS_CHAR_ID) = QSC.CHAR_ID (+)