Table: PA_ORG_HIERARCHY_DENORM | Oracle EBS ETRM Search

Table: PA_ORG_HIERARCHY_DENORM 12.1.1 standalone

owner PA·PA - Projects·12 columns

Denormalized table holding the relationship between parent and child organizations

PA.PA_ORG_HIERARCHY_DENORM·Explore PA module →

Table: PA_ORG_HIERARCHY_DENORM 12.2.2 standalone

owner PA·PA - Projects·12 columns

Denormalized table holding the relationship between parent and child organizations

PA.PA_ORG_HIERARCHY_DENORM·Explore PA module →

TABLE: PA.PA_ORG_HIERARCHY_DENORM 12.1.1

owner PA

SYNONYM: APPS.PA_ORG_HIERARCHY_DENORM 12.1.1

SYNONYM: APPS.PA_ORG_HIERARCHY_DENORM 12.2.2

TABLE: PA.PA_ORG_HIERARCHY_DENORM 12.2.2

owner PA

APPS.PA_RESOURCE_UTILS dependencies on PA_ORG_HIERARCHY_DENORM 12.1.1

APPS.PA_SUMMARIZE_ORG_ROLLUP_PVT dependencies on PA_ORG_HIERARCHY_DENORM 12.2.2

APPS.PA_RESOURCE_UTILS dependencies on PA_ORG_HIERARCHY_DENORM 12.2.2

APPS.PA_CC_TRANSFER_PRICE dependencies on PA_ORG_HIERARCHY_DENORM 12.2.2

APPS.PA_REP_UTILS_SUMM_PKG dependencies on PA_ORG_HIERARCHY_DENORM 12.1.1

APPS.PA_FI_AMT_CALC_PKG dependencies on PA_ORG_HIERARCHY_DENORM 12.1.1

APPS.PA_COST_RATE_PUB dependencies on PA_ORG_HIERARCHY_DENORM 12.1.1

APPS.PA_CC_TRANSFER_PRICE dependencies on PA_ORG_HIERARCHY_DENORM 12.1.1

APPS.PA_ORG_UTILS dependencies on PA_ORG_HIERARCHY_DENORM 12.2.2

APPS.PA_REP_UTIL_GLOB dependencies on PA_ORG_HIERARCHY_DENORM 12.2.2

APPS.PA_SEARCH_PUB dependencies on PA_ORG_HIERARCHY_DENORM 12.2.2

APPS.PA_REP_UTIL_GLOB dependencies on PA_ORG_HIERARCHY_DENORM 12.1.1

APPS.PA_SEARCH_PUB dependencies on PA_ORG_HIERARCHY_DENORM 12.1.1

APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_ORG_HIERARCHY_DENORM 12.1.1

APPS.PA_REP_UTILS_SUMM_PKG dependencies on PA_ORG_HIERARCHY_DENORM 12.2.2

APPS.PA_FP_ORG_FCST_GEN_PUB dependencies on PA_ORG_HIERARCHY_DENORM 12.2.2

APPS.PA_ORG_UTILS dependencies on PA_ORG_HIERARCHY_DENORM 12.1.1

APPS.PA_FI_AMT_CALC_PKG dependencies on PA_ORG_HIERARCHY_DENORM 12.2.2

APPS.PA_SEARCH_PVT dependencies on PA_ORG_HIERARCHY_DENORM 12.1.1

APPS.PA_ADVERTISEMENTS_PVT dependencies on PA_ORG_HIERARCHY_DENORM 12.1.1

APPS.PA_SUMMARIZE_ORG_ROLLUP_PVT dependencies on PA_ORG_HIERARCHY_DENORM 12.1.1

APPS.PA_COST_RATE_PUB dependencies on PA_ORG_HIERARCHY_DENORM 12.2.2

APPS.PA_ORG_UTILS dependencies on PA_ORG_HIERARCHY_DENORM 12.2.2

APPS.PA_ADVERTISEMENTS_PVT dependencies on PA_ORG_HIERARCHY_DENORM 12.2.2

APPS.PA_SEARCH_PVT dependencies on PA_ORG_HIERARCHY_DENORM 12.2.2

APPS.PA_REP_UTIL_GLOB SQL Statements 12.2.2

APPS.PA_REP_UTIL_GLOB SQL Statements 12.1.1

PACKAGE BODY: APPS.PA_REP_UTIL_GLOB 12.2.2

used by 38

PACKAGE: APPS.PA_REP_UTIL_GLOB 12.2.2

used by 38

PACKAGE BODY: APPS.PA_REP_UTIL_GLOB 12.1.1

used by 38

PACKAGE: APPS.PA_REP_UTIL_GLOB 12.1.1

used by 38

View: PA_EXP_START_ORGS_V 12.2.2

PA - Projects·4 columns

APPS.PA_EXP_START_ORGS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PA_ORG_HIERARCHY_DENORM·↳ PER_ORGANIZATION_STRUCTURES·Explore PA module →

VIEW: PA.PA_ORG_HIERARCHY_DENORM# 12.2.2

owner PA

APPS.PA_ORG_UTILS SQL Statements 12.2.2

View: PA_EXP_ORG_HIERARCHIES_V 12.1.1

PA - Projects·3 columns

APPS.PA_EXP_ORG_HIERARCHIES_V·↳ PA_ORG_HIERARCHY_DENORM·↳ PER_ORGANIZATION_STRUCTURES·↳ PER_ORG_STRUCTURE_VERSIONS·Explore PA module →

View: PA_EXP_ORG_HIERARCHIES_V 12.2.2

PA - Projects·3 columns

APPS.PA_EXP_ORG_HIERARCHIES_V·↳ PA_ORG_HIERARCHY_DENORM·↳ PER_ORGANIZATION_STRUCTURES·↳ PER_ORG_STRUCTURE_VERSIONS·Explore PA module →

View: PA_EXP_START_ORGS_V 12.1.1

PA - Projects·4 columns

APPS.PA_EXP_START_ORGS_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PA_ORG_HIERARCHY_DENORM·↳ PER_ORGANIZATION_STRUCTURES·Explore PA module →

View: PA_REP_FORECAST_ORG_V 12.1.1

PA - Projects·4 columns

PA_REP_FORECAST_ORG_V is a view that lists all child organizations for a given application user who has forecast authority

APPS.PA_REP_FORECAST_ORG_V·↳ FND_GLOBAL·↳ FND_GRANTS·↳ FND_OBJECTS·Explore PA module →

View: PA_RES_EMP_HCOUNT_V 12.2.2

PA - Projects·4 columns

PA_RES_EMP_HCOUNT_V is a view to provide employee headcounts by organization and periods. This information is used by OA Screens

APPS.PA_RES_EMP_HCOUNT_V·↳ PA_LOOKUPS·↳ PA_ORG_HIERARCHY_DENORM·↳ PA_REP_UTIL_GLOB·Explore PA module →

View: PA_REP_COMP_REP_ORG_V 12.2.2

PA - Projects·5 columns

View for reporting organization lov in competence reports

APPS.PA_REP_COMP_REP_ORG_V·↳ PA_EXPENDITURES_UTILS·↳ PA_IMPLEMENTATIONS·↳ PA_ORG_HIERARCHY_DENORM·Explore PA module →

View: PA_REP_COMP_REP_ORG_V 12.1.1

PA - Projects·5 columns

View for reporting organization lov in competence reports

APPS.PA_REP_COMP_REP_ORG_V·↳ PA_EXPENDITURES_UTILS·↳ PA_IMPLEMENTATIONS·↳ PA_ORG_HIERARCHY_DENORM·Explore PA module →

View: PA_RES_EMP_HCOUNT_V 12.1.1

PA - Projects·4 columns

PA_RES_EMP_HCOUNT_V is a view to provide employee headcounts by organization and periods. This information is used by OA Screens

APPS.PA_RES_EMP_HCOUNT_V·↳ PA_LOOKUPS·↳ PA_ORG_HIERARCHY_DENORM·↳ PA_REP_UTIL_GLOB·Explore PA module →

View: PA_REP_FORECAST_ORG_V 12.2.2

PA - Projects·4 columns

PA_REP_FORECAST_ORG_V is a view that lists all child organizations for a given application user who has forecast authority

APPS.PA_REP_FORECAST_ORG_V·↳ FND_GLOBAL·↳ FND_GRANTS·↳ FND_OBJECTS·Explore PA module →

Results for “pa_org_hierarchy_denorm”