[Home] [Help]
View: PA_TOP_TASK_CUSTOMERS_LOV_V
View Text
SELECT PPA.PROJECT_ID
, PPA.NAME
, PPA.SEGMENT1
, PPC.CUSTOMER_ID
, HZ_P.PARTY_NAME
, HZ_P.PARTY_NUMBER
FROM PA_PROJECT_CUSTOMERS PPC
, HZ_PARTIES HZ_P
, HZ_CUST_ACCOUNTS HZ_C
, PA_PROJECTS_ALL PPA
WHERE PPC.CUSTOMER_ID = HZ_C.CUST_ACCOUNT_ID
AND HZ_C.PARTY_ID = HZ_P.PARTY_ID
AND PPC.PROJECT_ID = PPA.PROJECT_ID
Columns
Name |
PROJECT_ID |
PROJECT_NAME |
SEGMENT1 |
CUSTOMER_ID |
CUSTOMER_NAME |
CUSTOMER_NUMBER |