VIEW: APPS.PSB_WS_YEAR_POSITIONS_V

Source

View Text - Preformatted

SELECT WA.WORKSHEET_ID , WA.ELEMENT_SET_ID, WA.POSITION_LINE_ID, WA.BUDGET_GROUP_ID , WA.CODE_COMBINATION_ID , WA.SERVICE_PACKAGE_ID , SP.SHORT_NAME , WA.TEMPLATE_ID , WA.CURRENCY_CODE , WA.STAGE_SET_ID, WA.ACCOUNT_TYPE , WA.SALARY_ACCOUNT_LINE, CC.SEGMENT1 , CC.SEGMENT2 , CC.SEGMENT3 , CC.SEGMENT4 , CC.SEGMENT5 , CC.SEGMENT6 , CC.SEGMENT7 , CC.SEGMENT8 , CC.SEGMENT9 , CC.SEGMENT10 , CC.SEGMENT11 , CC.SEGMENT12 , CC.SEGMENT13 , CC.SEGMENT14 , CC.SEGMENT15 , CC.SEGMENT16 , CC.SEGMENT17 , CC.SEGMENT18 , CC.SEGMENT19 , CC.SEGMENT20 , CC.SEGMENT21 , CC.SEGMENT22 , CC.SEGMENT23 , CC.SEGMENT24 , CC.SEGMENT25 , CC.SEGMENT26 , CC.SEGMENT27 , CC.SEGMENT28 , CC.SEGMENT29 , CC.SEGMENT30 FROM PSB_WS_POSITION_ACCOUNTS_V WA, GL_CODE_COMBINATIONS CC, PSB_SERVICE_PACKAGES SP WHERE WA.SERVICE_PACKAGE_ID = SP.SERVICE_PACKAGE_ID AND WA.CODE_COMBINATION_ID = CC.CODE_COMBINATION_ID

View Text - HTML Formatted

SELECT WA.WORKSHEET_ID
, WA.ELEMENT_SET_ID
, WA.POSITION_LINE_ID
, WA.BUDGET_GROUP_ID
, WA.CODE_COMBINATION_ID
, WA.SERVICE_PACKAGE_ID
, SP.SHORT_NAME
, WA.TEMPLATE_ID
, WA.CURRENCY_CODE
, WA.STAGE_SET_ID
, WA.ACCOUNT_TYPE
, WA.SALARY_ACCOUNT_LINE
, CC.SEGMENT1
, CC.SEGMENT2
, CC.SEGMENT3
, CC.SEGMENT4
, CC.SEGMENT5
, CC.SEGMENT6
, CC.SEGMENT7
, CC.SEGMENT8
, CC.SEGMENT9
, CC.SEGMENT10
, CC.SEGMENT11
, CC.SEGMENT12
, CC.SEGMENT13
, CC.SEGMENT14
, CC.SEGMENT15
, CC.SEGMENT16
, CC.SEGMENT17
, CC.SEGMENT18
, CC.SEGMENT19
, CC.SEGMENT20
, CC.SEGMENT21
, CC.SEGMENT22
, CC.SEGMENT23
, CC.SEGMENT24
, CC.SEGMENT25
, CC.SEGMENT26
, CC.SEGMENT27
, CC.SEGMENT28
, CC.SEGMENT29
, CC.SEGMENT30
FROM PSB_WS_POSITION_ACCOUNTS_V WA
, GL_CODE_COMBINATIONS CC
, PSB_SERVICE_PACKAGES SP
WHERE WA.SERVICE_PACKAGE_ID = SP.SERVICE_PACKAGE_ID
AND WA.CODE_COMBINATION_ID = CC.CODE_COMBINATION_ID