VIEW: APPS.JAI_CMN_VENDOR_ADDRESS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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