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


TABLE: OZF.OZF_FUNDS_UTILIZED_ALL_B

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


OZF_FUND_UTILIZATIONS_ALL stores the utilization details for a given Budget. The utilization may or may not contribute to the accruals in a given Budget detail.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OZF_FUNDS_UTILIZED_ALL_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnUTILIZATION_ID
OZF_FUNDS_UTILIZED_ALL_B_N10 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCUST_ACCOUNT_ID
OZF_FUNDS_UTILIZED_ALL_B_N12 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORG_ID
OZF_FUNDS_UTILIZED_ALL_B_N13 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAMS_ACTIVITY_BUDGET_ID
OZF_FUNDS_UTILIZED_ALL_B_N14 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREFERENCE_TYPE
ColumnREFERENCE_ID
OZF_FUNDS_UTILIZED_ALL_B_N16 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORDER_LINE_ID
OZF_FUNDS_UTILIZED_ALL_B_N17 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORIG_UTILIZATION_ID
OZF_FUNDS_UTILIZED_ALL_B_N18 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACTIVITY_PRODUCT_ID
OZF_FUNDS_UTILIZED_ALL_B_N19 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_TYPE
ColumnOBJECT_ID
OZF_FUNDS_UTILIZED_ALL_B_N20 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRICE_ADJUSTMENT_ID
ColumnOBJECT_TYPE
OZF_FUNDS_UTILIZED_ALL_B_N21 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnADJUSTMENT_TYPE_ID
OZF_FUNDS_UTILIZED_ALL_B_N22 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBILLTO_CUST_ACCOUNT_ID
ColumnOBJECT_TYPE
OZF_FUNDS_UTILIZED_ALL_B_N23 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGL_POSTED_FLAG
ColumnPRICE_ADJUSTMENT_ID
OZF_FUNDS_UTILIZED_ALL_B_N24 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnADJUSTMENT_DATE
ColumnPLAN_ID
ColumnPLAN_TYPE
OZF_FUNDS_UTILIZED_ALL_B_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOMPONENT_ID
OZF_FUNDS_UTILIZED_ALL_B_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFUND_ID
ColumnPLAN_ID
ColumnPLAN_TYPE
ColumnCREATION_DATE
OZF_FUNDS_UTILIZED_ALL_B_N8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnUTILIZATION_TYPE
OZF_FUNDS_UTILIZED_ALL_B_N9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPRODUCT_ID
ColumnPRODUCT_LEVEL_TYPE
Columns
Name Datatype Length Mandatory Comments
UTILIZATION_ID NUMBER
Yes Internal identifier for fund utilization
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
UTILIZATION_TYPE VARCHAR2 (30)
Type of utilization - Accrued, Utilized, Adjust.
FUND_ID NUMBER
Yes Budget against which the utilization is occuring
PLAN_TYPE VARCHAR2 (30)
'C'ampaign or 'T'rade promotion
PLAN_ID NUMBER

Internal identifier for the deal
COMPONENT_TYPE VARCHAR2 (30)
Offer Type
COMPONENT_ID NUMBER

Offer Identifier
OBJECT_TYPE VARCHAR2 (30)
Type of object - Invoice, Order.
OBJECT_ID NUMBER

Internal identifier for the object.
ORDER_ID NUMBER

Internal identifier for the order.
INVOICE_ID NUMBER

Invoice toed to the deal component
AMOUNT NUMBER
Yes Utilization amount
ACCTD_AMOUNT NUMBER

Functional currency amount.
CURRENCY_CODE VARCHAR2 (15)
Currency code.
EXCHANGE_RATE_TYPE VARCHAR2 (30)
Obsolete. Type of exchange rate.
EXCHANGE_RATE_DATE DATE

Exchange Rate Date
EXCHANGE_RATE NUMBER

Obsolete. Exchange rate.
ADJUSTMENT_TYPE VARCHAR2 (30)
Adjustment Type. Default 'Standard'
ADJUSTMENT_DATE DATE

Adjustment Date
OBJECT_VERSION_NUMBER NUMBER

Identifier for the record used in HTML screens.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flex structure defining column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flex segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flex segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flex segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flex segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flex segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flex segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flex segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flex segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flex segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flex segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flex segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flex segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flex segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flex segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flex segment
ORG_ID NUMBER
Yes Operating Unit Identifier
SECURITY_GROUP_ID NUMBER

Used in hosted environments
CAMP_SCHEDULE_ID NUMBER

Campaign Schedule Identifier.
ADJUSTMENT_TYPE_ID NUMBER

Adjustment Type Identifier.
AMS_ACTIVITY_BUDGET_ID NUMBER

Activity Budget Identifier.
PRODUCT_ID NUMBER

Product Identifier
CUST_ACCOUNT_ID NUMBER

Pay_to Customer Account Identifier.
GL_DATE DATE

General Ledger Posting Date.
PRODUCT_LEVEL_TYPE VARCHAR2 (30)
Product Level Code for eg. PRODUCT or PRODUCT_FAMILY
AMOUNT_REMAINING NUMBER

Utilization amount not used by a claim
ACCTD_AMOUNT_REMAINING NUMBER

Functional currency amount remaining
PRICE_ADJUSTMENT_ID NUMBER

Price Adjustment Identifier
PLAN_CURR_AMOUNT NUMBER

Amount in 'Plan Type' Currency
PLAN_CURR_AMOUNT_REMAINING NUMBER

Amount Remaining in 'Plan Type' Currency
SCAN_UNIT NUMBER

Scan Unit for Scan Data Offer
SCAN_UNIT_REMAINING NUMBER

Scan Unit Remaining to be Paid for Scan Data Offer
ACTIVITY_PRODUCT_ID NUMBER

Activity Product Id for Scan Data Offer
VOLUME_OFFER_TIERS_ID NUMBER

Volume Offer Tier id ( FK from table ams_volume_offer_tiers)
GL_POSTED_FLAG VARCHAR2 (1)
Gl Posted Flag
BILLTO_CUST_ACCOUNT_ID NUMBER

Bill_to Customer Account Id
REFERENCE_TYPE VARCHAR2 (30)
Reference Type
REFERENCE_ID NUMBER

Reference Id
MONTH_ID NUMBER

QUARTER_ID NUMBER

YEAR_ID NUMBER

ORDER_LINE_ID NUMBER

Order line Id for accrual
ORIG_UTILIZATION_ID NUMBER

original utilization id used for adjustment
SHIP_TO_SITE_USE_ID NUMBER

Ship to Site Use Id
BILL_TO_SITE_USE_ID NUMBER

Bill to Site Use Id
UNIV_CURR_AMOUNT NUMBER

Amount in TM reporting currency
UNIV_CURR_AMOUNT_REMAINING NUMBER

Amount Remaining in TM reporting currency
Query Text

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


SELECT UTILIZATION_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
,      UTILIZATION_TYPE
,      FUND_ID
,      PLAN_TYPE
,      PLAN_ID
,      COMPONENT_TYPE
,      COMPONENT_ID
,      OBJECT_TYPE
,      OBJECT_ID
,      ORDER_ID
,      INVOICE_ID
,      AMOUNT
,      ACCTD_AMOUNT
,      CURRENCY_CODE
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE_DATE
,      EXCHANGE_RATE
,      ADJUSTMENT_TYPE
,      ADJUSTMENT_DATE
,      OBJECT_VERSION_NUMBER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ORG_ID
,      SECURITY_GROUP_ID
,      CAMP_SCHEDULE_ID
,      ADJUSTMENT_TYPE_ID
,      AMS_ACTIVITY_BUDGET_ID
,      PRODUCT_ID
,      CUST_ACCOUNT_ID
,      GL_DATE
,      PRODUCT_LEVEL_TYPE
,      AMOUNT_REMAINING
,      ACCTD_AMOUNT_REMAINING
,      PRICE_ADJUSTMENT_ID
,      PLAN_CURR_AMOUNT
,      PLAN_CURR_AMOUNT_REMAINING
,      SCAN_UNIT
,      SCAN_UNIT_REMAINING
,      ACTIVITY_PRODUCT_ID
,      VOLUME_OFFER_TIERS_ID
,      GL_POSTED_FLAG
,      BILLTO_CUST_ACCOUNT_ID
,      REFERENCE_TYPE
,      REFERENCE_ID
,      MONTH_ID
,      QUARTER_ID
,      YEAR_ID
,      ORDER_LINE_ID
,      ORIG_UTILIZATION_ID
,      SHIP_TO_SITE_USE_ID
,      BILL_TO_SITE_USE_ID
,      UNIV_CURR_AMOUNT
,      UNIV_CURR_AMOUNT_REMAINING
FROM OZF.OZF_FUNDS_UTILIZED_ALL_B;

Dependencies

[top of page]

OZF.OZF_FUNDS_UTILIZED_ALL_B does not reference any database object

OZF.OZF_FUNDS_UTILIZED_ALL_B is referenced by following:

SchemaAPPS
Materialized ViewOZF_CUST_FUND_SUMMARY_MV
Materialized ViewOZF_EARNING_SUMMARY_MV
SynonymOZF_FUNDS_UTILIZED
SynonymOZF_FUNDS_UTILIZED_ALL_B