VIEW: APPS.POR_LOCATION_LOV_V

Source

View Text - Preformatted

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('POR_OVERRIDE_LOCATION') = '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('POR_OVERRIDE_LOCATION') = '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)

View Text - HTML Formatted

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('POR_OVERRIDE_LOCATION') = '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('POR_OVERRIDE_LOCATION') = '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)