VIEW: APPS.POR_REQUESTER_LOV_V

Source

View Text - Preformatted

SELECT FWU.USER_ID , HRE.FULL_NAME , HRE.EMAIL_ADDRESS , HRE.EMPLOYEE_NUM , HRE.EMPLOYEE_ID , HRE.DEFAULT_CODE_COMBINATION_ID , HRE.LOCATION_ID , NULL, HRE.ORGANIZATION_ID , HRE.BUSINESS_GROUP_ID , HRE.EXPENSE_CHECK_ADDRESS_FLAG , FSP.INVENTORY_ORGANIZATION_ID "DELIVER_TO_ORG_ID" FROM HR_EMPLOYEES_CURRENT_V HRE, FND_USER FWU, HR_EMPLOYEES_CURRENT_V HRE2, FINANCIALS_SYSTEM_PARAMETERS FSP WHERE HRE2.EMPLOYEE_ID = FWU.EMPLOYEE_ID AND FWU.USER_ID= FND_GLOBAL.USER_ID AND HRE.LOCATION_ID IS NULL AND (FND_PROFILE.VALUE_WNPS('POR_OVERRIDE_REQUESTER') = 'NO' AND HRE.EMPLOYEE_ID = FWU.EMPLOYEE_ID) union all SELECT FWU.USER_ID , HRE.FULL_NAME , HRE.EMAIL_ADDRESS , HRE.EMPLOYEE_NUM , HRE.EMPLOYEE_ID , HRE.DEFAULT_CODE_COMBINATION_ID , HRE.LOCATION_ID , NULL, HRE.ORGANIZATION_ID , HRE.BUSINESS_GROUP_ID , HRE.EXPENSE_CHECK_ADDRESS_FLAG , FSP.INVENTORY_ORGANIZATION_ID "DELIVER_TO_ORG_ID" FROM HR_EMPLOYEES_CURRENT_V HRE, FND_USER FWU, HR_EMPLOYEES_CURRENT_V HRE2, FINANCIALS_SYSTEM_PARAMETERS FSP WHERE HRE2.EMPLOYEE_ID = FWU.EMPLOYEE_ID AND FWU.USER_ID= FND_GLOBAL.USER_ID AND HRE.LOCATION_ID IS NULL AND (FND_PROFILE.VALUE_WNPS('POR_OVERRIDE_REQUESTER') = 'ORG' AND HRE2.ORGANIZATION_ID = HRE.ORGANIZATION_ID) union all SELECT FWU.USER_ID , HRE.FULL_NAME , HRE.EMAIL_ADDRESS , HRE.EMPLOYEE_NUM , HRE.EMPLOYEE_ID , HRE.DEFAULT_CODE_COMBINATION_ID , HRE.LOCATION_ID , NULL, HRE.ORGANIZATION_ID , HRE.BUSINESS_GROUP_ID , HRE.EXPENSE_CHECK_ADDRESS_FLAG , FSP.INVENTORY_ORGANIZATION_ID "DELIVER_TO_ORG_ID" FROM HR_EMPLOYEES_CURRENT_V HRE, FND_USER FWU, HR_EMPLOYEES_CURRENT_V HRE2, FINANCIALS_SYSTEM_PARAMETERS FSP WHERE HRE2.EMPLOYEE_ID = FWU.EMPLOYEE_ID AND FWU.USER_ID= FND_GLOBAL.USER_ID AND HRE.LOCATION_ID IS NULL AND (FND_PROFILE.VALUE_WNPS('POR_OVERRIDE_REQUESTER') = 'ALL') union all SELECT FWU.USER_ID , HRE.FULL_NAME , HRE.EMAIL_ADDRESS , HRE.EMPLOYEE_NUM , HRE.EMPLOYEE_ID , HRE.DEFAULT_CODE_COMBINATION_ID , HRE.LOCATION_ID , HRLT.LOCATION_CODE , HRE.ORGANIZATION_ID , HRE.BUSINESS_GROUP_ID , HRE.EXPENSE_CHECK_ADDRESS_FLAG , NVL(HRL.INVENTORY_ORGANIZATION_ID,FSP.INVENTORY_ORGANIZATION_ID) "DELIVER_TO_ORG_ID" FROM HR_EMPLOYEES_CURRENT_V HRE, HR_LOCATIONS_ALL HRL, HR_LOCATIONS_ALL_TL HRLT, HR_EMPLOYEES_CURRENT_V HRE2, FND_USER FWU, FINANCIALS_SYSTEM_PARAMETERS FSP WHERE HRE2.EMPLOYEE_ID = FWU.EMPLOYEE_ID AND HRE.LOCATION_ID = HRL.LOCATION_ID AND HRE.LOCATION_ID IS NOT NULL AND FWU.USER_ID= FND_GLOBAL.USER_ID AND (FND_PROFILE.VALUE_WNPS('POR_OVERRIDE_REQUESTER') = 'NO' AND HRE.EMPLOYEE_ID = FWU.EMPLOYEE_ID) AND HRL.LOCATION_ID = HRLT.LOCATION_ID AND HRLT.LANGUAGE = FND_GLOBAL.CURRENT_LANGUAGE union all SELECT FWU.USER_ID , HRE.FULL_NAME , HRE.EMAIL_ADDRESS , HRE.EMPLOYEE_NUM , HRE.EMPLOYEE_ID , HRE.DEFAULT_CODE_COMBINATION_ID , HRE.LOCATION_ID , HRLT.LOCATION_CODE , HRE.ORGANIZATION_ID , HRE.BUSINESS_GROUP_ID , HRE.EXPENSE_CHECK_ADDRESS_FLAG , NVL(HRL.INVENTORY_ORGANIZATION_ID,FSP.INVENTORY_ORGANIZATION_ID) "DELIVER_TO_ORG_ID" FROM HR_EMPLOYEES_CURRENT_V HRE, HR_LOCATIONS_ALL HRL, HR_LOCATIONS_ALL_TL HRLT, HR_EMPLOYEES_CURRENT_V HRE2, FND_USER FWU, FINANCIALS_SYSTEM_PARAMETERS FSP WHERE HRE2.EMPLOYEE_ID = FWU.EMPLOYEE_ID AND HRE.LOCATION_ID = HRL.LOCATION_ID AND HRE.LOCATION_ID IS NOT NULL AND FWU.USER_ID= FND_GLOBAL.USER_ID AND (FND_PROFILE.VALUE_WNPS('POR_OVERRIDE_REQUESTER')= 'ORG' AND HRE2.ORGANIZATION_ID = HRE.ORGANIZATION_ID) AND HRL.LOCATION_ID = HRLT.LOCATION_ID AND HRLT.LANGUAGE = FND_GLOBAL.CURRENT_LANGUAGE union all SELECT FWU.USER_ID , HRE.FULL_NAME , HRE.EMAIL_ADDRESS , HRE.EMPLOYEE_NUM , HRE.EMPLOYEE_ID , HRE.DEFAULT_CODE_COMBINATION_ID , HRE.LOCATION_ID , HRLT.LOCATION_CODE , HRE.ORGANIZATION_ID , HRE.BUSINESS_GROUP_ID , HRE.EXPENSE_CHECK_ADDRESS_FLAG , NVL(HRL.INVENTORY_ORGANIZATION_ID,FSP.INVENTORY_ORGANIZATION_ID) "DELIVER_TO_ORG_ID" FROM HR_EMPLOYEES_CURRENT_V HRE, HR_LOCATIONS_ALL HRL, HR_LOCATIONS_ALL_TL HRLT, HR_EMPLOYEES_CURRENT_V HRE2, FND_USER FWU, FINANCIALS_SYSTEM_PARAMETERS FSP WHERE HRE2.EMPLOYEE_ID = FWU.EMPLOYEE_ID AND HRE.LOCATION_ID = HRL.LOCATION_ID AND HRE.LOCATION_ID IS NOT NULL AND FWU.USER_ID= FND_GLOBAL.USER_ID AND (FND_PROFILE.VALUE_WNPS('POR_OVERRIDE_REQUESTER') = 'ALL') AND HRL.LOCATION_ID = HRLT.LOCATION_ID AND HRLT.LANGUAGE = FND_GLOBAL.CURRENT_LANGUAGE

View Text - HTML Formatted

SELECT FWU.USER_ID
, HRE.FULL_NAME
, HRE.EMAIL_ADDRESS
, HRE.EMPLOYEE_NUM
, HRE.EMPLOYEE_ID
, HRE.DEFAULT_CODE_COMBINATION_ID
, HRE.LOCATION_ID
, NULL
, HRE.ORGANIZATION_ID
, HRE.BUSINESS_GROUP_ID
, HRE.EXPENSE_CHECK_ADDRESS_FLAG
, FSP.INVENTORY_ORGANIZATION_ID "DELIVER_TO_ORG_ID"
FROM HR_EMPLOYEES_CURRENT_V HRE
, FND_USER FWU
, HR_EMPLOYEES_CURRENT_V HRE2
, FINANCIALS_SYSTEM_PARAMETERS FSP
WHERE HRE2.EMPLOYEE_ID = FWU.EMPLOYEE_ID
AND FWU.USER_ID= FND_GLOBAL.USER_ID
AND HRE.LOCATION_ID IS NULL
AND (FND_PROFILE.VALUE_WNPS('POR_OVERRIDE_REQUESTER') = 'NO'
AND HRE.EMPLOYEE_ID = FWU.EMPLOYEE_ID) UNION ALL SELECT FWU.USER_ID
, HRE.FULL_NAME
, HRE.EMAIL_ADDRESS
, HRE.EMPLOYEE_NUM
, HRE.EMPLOYEE_ID
, HRE.DEFAULT_CODE_COMBINATION_ID
, HRE.LOCATION_ID
, NULL
, HRE.ORGANIZATION_ID
, HRE.BUSINESS_GROUP_ID
, HRE.EXPENSE_CHECK_ADDRESS_FLAG
, FSP.INVENTORY_ORGANIZATION_ID "DELIVER_TO_ORG_ID"
FROM HR_EMPLOYEES_CURRENT_V HRE
, FND_USER FWU
, HR_EMPLOYEES_CURRENT_V HRE2
, FINANCIALS_SYSTEM_PARAMETERS FSP
WHERE HRE2.EMPLOYEE_ID = FWU.EMPLOYEE_ID
AND FWU.USER_ID= FND_GLOBAL.USER_ID
AND HRE.LOCATION_ID IS NULL
AND (FND_PROFILE.VALUE_WNPS('POR_OVERRIDE_REQUESTER') = 'ORG'
AND HRE2.ORGANIZATION_ID = HRE.ORGANIZATION_ID) UNION ALL SELECT FWU.USER_ID
, HRE.FULL_NAME
, HRE.EMAIL_ADDRESS
, HRE.EMPLOYEE_NUM
, HRE.EMPLOYEE_ID
, HRE.DEFAULT_CODE_COMBINATION_ID
, HRE.LOCATION_ID
, NULL
, HRE.ORGANIZATION_ID
, HRE.BUSINESS_GROUP_ID
, HRE.EXPENSE_CHECK_ADDRESS_FLAG
, FSP.INVENTORY_ORGANIZATION_ID "DELIVER_TO_ORG_ID"
FROM HR_EMPLOYEES_CURRENT_V HRE
, FND_USER FWU
, HR_EMPLOYEES_CURRENT_V HRE2
, FINANCIALS_SYSTEM_PARAMETERS FSP
WHERE HRE2.EMPLOYEE_ID = FWU.EMPLOYEE_ID
AND FWU.USER_ID= FND_GLOBAL.USER_ID
AND HRE.LOCATION_ID IS NULL
AND (FND_PROFILE.VALUE_WNPS('POR_OVERRIDE_REQUESTER') = 'ALL') UNION ALL SELECT FWU.USER_ID
, HRE.FULL_NAME
, HRE.EMAIL_ADDRESS
, HRE.EMPLOYEE_NUM
, HRE.EMPLOYEE_ID
, HRE.DEFAULT_CODE_COMBINATION_ID
, HRE.LOCATION_ID
, HRLT.LOCATION_CODE
, HRE.ORGANIZATION_ID
, HRE.BUSINESS_GROUP_ID
, HRE.EXPENSE_CHECK_ADDRESS_FLAG
, NVL(HRL.INVENTORY_ORGANIZATION_ID
, FSP.INVENTORY_ORGANIZATION_ID) "DELIVER_TO_ORG_ID"
FROM HR_EMPLOYEES_CURRENT_V HRE
, HR_LOCATIONS_ALL HRL
, HR_LOCATIONS_ALL_TL HRLT
, HR_EMPLOYEES_CURRENT_V HRE2
, FND_USER FWU
, FINANCIALS_SYSTEM_PARAMETERS FSP
WHERE HRE2.EMPLOYEE_ID = FWU.EMPLOYEE_ID
AND HRE.LOCATION_ID = HRL.LOCATION_ID
AND HRE.LOCATION_ID IS NOT NULL
AND FWU.USER_ID= FND_GLOBAL.USER_ID
AND (FND_PROFILE.VALUE_WNPS('POR_OVERRIDE_REQUESTER') = 'NO'
AND HRE.EMPLOYEE_ID = FWU.EMPLOYEE_ID)
AND HRL.LOCATION_ID = HRLT.LOCATION_ID
AND HRLT.LANGUAGE = FND_GLOBAL.CURRENT_LANGUAGE UNION ALL SELECT FWU.USER_ID
, HRE.FULL_NAME
, HRE.EMAIL_ADDRESS
, HRE.EMPLOYEE_NUM
, HRE.EMPLOYEE_ID
, HRE.DEFAULT_CODE_COMBINATION_ID
, HRE.LOCATION_ID
, HRLT.LOCATION_CODE
, HRE.ORGANIZATION_ID
, HRE.BUSINESS_GROUP_ID
, HRE.EXPENSE_CHECK_ADDRESS_FLAG
, NVL(HRL.INVENTORY_ORGANIZATION_ID
, FSP.INVENTORY_ORGANIZATION_ID) "DELIVER_TO_ORG_ID"
FROM HR_EMPLOYEES_CURRENT_V HRE
, HR_LOCATIONS_ALL HRL
, HR_LOCATIONS_ALL_TL HRLT
, HR_EMPLOYEES_CURRENT_V HRE2
, FND_USER FWU
, FINANCIALS_SYSTEM_PARAMETERS FSP
WHERE HRE2.EMPLOYEE_ID = FWU.EMPLOYEE_ID
AND HRE.LOCATION_ID = HRL.LOCATION_ID
AND HRE.LOCATION_ID IS NOT NULL
AND FWU.USER_ID= FND_GLOBAL.USER_ID
AND (FND_PROFILE.VALUE_WNPS('POR_OVERRIDE_REQUESTER')= 'ORG'
AND HRE2.ORGANIZATION_ID = HRE.ORGANIZATION_ID)
AND HRL.LOCATION_ID = HRLT.LOCATION_ID
AND HRLT.LANGUAGE = FND_GLOBAL.CURRENT_LANGUAGE UNION ALL SELECT FWU.USER_ID
, HRE.FULL_NAME
, HRE.EMAIL_ADDRESS
, HRE.EMPLOYEE_NUM
, HRE.EMPLOYEE_ID
, HRE.DEFAULT_CODE_COMBINATION_ID
, HRE.LOCATION_ID
, HRLT.LOCATION_CODE
, HRE.ORGANIZATION_ID
, HRE.BUSINESS_GROUP_ID
, HRE.EXPENSE_CHECK_ADDRESS_FLAG
, NVL(HRL.INVENTORY_ORGANIZATION_ID
, FSP.INVENTORY_ORGANIZATION_ID) "DELIVER_TO_ORG_ID"
FROM HR_EMPLOYEES_CURRENT_V HRE
, HR_LOCATIONS_ALL HRL
, HR_LOCATIONS_ALL_TL HRLT
, HR_EMPLOYEES_CURRENT_V HRE2
, FND_USER FWU
, FINANCIALS_SYSTEM_PARAMETERS FSP
WHERE HRE2.EMPLOYEE_ID = FWU.EMPLOYEE_ID
AND HRE.LOCATION_ID = HRL.LOCATION_ID
AND HRE.LOCATION_ID IS NOT NULL
AND FWU.USER_ID= FND_GLOBAL.USER_ID
AND (FND_PROFILE.VALUE_WNPS('POR_OVERRIDE_REQUESTER') = 'ALL')
AND HRL.LOCATION_ID = HRLT.LOCATION_ID
AND HRLT.LANGUAGE = FND_GLOBAL.CURRENT_LANGUAGE