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_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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