eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.QA_PC_RESULTS_RELATIONSHIP_V

Object Details

Object Name:	QA_PC_RESULTS_RELATIONSHIP_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	QA.QA_PC_RESULTS_RELATIONSHIP_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Mandatory	Comments
PARENT_PLAN_ID	NUMBER	Yes	parent plan ID
PARENT_COLLECTION_ID	NUMBER	Yes	parent collection ID
PARENT_OCCURRENCE	NUMBER	Yes	parent occurrence
CHILD_PLAN_ID	NUMBER	Yes	child plan ID
CHILD_COLLECTION_ID	NUMBER	Yes	child collection ID
CHILD_OCCURRENCE	NUMBER	Yes	child occurrence
ENABLED_FLAG	NUMBER	Yes	enabled flag, for future expansion
CHILD_TXN_HEADER_ID	NUMBER		child txn header ID, see table description
LAST_UPDATE_DATE	DATE	Yes	Standard WHO column
LAST_UPDATED_BY	NUMBER	Yes	Standard WHO column
CREATION_DATE	DATE	Yes	Standard WHO column
CREATED_BY	NUMBER	Yes	Standard WHO column
LAST_UPDATE_LOGIN	NUMBER		Standard WHO column
PLAN_RELATIONSHIP_ID	NUMBER	Yes	plan relationship ID
PLAN_RELATIONSHIP_TYPE	NUMBER	Yes	plan relationship type
DATA_ENTRY_MODE	NUMBER	Yes	data entry mode
AUTO_ROW_COUNT	NUMBER	Yes	No. of rows to add in automatic relationship
DEFAULT_PARENT_SPEC	NUMBER	Yes	indicates whether to default specification from parent
LAYOUT_MODE	NUMBER		indicates single or multi row rendering for child plan in self-service UI

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
,      CHILD_TXN_HEADER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PLAN_RELATIONSHIP_ID
,      PLAN_RELATIONSHIP_TYPE
,      DATA_ENTRY_MODE
,      AUTO_ROW_COUNT
,      DEFAULT_PARENT_SPEC
,      LAYOUT_MODE
FROM APPS.QA_PC_RESULTS_RELATIONSHIP_V;

Dependencies

[top of page]

APPS.QA_PC_RESULTS_RELATIONSHIP_V references the following:

APPS: QA_PC_PLAN_RELATIONSHIP; QA_PC_RESULTS_RELATIONSHIP; QA_RESULTS

APPS.QA_PC_RESULTS_RELATIONSHIP_V is not referenced by any database object