FND Design Data [Home] [Help]

View: PA_REP_RES_ORGS_V

Product: PA - Projects
Description: PA_REP_RES_ORGS_V is a view that lists all organizations of the resources for the manager
Implementation/DBA Data: ViewAPPS.PA_REP_RES_ORGS_V
View Text

SELECT MANAGER_ID
, PERSON_ID
, RESOURCE_ORGANIZATION_ID
, PA_EXPENDITURES_UTILS.GETORGTLNAME(RESOURCE_ORGANIZATION_ID)
FROM PA_RESOURCES_DENORM

Columns

Name
MANAGER_ID
RESOURCE_ID
ORGANIZATION_ID
ORGANIZATION_NAME