APPS.OE_OE_PRICING_AVAILABILITY dependencies on OE_ORDER_LINES_ALL

Line 8198: from oe_order_lines_all

8194: end if;
8195: begin
8196: select booked_flag, shipping_interfaced_flag
8197: into l_booked_flag, l_shipping_interfaced_flag
8198: from oe_order_lines_all
8199: where header_id = l_header_rec.header_id
8200: and rownum = 1;
8201: oe_Debug_pub.add('booked_flag'||l_booked_flag ||'shipping interfaced flag'||l_shipping_interfaced_flag);
8202: Exception

Line 8204: oe_debug_pub.add('error while querying the oe_order_lines_all'||SQLERRM||SQLCODE);

8200: and rownum = 1;
8201: oe_Debug_pub.add('booked_flag'||l_booked_flag ||'shipping interfaced flag'||l_shipping_interfaced_flag);
8202: Exception
8203: When others then
8204: oe_debug_pub.add('error while querying the oe_order_lines_all'||SQLERRM||SQLCODE);
8205: End;
8206:
8207: if l_debug_level >0 then
8208: oe_Debug_pub.add('booked_flag'||l_booked_flag ||'shipping interfaced flag'||l_shipping_interfaced_flag);