VIEW: APPS.PSB_WS_SELECT_POSITIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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