View: QA_PC_RESULT_COLUMNS_V

Product:	QA - Quality
Description:	This view will be useful in dealing with copy relationship or others.
Implementation/DBA Data:	APPS.QA_PC_RESULT_COLUMNS_V

View Text

SELECT PR.PARENT_PLAN_ID
, PR.CHILD_PLAN_ID
, PE.PARENT_CHAR_ID
, REPLACE(DECODE(QC1.HARDCODED_COLUMN
, NULL
, QPC1.RESULT_COLUMN_NAME
, QC1.DEVELOPER_NAME)
, 'CHARACTER'
, 'DISPLAY') PARENT_FORM_FIELD
, QPC1.RESULT_COLUMN_NAME PARENT_DATABASE_COLUMN
, PE.CHILD_CHAR_ID
, REPLACE(DECODE(QC2.HARDCODED_COLUMN
, NULL
, QPC2.RESULT_COLUMN_NAME
, QC2.DEVELOPER_NAME)
, 'CHARACTER'
, 'DISPLAY') CHILD_FORM_FIELD
, QPC2.RESULT_COLUMN_NAME CHILD_DATABASE_COLUMN
, PE.ELEMENT_RELATIONSHIP_TYPE ELEMENT_RELATIONSHIP_TYPE
, QPC1.ENABLED_FLAG PARENT_ENABLED_FLAG
, QPC2.ENABLED_FLAG CHILD_ENABLED_FLAG
, QC1.DATATYPE
, QC2.DATATYPE
FROM QA_PC_PLAN_RELATIONSHIP PR
, QA_PC_ELEMENT_RELATIONSHIP PE
, QA_CHARS QC1
, QA_PLAN_CHARS QPC1
, QA_CHARS QC2
, QA_PLAN_CHARS QPC2
WHERE PR.PLAN_RELATIONSHIP_ID = PE.PLAN_RELATIONSHIP_ID
AND PE.PARENT_CHAR_ID = QC1.CHAR_ID
AND PE.CHILD_CHAR_ID = QC2.CHAR_ID
AND PR.PARENT_PLAN_ID = QPC1.PLAN_ID
AND PE.PARENT_CHAR_ID = QPC1.CHAR_ID
AND PR.CHILD_PLAN_ID = QPC2.PLAN_ID
AND PE.CHILD_CHAR_ID = QPC2.CHAR_ID

Columns