View: PA_IMP_EXP_HIERARCHY_V

Product:	PA - Projects
Description:	Displays information on Expenditure Owning Hierarchy for the Implementation
Implementation/DBA Data:	APPS.PA_IMP_EXP_HIERARCHY_V

View Text

SELECT IMP.BUSINESS_GROUP_ID
, IMP.ORG_ID
, IMP.EXP_ORG_STRUCTURE_ID
, ORGSTRUCTURE.NAME
, IMP.EXP_ORG_STRUCTURE_VERSION_ID
, IMP.EXP_START_ORG_ID
, ORG.NAME
FROM PA_IMPLEMENTATIONS IMP
, PER_ORGANIZATION_STRUCTURES ORGSTRUCTURE
, HR_ORGANIZATION_UNITS ORG
WHERE IMP.EXP_ORG_STRUCTURE_ID = ORGSTRUCTURE.ORGANIZATION_STRUCTURE_ID
AND IMP.EXP_START_ORG_ID = ORG.ORGANIZATION_ID

Columns