View: ICX_REQS_LOCATION_LOV

Product:	ICX - Oracle iProcurement
Description:	Web Requisitions Location LOV View
Implementation/DBA Data:	APPS.ICX_REQS_LOCATION_LOV

View Text

SELECT HRL.LOCATION_CODE||' ('||OOD.ORGANIZATION_CODE||')'
, HRL.LOCATION_CODE
, OOD.ORGANIZATION_CODE
FROM HR_LOCATIONS HRL
, ORG_ORGANIZATION_DEFINITIONS OOD
, FINANCIALS_SYSTEM_PARAMETERS FSP
WHERE OOD.ORGANIZATION_ID = NVL(HRL.INVENTORY_ORGANIZATION_ID
, FSP.INVENTORY_ORGANIZATION_ID)
AND SYSDATE < NVL(HRL.INACTIVE_DATE
, SYSDATE + 1)

Columns