VIEW: APPS.OZF_FUND_REQUESTS_V

Source

View Text - Preformatted

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.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

View Text - HTML Formatted

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.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