[Home] [Help]
View: PABV_CUSTOMERS
View Text
SELECT PPA.PROJECT_ID
, PPC.CUSTOMER_ID
, '_LA:PROJECT_RELATIONSHIP_CODE:PA_LOOKUPS:CUSTOMER PROJECT RELATIONSHIP:MEANING'
, PPC.CUSTOMER_BILL_SPLIT
, PPC.BILL_TO_ADDRESS_ID
, PPC.SHIP_TO_ADDRESS_ID
, PPC.LAST_UPDATE_DATE
, PPC.LAST_UPDATED_BY
, PPC.CREATION_DATE
, PPC.CREATED_BY
FROM PA_PROJECT_CUSTOMERS PPC
, HZ_CUST_ACCOUNTS HZ_C
, HZ_PARTIES HZ_P
, PA_PROJECTS_ALL PPA
WHERE PPC.PROJECT_ID = PPA.PROJECT_ID
AND HZ_C.CUST_ACCOUNT_ID = PPC.CUSTOMER_ID
AND HZ_C.PARTY_ID = HZ_P.PARTY_ID
AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY
Columns
Name |
PROJECT_ID |
CUSTOMER_ID |
"_LA:PROJECT_CUST_RELATION" |
CUSTOMER_BILL_SPLIT |
BILL_TO_ADDRESS_ID |
SHIP_TO_ADDRESS_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |