DBA Data[Home] [Help]

VIEW: APPS.QA_PC_CRITERIA_COLUMNS_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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