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: PJI.PJI_FP_AGGR_XBS#

Object Details

Object Name:	PJI_FP_AGGR_XBS#
Object Type:	VIEW
Owner:	PJI
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
WORKER_ID	NUMBER	(15)	Yes
STRUCT_TYPE	VARCHAR2	(30)	Yes
PRG_GROUP	NUMBER	(15)
STRUCT_VERSION_ID	NUMBER	(15)
SUP_PROJECT_ID	NUMBER	(15)	Yes
SUP_ID	NUMBER	(15)	Yes
SUP_EMT_ID	NUMBER	(15)	Yes
SUBRO_ID	NUMBER	(15)
SUB_ID	NUMBER	(15)	Yes
SUB_EMT_ID	NUMBER	(15)	Yes
SUP_LEVEL	NUMBER	(15)	Yes
SUB_LEVEL	NUMBER	(15)	Yes
SUB_ROLLUP_ID	NUMBER	(15)
SUB_LEAF_FLAG	VARCHAR2	(1)	Yes
SUB_LEAF_FLAG_ID	NUMBER	(15)
STATUS_ID	VARCHAR2	(255)
STRUCT_EMT_ID	NUMBER	(15)
RELATIONSHIP_TYPE	VARCHAR2	(2)

Query Text

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


SELECT WORKER_ID
,      STRUCT_TYPE
,      PRG_GROUP
,      STRUCT_VERSION_ID
,      SUP_PROJECT_ID
,      SUP_ID
,      SUP_EMT_ID
,      SUBRO_ID
,      SUB_ID
,      SUB_EMT_ID
,      SUP_LEVEL
,      SUB_LEVEL
,      SUB_ROLLUP_ID
,      SUB_LEAF_FLAG
,      SUB_LEAF_FLAG_ID
,      STATUS_ID
,      STRUCT_EMT_ID
,      RELATIONSHIP_TYPE
FROM PJI.PJI_FP_AGGR_XBS#;

Dependencies

[top of page]

PJI.PJI_FP_AGGR_XBS# references the following:

PJI: PJI_FP_AGGR_XBS

PJI.PJI_FP_AGGR_XBS# is referenced by following:

APPS: PJI_FP_AGGR_XBS