DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OZF_FUND_REQUESTS_V

Object Details
Object Name: OZF_FUND_REQUESTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOZF.OZF_FUND_REQUESTS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
FUND_REQUEST_ID NUMBER
Yes Unique identifier.
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
CREATED_BY NUMBER (15) Yes Standard WHO column
CREATED_FROM VARCHAR2 (30)
Standard WHO column
REQUEST_ID NUMBER (15)
Standard WHO column
PROGRAM_APPLICATION_ID NUMBER (15)
Standard WHO column
PROGRAM_ID NUMBER (15)
Standard WHO column
PROGRAM_UPDATE_DATE DATE

Standard WHO column
FUND_REQUEST_STATUS VARCHAR2 (30) Yes Current Status of the Fund Request
TRANSFER_TO_TYPE VARCHAR2 (30) Yes Type of source originating the request - campaign, fund, event, etc.
TRANSFER_TO_ID NUMBER
Yes Internal identifier for the request source.
TRANSFER_TO_NAME VARCHAR2 (240) Yes
TRANSFER_TO_NUMBER VARCHAR2 (30) Yes
TRANSFER_TO_CURR_CODE VARCHAR2 (15)
TRANSFER_TO_OWNER_NAME VARCHAR2 (360)
TRANSFER_TO_AVAIL_AMT NUMBER

TRANSFER_TO_BUDG_AMT NUMBER

TRANSFER_TO_HOLD_AMT NUMBER

TRANSFER_TO_DIST_AMT NUMBER

TRANSFER_TO_TRANS_IN_AMT NUMBER

TRANSFER_TO_TRANS_OUT_AMT NUMBER

DATE_REQUIRED_BY DATE

Date by which decision is required
TRANSFER_FM_TYPE VARCHAR2 (30)
Type of fund source serving the request. This can be a fund, campaign, event, etc.
TRANSFER_FM_ID NUMBER

Internal identifier for the fund source.
TRANSFER_FM_NAME VARCHAR2 (240) Yes
TRANSFER_FM_NUMBER VARCHAR2 (30) Yes
TRANSFER_FM_CURR_CODE VARCHAR2 (15)
TRANSFER_FM_OWNER_NAME VARCHAR2 (360)
REQUESTER NUMBER
Yes Id of the person initiating the request.
APPROVER NUMBER

Id fo the person approving the request.
REQUESTED_AMOUNT NUMBER
Yes Amount Requested on the Fund Request
APPROVED_AMOUNT NUMBER

Amount approved for the fund request.
OBJECT_VERSION_NUMBER NUMBER

Identifier for the record used in HTML screens.
TO_CURRENCY_CODE VARCHAR2 (15)
EXCHANGE_RATE_TYPE VARCHAR2 (30)
EXCHANGE_RATE_DATE DATE

EXCHANGE_RATE VARCHAR2 (240)
TRANSFER_TYPE VARCHAR2 (30)
DESCRIPTION VARCHAR2 (2000)
FUND_REQUEST_DATE DATE

Date the fund request is made
FUND_TRANSFER_DATE DATE

Date the fund transfer is completed.
RECEIVED_AMOUNT NUMBER

Amount Received by the requestinng fund .
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FUND_REQUEST_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      CREATED_FROM
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      FUND_REQUEST_STATUS
,      TRANSFER_TO_TYPE
,      TRANSFER_TO_ID
,      TRANSFER_TO_NAME
,      TRANSFER_TO_NUMBER
,      TRANSFER_TO_CURR_CODE
,      TRANSFER_TO_OWNER_NAME
,      TRANSFER_TO_AVAIL_AMT
,      TRANSFER_TO_BUDG_AMT
,      TRANSFER_TO_HOLD_AMT
,      TRANSFER_TO_DIST_AMT
,      TRANSFER_TO_TRANS_IN_AMT
,      TRANSFER_TO_TRANS_OUT_AMT
,      DATE_REQUIRED_BY
,      TRANSFER_FM_TYPE
,      TRANSFER_FM_ID
,      TRANSFER_FM_NAME
,      TRANSFER_FM_NUMBER
,      TRANSFER_FM_CURR_CODE
,      TRANSFER_FM_OWNER_NAME
,      REQUESTER
,      APPROVER
,      REQUESTED_AMOUNT
,      APPROVED_AMOUNT
,      OBJECT_VERSION_NUMBER
,      TO_CURRENCY_CODE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE_DATE
,      EXCHANGE_RATE
,      TRANSFER_TYPE
,      DESCRIPTION
,      FUND_REQUEST_DATE
,      FUND_TRANSFER_DATE
,      RECEIVED_AMOUNT
FROM APPS.OZF_FUND_REQUESTS_V;

Dependencies

[top of page]

APPS.OZF_FUND_REQUESTS_V references the following:

SchemaAPPS
ViewOZF_FUND_DETAILS_V
SynonymOZF_FUND_REQUESTS

APPS.OZF_FUND_REQUESTS_V is not referenced by any database object