DBA Data[Home] [Help]

APPS.INV_INV_LOVS dependencies on OE_ORDER_HEADERS_ALL

Line 189: oe_order_headers_all ooha,oe_order_lines_all oola

185: /* Bug 12595030. Added the below condition to validate lot numbers
186: if the 'validate lot on rma receipt' value is 'Restricted' */
187: AND ((l_enforce_rma_lot_num <> 'R') OR (p_rma IS NULL) OR
188: (EXISTS (SELECT 'Y' FROM oe_lot_serial_numbers olsn,
189: oe_order_headers_all ooha,oe_order_lines_all oola
190: WHERE ooha.order_number = p_rma
191: AND oola.header_id = ooha.header_id
192: AND oola.inventory_item_id = p_item_id
193: AND olsn.line_id = oola.line_id