Product: | QA - Quality |
---|---|
Description: | Shows collection plan , elements and chart and Quality Dynamic Reportwriter criterias |
Implementation/DBA Data: | APPS.QA_CRITERIA_V |
SELECT QCV1.ROW_ID
, QCV1.CRITERIA_SEQUENCE
, QCV1.LAST_UPDATE_DATE
, QCV1.LAST_UPDATED_BY
, QCV1.CREATION_DATE
, QCV1.CREATED_BY
, QCV1.LAST_UPDATE_LOGIN
, QCV1.CRITERIA_ID
, QCV1.ORDER_SEQUENCE
, QCV1.SQL_TYPE
, QCV1.CHAR_ID
, QC.NAME CHAR_NAME
, QC.HARDCODED_COLUMN
, QPC.RESULT_COLUMN_NAME
, QC.DATATYPE
, QC.DISPLAY_LENGTH
, QC.PROMPT
, NVL(QPC.DECIMAL_PRECISION
, QC.DECIMAL_PRECISION) DECIMAL_PRECISION
, NVL(QPC.VALUES_EXIST_FLAG
, QC.VALUES_EXIST_FLAG)
, DECODE(QC.SQL_VALIDATION_STRING
, NULL
, 'N'
, 'Y') SQL_STRING_FLAG
, 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
, QCV1.OPERATOR
, QCV1.LOW_VALUE
, QCV1.LOW_VALUE_ID
, QCV1.HIGH_VALUE
, QCV1.HIGH_VALUE_ID
, QCV1.FXN
, M.MEANING FXN_MEANING
, QCV1.TOTAL
, QCV1.SORT_BY
FROM QA_PLAN_CHARS QPC
, QA_CHARS QC
, MFG_LOOKUPS M
, QA_CRITERIA_V1 QCV1
WHERE M.LOOKUP_TYPE (+) = 'QA_FUNCTION'
AND M.LOOKUP_CODE (+) = QCV1.FXN
AND QCV1.CHAR_ID = QC.CHAR_ID
AND QCV1.PLAN_ID = QPC.PLAN_ID (+)
AND QCV1.CHAR_ID = QPC.CHAR_ID (+)