VIEW: GL.GL_ALLOC_FORMULA_LINES#

Source

View Text - Preformatted

select ALLOCATION_FORMULA_ID ALLOCATION_FORMULA_ID, LINE_NUMBER LINE_NUMBER, LINE_TYPE LINE_TYPE, OPERATOR OPERATOR, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, AMOUNT AMOUNT, RELATIVE_PERIOD RELATIVE_PERIOD, PERIOD_NAME PERIOD_NAME, CURRENCY_CODE CURRENCY_CODE, TRANSACTION_CURRENCY_11I TRANSACTION_CURRENCY_11I, ACTUAL_FLAG ACTUAL_FLAG, BUDGET_VERSION_ID BUDGET_VERSION_ID, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID, AMOUNT_TYPE AMOUNT_TYPE, SEGMENT_TYPES_KEY SEGMENT_TYPES_KEY, SEGMENT_BREAK_KEY SEGMENT_BREAK_KEY, SEGMENT1 SEGMENT1, SEGMENT2 SEGMENT2, SEGMENT3 SEGMENT3, SEGMENT4 SEGMENT4, SEGMENT5 SEGMENT5, SEGMENT6 SEGMENT6, SEGMENT7 SEGMENT7, SEGMENT8 SEGMENT8, SEGMENT9 SEGMENT9, SEGMENT10 SEGMENT10, SEGMENT11 SEGMENT11, SEGMENT12 SEGMENT12, SEGMENT13 SEGMENT13, SEGMENT14 SEGMENT14, SEGMENT15 SEGMENT15, SEGMENT16 SEGMENT16, SEGMENT17 SEGMENT17, SEGMENT18 SEGMENT18, SEGMENT19 SEGMENT19, SEGMENT20 SEGMENT20, SEGMENT21 SEGMENT21, SEGMENT22 SEGMENT22, SEGMENT23 SEGMENT23, SEGMENT24 SEGMENT24, SEGMENT25 SEGMENT25, SEGMENT26 SEGMENT26, SEGMENT27 SEGMENT27, SEGMENT28 SEGMENT28, SEGMENT29 SEGMENT29, SEGMENT30 SEGMENT30, CURRENCY_TYPE CURRENCY_TYPE, TRANSACTION_CURRENCY TRANSACTION_CURRENCY, ENTERED_CURRENCY ENTERED_CURRENCY, LEDGER_CURRENCY LEDGER_CURRENCY, LEDGER_ID LEDGER_ID, LEDGER_ACTION_CODE LEDGER_ACTION_CODE from "GL"."GL_ALLOC_FORMULA_LINES"

View Text - HTML Formatted

SELECT ALLOCATION_FORMULA_ID ALLOCATION_FORMULA_ID
, LINE_NUMBER LINE_NUMBER
, LINE_TYPE LINE_TYPE
, OPERATOR OPERATOR
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AMOUNT AMOUNT
, RELATIVE_PERIOD RELATIVE_PERIOD
, PERIOD_NAME PERIOD_NAME
, CURRENCY_CODE CURRENCY_CODE
, TRANSACTION_CURRENCY_11I TRANSACTION_CURRENCY_11I
, ACTUAL_FLAG ACTUAL_FLAG
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, AMOUNT_TYPE AMOUNT_TYPE
, SEGMENT_TYPES_KEY SEGMENT_TYPES_KEY
, SEGMENT_BREAK_KEY SEGMENT_BREAK_KEY
, SEGMENT1 SEGMENT1
, SEGMENT2 SEGMENT2
, SEGMENT3 SEGMENT3
, SEGMENT4 SEGMENT4
, SEGMENT5 SEGMENT5
, SEGMENT6 SEGMENT6
, SEGMENT7 SEGMENT7
, SEGMENT8 SEGMENT8
, SEGMENT9 SEGMENT9
, SEGMENT10 SEGMENT10
, SEGMENT11 SEGMENT11
, SEGMENT12 SEGMENT12
, SEGMENT13 SEGMENT13
, SEGMENT14 SEGMENT14
, SEGMENT15 SEGMENT15
, SEGMENT16 SEGMENT16
, SEGMENT17 SEGMENT17
, SEGMENT18 SEGMENT18
, SEGMENT19 SEGMENT19
, SEGMENT20 SEGMENT20
, SEGMENT21 SEGMENT21
, SEGMENT22 SEGMENT22
, SEGMENT23 SEGMENT23
, SEGMENT24 SEGMENT24
, SEGMENT25 SEGMENT25
, SEGMENT26 SEGMENT26
, SEGMENT27 SEGMENT27
, SEGMENT28 SEGMENT28
, SEGMENT29 SEGMENT29
, SEGMENT30 SEGMENT30
, CURRENCY_TYPE CURRENCY_TYPE
, TRANSACTION_CURRENCY TRANSACTION_CURRENCY
, ENTERED_CURRENCY ENTERED_CURRENCY
, LEDGER_CURRENCY LEDGER_CURRENCY
, LEDGER_ID LEDGER_ID
, LEDGER_ACTION_CODE LEDGER_ACTION_CODE
FROM "GL"."GL_ALLOC_FORMULA_LINES"