24160: END IF;
24161:
24162: SELECT count(*)
24163: INTO l_count
24164: FROM oe_drop_ship_sources
24165: WHERE line_id = p_x_line_rec.line_id
24166: AND header_id = p_x_line_rec.header_id;
24167:
24168: IF l_count = 0 THEN
24242: BEGIN
24243: SELECT Count(1)
24244: INTO l_rcv_count
24245: FROM rcv_transactions rcv,
24246: oe_drop_ship_sources odss,
24247: po_line_locations_all pol
24248: WHERE rcv.PO_LINE_ID=odss.po_line_id
24249: AND pol.line_location_id=odss.line_location_id
24250: AND odss.line_id=p_x_line_rec.line_id