[Home] [Help]
View: PSB_WS_SELECT_POSITIONS_V
View Text
SELECT DISTINCT WS.WORKSHEET_ID
, PSB_POSITIONS_PVT.GET_EMPLOYEE_NUMBER(WS.DATA_EXTRACT_ID
, WS.WORKSHEET_ID
, POS.POSITION_ID) EMPLOYEE_NUMBER
, PSB_POSITIONS_PVT.GET_EMPLOYEE_NAME(WS.DATA_EXTRACT_ID
, WS.WORKSHEET_ID
, POS.POSITION_ID) EMPLOYEE_NAME
, PSB_POSITIONS_PVT.GET_JOB_NAME(WS.DATA_EXTRACT_ID
, WS.WORKSHEET_ID
, POS.POSITION_ID) JOB_NAME
, WLP.POSITION_LINE_ID
, POS.POSITION_ID
, POS.NAME
, POS.POSITION_DEFINITION_ID
, NVL(POS.NEW_POSITION_FLAG
, 'N')
, POS.NAME
, POS.ORGANIZATION_ID
, POS.DATA_EXTRACT_ID
FROM PSB_WORKSHEETS WS
, PSB_WS_LINES_POSITIONS WLP
, PSB_WS_POSITION_LINES WPL
, PSB_POSITIONS POS
WHERE WLP.WORKSHEET_ID = WS.WORKSHEET_ID
AND WPL.POSITION_LINE_ID = WLP.POSITION_LINE_ID
AND POS.DATA_EXTRACT_ID = WS.DATA_EXTRACT_ID
AND POS.POSITION_ID = WPL.POSITION_ID
Columns
Name |
WORKSHEET_ID |
EMPLOYEE_NUMBER |
EMPLOYEE_NAME |
JOB_NAME |
POSITION_LINE_ID |
POSITION_ID |
POSITION_NAME |
POSITION_DEFINITION_ID |
NEW_POSITION_FLAG |
POSITION_SEGMENTS |
ORGANIZATION_ID |
DATA_EXTRACT_ID |