DBA Data[Home] [Help]

APPS.JAI_AR_TRX_PKG dependencies on OE_ORDER_LINES_ALL

Line 215: OR order_line_id in (SELECT line_id FROM oe_order_lines_all

211: WHERE (delivery_id IS NULL OR delivery_id = p_delivery_id)
212: -- modified by Allen Yang for bug 9485355 (12.1.3 non-shippable Enhancement), end
213: AND (order_line_id = p_order_line_id
214: /* Added for bug#6391684, Starts */
215: OR order_line_id in (SELECT line_id FROM oe_order_lines_all
216: WHERE header_id in (SELECT header_id
217: FROM oe_order_lines_all
218: WHERE line_id = p_order_line_id)
219: AND item_type_code = 'CONFIG')

Line 217: FROM oe_order_lines_all

213: AND (order_line_id = p_order_line_id
214: /* Added for bug#6391684, Starts */
215: OR order_line_id in (SELECT line_id FROM oe_order_lines_all
216: WHERE header_id in (SELECT header_id
217: FROM oe_order_lines_all
218: WHERE line_id = p_order_line_id)
219: AND item_type_code = 'CONFIG')
220: ) /* Added for bug#6391684, Ends */
221: AND ( excise_invoice_no IS NOT NULL OR vat_invoice_no IS NOT NULL ) ; -- Bug Fixed 5894175