[Home] [Help]
View: 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
Name |
POSITION_NAME |
ORGANIZATION_NAME |
JOB_NAME |
POSITION_ID |
JOB_ID |
ORGANIZATION_ID |