VIEW: APPS.OZF_FUNDS_ALL_VL

Source

View Text - Preformatted

SELECT B.ROWID, B.FUND_ID, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.CREATED_FROM, B.REQUEST_ID, B.PROGRAM_APPLICATION_ID, B.PROGRAM_ID, B.PROGRAM_UPDATE_DATE, B.FUND_NUMBER, B.PARENT_FUND_ID, B.CATEGORY_ID, B.FUND_TYPE, B.FUND_USAGE, B.STATUS_CODE, B.STATUS_DATE, B.USER_STATUS_ID, B.ACCRUED_LIABLE_ACCOUNT, B.DED_ADJUSTMENT_ACCOUNT, B.LIABILITY_FLAG, B.SET_OF_BOOKS_ID, B.START_PERIOD_ID, B.END_PERIOD_ID, B.START_DATE_ACTIVE, B.END_DATE_ACTIVE, B.BUDGET_AMOUNT_TC, B.BUDGET_AMOUNT_FC, B.AVAILABLE_AMOUNT, B.DISTRIBUTED_AMOUNT, B.CURRENCY_CODE_TC, B.CURRENCY_CODE_FC, B.EXCHANGE_RATE_TYPE, B.EXCHANGE_RATE_DATE, B.EXCHANGE_RATE, B.DEPARTMENT_ID, B.COSTCENTRE_ID, B.OWNER, B.ACCRUAL_METHOD, B.ACCRUAL_OPERAND, B.ACCRUAL_RATE, B.ACCRUAL_BASIS, B.HIERARCHY, B.HIERARCHY_ID, B.HIERARCHY_LEVEL, B.PARENT_NODE_ID, B.NODE_ID, B.BUDGET_FLAG, B.EARNED_FLAG, B.APPLY_ACCRUAL_ON, B.ACCRUAL_PHASE, B.ACCRUAL_CAP, B.ACCRUAL_UOM, B.ORIGINAL_BUDGET, B.TRANSFERED_IN_AMT, B.TRANSFERED_OUT_AMT, B.HOLDBACK_AMT, B.PLANNED_AMT, B.COMMITTED_AMT, B.EARNED_AMT, B.PAID_AMT, B.PLAN_TYPE, B.PLAN_ID, B.LIABLE_ACCNT_SEGMENTS, B.ADJUSTMENT_ACCNT_SEGMENTS, B.COUNTRY_ID, B.TASK_ID, B.custom_setup_id, B. threshold_id, B.fund_calendar, B.start_period_name, B.end_period_name, B.accrue_to_level_id, B.accrual_quantity, B.accrual_discount_level, B.business_unit_id, B.ATTRIBUTE_CATEGORY, B.ATTRIBUTE1, B.ATTRIBUTE2, B.ATTRIBUTE3, B.ATTRIBUTE4, B.ATTRIBUTE5, B.ATTRIBUTE6, B.ATTRIBUTE7, B.ATTRIBUTE8, B.ATTRIBUTE9, B.ATTRIBUTE10, B.ATTRIBUTE11, B.ATTRIBUTE12, B.ATTRIBUTE13, B.ATTRIBUTE14, B.ATTRIBUTE15, B.ORG_ID, B.RECAL_COMMITTED, B.ROLLUP_ORIGINAL_BUDGET, B.ROLLUP_TRANSFERED_IN_AMT, B.ROLLUP_TRANSFERED_OUT_AMT, B.ROLLUP_HOLDBACK_AMT, B.ROLLUP_PLANNED_AMT, B.ROLLUP_COMMITTED_AMT, B.ROLLUP_RECAL_COMMITTED, B.ROLLUP_EARNED_AMT, B.ROLLUP_PAID_AMT, T.SHORT_NAME, T.DESCRIPTION, B.RETROACTIVE_FLAG, B.QUALIFIER_ID, B.PREV_FUND_ID, B.TRANSFERED_FLAG, B.UTILIZED_AMT, B.ROLLUP_UTILIZED_AMT, B.PRODUCT_SPREAD_TIME_ID, B.LEDGER_ID FROM OZF_FUNDS_ALL_B B, OZF_FUNDS_ALL_TL T WHERE B.FUND_ID = T.FUND_ID AND NVL(B.ORG_ID,-99) = NVL(T.ORG_ID,-99) AND T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

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