[Home] [Help]
View: MSC_X_COMPANY_SITES_LOV_V
View Text
SELECT CR.SUBJECT_ID
, CR.RELATIONSHIP_TYPE
, CS.COMPANY_SITE_ID
, CS.COMPANY_SITE_NAME
, CS.COMPANY_ID
, CM.COMPANY_NAME
FROM MSC_COMPANY_SITES CS
, MSC_COMPANY_RELATIONSHIPS CR
, MSC_COMPANIES CM
WHERE ((CR.RELATIONSHIP_TYPE = 1) OR (CR.RELATIONSHIP_TYPE = 2))
AND CR.OBJECT_ID = CS.COMPANY_ID
AND CS.COMPANY_ID = CM.COMPANY_ID
Columns
Name |
SUBJECT_ID |
RELATIONSHIP_TYPE |
COMPANY_SITE_ID |
COMPANY_SITE_NAME |
COMPANY_ID |
COMPANY_NAME |