VIEW: APPS.QA_PC_PLAN_COLUMNS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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