Product: | QP - Advanced Pricing |
---|---|
Description: | This view gives information about Coupon Issue type of modifier. |
Implementation/DBA Data: | APPS.QPFV_COUPON_ISSUES |
SELECT LL.LIST_HEADER_ID
, RLTD.TO_RLTD_MODIFIER_ID
, LL.LIST_LINE_NO
, LL.START_DATE_ACTIVE
, LL.END_DATE_ACTIVE
, LL.PRODUCT_PRECEDENCE
, LL.PRICING_PHASE_ID
, LL.PRICING_GROUP_SEQUENCE
, LL.EXPIRATION_PERIOD_START_DATE
, LL.NUMBER_EXPIRATION_PERIODS
, LL.EXPIRATION_DATE
, LL.ACCRUAL_FLAG
, LL.ESTIM_GL_VALUE
, LL.ACCRUAL_CONVERSION_RATE
, LL.EXPIRATION_PERIOD_UOM
, MTL.UNIT_OF_MEASURE
, LL.INCOMPATIBILITY_GRP_CODE
, '_LA:LL.INCOMPATIBILITY_GRP_CODE:QP_LOOKUPS:INCOMPATIBILITY_GROUPS:MEANING'
, LL.LIST_LINE_TYPE_CODE
, '_LA:LL.LIST_LINE_TYPE_CODE:QP_LOOKUPS:LIST_LINE_TYPE_CODE:MEANING'
, LL.PRICE_BREAK_TYPE_CODE
, '_LA:LL.PRICE_BREAK_TYPE_CODE:QP_LOOKUPS:PRICE_BREAK_TYPE_CODE:MEANING'
, LL.MODIFIER_LEVEL_CODE
, '_LA:LL.MODIFIER_LEVEL_CODE:QP_LOOKUPS:MODIFIER_LEVEL_CODE:MEANING'
, LL.LIST_LINE_ID
, LL.CREATION_DATE
, LL.CREATED_BY
, LL.LAST_UPDATE_DATE
, LL.LAST_UPDATED_BY
, '_DF:QP:QP_LIST_LINES:LL'
FROM QP_LIST_LINES LL
, QP_RLTD_MODIFIERS RLTD
, MTL_UNITS_OF_MEASURE MTL
WHERE LL.LIST_LINE_TYPE_CODE = 'CIE'
AND LL.LIST_LINE_ID = RLTD.FROM_RLTD_MODIFIER_ID
AND RLTD.RLTD_MODIFIER_GRP_TYPE = 'COUPON'
AND LL.EXPIRATION_PERIOD_UOM = MTL.UOM_CODE (+) WITH READ ONLY