[Home] [Help]
View: QA_PC_CRITERIA_COLUMNS_V
Product: | QA - Quality |
Description: | This view is for getting all elements that form the criteria elements of current plan. |
Implementation/DBA Data: |
APPS.QA_PC_CRITERIA_COLUMNS_V
|
View Text
SELECT PR.PARENT_PLAN_ID
, PC.CHAR_ID
, REPLACE(DECODE(QC.HARDCODED_COLUMN
, NULL
, QPC.RESULT_COLUMN_NAME
, QC.DEVELOPER_NAME)
, 'CHARACTER'
, 'DISPLAY') FORM_FIELD
, QPC.RESULT_COLUMN_NAME DATABASE_COLUMN
, QC.DATATYPE
FROM QA_PC_CRITERIA PC
, QA_PC_PLAN_RELATIONSHIP PR
, QA_CHARS QC
, QA_PLAN_CHARS QPC
WHERE PR.PLAN_RELATIONSHIP_ID = PC.PLAN_RELATIONSHIP_ID
AND QPC.CHAR_ID = QC.CHAR_ID
AND QPC.CHAR_ID = PC.CHAR_ID
AND QPC.PLAN_ID = PR.PARENT_PLAN_ID
Columns
Name |
PLAN_ID |
CHAR_ID |
FORM_FIELD |
DATABASE_COLUMN |
DATATYPE |