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
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	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.

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
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:

APPS: QA_PC_PLAN_RELATIONSHIP