DBA Data[Home] [Help]

APPS.JAI_AR_TRX_PKG dependencies on OE_ORDER_LINES_ALL

Line 146: OR order_line_id in (SELECT line_id FROM oe_order_lines_all

142: FROM JAI_OM_WSH_LINES_ALL
143: WHERE delivery_id = p_delivery_id
144: AND (order_line_id = p_order_line_id
145: /* Added for bug#6391684, Starts */
146: OR order_line_id in (SELECT line_id FROM oe_order_lines_all
147: WHERE header_id in (SELECT header_id
148: FROM oe_order_lines_all
149: WHERE line_id = p_order_line_id)
150: AND item_type_code = 'CONFIG')

Line 148: FROM oe_order_lines_all

144: AND (order_line_id = p_order_line_id
145: /* Added for bug#6391684, Starts */
146: OR order_line_id in (SELECT line_id FROM oe_order_lines_all
147: WHERE header_id in (SELECT header_id
148: FROM oe_order_lines_all
149: WHERE line_id = p_order_line_id)
150: AND item_type_code = 'CONFIG')
151: ) /* Added for bug#6391684, Ends */
152: AND ( excise_invoice_no IS NOT NULL OR vat_invoice_no IS NOT NULL ) ; -- Bug Fixed 5894175