View: OE_PRINT_INTERNAL_ORG_V

Product:	ONT - Order Management
Description:	This view is used to print the Name and Address of the vendor
Implementation/DBA Data:	APPS.OE_PRINT_INTERNAL_ORG_V

View Text

SELECT HRAOU.ORGANIZATION_ID
, HRAOU.NAME
, HRLA.ADDRESS_LINE_1
, HRLA.ADDRESS_LINE_2
, HRLA.ADDRESS_LINE_3
, HRLA.TOWN_OR_CITY
, HRLA.POSTAL_CODE
, HRLA.REGION_1 COUNTY
, HRLA.REGION_2 STATE
, HRLA.COUNTRY
, HRLA.TELEPHONE_NUMBER_1
, HRLA.TELEPHONE_NUMBER_2
, HRLA.TELEPHONE_NUMBER_3
FROM HR_ALL_ORGANIZATION_UNITS HRAOU
, HR_LOCATIONS_ALL HRLA
WHERE HRAOU.LOCATION_ID = HRLA.LOCATION_ID

Columns