Product: | OZF - Trade Management |
---|---|
Description: | Fund request tracking table. |
Implementation/DBA Data: | APPS.OZF_FUND_REQUESTS_V |
SELECT OZFREQ.FUND_REQUEST_ID
, OZFREQ.LAST_UPDATE_DATE
, OZFREQ.LAST_UPDATED_BY
, OZFREQ.LAST_UPDATE_LOGIN
, OZFREQ.CREATION_DATE
, OZFREQ.CREATED_BY
, OZFREQ.CREATED_FROM
, OZFREQ.REQUEST_ID
, OZFREQ.PROGRAM_APPLICATION_ID
, OZFREQ.PROGRAM_ID
, OZFREQ.PROGRAM_UPDATE_DATE
, OZFREQ.FUND_REQUEST_STATUS
, OZFREQ.TRANSFER_TO_TYPE
, OZFREQ.TRANSFER_TO_ID
, OZFFUN1.SHORT_NAME
, OZFFUN1.FUND_NUMBER
, OZFFUN1.CURRENCY_CODE_TC
, OZFFUN1.OWNER_FULL_NAME
, OZFFUN1.AVAILABLE_BUDGET
, OZFFUN1.TOTAL_BUDGET
, OZFFUN1.HOLDBACK_AMT
, OZFFUN1.DISTRIBUTED_AMOUNT
, OZFFUN1.TRANSFERED_IN_AMT
, OZFFUN1.TRANSFERED_OUT_AMT
, OZFREQ.DATE_REQUIRED_BY
, OZFREQ.TRANSFER_FM_TYPE
, OZFREQ.TRANSFER_FM_ID
, OZFFUN2.SHORT_NAME
, OZFFUN2.FUND_NUMBER
, OZFFUN2.CURRENCY_CODE_TC
, OZFFUN2.OWNER_FULL_NAME
, OZFREQ.REQUESTER
, OZFREQ.APPROVER
, OZFREQ.REQUESTED_AMOUNT
, OZFREQ.APPROVED_AMOUNT
, OZFREQ.OBJECT_VERSION_NUMBER
, OZFREQ.TO_CURRENCY_CODE
, OZFREQ.FM_CURRENTY_CODE
, OZFREQ.EXCHANGE_RATE_TYPE
, OZFREQ.EXCHANGE_RATE_DATE
, OZFREQ.EXCHANGE_RATE
, OZFREQ.TRANSFER_TYPE
, OZFREQ.DESCRIPTION
, OZFREQ.FUND_REQUEST_DATE
, OZFREQ.FUND_TRANSFER_DATE
, OZFREQ.RECEIVED_AMOUNT
FROM OZF_FUND_REQUESTS OZFREQ
, OZF_FUND_DETAILS_V OZFFUN1
, OZF_FUND_DETAILS_V OZFFUN2
WHERE OZFREQ.TRANSFER_TO_ID = OZFFUN1.FUND_ID
AND OZFREQ.TRANSFER_FM_ID = OZFFUN2.FUND_ID