View: PA_REP_MGR_ORG_V

Product:	PA - Projects
Description:	PA_REP_MGR_ORG_V is a view that lists all managers for the given organization
Implementation/DBA Data:	APPS.PA_REP_MGR_ORG_V

View Text

SELECT MAN_ORG.MANAGER_ID
, MAN_ORG.MANAGER_NAME
, MAN_RES_ORG.RESOURCE_ORGANIZATION_ID
, PA_EXPENDITURES_UTILS.GETORGTLNAME(MAN_RES_ORG.RESOURCE_ORGANIZATION_ID)
FROM PA_RESOURCES_DENORM MAN_ORG
, PA_RESOURCES_DENORM MAN_RES_ORG
WHERE MAN_ORG.MANAGER_ID = MAN_RES_ORG.PERSON_ID

Columns