[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OZF_OFFER_DISCOUNT_LINES |
|---|---|
| Object Type: | TABLE |
| Owner: | OZF |
| FND Design Data: |  OZF.OZF_OFFER_DISCOUNT_LINES
|
| Subobject Name: | |
| Status: | VALID |
This table stores the discount lines for a net accrual offer.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OZF_OFFER_DISCOUNT_LINES_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 OFFER_DISCOUNT_LINE_ID
|
| OZF_OFFER_DISCOUNT_LINES_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
OFFER_ID
|
| OZF_OFFER_DISCOUNT_LINES_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PARENT_DISCOUNT_LINE_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| OFFER_DISCOUNT_LINE_ID | NUMBER | Yes | Unique Identifier | |
| PARENT_DISCOUNT_LINE_ID | NUMBER | Unique Identifier of the Parent Discount Line | ||
| VOLUME_FROM | NUMBER | Start Value of the volume range | ||
| VOLUME_TO | NUMBER | End Value of the volume range | ||
| VOLUME_OPERATOR | VARCHAR2 | (30) | Arithmatic operator for Volume range | |
| VOLUME_TYPE | VARCHAR2 | (30) | Type of Volume. Amount or Quantity | |
| VOLUME_BREAK_TYPE | VARCHAR2 | (30) | Volume break type. Point or Range | |
| DISCOUNT | NUMBER | Discount Value | ||
| DISCOUNT_TYPE | VARCHAR2 | (30) | Type of Discount. Percent or Amount | |
| TIER_TYPE | VARCHAR2 | (30) | Yes | Tier Type used for the discount. |
| TIER_LEVEL | VARCHAR2 | (30) | Yes | Tier Level |
| INCOMPATIBILITY_GROUP | VARCHAR2 | (30) | Incompatibility Group | |
| PRECEDENCE | NUMBER | Precedence | ||
| BUCKET | VARCHAR2 | (30) | Bucket | |
| SCAN_VALUE | NUMBER | Scan Value | ||
| SCAN_DATA_QUANTITY | NUMBER | Scan Data Quantity | ||
| SCAN_UNIT_FORECAST | NUMBER | Scan Unit Forecast | ||
| CHANNEL_ID | NUMBER | Unique Identifier of Marketing Medium | ||
| ADJUSTMENT_FLAG | VARCHAR2 | (1) | Indicates if this line has been adjusted or not | |
| START_DATE_ACTIVE | DATE | Start Date Active | ||
| END_DATE_ACTIVE | DATE | End Date Active | ||
| UOM_CODE | VARCHAR2 | (30) | Unit Of Measure | |
| CREATION_DATE | DATE | Standard WHO Column | ||
| CREATED_BY | NUMBER | Standard WHO Column | ||
| LAST_UPDATE_DATE | DATE | Standard WHO Column | ||
| LAST_UPDATED_BY | NUMBER | Standard WHO Column | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard WHO Column | ||
| OBJECT_VERSION_NUMBER | NUMBER | Standard WHO Column | ||
| OFFER_ID | NUMBER | Yes | Unique Identifier of the Offer | |
| FORMULA_ID | NUMBER | Identifier of the formula for getting discount | ||
| PRICING_PHASE_ID | NUMBER | Pricing phase id | ||
| PRINT_ON_INVOICE_FLAG | NUMBER | Print on invoice flag | ||
| CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining Column | |
| ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive Flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Flexfield segment |
Cut, paste (and edit) the following text to query this object:
SELECT OFFER_DISCOUNT_LINE_ID
, PARENT_DISCOUNT_LINE_ID
, VOLUME_FROM
, VOLUME_TO
, VOLUME_OPERATOR
, VOLUME_TYPE
, VOLUME_BREAK_TYPE
, DISCOUNT
, DISCOUNT_TYPE
, TIER_TYPE
, TIER_LEVEL
, INCOMPATIBILITY_GROUP
, PRECEDENCE
, BUCKET
, SCAN_VALUE
, SCAN_DATA_QUANTITY
, SCAN_UNIT_FORECAST
, CHANNEL_ID
, ADJUSTMENT_FLAG
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, UOM_CODE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, OFFER_ID
, FORMULA_ID
, PRICING_PHASE_ID
, PRINT_ON_INVOICE_FLAG
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM OZF.OZF_OFFER_DISCOUNT_LINES;
OZF.OZF_OFFER_DISCOUNT_LINES does not reference any database object
OZF.OZF_OFFER_DISCOUNT_LINES is referenced by following:
OZF
OZF_OFFER_DISCOUNT_LINES#
|
|
|
|