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

TABLE: OZF.OZF_FUNDS_ALL_B_INT

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


Interface table to store data of ozf_funds_all_b table when Chargeback Batch upload or Third Party Accrual programs are run in parallel.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
RESALE_BATCH_ID NUMBER
Yes Resale Batch Identifier
FUND_ID NUMBER
Yes Fund Identifier
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER

Standard WHO column
CREATION_DATE DATE

Standard WHO column
CREATED_BY NUMBER

Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
BUDGET_AMOUNT_TC NUMBER

Budget Amount in Transactional Currency
BUDGET_AMOUNT_FC NUMBER

Budget Amount in Functional Currency
AVAILABLE_AMOUNT NUMBER

Available Amount
TRANSFERED_IN_AMT NUMBER

Transferred In Amount
TRANSFERED_OUT_AMT NUMBER

Transferred Out Amount
PLANNED_AMT NUMBER

Planned Amount
COMMITTED_AMT NUMBER

Committed Amount
EARNED_AMT NUMBER

Earned Amount
PAID_AMT NUMBER

Paid Amount
RECAL_COMMITTED NUMBER

Recalculated Committed Amount
ROLLUP_ORIGINAL_BUDGET NUMBER

Rollup Original Budget Amount
ROLLUP_TRANSFERED_IN_AMT NUMBER

Rollup Transferred In Amount
ROLLUP_TRANSFERED_OUT_AMT NUMBER

Rollup Transferred Out Amount
ROLLUP_HOLDBACK_AMT NUMBER

Rollup Holdback Amount
ROLLUP_PLANNED_AMT NUMBER

Rollup Planned Amount
ROLLUP_COMMITTED_AMT NUMBER

Rollup Committed Amount
ROLLUP_RECAL_COMMITTED NUMBER

Rollup Recalculated Committed Amount
ROLLUP_EARNED_AMT NUMBER

Rollup Earned Amount
ROLLUP_PAID_AMT NUMBER

Rollup Paid Amount
UTILIZED_AMT NUMBER

Utilized Amount
ROLLUP_UTILIZED_AMT NUMBER

Rollup Utilized Amount
BATCH_TYPE VARCHAR2 (30) Yes Batch Type
REQUEST_ID NUMBER

Request Identifier
Query Text

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


SELECT RESALE_BATCH_ID
,      FUND_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      BUDGET_AMOUNT_TC
,      BUDGET_AMOUNT_FC
,      AVAILABLE_AMOUNT
,      TRANSFERED_IN_AMT
,      TRANSFERED_OUT_AMT
,      PLANNED_AMT
,      COMMITTED_AMT
,      EARNED_AMT
,      PAID_AMT
,      RECAL_COMMITTED
,      ROLLUP_ORIGINAL_BUDGET
,      ROLLUP_TRANSFERED_IN_AMT
,      ROLLUP_TRANSFERED_OUT_AMT
,      ROLLUP_HOLDBACK_AMT
,      ROLLUP_PLANNED_AMT
,      ROLLUP_COMMITTED_AMT
,      ROLLUP_RECAL_COMMITTED
,      ROLLUP_EARNED_AMT
,      ROLLUP_PAID_AMT
,      UTILIZED_AMT
,      ROLLUP_UTILIZED_AMT
,      BATCH_TYPE
,      REQUEST_ID
FROM OZF.OZF_FUNDS_ALL_B_INT;

Dependencies

[top of page]

OZF.OZF_FUNDS_ALL_B_INT does not reference any database object

OZF.OZF_FUNDS_ALL_B_INT is referenced by following:

SchemaOZF
ViewOZF_FUNDS_ALL_B_INT#