eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.QA_CRITERIA_HEADERS_V

Source

View Text - Preformatted


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 (+)

View Text - HTML Formatted

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 (+)