Product: | PSB - Public Sector Budgeting |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PSB_STD_BUDGET_ITEM_LINES_V |
SELECT SBIL.ROWID
, SBIL.STANDARD_BUDGET_ITEM_ID
, SBIL.SET_OF_BOOKS_ID
, SOB.NAME
, SOB.CHART_OF_ACCOUNTS_ID
, SBIL.RATE
, SBIL.CURRENCY
, SBIL.CONCATENATED_SEGMENTS
, SBIL.SEGMENT1
, SBIL.SEGMENT2
, SBIL.SEGMENT3
, SBIL.SEGMENT4
, SBIL.SEGMENT5
, SBIL.SEGMENT6
, SBIL.SEGMENT7
, SBIL.SEGMENT8
, SBIL.SEGMENT9
, SBIL.SEGMENT10
, SBIL.SEGMENT11
, SBIL.SEGMENT12
, SBIL.SEGMENT13
, SBIL.SEGMENT14
, SBIL.SEGMENT15
, SBIL.SEGMENT16
, SBIL.SEGMENT17
, SBIL.SEGMENT18
, SBIL.SEGMENT19
, SBIL.SEGMENT20
, SBIL.SEGMENT21
, SBIL.SEGMENT22
, SBIL.SEGMENT23
, SBIL.SEGMENT24
, SBIL.SEGMENT25
, SBIL.SEGMENT26
, SBIL.SEGMENT27
, SBIL.SEGMENT28
, SBIL.SEGMENT29
, SBIL.SEGMENT30
, SBIL.LAST_UPDATE_DATE
, SBIL.LAST_UPDATED_BY
, SBIL.LAST_UPDATE_LOGIN
, SBIL.CREATION_DATE
, SBIL.CREATED_BY
FROM PSB_STANDARD_BUDGET_ITEM_LINES SBIL
, GL_SETS_OF_BOOKS_11I SOB
WHERE SBIL.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID