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

TABLE: OZF.OZF_VOLUME_SUMMARY

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


This table stores accumulated volume for volume offers


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OZF_VOLUME_SUMMARY_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOFFER_ID
Columns
Name Datatype Length Mandatory Comments
VOLUME_SUMMARY_ID NUMBER
Yes Unique identifier of volume summary
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
OFFER_ID NUMBER
Yes Identifier of offer
QP_LIST_HEADER_ID NUMBER

Identifier of QP list header
GROUP_NO NUMBER

Qualifier group number
GROUP_VOLUME NUMBER

Accumulated volume of qualifying group
INDIVIDUAL_TYPE VARCHAR2 (30)
Volume tracking type for individual customer
INDIVIDUAL_ID NUMBER

Customer account id, bill to site use id or ship to site use id depending on individual_type
INDIVIDUAL_VOLUME NUMBER

Accumulated volume for individual customer
PBH_LINE_ID NUMBER
Yes Identifier of price break header (PBH) to which product belongs
Query Text

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


SELECT VOLUME_SUMMARY_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OFFER_ID
,      QP_LIST_HEADER_ID
,      GROUP_NO
,      GROUP_VOLUME
,      INDIVIDUAL_TYPE
,      INDIVIDUAL_ID
,      INDIVIDUAL_VOLUME
,      PBH_LINE_ID
FROM OZF.OZF_VOLUME_SUMMARY;

Dependencies

[top of page]

OZF.OZF_VOLUME_SUMMARY does not reference any database object

OZF.OZF_VOLUME_SUMMARY is referenced by following:

SchemaAPPS
SynonymOZF_VOLUME_SUMMARY