VIEW: APPS.OZF_PRODUCT_OFFERS_V

Source

View Text - Preformatted

SELECT qlh.name ,qlh.description ,qlh.ask_for_flag request_only ,qlh.active_flag ,offr.offer_type ,offr.reusable ,OZF_UTILITY_PVT.GET_LOOKUP_MEANING('OZF_OFFER_TYPE',offr.offer_type) Offer_type_meaning ,qlh.start_date_active ,qlh.end_date_active ,qll.operand ,qll.product_precedence ,qpa.product_attr_value product_id ,decode(offr.offer_type,'OFF_INVOICE',QP_QP_Form_Pricing_Attr.Get_Meaning(qll.arithmetic_operator, 'ARITHMETIC_OPERATOR'),NULL) operator ,QP_QP_Form_Pricing_Attr.Get_Pricing_Phase(qll.pricing_phase_id) phase ,QP_QP_Form_Pricing_Attr.Get_Meaning(qll.incompatibility_grp_code, 'INCOMPATIBILITY_GROUPS') incompatibility ,QP_QP_Form_Pricing_Attr.Get_Meaning(qll.modifier_level_code, 'MODIFIER_LEVEL_CODE') discount_level ,QP_QP_Form_Pricing_Attr.Get_Meaning(qll.list_line_type_code, 'LIST_LINE_TYPE_CODE') line_type ,QP_QP_Form_Pricing_Attr.Get_Meaning(qll.price_break_type_code, 'PRICE_BREAK_TYPE_CODE') Price_break ,AMS_UTILITY_PVT.GET_UOM_NAME(qpa.product_uom_code) Unit_of_measure from qp_list_headers_vl qlh, ozf_offers offr, qp_list_lines qll, qp_pricing_attributes qpa WHERE qlh.list_header_id = offr.qp_list_header_id and qlh.list_header_id = qll.list_header_id and qll.list_line_id = qpa.list_line_id and nvl(qll.end_date_active,sysdate+1) > sysdate and nvl(qlh.end_date_active,sysdate+1) > sysdate and qpa.excluder_flag = 'N' order by qlh.name

View Text - HTML Formatted

SELECT QLH.NAME
, QLH.DESCRIPTION
, QLH.ASK_FOR_FLAG REQUEST_ONLY
, QLH.ACTIVE_FLAG
, OFFR.OFFER_TYPE
, OFFR.REUSABLE
, OZF_UTILITY_PVT.GET_LOOKUP_MEANING('OZF_OFFER_TYPE'
, OFFR.OFFER_TYPE) OFFER_TYPE_MEANING
, QLH.START_DATE_ACTIVE
, QLH.END_DATE_ACTIVE
, QLL.OPERAND
, QLL.PRODUCT_PRECEDENCE
, QPA.PRODUCT_ATTR_VALUE PRODUCT_ID
, DECODE(OFFR.OFFER_TYPE
, 'OFF_INVOICE'
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QLL.ARITHMETIC_OPERATOR
, 'ARITHMETIC_OPERATOR')
, NULL) OPERATOR
, QP_QP_FORM_PRICING_ATTR.GET_PRICING_PHASE(QLL.PRICING_PHASE_ID) PHASE
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QLL.INCOMPATIBILITY_GRP_CODE
, 'INCOMPATIBILITY_GROUPS') INCOMPATIBILITY
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QLL.MODIFIER_LEVEL_CODE
, 'MODIFIER_LEVEL_CODE') DISCOUNT_LEVEL
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QLL.LIST_LINE_TYPE_CODE
, 'LIST_LINE_TYPE_CODE') LINE_TYPE
, QP_QP_FORM_PRICING_ATTR.GET_MEANING(QLL.PRICE_BREAK_TYPE_CODE
, 'PRICE_BREAK_TYPE_CODE') PRICE_BREAK
, AMS_UTILITY_PVT.GET_UOM_NAME(QPA.PRODUCT_UOM_CODE) UNIT_OF_MEASURE
FROM QP_LIST_HEADERS_VL QLH
, OZF_OFFERS OFFR
, QP_LIST_LINES QLL
, QP_PRICING_ATTRIBUTES QPA
WHERE QLH.LIST_HEADER_ID = OFFR.QP_LIST_HEADER_ID
AND QLH.LIST_HEADER_ID = QLL.LIST_HEADER_ID
AND QLL.LIST_LINE_ID = QPA.LIST_LINE_ID
AND NVL(QLL.END_DATE_ACTIVE
, SYSDATE+1) > SYSDATE
AND NVL(QLH.END_DATE_ACTIVE
, SYSDATE+1) > SYSDATE
AND QPA.EXCLUDER_FLAG = 'N' ORDER BY QLH.NAME