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

TABLE: OZF.OZF_FUND_REQUESTS

Object Details
Object Name: OZF_FUND_REQUESTS
Object Type: TABLE
Owner: OZF
FND Design Data: TableOZF.OZF_FUND_REQUESTS
Subobject Name:
Status: VALID


OZF_FUND_REQUESTS provides the fund request log details. The transfer to and transfer from columns define the request initiator and the request approving source. In addition to these details, the details related to request date, requested amount and approved amount are also stored in this table.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OZF_FUND_REQUESTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnFUND_REQUEST_ID
OZF_FUND_REQUESTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnTRANSFER_TO_ID
OZF_FUND_REQUESTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_ARCHIVE ColumnTRANSFER_FM_ID
Columns
Name Datatype Length Mandatory Comments
FUND_REQUEST_ID NUMBER
Yes Fund request 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, budget or event., Currently 'FUND'
TRANSFER_TO_ID NUMBER
Yes Budget identifier requesting transfer
DATE_REQUIRED_BY DATE

For future use
TRANSFER_FM_TYPE VARCHAR2 (30)
Type of fund source serving the request. This can be a Budget, campaign or event. Currently 'FUND'
TRANSFER_FM_ID NUMBER

Budget identifier transferring amount
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
APPROVED_AMOUNT NUMBER

Amount approved
OBJECT_VERSION_NUMBER NUMBER

Identifier for the record used in HTML screens.
TO_CURRENCY_CODE VARCHAR2 (15)
Currentcy Code of the requesting Budget
FM_CURRENTY_CODE VARCHAR2 (3)
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Type of Exchange Rate
EXCHANGE_RATE_DATE DATE

Date of Exchange Rate
EXCHANGE_RATE VARCHAR2 (240)
Exchange Rate
TRANSFER_TYPE VARCHAR2 (30)
Type of budget transfer. 'TRANSFER','RESERVE' and 'RELEASE'
DESCRIPTION VARCHAR2 (2000)
Description
FUND_REQUEST_DATE DATE

Date the fund request is made.
FUND_TRANSFER_DATE DATE

Date the fund transfer is done.
SECURITY_GROUP_ID NUMBER

Used in hosted environments
RECEIVED_AMOUNT NUMBER

Amount received by the requesting fund.
FM_CURRENCY_CODE VARCHAR2 (15)
Currentcy Code of the transferring Budget
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
,      DATE_REQUIRED_BY
,      TRANSFER_FM_TYPE
,      TRANSFER_FM_ID
,      REQUESTER
,      APPROVER
,      REQUESTED_AMOUNT
,      APPROVED_AMOUNT
,      OBJECT_VERSION_NUMBER
,      TO_CURRENCY_CODE
,      FM_CURRENTY_CODE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE_DATE
,      EXCHANGE_RATE
,      TRANSFER_TYPE
,      DESCRIPTION
,      FUND_REQUEST_DATE
,      FUND_TRANSFER_DATE
,      SECURITY_GROUP_ID
,      RECEIVED_AMOUNT
,      FM_CURRENCY_CODE
FROM OZF.OZF_FUND_REQUESTS;

Dependencies

[top of page]

OZF.OZF_FUND_REQUESTS does not reference any database object

OZF.OZF_FUND_REQUESTS is referenced by following:

SchemaOZF
ViewOZF_FUND_REQUESTS#