[Home] [Help]
View: PSBFV_WS_POSITION_LINES
Product: | PSB - Public Sector Budgeting (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT WS.NAME
, '_KF:PSB:BPS:PKFV:_CO'
, WS.WORKSHEET_ID
, WLP.POSITION_LINE_ID
, WPL.POSITION_ID
FROM PSB_WORKSHEETS WS
, PSB_WS_LINES_POSITIONS WLP
, PSB_WS_POSITION_LINES WPL
, PSB_POSITIONS POS
, PSB_POSITION_DEFINITIONS_KFV PKFV
WHERE WLP.WORKSHEET_ID = WS.WORKSHEET_ID
AND WLP.POSITION_LINE_ID = WPL.POSITION_LINE_ID
AND POS.POSITION_ID = WPL.POSITION_ID
AND PKFV.POSITION_DEFINITION_ID = POS.POSITION_DEFINITION_ID WITH READ ONLY
Columns
Name |
WORKSHEET_NAME |
"_KF:POSITION_NAME" |
WORKSHEET_ID |
POSITION_LINE_ID |
POSITION_ID |