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