VIEW: APPS.QA_PC_RESULT_COLUMNS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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