View: HR_BILLING_LOCATIONS_PO_V

Product:	PER - Human Resources
Description:	Used to support user interface
Implementation/DBA Data:	APPS.HR_BILLING_LOCATIONS_PO_V

View Text

SELECT HRL.LOCATION_CODE
, HRL.DESCRIPTION
, HRL.ADDRESS_LINE_1 ADDRESS
, HRL.TOWN_OR_CITY
, DECODE(HRL.STYLE
, 'US'
, HRL.REGION_2
, HRL.REGION_1) STATE
, HRL.LOCATION_ID
FROM HR_LOCATIONS HRL
WHERE SYSDATE < NVL(HRL.INACTIVE_DATE
, SYSDATE + 1)
AND HRL.BILL_TO_SITE_FLAG = 'Y'

Columns