DBA Data[Home] [Help]

APPS.OE_LINE_UTIL dependencies on WSH_DELIVERY_DETAILS

Line 648: FROM wsh_delivery_details wdd

644: IF Nvl(p_x_line_rec.shipping_interfaced_flag,'N')='Y' THEN
645:
646: SELECT Count(1)
647: INTO l_ship_inv_count
648: FROM wsh_delivery_details wdd
649: WHERE wdd.source_code='OE'
650: AND wdd.source_line_id=p_x_line_rec.line_id
651: AND (wdd.released_status IN ('C','I')
652: OR oe_interfaced_flag='Y');