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

TABLE: OZF.OZF_ACT_BUDGETS_INT

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


Interface table to store data of ozf_act_budgets 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
ACTIVITY_BUDGET_ID NUMBER
Yes Activity Budget 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
REQUEST_AMOUNT NUMBER

Request Amount
APPROVED_AMOUNT NUMBER

Approved Amount
APPROVED_ORIGINAL_AMOUNT NUMBER

Approved Original Amount
APPROVED_AMOUNT_FC NUMBER

Approved Amount in Functional Currency
PARENT_SRC_APPRVD_AMT NUMBER

Parent Source Approved Amount
SRC_CURR_REQUEST_AMT NUMBER

Source Currency Approved 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
,      ACTIVITY_BUDGET_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_AMOUNT
,      APPROVED_AMOUNT
,      APPROVED_ORIGINAL_AMOUNT
,      APPROVED_AMOUNT_FC
,      PARENT_SRC_APPRVD_AMT
,      SRC_CURR_REQUEST_AMT
,      BATCH_TYPE
,      REQUEST_ID
FROM OZF.OZF_ACT_BUDGETS_INT;

Dependencies

[top of page]

OZF.OZF_ACT_BUDGETS_INT does not reference any database object

OZF.OZF_ACT_BUDGETS_INT is referenced by following:

SchemaOZF
ViewOZF_ACT_BUDGETS_INT#