View: PER_POSITION_STRUCTURES_ALL_V

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

View Text

SELECT DISTINCT PP.NAME POSITION_NAME
, POU.NAME ORGANIZATION_NAME
, PJ.NAME JOB_NAME
, PP.POSITION_ID
, PJ.JOB_ID
, PP.ORGANIZATION_ID
FROM PER_JOBS PJ
, PER_ORGANIZATION_UNITS POU
, PER_POSITIONS PP
, FINANCIALS_SYSTEM_PARAMETERS FSP
WHERE PP.JOB_ID = PJ.JOB_ID
AND PP.BUSINESS_GROUP_ID = FSP.BUSINESS_GROUP_ID
AND POU.ORGANIZATION_ID = PP.ORGANIZATION_ID

Columns