eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.ICX_REQS_LOCATION_V

Source

View Text - Preformatted


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)

View Text - HTML Formatted

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)