View: QA_PC_PLAN_COLUMNS_V

Product:	QA - Quality
Description:	This view will be useful in getting all elements and values from current form so that these can be passed on to child plans.
Implementation/DBA Data:	APPS.QA_PC_PLAN_COLUMNS_V

View Text

SELECT QPC.PLAN_ID
, QPC.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
, QPC.ENABLED_FLAG
, QC.DATATYPE
FROM QA_PLAN_CHARS QPC
, QA_CHARS QC
WHERE QPC.CHAR_ID = QC.CHAR_ID

Columns