[Home] [Help]
View: PO_POSITIONS_VAL_V
View Text
SELECT PP.NAME
, POU.NAME
, PJ.NAME
, PP.POSITION_ID
, PJ.JOB_ID
, PP.ORGANIZATION_ID
, PP.BUSINESS_GROUP_ID
FROM PER_JOBS PJ
, PER_ORGANIZATION_UNITS POU
, PER_POSITIONS PP
WHERE PP.JOB_ID = PJ.JOB_ID
AND POU.ORGANIZATION_ID = PP.ORGANIZATION_ID
AND SYSDATE BETWEEN PP.DATE_EFFECTIVE
AND NVL(PP.DATE_END
, SYSDATE+1)
Columns
Name |
POSITION_NAME |
ORGANIZATION_NAME |
JOB_NAME |
POSITION_ID |
JOB_ID |
ORGANIZATION_ID |
BUSINESS_GROUP_ID |