VIEW: APPS.MSC_X_COMPANY_SITES_LOV_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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