View: PO_EMPLOYEE_HIERARCHIES

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PO_EMPLOYEE_HIERARCHIES

View Text

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)

Columns