VIEW: APPS.MSC_X_SUPPLIER_LOV_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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