View: JAI_CMN_VENDOR_NAME_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_CMN_VENDOR_NAME_V

View Text

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

Columns