DBA Data[Home] [Help]

APPS.OE_LINE_UTIL dependencies on WSH_DELIVERY_DETAILS

Line 868: FROM wsh_delivery_details wdd

864: IF Nvl(p_x_line_rec.shipping_interfaced_flag,'N')='Y' THEN
865:
866: SELECT Count(1)
867: INTO l_ship_inv_count
868: FROM wsh_delivery_details wdd
869: WHERE wdd.source_code='OE'
870: AND wdd.source_line_id=p_x_line_rec.line_id
871: AND (wdd.released_status IN ('C','I')
872: OR oe_interfaced_flag='Y');

Line 24769: FROM wsh_delivery_details

24765: BEGIN
24766:
24767: SELECT count(1)
24768: INTO l_delivery_detail_count
24769: FROM wsh_delivery_details
24770: WHERE source_code = 'OE'
24771: AND source_line_id = p_line_id
24772: AND released_status NOT IN ('C','D');
24773: