VIEW: OZF.OZF_FUNDS_ALL_B#

Source

View Text - Preformatted

select FUND_ID FUND_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, CREATED_FROM CREATED_FROM, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, FUND_NUMBER FUND_NUMBER, PARENT_FUND_ID PARENT_FUND_ID, CATEGORY_ID CATEGORY_ID, FUND_TYPE FUND_TYPE, FUND_USAGE FUND_USAGE, STATUS_CODE STATUS_CODE, STATUS_DATE STATUS_DATE, ACCRUED_LIABLE_ACCOUNT ACCRUED_LIABLE_ACCOUNT, DED_ADJUSTMENT_ACCOUNT DED_ADJUSTMENT_ACCOUNT, LIABILITY_FLAG LIABILITY_FLAG, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, START_PERIOD_ID START_PERIOD_ID, END_PERIOD_ID END_PERIOD_ID, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, BUDGET_AMOUNT_TC BUDGET_AMOUNT_TC, BUDGET_AMOUNT_FC BUDGET_AMOUNT_FC, AVAILABLE_AMOUNT AVAILABLE_AMOUNT, DISTRIBUTED_AMOUNT DISTRIBUTED_AMOUNT, CURRENCY_CODE_TC CURRENCY_CODE_TC, CURRENCY_CODE_FC CURRENCY_CODE_FC, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, EXCHANGE_RATE_DATE EXCHANGE_RATE_DATE, EXCHANGE_RATE EXCHANGE_RATE, DEPARTMENT_ID DEPARTMENT_ID, COSTCENTRE_ID COSTCENTRE_ID, OWNER OWNER, ACCRUAL_METHOD ACCRUAL_METHOD, ACCRUAL_OPERAND ACCRUAL_OPERAND, ACCRUAL_RATE ACCRUAL_RATE, ACCRUAL_BASIS ACCRUAL_BASIS, HIERARCHY HIERARCHY, HIERARCHY_LEVEL HIERARCHY_LEVEL, LEVEL_VALUE LEVEL_VALUE, BUDGET_FLAG BUDGET_FLAG, EARNED_FLAG EARNED_FLAG, APPLY_ACCRUAL_ON APPLY_ACCRUAL_ON, ACCRUAL_PHASE ACCRUAL_PHASE, ACCRUAL_CAP ACCRUAL_CAP, ACCRUAL_UOM ACCRUAL_UOM, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ORG_ID ORG_ID, USER_STATUS_ID USER_STATUS_ID, HIERARCHY_ID HIERARCHY_ID, PARENT_NODE_ID PARENT_NODE_ID, NODE_ID NODE_ID, ORIGINAL_BUDGET ORIGINAL_BUDGET, TRANSFERED_IN_AMT TRANSFERED_IN_AMT, TRANSFERED_OUT_AMT TRANSFERED_OUT_AMT, HOLDBACK_AMT HOLDBACK_AMT, PLANNED_AMT PLANNED_AMT, COMMITTED_AMT COMMITTED_AMT, EARNED_AMT EARNED_AMT, PAID_AMT PAID_AMT, PLAN_TYPE PLAN_TYPE, PLAN_ID PLAN_ID, LIABLE_ACCNT_SEGMENTS LIABLE_ACCNT_SEGMENTS, ADJUSTMENT_ACCNT_SEGMENTS ADJUSTMENT_ACCNT_SEGMENTS, SECURITY_GROUP_ID SECURITY_GROUP_ID, THRESHOLD_ID THRESHOLD_ID, CUSTOM_SETUP_ID CUSTOM_SETUP_ID, COUNTRY_ID COUNTRY_ID, TASK_ID TASK_ID, FUND_CALENDAR FUND_CALENDAR, END_PERIOD_NAME END_PERIOD_NAME, START_PERIOD_NAME START_PERIOD_NAME, ACCRUAL_QUANTITY ACCRUAL_QUANTITY, ACCRUAL_DISCOUNT_LEVEL ACCRUAL_DISCOUNT_LEVEL, ACCRUE_TO_LEVEL_ID ACCRUE_TO_LEVEL_ID, RECAL_COMMITTED RECAL_COMMITTED, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, ROLLUP_ORIGINAL_BUDGET ROLLUP_ORIGINAL_BUDGET, ROLLUP_TRANSFERED_IN_AMT ROLLUP_TRANSFERED_IN_AMT, ROLLUP_TRANSFERED_OUT_AMT ROLLUP_TRANSFERED_OUT_AMT, ROLLUP_HOLDBACK_AMT ROLLUP_HOLDBACK_AMT, ROLLUP_PLANNED_AMT ROLLUP_PLANNED_AMT, ROLLUP_COMMITTED_AMT ROLLUP_COMMITTED_AMT, ROLLUP_RECAL_COMMITTED ROLLUP_RECAL_COMMITTED, ROLLUP_EARNED_AMT ROLLUP_EARNED_AMT, ROLLUP_PAID_AMT ROLLUP_PAID_AMT, RETROACTIVE_FLAG RETROACTIVE_FLAG, QUALIFIER_ID QUALIFIER_ID, PREV_FUND_ID PREV_FUND_ID, TRANSFERED_FLAG TRANSFERED_FLAG, UTILIZED_AMT UTILIZED_AMT, ROLLUP_UTILIZED_AMT ROLLUP_UTILIZED_AMT, PRODUCT_SPREAD_TIME_ID PRODUCT_SPREAD_TIME_ID, ACTIVATION_DATE ACTIVATION_DATE, LEDGER_ID LEDGER_ID from "OZF"."OZF_FUNDS_ALL_B"

View Text - HTML Formatted

SELECT FUND_ID FUND_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, CREATED_FROM CREATED_FROM
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, FUND_NUMBER FUND_NUMBER
, PARENT_FUND_ID PARENT_FUND_ID
, CATEGORY_ID CATEGORY_ID
, FUND_TYPE FUND_TYPE
, FUND_USAGE FUND_USAGE
, STATUS_CODE STATUS_CODE
, STATUS_DATE STATUS_DATE
, ACCRUED_LIABLE_ACCOUNT ACCRUED_LIABLE_ACCOUNT
, DED_ADJUSTMENT_ACCOUNT DED_ADJUSTMENT_ACCOUNT
, LIABILITY_FLAG LIABILITY_FLAG
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, START_PERIOD_ID START_PERIOD_ID
, END_PERIOD_ID END_PERIOD_ID
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, BUDGET_AMOUNT_TC BUDGET_AMOUNT_TC
, BUDGET_AMOUNT_FC BUDGET_AMOUNT_FC
, AVAILABLE_AMOUNT AVAILABLE_AMOUNT
, DISTRIBUTED_AMOUNT DISTRIBUTED_AMOUNT
, CURRENCY_CODE_TC CURRENCY_CODE_TC
, CURRENCY_CODE_FC CURRENCY_CODE_FC
, EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, EXCHANGE_RATE_DATE EXCHANGE_RATE_DATE
, EXCHANGE_RATE EXCHANGE_RATE
, DEPARTMENT_ID DEPARTMENT_ID
, COSTCENTRE_ID COSTCENTRE_ID
, OWNER OWNER
, ACCRUAL_METHOD ACCRUAL_METHOD
, ACCRUAL_OPERAND ACCRUAL_OPERAND
, ACCRUAL_RATE ACCRUAL_RATE
, ACCRUAL_BASIS ACCRUAL_BASIS
, HIERARCHY HIERARCHY
, HIERARCHY_LEVEL HIERARCHY_LEVEL
, LEVEL_VALUE LEVEL_VALUE
, BUDGET_FLAG BUDGET_FLAG
, EARNED_FLAG EARNED_FLAG
, APPLY_ACCRUAL_ON APPLY_ACCRUAL_ON
, ACCRUAL_PHASE ACCRUAL_PHASE
, ACCRUAL_CAP ACCRUAL_CAP
, ACCRUAL_UOM ACCRUAL_UOM
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ORG_ID ORG_ID
, USER_STATUS_ID USER_STATUS_ID
, HIERARCHY_ID HIERARCHY_ID
, PARENT_NODE_ID PARENT_NODE_ID
, NODE_ID NODE_ID
, ORIGINAL_BUDGET ORIGINAL_BUDGET
, TRANSFERED_IN_AMT TRANSFERED_IN_AMT
, TRANSFERED_OUT_AMT TRANSFERED_OUT_AMT
, HOLDBACK_AMT HOLDBACK_AMT
, PLANNED_AMT PLANNED_AMT
, COMMITTED_AMT COMMITTED_AMT
, EARNED_AMT EARNED_AMT
, PAID_AMT PAID_AMT
, PLAN_TYPE PLAN_TYPE
, PLAN_ID PLAN_ID
, LIABLE_ACCNT_SEGMENTS LIABLE_ACCNT_SEGMENTS
, ADJUSTMENT_ACCNT_SEGMENTS ADJUSTMENT_ACCNT_SEGMENTS
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, THRESHOLD_ID THRESHOLD_ID
, CUSTOM_SETUP_ID CUSTOM_SETUP_ID
, COUNTRY_ID COUNTRY_ID
, TASK_ID TASK_ID
, FUND_CALENDAR FUND_CALENDAR
, END_PERIOD_NAME END_PERIOD_NAME
, START_PERIOD_NAME START_PERIOD_NAME
, ACCRUAL_QUANTITY ACCRUAL_QUANTITY
, ACCRUAL_DISCOUNT_LEVEL ACCRUAL_DISCOUNT_LEVEL
, ACCRUE_TO_LEVEL_ID ACCRUE_TO_LEVEL_ID
, RECAL_COMMITTED RECAL_COMMITTED
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, ROLLUP_ORIGINAL_BUDGET ROLLUP_ORIGINAL_BUDGET
, ROLLUP_TRANSFERED_IN_AMT ROLLUP_TRANSFERED_IN_AMT
, ROLLUP_TRANSFERED_OUT_AMT ROLLUP_TRANSFERED_OUT_AMT
, ROLLUP_HOLDBACK_AMT ROLLUP_HOLDBACK_AMT
, ROLLUP_PLANNED_AMT ROLLUP_PLANNED_AMT
, ROLLUP_COMMITTED_AMT ROLLUP_COMMITTED_AMT
, ROLLUP_RECAL_COMMITTED ROLLUP_RECAL_COMMITTED
, ROLLUP_EARNED_AMT ROLLUP_EARNED_AMT
, ROLLUP_PAID_AMT ROLLUP_PAID_AMT
, RETROACTIVE_FLAG RETROACTIVE_FLAG
, QUALIFIER_ID QUALIFIER_ID
, PREV_FUND_ID PREV_FUND_ID
, TRANSFERED_FLAG TRANSFERED_FLAG
, UTILIZED_AMT UTILIZED_AMT
, ROLLUP_UTILIZED_AMT ROLLUP_UTILIZED_AMT
, PRODUCT_SPREAD_TIME_ID PRODUCT_SPREAD_TIME_ID
, ACTIVATION_DATE ACTIVATION_DATE
, LEDGER_ID LEDGER_ID
FROM "OZF"."OZF_FUNDS_ALL_B"