[Home] [Help] [Dependency Information]
Object Name: | OZF_OFFER_DISCOUNT_LINES# |
---|---|
Object Type: | VIEW |
Owner: | OZF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OFFER_DISCOUNT_LINE_ID | NUMBER | Yes | ||
PARENT_DISCOUNT_LINE_ID | NUMBER | |||
VOLUME_FROM | NUMBER | |||
VOLUME_TO | NUMBER | |||
VOLUME_OPERATOR | VARCHAR2 | (30) | ||
VOLUME_TYPE | VARCHAR2 | (30) | ||
VOLUME_BREAK_TYPE | VARCHAR2 | (30) | ||
DISCOUNT | NUMBER | |||
DISCOUNT_TYPE | VARCHAR2 | (30) | ||
TIER_TYPE | VARCHAR2 | (30) | Yes | |
TIER_LEVEL | VARCHAR2 | (30) | Yes | |
INCOMPATIBILITY_GROUP | VARCHAR2 | (30) | ||
PRECEDENCE | NUMBER | |||
BUCKET | VARCHAR2 | (30) | ||
SCAN_VALUE | NUMBER | |||
SCAN_DATA_QUANTITY | NUMBER | |||
SCAN_UNIT_FORECAST | NUMBER | |||
CHANNEL_ID | NUMBER | |||
ADJUSTMENT_FLAG | VARCHAR2 | (1) | ||
START_DATE_ACTIVE | DATE | |||
END_DATE_ACTIVE | DATE | |||
UOM_CODE | VARCHAR2 | (30) | ||
CREATION_DATE | DATE | |||
CREATED_BY | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
OBJECT_VERSION_NUMBER | NUMBER | |||
OFFER_ID | NUMBER | Yes | ||
FORMULA_ID | NUMBER | |||
PRICING_PHASE_ID | NUMBER | |||
PRINT_ON_INVOICE_FLAG | NUMBER | |||
CONTEXT | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (240) | ||
ATTRIBUTE2 | VARCHAR2 | (240) | ||
ATTRIBUTE3 | VARCHAR2 | (240) | ||
ATTRIBUTE4 | VARCHAR2 | (240) | ||
ATTRIBUTE5 | VARCHAR2 | (240) | ||
ATTRIBUTE6 | VARCHAR2 | (240) | ||
ATTRIBUTE7 | VARCHAR2 | (240) | ||
ATTRIBUTE8 | VARCHAR2 | (240) | ||
ATTRIBUTE9 | VARCHAR2 | (240) | ||
ATTRIBUTE10 | VARCHAR2 | (240) | ||
ATTRIBUTE11 | VARCHAR2 | (240) | ||
ATTRIBUTE12 | VARCHAR2 | (240) | ||
ATTRIBUTE13 | VARCHAR2 | (240) | ||
ATTRIBUTE14 | VARCHAR2 | (240) | ||
ATTRIBUTE15 | VARCHAR2 | (240) |
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#;
|
|
|