View: OZF_FUNDS_VL

Product:	OZF - Trade Management
Description:	Fund setup master base table and translation table view.
Implementation/DBA Data:	APPS.OZF_FUNDS_VL

View Text

SELECT B.ROWID
, B.FUND_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREATION_DATE
, B.CREATED_BY
, 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
, T.SHORT_NAME
, T.DESCRIPTION
, T.LANGUAGE
, T.SOURCE_LANG
, B.OBJECT_VERSION_NUMBER
, 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.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
FROM OZF_FUNDS_ALL_B B
, OZF_FUNDS_ALL_TL T
WHERE B.FUND_ID = T.FUND_ID
AND NVL(T.ORG_ID
, -99) = NVL(B.ORG_ID
, -99)
AND NVL(T.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)
AND T.LANGUAGE = USERENV('LANG')

Columns