Product: | OZF - Trade Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OZF_FUNDS |
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
, SECURITY_GROUP_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)