View: POR_LOCATION_LOV_V

Product:	ICX - Oracle iProcurement
Description:	List of Values for Locations
Implementation/DBA Data:	APPS.POR_LOCATION_LOV_V

View Text

SELECT HRLT.LOCATION_CODE||' ('||OOD.ORGANIZATION_CODE||')' "LOCATION_DISPLAY"
, HRLT.DESCRIPTION
, HRLT.LOCATION_CODE
, HRL.LOCATION_ID
, OOD.ORGANIZATION_ID "DELIVER_TO_ORG_ID"
FROM HR_LOCATIONS_ALL HRL
, HR_LOCATIONS_ALL_TL HRLT
, ORG_ORGANIZATION_DEFINITIONS OOD
, FINANCIALS_SYSTEM_PARAMETERS FSP
WHERE OOD.ORGANIZATION_ID = NVL(HRL.INVENTORY_ORGANIZATION_ID
, FSP.INVENTORY_ORGANIZATION_ID)
AND OOD.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID
AND SYSDATE < NVL(HRL.INACTIVE_DATE
, SYSDATE + 1)
AND TRUNC(SYSDATE) < NVL(OOD.DISABLE_DATE
, TRUNC(SYSDATE + 1))
AND (FND_PROFILE.VALUE_WNPS('ICX_REQ_OVERRIDE_LOCATION_FLAG') = 'Y')
AND HRL.LOCATION_ID = HRLT.LOCATION_ID
AND HRLT.LANGUAGE = FND_GLOBAL.CURRENT_LANGUAGE
AND NVL(HRL.BUSINESS_GROUP_ID
, NVL(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
, -99)) = NVL(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
, -99) UNION ALL SELECT HRLT.LOCATION_CODE||' ('||OOD.ORGANIZATION_CODE||')' "LOCATION_DISPLAY"
, HRLT.DESCRIPTION
, HRLT.LOCATION_CODE
, HRL.LOCATION_ID
, OOD.ORGANIZATION_ID "DELIVER_TO_ORG_ID"
FROM HR_LOCATIONS_ALL HRL
, HR_LOCATIONS_ALL_TL HRLT
, HR_EMPLOYEES_CURRENT_V HRE
, FND_USER FWU
, ORG_ORGANIZATION_DEFINITIONS OOD
, FINANCIALS_SYSTEM_PARAMETERS FSP
WHERE OOD.ORGANIZATION_ID = NVL(HRL.INVENTORY_ORGANIZATION_ID
, FSP.INVENTORY_ORGANIZATION_ID)
AND OOD.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID
AND SYSDATE < NVL(HRL.INACTIVE_DATE
, SYSDATE + 1)
AND TRUNC(SYSDATE) < NVL(OOD.DISABLE_DATE
, TRUNC(SYSDATE + 1))
AND (FND_PROFILE.VALUE_WNPS('ICX_REQ_OVERRIDE_LOCATION_FLAG') = 'N'
AND FWU.USER_ID= FND_GLOBAL.USER_ID
AND HRE.LOCATION_ID = HRL.LOCATION_ID
AND HRE.EMPLOYEE_ID = FWU.EMPLOYEE_ID)
AND HRL.LOCATION_ID = HRLT.LOCATION_ID
AND HRLT.LANGUAGE = FND_GLOBAL.CURRENT_LANGUAGE
AND NVL(HRL.BUSINESS_GROUP_ID
, NVL(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
, -99)) = NVL(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
, -99)

Columns