DBA Data[Home] [Help] [Dependency Information]

VIEW: QA.QA_PC_RESULTS_RELATIONSHIP#

Object Details
Object Name: QA_PC_RESULTS_RELATIONSHIP#
Object Type: VIEW
Owner: QA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
PARENT_PLAN_ID NUMBER
Yes
PARENT_COLLECTION_ID NUMBER
Yes
PARENT_OCCURRENCE NUMBER
Yes
CHILD_PLAN_ID NUMBER
Yes
CHILD_COLLECTION_ID NUMBER
Yes
CHILD_OCCURRENCE NUMBER
Yes
ENABLED_FLAG NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

CHILD_TXN_HEADER_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PARENT_PLAN_ID
,      PARENT_COLLECTION_ID
,      PARENT_OCCURRENCE
,      CHILD_PLAN_ID
,      CHILD_COLLECTION_ID
,      CHILD_OCCURRENCE
,      ENABLED_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CHILD_TXN_HEADER_ID
FROM QA.QA_PC_RESULTS_RELATIONSHIP#;

Dependencies

[top of page]

QA.QA_PC_RESULTS_RELATIONSHIP# references the following:

SchemaQA
TableQA_PC_RESULTS_RELATIONSHIP
QA.QA_PC_RESULTS_RELATIONSHIP# is referenced by following:

SchemaAPPS
SynonymQA_PC_RESULTS_RELATIONSHIP