View: ICX_REQS_LOCATION_V

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

View Text

SELECT DISTINCT HRL.LOCATION_CODE
, HRL.LOCATION_ID
, OOD.ORGANIZATION_ID
, OOD.ORGANIZATION_CODE
, HRL.ADDRESS_LINE_1
, HRL.ADDRESS_LINE_2
, HRL.ADDRESS_LINE_3
, HRL.REGION_1
, HRL.REGION_2
, HRL.REGION_3
, HRL.TOWN_OR_CITY
, HRL.COUNTRY
, HRL.DESCRIPTION
, HRL.POSTAL_CODE
, HRL.TELEPHONE_NUMBER_1
, HRL.TELEPHONE_NUMBER_2
, HRL.TELEPHONE_NUMBER_3
FROM HR_LOCATIONS HRL
, ORG_ORGANIZATION_DEFINITIONS OOD
, FINANCIALS_SYSTEM_PARAMETERS FSP
, GL_SETS_OF_BOOKS SOB
WHERE SOB.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID
AND OOD.ORGANIZATION_ID = NVL(HRL.INVENTORY_ORGANIZATION_ID
, FSP.INVENTORY_ORGANIZATION_ID)
AND SYSDATE < NVL(HRL.INACTIVE_DATE
, SYSDATE + 1) -- THIS LINE IS TO DETERMINE IF THE ICX: OVERRIDE LOCATION FLAG IS TRUE
AND (FND_PROFILE.VALUE_WNPS('ICX_REQ_OVERRIDE_LOCATION_FLAG') = 'Y') UNION SELECT DISTINCT HRL.LOCATION_CODE
, HRL.LOCATION_ID
, OOD.ORGANIZATION_ID
, OOD.ORGANIZATION_CODE
, HRL.ADDRESS_LINE_1
, HRL.ADDRESS_LINE_2
, HRL.ADDRESS_LINE_3
, HRL.REGION_1
, HRL.REGION_2
, HRL.REGION_3
, HRL.TOWN_OR_CITY
, HRL.COUNTRY
, HRL.DESCRIPTION
, HRL.POSTAL_CODE
, HRL.TELEPHONE_NUMBER_1
, HRL.TELEPHONE_NUMBER_2
, HRL.TELEPHONE_NUMBER_3
FROM HR_LOCATIONS HRL
, GL_SETS_OF_BOOKS SOB
, ORG_ORGANIZATION_DEFINITIONS OOD
, FINANCIALS_SYSTEM_PARAMETERS FSP
, HR_EMPLOYEES_CURRENT_V HEC
, FND_USER FU
WHERE FU.USER_ID = FND_PROFILE.VALUE_WNPS('USER_ID')
AND HEC.EMPLOYEE_ID = FU.EMPLOYEE_ID
AND HRL.LOCATION_ID = HEC.LOCATION_ID
AND SYSDATE < NVL(HRL.INACTIVE_DATE
, SYSDATE + 1)
AND SOB.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID
AND OOD.ORGANIZATION_ID = NVL(HRL.INVENTORY_ORGANIZATION_ID
, FSP.INVENTORY_ORGANIZATION_ID)

Columns