[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 |