0023113: PL OBDISC_XY_GIFT is referencing a column that does not exist

Description

PL OBDISC_XY_GIFT is referencing a column that does not exist. Purchase and sales invoices can not be booked under some conditions

Steps To Reproduce

- il.qtyordered column does not exist

select floor(il.qtyordered / coalesce(op.em_obdisc_qty + op.em_obdisc_gifqty, 1))
into v_gift_chunks
from c_invoiceline il, m_offer_product op
where il.c_invoice_id = v_docId
and op.m_product_id = il.m_product_id
and op.m_offer_id = p_rule_id
and op.em_obdisc_is_gift = 'Y';

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

defect

0023145

closed

migueldejuana

Function OBDISC_XY_GIFT Does not compile in Oracle

Notes
(0056553) hgbot (developer) 2013-02-19 21:49	Repository: erp/pmods/org.openbravo.retail.discounts Changeset: 0dc9623b7cff8cc65841c9cb70aad73a45f11973 Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com> Date: Tue Feb 19 21:48:37 2013 +0100 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.discounts/rev/0dc9623b7cff8cc65841c9cb70aad73a45f11973 [^] fixed issue 23113: qtyinvoiced column is used instead of qtyordered wich not exists --- M src-db/database/model/functions/OBDISC_XY_GIFT.xml ---

Issue History
Date Modified	Username	Field	Change
2013-02-19 12:06	jonalegriaesarte	New Issue
2013-02-19 12:06	jonalegriaesarte	Assigned To	=> guilleaer
2013-02-19 12:06	jonalegriaesarte	OBNetwork customer	=> Yes
2013-02-19 21:49	hgbot	Checkin
2013-02-19 21:49	hgbot	Note Added: 0056553
2013-02-19 21:49	hgbot	Status	new => resolved
2013-02-19 21:49	hgbot	Resolution	open => fixed
2013-02-19 21:49	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/pmods/org.openbravo.retail.discounts/rev/0dc9623b7cff8cc65841c9cb70aad73a45f11973 [^]
2013-03-04 10:55	marvintm	Review Assigned To	=> marvintm
2013-03-04 10:55	marvintm	Status	resolved => closed
2013-03-13 17:16	migueldejuana	Relationship added	related to 0023145