APPS.OE_OE_PRICING_AVAILABILITY dependencies on OE_ORDER_LINES_ALL

Line 8223: from oe_order_lines_all

8219: end if;
8220: begin
8221: select booked_flag, shipping_interfaced_flag
8222: into l_booked_flag, l_shipping_interfaced_flag
8223: from oe_order_lines_all
8224: where header_id = l_header_rec.header_id
8225: and rownum = 1;
8226: oe_Debug_pub.add('booked_flag'||l_booked_flag ||'shipping interfaced flag'||l_shipping_interfaced_flag);
8227: Exception

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

8225: and rownum = 1;
8226: oe_Debug_pub.add('booked_flag'||l_booked_flag ||'shipping interfaced flag'||l_shipping_interfaced_flag);
8227: Exception
8228: When others then
8229: oe_debug_pub.add('error while querying the oe_order_lines_all'||SQLERRM||SQLCODE);
8230: End;
8231:
8232: if l_debug_level >0 then
8233: oe_Debug_pub.add('booked_flag'||l_booked_flag ||'shipping interfaced flag'||l_shipping_interfaced_flag);