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

TABLE: OZF.OZF_OFFER_ADJUSTMENT_LINES

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


This table stores the disount adjustment for each discount level define in the Offer.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
OZF_OFFER_ADJUSTMENT_LINES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnOFFER_ADJUSTMENT_LINE_ID
OZF_OFFER_ADJUSTMENT_LINES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOFFER_ADJUSTMENT_ID
OZF_OFFER_ADJUSTMENT_LINES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLIST_LINE_ID
OZF_OFFER_ADJUSTMENT_LINES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLIST_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
OFFER_ADJUSTMENT_LINE_ID NUMBER
Yes Offer Adjustment Line Identifier
OFFER_ADJUSTMENT_ID NUMBER
Yes Offer Adjustment Identifier
LIST_LINE_ID NUMBER
Yes List line identifier that stores the offer discount level information.
ARITHMETIC_OPERATOR VARCHAR2 (30)
Arithmetic Operator
ORIGINAL_DISCOUNT NUMBER

Original Discount
MODIFIED_DISCOUNT NUMBER

Modified Discount
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER
Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
CREATED_BY NUMBER
Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
OBJECT_VERSION_NUMBER NUMBER

This column is used for locking purposes
SECURITY_GROUP_ID NUMBER

Used in hosting environment.
LIST_HEADER_ID NUMBER
Yes Identifier of the list header that stores original offer discount
ACCRUAL_FLAG VARCHAR2 (1)
Flag that indicates if the original dicount line is accrual type or not
LIST_LINE_ID_TD NUMBER

Identifier of related trade deal discount line
ORIGINAL_DISCOUNT_TD NUMBER

Original related trade deal line discount
MODIFIED_DISCOUNT_TD NUMBER

Modified dicsount for trade deal line
QUANTITY NUMBER

Quantity
CREATED_FROM_ADJUSTMENTS VARCHAR2 (1)
Indicates if the line has been added from Adjustments Screen
DISCOUNT_END_DATE DATE

End date of the adjustment line
Query Text

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


SELECT OFFER_ADJUSTMENT_LINE_ID
,      OFFER_ADJUSTMENT_ID
,      LIST_LINE_ID
,      ARITHMETIC_OPERATOR
,      ORIGINAL_DISCOUNT
,      MODIFIED_DISCOUNT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      LIST_HEADER_ID
,      ACCRUAL_FLAG
,      LIST_LINE_ID_TD
,      ORIGINAL_DISCOUNT_TD
,      MODIFIED_DISCOUNT_TD
,      QUANTITY
,      CREATED_FROM_ADJUSTMENTS
,      DISCOUNT_END_DATE
FROM OZF.OZF_OFFER_ADJUSTMENT_LINES;

Dependencies

[top of page]

OZF.OZF_OFFER_ADJUSTMENT_LINES does not reference any database object

OZF.OZF_OFFER_ADJUSTMENT_LINES is referenced by following:

SchemaOZF
ViewOZF_OFFER_ADJUSTMENT_LINES#