eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OZF_FUND_DETAILS_V

Product:	OZF - Trade Management
Description:
Implementation/DBA Data:	APPS.OZF_FUND_DETAILS_V

View Text

SELECT A.FUND_ID
, A.PARENT_FUND_ID
, A.CATEGORY_ID
, F.CATEGORY_NAME
, A.FUND_NUMBER
, A.FUND_TYPE
, A.FUND_USAGE
, A.STATUS_CODE
, A.START_DATE_ACTIVE
, A.END_DATE_ACTIVE
, NVL(A.BUDGET_AMOUNT_TC
, 0)
, NVL(A.BUDGET_AMOUNT_FC
, 0)
, NVL(A.AVAILABLE_AMOUNT
, 0)
, NVL(A.DISTRIBUTED_AMOUNT
, 0)
, A.CURRENCY_CODE_TC
, A.CURRENCY_CODE_FC
, A.OWNER
, A.SHORT_NAME
, A.DESCRIPTION
, A.USER_STATUS_ID
, AUS.NAME
, D.FULL_NAME
, A.ORG_ID
, A.HOLDBACK_AMT
, A.OBJECT_VERSION_NUMBER
, D.EMAIL
, E.SHORT_NAME
, A.ORIGINAL_BUDGET
, ((NVL(A.ORIGINAL_BUDGET
, 0) - NVL(A.HOLDBACK_AMT
, 0)) + (NVL(A.TRANSFERED_IN_AMT
, 0) - NVL(A.TRANSFERED_OUT_AMT
, 0)))
, (NVL(A.ORIGINAL_BUDGET
, 0) + (NVL(A.TRANSFERED_IN_AMT
, 0) - NVL(A.TRANSFERED_OUT_AMT
, 0)))
, A.TRANSFERED_IN_AMT
, A.TRANSFERED_OUT_AMT
, A.HOLDBACK_AMT
, A.PLANNED_AMT
, A.COMMITTED_AMT
, A.EARNED_AMT
, A.PAID_AMT
, A.PLAN_TYPE
, A.PLAN_ID
, A.ACCRUED_LIABLE_ACCOUNT
, A.DED_ADJUSTMENT_ACCOUNT
, A.LIABLE_ACCNT_SEGMENTS
, A.ADJUSTMENT_ACCNT_SEGMENTS
, A.ACCRUAL_METHOD
, A.ACCRUAL_OPERAND
, A.ACCRUAL_RATE
, A.ACCRUAL_BASIS
, A.ACCRUAL_UOM
, A.ACCRUAL_CAP
, A.ACCRUAL_PHASE
, A.DEPARTMENT_ID
, A. COUNTRY_ID
, A.TASK_ID
, A.CUSTOM_SETUP_ID
, A. THRESHOLD_ID
, A. FUND_CALENDAR
, A.START_PERIOD_NAME
, A.END_PERIOD_NAME
, A.ACCRUE_TO_LEVEL_ID
, A.ACCRUAL_QUANTITY
, A.ACCRUAL_DISCOUNT_LEVEL
, A.HIERARCHY_ID
, A.BUSINESS_UNIT_ID
, A.LIABILITY_FLAG
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
FROM AMS_JTF_RS_EMP_V D
, AMS_CATEGORIES_V F
, AMS_USER_STATUSES_VL AUS
, OZF_FUNDS_ALL_VL E
, OZF_FUNDS_ALL_VL A
WHERE A.USER_STATUS_ID = AUS.USER_STATUS_ID (+)
AND AUS.SYSTEM_STATUS_TYPE = 'AMS_FUND_STATUS'
AND D.RESOURCE_ID = A.OWNER
AND E.FUND_ID (+) = A.PARENT_FUND_ID
AND F.CATEGORY_ID (+) = A.CATEGORY_ID

Columns

Name
FUND_ID
PARENT_FUND_ID
CATEGORY_ID
CATEGORY
FUND_NUMBER
FUND_TYPE
FUND_USAGE
STATUS_CODE
START_DATE_ACTIVE
END_DATE_ACTIVE
BUDGET_AMOUNT_TC
BUDGET_AMOUNT_FC
AVAILABLE_AMOUNT
DISTRIBUTED_AMOUNT
CURRENCY_CODE_TC
CURRENCY_CODE_FC
OWNER
SHORT_NAME
DESCRIPTION
USER_STATUS_ID
USER_STATUS_NAME
OWNER_FULL_NAME
ORG_ID
PENDING_AMOUNT
OBJECT_VERSION_NUMBER
EMAIL
PARENT_FUND_NAME
ORIGINAL_BUDGET
AVAILABLE_BUDGET
TOTAL_BUDGET
TRANSFERED_IN_AMT
TRANSFERED_OUT_AMT
HOLDBACK_AMT
PLANNED_AMT
COMMITTED_AMT
EARNED_AMT
PAID_AMT
PLAN_TYPE
PLAN_ID
ACCRUED_LIABLE_ACCOUNT
DED_ADJUSTMENT_ACCOUNT
LIABLE_ACCNT_SEGMENTS
ADJUSTMENT_ACCNT_SEGMENTS
ACCRUAL_METHOD
ACCRUAL_OPERAND
ACCRUAL_RATE
ACCRUAL_BASIS
ACCRUAL_UOM
ACCRUAL_CAP
ACCRUAL_PHASE
DEPARTMENT_ID
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
HIERARCHY_ID
BUSINESS_UNIT_ID
LIABILITY_FLAG
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15