DBA Data[Home] [Help]

VIEW: APPS.QA_PC_RESULTS_RELATIONSHIP_V

Source

View Text - Preformatted

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

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