[Home] [Help]
View: MSC_X_SUPPLIER_LOV_V
View Text
SELECT SUPPLIER.COMPANY_ID
, SUPPLIER.COMPANY_NAME
, CR.SUBJECT_ID
FROM MSC_COMPANIES SUPPLIER
, MSC_COMPANY_RELATIONSHIPS CR
WHERE CR.RELATIONSHIP_TYPE = 2
AND CR.OBJECT_ID = SUPPLIER.COMPANY_ID GROUP BY SUPPLIER.COMPANY_ID
, SUPPLIER.COMPANY_NAME
, CR.SUBJECT_ID
Columns
Name |
SUPPLIER_ID |
SUPPLIER_NAME |
COMPANY_ID |