VIEW: APPS.JAI_CMN_VENDOR_NAME_V

Source

View Text - Preformatted

SELECT vendor_name vendor, a.vendor_id, 'Vendor' entity_type FROM po_vendors A, (SELECT DISTINCT vendor_id FROM JAI_CMN_VENDOR_SITES ) B WHERE a.vendor_id = B.vendor_id UNION ALL SELECT HOU.name, HOU.organization_id, 'Organization' Entity_type FROM HR_ORGANIZATION_UNITS HOU, HR_ORGANIZATION_INFORMATION HOI1, (SELECT DISTINCT organization_id FROM JAI_CMN_INVENTORY_ORGS) c WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID AND HOI1.ORG_INFORMATION1 = 'INV' AND HOI1.ORG_INFORMATION2 = 'Y' AND (HOI1.ORG_INFORMATION_CONTEXT || '') = 'CLASS' AND HOU.organization_id = c.organization_id

View Text - HTML Formatted

SELECT VENDOR_NAME VENDOR
, A.VENDOR_ID
, 'VENDOR' ENTITY_TYPE
FROM PO_VENDORS A
, (SELECT DISTINCT VENDOR_ID
FROM JAI_CMN_VENDOR_SITES ) B
WHERE A.VENDOR_ID = B.VENDOR_ID UNION ALL SELECT HOU.NAME
, HOU.ORGANIZATION_ID
, 'ORGANIZATION' ENTITY_TYPE
FROM HR_ORGANIZATION_UNITS HOU
, HR_ORGANIZATION_INFORMATION HOI1
, (SELECT DISTINCT ORGANIZATION_ID
FROM JAI_CMN_INVENTORY_ORGS) C
WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
AND HOI1.ORG_INFORMATION1 = 'INV'
AND HOI1.ORG_INFORMATION2 = 'Y'
AND (HOI1.ORG_INFORMATION_CONTEXT || '') = 'CLASS'
AND HOU.ORGANIZATION_ID = C.ORGANIZATION_ID