VIEW: APPS.OZF_FUNDS_VL

Source

View Text - Preformatted

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 ,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 ,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, B.RETROACTIVE_FLAG, B.QUALIFIER_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')

View Text - HTML Formatted

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
, 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
, 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
, B.RETROACTIVE_FLAG
, B.QUALIFIER_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')