[Home] [Help]
View: OKE_PROJECT_CUSTOMERS_V
View Text
SELECT PC.ROWID
, PC.PROJECT_ID
, PC.CUSTOMER_ID
, C.CUSTOMER_NAME
, C.CUSTOMER_NUMBER
, C.STATUS
, C.PARTY_ID
, PC.PROJECT_RELATIONSHIP_CODE
, CR.PROJECT_RELATIONSHIP_M
, PC.CUSTOMER_BILL_SPLIT
FROM PA_CUSTOMER_RELATIONSHIPS_V CR
, RA_CUSTOMERS C
, PA_PROJECT_CUSTOMERS PC
WHERE PC.CUSTOMER_ID = C.CUSTOMER_ID
AND PC.PROJECT_RELATIONSHIP_CODE = CR.PROJECT_RELATIONSHIP_CODE
Columns
Name |
ROW_ID |
PROJECT_ID |
CUSTOMER_ID |
CUSTOMER_NAME |
CUSTOMER_NUMBER |
CUSTOMER_STATUS |
PARTY_ID |
PROJECT_RELATIONSHIP_CODE |
PROJECT_RELATIONSHIP_M |
CUSTOMER_BILL_SPLIT |