[Home] [Help]
View: PA_PROJECT_PARTIES_ALL_V
Product: | PA - Projects |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT DISTINCT PARTY_ID
, PARTY_NAME
, PROJECT_ID
, RESOURCE_SOURCE_ID
FROM PA_PROJECT_PARTIES_V
, HZ_PARTIES
WHERE HZ_PARTIES.ORIG_SYSTEM_REFERENCE = 'PER:'|| RESOURCE_SOURCE_ID
Columns
Name |
PARTY_ID |
PARTY_NAME |
PROJECT_ID |
RESOURCE_SOURCE_ID |