0023145: Function OBDISC_XY_GIFT Does not compile in Oracle

Description

The error that shows in the SQL Manager when trying to recompile this function is:

Error(95,31): PL/SQL: ORA-00904: "IL"."QTYORDERED": identificador no válido

And the sentence that returns the error is:

                 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';

Steps To Reproduce

In description

Tags

No tags attached.

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

defect

0023113

closed

guilleaer

PL OBDISC_XY_GIFT is referencing a column that does not exist

Notes
(0057261) migueldejuana (viewer) 2013-03-14 16:57	I tested the functionality which launch this function and it works well. Perhaps, it has been resolved with the fix of the related issue.

Issue History
Date Modified	Username	Field	Change
2013-02-21 19:27	adrianromero	New Issue
2013-02-21 19:27	adrianromero	Assigned To	=> marvintm
2013-02-21 19:27	adrianromero	OBNetwork customer	=> No
2013-03-13 17:09	migueldejuana	Assigned To	marvintm => migueldejuana
2013-03-13 17:16	migueldejuana	Relationship added	related to 0023113
2013-03-14 16:57	migueldejuana	Review Assigned To	=> adrianromero
2013-03-14 16:57	migueldejuana	Note Added: 0057261
2013-03-14 16:57	migueldejuana	Status	new => closed
2013-03-14 16:57	migueldejuana	Resolution	open => no change required
2013-03-14 16:57	migueldejuana	Fixed in Version	=> RMP21