VIEW: APPS.PSB_STD_BUDGET_ITEM_LINES_V

Source

View Text - Preformatted

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 SOB WHERE SBIL.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID

View Text - HTML Formatted

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 SOB
WHERE SBIL.SET_OF_BOOKS_ID = SOB.SET_OF_BOOKS_ID