VIEW: GL.GL_RECURRING_LINE_CALC_RULES#

Source

View Text - Preformatted

select RECURRING_HEADER_ID RECURRING_HEADER_ID, RECURRING_LINE_NUM RECURRING_LINE_NUM, RULE_NUM RULE_NUM, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, OPERATOR OPERATOR, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, AMOUNT AMOUNT, PERIOD_TO_DATE_FLAG PERIOD_TO_DATE_FLAG, ACTUAL_FLAG ACTUAL_FLAG, CURRENCY_CODE_11I CURRENCY_CODE_11I, RELATIVE_PERIOD_CODE RELATIVE_PERIOD_CODE, AMOUNT_TYPE AMOUNT_TYPE, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, CONTEXT CONTEXT, ASSIGNED_CODE_COMBINATION ASSIGNED_CODE_COMBINATION, TEMPLATE_ID TEMPLATE_ID, 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, LEDGER_CURRENCY LEDGER_CURRENCY, CURRENCY_TYPE CURRENCY_TYPE, ENTERED_CURRENCY ENTERED_CURRENCY, LEDGER_ID LEDGER_ID from "GL"."GL_RECURRING_LINE_CALC_RULES"

View Text - HTML Formatted

SELECT RECURRING_HEADER_ID RECURRING_HEADER_ID
, RECURRING_LINE_NUM RECURRING_LINE_NUM
, RULE_NUM RULE_NUM
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, OPERATOR OPERATOR
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, AMOUNT AMOUNT
, PERIOD_TO_DATE_FLAG PERIOD_TO_DATE_FLAG
, ACTUAL_FLAG ACTUAL_FLAG
, CURRENCY_CODE_11I CURRENCY_CODE_11I
, RELATIVE_PERIOD_CODE RELATIVE_PERIOD_CODE
, AMOUNT_TYPE AMOUNT_TYPE
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, CONTEXT CONTEXT
, ASSIGNED_CODE_COMBINATION ASSIGNED_CODE_COMBINATION
, TEMPLATE_ID TEMPLATE_ID
, 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
, LEDGER_CURRENCY LEDGER_CURRENCY
, CURRENCY_TYPE CURRENCY_TYPE
, ENTERED_CURRENCY ENTERED_CURRENCY
, LEDGER_ID LEDGER_ID
FROM "GL"."GL_RECURRING_LINE_CALC_RULES"