View: MSC_X_COMPANY_SITES_LOV_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.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