VIEW: APPS.PER_POSITION_STRUCTURES_ALL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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