[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 |
APPS.PO_POSITIONS_VAL_V