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]

TABLE: QA.QA_PC_PLAN_RELATIONSHIP

Object Details

Object Name:	QA_PC_PLAN_RELATIONSHIP
Object Type:	TABLE
Owner:	QA
FND Design Data:	QA.QA_PC_PLAN_RELATIONSHIP
Subobject Name:
Status:	VALID

This table stores the parent plan id and the child plan id, along with the relation type and a flag to indicate if the child plan is mandatory

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
QA_PC_PLAN_RELATIONSHIP_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PLAN_RELATIONSHIP_ID ZD_EDITION_NAME
QA_PC_PLAN_RELATIONSHIP_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_PLAN_ID
QA_PC_PLAN_RELATIONSHIP_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHILD_PLAN_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PLAN_RELATIONSHIP_ID	NUMBER		Yes	Parent Child relationship identifier
PARENT_PLAN_ID	NUMBER		Yes	Parent Plan Identifier
CHILD_PLAN_ID	NUMBER		Yes	Child Plan Identifier
PLAN_RELATIONSHIP_TYPE	NUMBER		Yes	Relationship type
DATA_ENTRY_MODE	NUMBER		Yes	Data entry mode, can be immediate, deferred or history
AUTO_ROW_COUNT	NUMBER		Yes	Number of automatic rows to be entered
DEFAULT_PARENT_SPEC	NUMBER		Yes	Indicates whether parent specification should be defaulted in the child
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
LAYOUT_MODE	NUMBER			To indicate child plan shall be rendered as single or multi row in self-service.
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT PLAN_RELATIONSHIP_ID
,      PARENT_PLAN_ID
,      CHILD_PLAN_ID
,      PLAN_RELATIONSHIP_TYPE
,      DATA_ENTRY_MODE
,      AUTO_ROW_COUNT
,      DEFAULT_PARENT_SPEC
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAYOUT_MODE
,      ZD_EDITION_NAME
FROM QA.QA_PC_PLAN_RELATIONSHIP;

Dependencies

[top of page]

QA.QA_PC_PLAN_RELATIONSHIP does not reference any database object

QA.QA_PC_PLAN_RELATIONSHIP is referenced by following:

QA: QA_PC_PLAN_RELATIONSHIP#