View: JAI_CMN_VENDOR_ADDRESS_V

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

View Text

SELECT A.VENDOR_SITE_ID ID
, A.VENDOR_SITE_CODE CODE
, A.ADDRESS_LINE1 ADDRESS1
, A.ADDRESS_LINE2 ADDRESS2
, A.ADDRESS_LINE3 ADDRESS3
, A1.VENDOR_ID
, 'VENDOR' TYPE
FROM PO_VENDOR_SITES_ALL A
, JAI_CMN_VENDOR_SITES A1
WHERE A.VENDOR_SITE_ID = A1.VENDOR_SITE_ID UNION ALL SELECT B.LOCATION_ID ID
, B.LOCATION_CODE CODE
, B.ADDRESS_LINE_1 ADDRESS1
, B.ADDRESS_LINE_2 ADDRESS2
, B.ADDRESS_LINE_3 ADDRESS3
, B1.ORGANIZATION_ID
, 'ORGANIZATION' TYPE
FROM HR_LOCATIONS B
, JAI_CMN_INVENTORY_ORGS B1
WHERE B.LOCATION_ID = B1.LOCATION_ID

Columns