eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: OZF.OZF_ORDER_GROUP_PROD

Object Details

Object Name:	OZF_ORDER_GROUP_PROD
Object Type:	TABLE
Owner:	OZF
FND Design Data:	OZF.OZF_ORDER_GROUP_PROD
Subobject Name:
Status:	VALID

This table stores order line info with qualifying product and market qualifiers

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OZF_ORDER_GROUP_PROD_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OFFER_ID
OZF_ORDER_GROUP_PROD_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OFFER_ID ORDER_LINE_ID INDIRECT_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
ORDER_GROUP_PROD_ID	NUMBER		Yes	Unique identifier of an order line, market qualifier group and product combination
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			Identifier of offer
QP_LIST_HEADER_ID	NUMBER			List header id of offer
ORDER_LINE_ID	NUMBER			Identifier of order line
GROUP_NO	NUMBER			Qualifier group number
VOLUME_TRACK_TYPE	VARCHAR2	(30)		Volume tracking level code
COMBINE_SCHEDULE_YN	VARCHAR2	(1)		Combine discount structure flag
PBH_LINE_ID	NUMBER			Identifier of price break header (PBH) to which product belongs
VOLUME_TYPE	VARCHAR2	(30)		Volume type of PBH
PROD_ATTRIBUTE	VARCHAR2	(30)		Product attribute
PROD_ATTR_VALUE	VARCHAR2	(240)		Product attribute value
APPLY_DISCOUNT_FLAG	VARCHAR2	(1)		Apply discount to product flag
INCLUDE_VOLUME_FLAG	VARCHAR2	(1)		Include volume of product in volume accumulation flag
INDIRECT_FLAG	VARCHAR2	(1)		Indirect flag for the order line

Query Text

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


SELECT ORDER_GROUP_PROD_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OFFER_ID
,      QP_LIST_HEADER_ID
,      ORDER_LINE_ID
,      GROUP_NO
,      VOLUME_TRACK_TYPE
,      COMBINE_SCHEDULE_YN
,      PBH_LINE_ID
,      VOLUME_TYPE
,      PROD_ATTRIBUTE
,      PROD_ATTR_VALUE
,      APPLY_DISCOUNT_FLAG
,      INCLUDE_VOLUME_FLAG
,      INDIRECT_FLAG
FROM OZF.OZF_ORDER_GROUP_PROD;

Dependencies

[top of page]

OZF.OZF_ORDER_GROUP_PROD does not reference any database object

OZF.OZF_ORDER_GROUP_PROD is referenced by following:

OZF: OZF_ORDER_GROUP_PROD#