View: QA_PC_RESULTS_RELATIONSHIP_V

Product:	QA - Quality
Description:	Parent/child relationship view
Implementation/DBA Data:	APPS.QA_PC_RESULTS_RELATIONSHIP_V

View Text

SELECT QPRR.PARENT_PLAN_ID
, QPRR.PARENT_COLLECTION_ID
, QPRR.PARENT_OCCURRENCE
, QPRR.CHILD_PLAN_ID
, QPRR.CHILD_COLLECTION_ID
, QPRR.CHILD_OCCURRENCE
, QPRR.ENABLED_FLAG
, QR.TXN_HEADER_ID CHILD_TXN_HEADER_ID
, QPRR.LAST_UPDATE_DATE
, QPRR.LAST_UPDATED_BY
, QPRR.CREATION_DATE
, QPRR.CREATED_BY
, QPRR.LAST_UPDATE_LOGIN
, QPPR.PLAN_RELATIONSHIP_ID
, QPPR.PLAN_RELATIONSHIP_TYPE
, QPPR.DATA_ENTRY_MODE
, QPPR.AUTO_ROW_COUNT
, QPPR.DEFAULT_PARENT_SPEC
, QPPR.LAYOUT_MODE
FROM QA_PC_RESULTS_RELATIONSHIP QPRR
, QA_PC_PLAN_RELATIONSHIP QPPR
, QA_RESULTS QR
WHERE QPRR.PARENT_PLAN_ID = QPPR.PARENT_PLAN_ID
AND QPRR.CHILD_PLAN_ID = QPPR.CHILD_PLAN_ID
AND QPRR.CHILD_PLAN_ID = QR.PLAN_ID
AND QPRR.CHILD_COLLECTION_ID = QR.COLLECTION_ID
AND QPRR.CHILD_OCCURRENCE = QR.OCCURRENCE

Columns