[Home] [Help] [Dependency Information]
Object Name: | QP_DISCOUNT_MAPPING# |
---|---|
Object Type: | VIEW |
Owner: | QP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OLD_DISCOUNT_ID | NUMBER | |||
OLD_DISCOUNT_LINE_ID | NUMBER | |||
NEW_LIST_HEADER_ID | NUMBER | |||
NEW_LIST_LINE_ID | NUMBER | |||
OLD_PRICE_BREAK_LINES_LOW | NUMBER | |||
OLD_PRICE_BREAK_LINES_HIGH | NUMBER | |||
OLD_METHOD_TYPE_CODE | VARCHAR2 | (30) | ||
OLD_PRICE_BREAK_PERCENT | NUMBER | |||
OLD_PRICE_BREAK_PRICE | NUMBER | |||
OLD_PRICE_BREAK_AMOUNT | NUMBER | |||
NEW_TYPE | VARCHAR2 | (1) | ||
PRICING_CONTEXT | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT OLD_DISCOUNT_ID
, OLD_DISCOUNT_LINE_ID
, NEW_LIST_HEADER_ID
, NEW_LIST_LINE_ID
, OLD_PRICE_BREAK_LINES_LOW
, OLD_PRICE_BREAK_LINES_HIGH
, OLD_METHOD_TYPE_CODE
, OLD_PRICE_BREAK_PERCENT
, OLD_PRICE_BREAK_PRICE
, OLD_PRICE_BREAK_AMOUNT
, NEW_TYPE
, PRICING_CONTEXT
FROM QP.QP_DISCOUNT_MAPPING#;
|
|
|