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

Object Details

Object Name:	PQH_PC_ORG_HIERARCHIES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PQH.PQH_PC_ORG_HIERARCHIES_V
Subobject Name:
Status:	VALID

View Type

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

Position Control Organization Hierarchy view for reports

[View Source]

Columns

Name	Datatype	Length	Comments
ROW_NUMBER	NUMBER		Row Number
ORGANIZATION_HIERARCHY_LEVEL	NUMBER		Hierarchy Level
BUSINESS_GROUP_NAME	VARCHAR2	(4000)	Business Group Name
BUSINESS_GROUP_ID	NUMBER	(15)	Business Group Identifier
ORGANIZATION_NAME	VARCHAR2	(4000)	Organization Name
ORGANIZATION_ID	NUMBER	(15)	Organization Identifier
POSITION_CONTROL_ENABLED_FLAG	VARCHAR2	(4000)	Position Control Enable Indicator

Query Text

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


SELECT ROW_NUMBER
,      ORGANIZATION_HIERARCHY_LEVEL
,      BUSINESS_GROUP_NAME
,      BUSINESS_GROUP_ID
,      ORGANIZATION_NAME
,      ORGANIZATION_ID
,      POSITION_CONTROL_ENABLED_FLAG
FROM APPS.PQH_PC_ORG_HIERARCHIES_V;

Dependencies

[top of page]

APPS.PQH_PC_ORG_HIERARCHIES_V references the following:

APPS: FND_SESSIONS; HR_GENERAL - show dependent code; PER_ORGANIZATION_STRUCTURES; PER_ORG_STRUCTURE_ELEMENTS; PER_ORG_STRUCTURE_VERSIONS; PQH_PSF_BUS - show dependent code

APPS.PQH_PC_ORG_HIERARCHIES_V is referenced by following:

PUBLIC: PQH_PC_ORG_HIERARCHIES_V