Patch 16303269 fails on file porep.odf
Hi All
We try to apply a patch 16303269 and we are getting error as -
The definition of the view PO_ALERT_CONTRACT_VIEW2 is incorrect.
The view text is incorrectly defined as:
SELECT ph.po_header_id, NVL(SUM(DECODE(c.minimum_accountable_unit, NULL,
ROUND ((pll.quantity - NVL(pll.quantity_cancelled, 0)) *
NVL(pll.price_override, 0), c.precision ), ROUND ((pll.quantity -
NVL(pll.quantity_cancelled, 0)) * NVL(pll.price_override, 0) /
c.minimum_accountable_unit ) * c.minimum_accountable_unit ) ), 0) FROM
PO_LINE_LOCATIONS_ALL PLL,PO_LINES_ALL PL,FND_CURRENCIES C,PO_HEADERS PH
WHERE ph.currency_code = c.currency_code AND pl.po_header_id =