[Home] [Help]
View: PO_LOCATIONS_VAL_V
View Text
SELECT LOCATION_CODE
, LOCATION_ID
, DESCRIPTION
, IN_ORGANIZATION_FLAG
, SHIP_TO_SITE_FLAG
, BILL_TO_SITE_FLAG
, RECEIVING_SITE_FLAG
, OFFICE_SITE_FLAG
, SHIP_TO_LOCATION_ID
, INVENTORY_ORGANIZATION_ID
, TAX_NAME
, DESIGNATED_RECEIVER_ID
, ADDRESS_LINE_1
, ADDRESS_LINE_2
, ADDRESS_LINE_3
, POSTAL_CODE
, REGION_1
, REGION_2
, REGION_3
, TOWN_OR_CITY
, COUNTRY
, TELEPHONE_NUMBER_1
, TELEPHONE_NUMBER_2
, TELEPHONE_NUMBER_3
FROM HR_LOCATIONS
WHERE SYSDATE < NVL(INACTIVE_DATE
, SYSDATE+1)
Columns
Name |
LOCATION_CODE |
LOCATION_ID |
DESCRIPTION |
IN_ORGANIZATION_FLAG |
SHIP_TO_SITE_FLAG |
BILL_TO_SITE_FLAG |
RECEIVING_SITE_FLAG |
OFFICE_SITE_FLAG |
SHIP_TO_LOCATION_ID |
INVENTORY_ORGANIZATION_ID |
TAX_NAME |
DESIGNATED_RECEIVER_ID |
ADDRESS_LINE_1 |
ADDRESS_LINE_2 |
ADDRESS_LINE_3 |
POSTAL_CODE |
REGION_1 |
REGION_2 |
REGION_3 |
TOWN_OR_CITY |
COUNTRY |
TELEPHONE_NUMBER_1 |
TELEPHONE_NUMBER_2 |
TELEPHONE_NUMBER_3 |