Product: | PO - Purchasing |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.PO_EMPLOYEE_HIERARCHIES |
SELECT EMPLOYEE_ID
, SUPERIOR_ID
, POSITION_STRUCTURE_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, EMPLOYEE_POSITION_ID
, SUPERIOR_POSITION_ID
, SUPERIOR_LEVEL
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
, BUSINESS_GROUP_ID
FROM PO_EMPLOYEE_HIERARCHIES_ALL
WHERE BUSINESS_GROUP_ID IN ( SELECT NVL(FSP.BUSINESS_GROUP_ID
, 0)
FROM FINANCIALS_SYSTEM_PARAMETERS FSP)