View: PO_LOCATIONS_VAL_V

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.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