VIEW: APPS.QPBV_COUPON_ISSUES

Source

View Text - Preformatted

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_PERIOD_UOM ,ll.EXPIRATION_DATE ,ll.ACCRUAL_FLAG ,ll.ESTIM_GL_VALUE ,ll.ACCRUAL_CONVERSION_RATE ,ll.INCOMPATIBILITY_GRP_CODE ,ll.LIST_LINE_TYPE_CODE ,ll.PRICE_BREAK_TYPE_CODE ,ll.MODIFIER_LEVEL_CODE ,ll.LIST_LINE_ID ,ll.CREATION_DATE ,ll.CREATED_BY ,ll.LAST_UPDATE_DATE ,ll.LAST_UPDATED_BY ,ll.ORIG_SYS_HEADER_REF ,ll.ORIG_SYS_LINE_REF from qp_list_lines ll, qp_rltd_modifiers rltd WHERE ll.list_line_type_code = 'CIE' and ll.list_line_id = rltd.from_rltd_modifier_id and rltd.rltd_modifier_grp_type = 'COUPON'

View Text - HTML Formatted

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_PERIOD_UOM
, LL.EXPIRATION_DATE
, LL.ACCRUAL_FLAG
, LL.ESTIM_GL_VALUE
, LL.ACCRUAL_CONVERSION_RATE
, LL.INCOMPATIBILITY_GRP_CODE
, LL.LIST_LINE_TYPE_CODE
, LL.PRICE_BREAK_TYPE_CODE
, LL.MODIFIER_LEVEL_CODE
, LL.LIST_LINE_ID
, LL.CREATION_DATE
, LL.CREATED_BY
, LL.LAST_UPDATE_DATE
, LL.LAST_UPDATED_BY
, LL.ORIG_SYS_HEADER_REF
, LL.ORIG_SYS_LINE_REF
FROM QP_LIST_LINES LL
, QP_RLTD_MODIFIERS RLTD
WHERE LL.LIST_LINE_TYPE_CODE = 'CIE'
AND LL.LIST_LINE_ID = RLTD.FROM_RLTD_MODIFIER_ID
AND RLTD.RLTD_MODIFIER_GRP_TYPE = 'COUPON'