[Home] [Help] [Dependency Information]
Object Name: | QPBV_COUPON_ISSUES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | QP.QPBV_COUPON_ISSUES |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view gives information about Coupon Issue type of modifier.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LIST_HEADER_ID | NUMBER | Yes | ||
BENEFIT_MODIFIER_LINE_ID | NUMBER | Yes | This is the list_line_id of the Benefit part of a Coupon. For example, Buy 1 Shampoo, get a coupon for 50% off on next purchase. BENEFIT_MODIFIER_LINE_ID is the list_line_id of the 50% off part of the Coupon issue. | |
LIST_LINE_NO | VARCHAR2 | (30) | Here is an example of a Coupon Issue - Buy 1 Shampoo, get a coupon for 50% off on next purchase. This is the list_line_id of the Buy 1 Shampoo part of a Coupon. | |
START_DATE_ACTIVE | DATE | |||
END_DATE_ACTIVE | DATE | |||
PRODUCT_PRECEDENCE | NUMBER | |||
PRICING_PHASE_ID | NUMBER | |||
PRICING_GROUP_SEQUENCE | NUMBER | |||
EXPIRATION_PERIOD_START_DATE | DATE | |||
NUMBER_EXPIRATION_PERIODS | NUMBER | |||
EXPIRATION_PERIOD_UOM | VARCHAR2 | (3) | ||
EXPIRATION_DATE | DATE | |||
ACCRUAL_FLAG | VARCHAR2 | (1) | ||
ESTIM_GL_VALUE | NUMBER | |||
ACCRUAL_CONVERSION_RATE | NUMBER | |||
INCOMPATIBILITY_GRP_CODE | VARCHAR2 | (30) | ||
LIST_LINE_TYPE_CODE | VARCHAR2 | (30) | Yes | |
PRICE_BREAK_TYPE_CODE | VARCHAR2 | (30) | ||
MODIFIER_LEVEL_CODE | VARCHAR2 | (30) | Yes | |
LIST_LINE_ID | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
ORIG_SYS_HEADER_REF | VARCHAR2 | (50) | The combination of this and ORIG_SYS_LINE_REF is the primary key of the equivalent of the price list line table of the external system from where the price data is loaded. | |
ORIG_SYS_LINE_REF | VARCHAR2 | (50) | The combination of this and ORIG_SYS_HEADER_REF is the primary key of the equivalent of the price list line table of the external system from where the price data is loaded. |
Cut, paste (and edit) the following text to query this object:
SELECT LIST_HEADER_ID
, BENEFIT_MODIFIER_LINE_ID
, LIST_LINE_NO
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, PRODUCT_PRECEDENCE
, PRICING_PHASE_ID
, PRICING_GROUP_SEQUENCE
, EXPIRATION_PERIOD_START_DATE
, NUMBER_EXPIRATION_PERIODS
, EXPIRATION_PERIOD_UOM
, EXPIRATION_DATE
, ACCRUAL_FLAG
, ESTIM_GL_VALUE
, ACCRUAL_CONVERSION_RATE
, INCOMPATIBILITY_GRP_CODE
, LIST_LINE_TYPE_CODE
, PRICE_BREAK_TYPE_CODE
, MODIFIER_LEVEL_CODE
, LIST_LINE_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, ORIG_SYS_HEADER_REF
, ORIG_SYS_LINE_REF
FROM APPS.QPBV_COUPON_ISSUES;
APPS.QPBV_COUPON_ISSUES is not referenced by any database object
|
|
|