[Home] [Help]
View: MSC_X_CUSTOMER_LOV_V
View Text
SELECT CUST.COMPANY_ID
, CUST.COMPANY_NAME
, CR.SUBJECT_ID
FROM MSC_COMPANIES CUST
, MSC_COMPANY_RELATIONSHIPS CR
WHERE CR.RELATIONSHIP_TYPE = 1
AND CR.OBJECT_ID = CUST.COMPANY_ID GROUP BY CUST.COMPANY_ID
, CUST.COMPANY_NAME
, CR.SUBJECT_ID
Columns
Name |
CUSTOMER_ID |
CUSTOMER_NAME |
COMPANY_ID |