DBA Data[Home] [Help]

VIEW: APPS.PSBBV_WS_POSITION_LINES

Source

View Text - Preformatted

SELECT WS.WORKSHEET_ID, WLP.POSITION_LINE_ID, WPL.POSITION_ID from PSB_WORKSHEETS WS, PSB_WS_LINES_POSITIONS WLP, PSB_WS_POSITION_LINES WPL where WLP.Worksheet_ID = WS.Worksheet_ID and WLP.Position_Line_ID = WPL.Position_Line_ID with read only
View Text - HTML Formatted

SELECT WS.WORKSHEET_ID
, WLP.POSITION_LINE_ID
, WPL.POSITION_ID
FROM PSB_WORKSHEETS WS
, PSB_WS_LINES_POSITIONS WLP
, PSB_WS_POSITION_LINES WPL
WHERE WLP.WORKSHEET_ID = WS.WORKSHEET_ID
AND WLP.POSITION_LINE_ID = WPL.POSITION_LINE_ID WITH READ ONLY