[Home] [Help]
View: RLM_CUSTOMERS_V
View Text
SELECT DISTINCT TERMS.CUSTOMER_ID
, TERMS.SHIP_FROM_ORG_ID
, RAC.CUSTOMER_NAME
, RAC.CUSTOMER_NUMBER
, ORG.ORGANIZATION_CODE
, ORG.ORGANIZATION_NAME
, TERMS.ORG_ID
FROM ORG_ORGANIZATION_DEFINITIONS ORG
, RLM_CUST_SHIPTO_TERMS TERMS
, RA_CUSTOMERS RAC
WHERE TERMS.CUSTOMER_ID = RAC.CUSTOMER_ID
AND TERMS.SHIP_FROM_ORG_ID = ORG.ORGANIZATION_ID
Columns
Name |
CUSTOMER_ID |
SHIP_FROM_ORG_ID |
CUSTOMER_NAME |
CUSTOMER_NUMBER |
ORGANIZATION_CODE |
ORGANIZATION_NAME |
ORG_ID |