[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: |
APPS.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 |