VIEW: APPS.OZF_FUNDS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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