[Home] [Help]
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
Name |
ORGANIZATION_ID |
NAME |
ADDRESS_LINE_1 |
ADDRESS_LINE_2 |
ADDRESS_LINE_3 |
TOWN_OR_CITY |
POSTAL_CODE |
COUNTY |
STATE |
COUNTRY |
TELEPHONE_NUMBER_1 |
TELEPHONE_NUMBER_2 |
TELEPHONE_NUMBER_3 |