[Home] [Help]
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
Name |
PLAN_ID |
CHAR_ID |
FORM_FIELD |
DATABASE_COLUMN |
ENABLED_FLAG |
DATATYPE |