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

Object Details

Object Name:	PJI_DIS_ORG_ROHRCHY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PJI.PJI_DIS_ORG_ROHRCHY_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

Organization rollup hierarchy is based on the organization hierarchy folder. This is a 3 level hierarchy. The subro items in this hierarchy represent the intermediate level between Organization and sub-organizations.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SUP_ORGANIZATION_ID	NUMBER			Identifier for supervisor organization.
SUP_ORGANIZATION_NAME	VARCHAR2	(240)	Yes	Supervisor organization name
SUB_ORGANIZATION_ID	NUMBER			Identifier for subordinate organization
SUB_ORGANIZATION_NAME	VARCHAR2	(240)	Yes	Subordinate organization name
SUBRO_ORGANIZATION_ID	NUMBER			Identifier for subordinate rollup organization.
SUBRO_ORGANIZATION_NAME	VARCHAR2	(240)	Yes	Subordinate rollup organization name
SUP_ORGANIZATION_LEVEL	NUMBER			Supervisor organization level
SUB_ORGANIZATION_LEVEL	NUMBER			Subordinate organization level
SUBRO_ORGANIZATION_LEVEL	NUMBER			Subordinate rollup organization level
SUB_RELATIVE_LEVEL	NUMBER			Subordinate relative level
SUBRO_SUP_RELATIVE_LEVEL	NUMBER			Subordinate rollup supervisor relative level
SUBRO_SUB_RELATIVE_LEVEL	NUMBER			Subordinate rollup subordinate relative level

Query Text

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


SELECT SUP_ORGANIZATION_ID
,      SUP_ORGANIZATION_NAME
,      SUB_ORGANIZATION_ID
,      SUB_ORGANIZATION_NAME
,      SUBRO_ORGANIZATION_ID
,      SUBRO_ORGANIZATION_NAME
,      SUP_ORGANIZATION_LEVEL
,      SUB_ORGANIZATION_LEVEL
,      SUBRO_ORGANIZATION_LEVEL
,      SUB_RELATIVE_LEVEL
,      SUBRO_SUP_RELATIVE_LEVEL
,      SUBRO_SUB_RELATIVE_LEVEL
FROM APPS.PJI_DIS_ORG_ROHRCHY_V;

Dependencies

[top of page]

APPS.PJI_DIS_ORG_ROHRCHY_V references the following:

APPS: HR_ALL_ORGANIZATION_UNITS_TL; PJI_ORG_DENORM

APPS.PJI_DIS_ORG_ROHRCHY_V is not referenced by any database object