DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PQH_PC_ORG_SUMMARY_V

Object Details
Object Name: PQH_PC_ORG_SUMMARY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPQH.PQH_PC_ORG_SUMMARY_V
Subobject Name:
Status: VALID

View Type

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


Position Control Organization summary view for reports


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_NUM NUMBER

Row Indicator
HIERARCHY_LEVEL NUMBER

Level on the hierarchy
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
PC_ENABLED_FLAG VARCHAR2 (4000)
Position Control Enabled Flag
POSITION_NAME VARCHAR2 (4000)
Position Name
POSITION_ID NUMBER (15)
Position Identifier
BUDGET_MEASUREMENT_TYPE VARCHAR2 (4000)
Budget Measurement Type
BUDGET_UNIT_ID NUMBER (15)
Budget Unit Identifier
Query Text

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


SELECT ROW_NUM
,      HIERARCHY_LEVEL
,      BUSINESS_GROUP_NAME
,      BUSINESS_GROUP_ID
,      ORGANIZATION_NAME
,      ORGANIZATION_ID
,      PC_ENABLED_FLAG
,      POSITION_NAME
,      POSITION_ID
,      BUDGET_MEASUREMENT_TYPE
,      BUDGET_UNIT_ID
FROM APPS.PQH_PC_ORG_SUMMARY_V;

Dependencies

[top of page]

APPS.PQH_PC_ORG_SUMMARY_V references the following:

SchemaAPPS
PL/SQL PackageFND_PROFILE - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
ViewPQH_BUDGETS_V
SynonymPQH_BUDGET_DETAILS
SynonymPQH_BUDGET_VERSIONS
ViewPQH_POSN_CTL_HIERARCHY_V
PL/SQL PackagePQH_PSF_BUS - show dependent code
PL/SQL PackagePQH_UTILITY - show dependent code
APPS.PQH_PC_ORG_SUMMARY_V is referenced by following:

SchemaPUBLIC
SynonymPQH_PC_ORG_SUMMARY_V