263: NULL
264: ) osa_flag
265: FROM rcv_headers_interface rsh,
266: rcv_transactions_interface rti,
267: po_line_locations_all poll
268: WHERE rsh.asn_type = 'ASBN'
269: AND rsh.header_interface_id = rti.header_interface_id
270: AND poll.line_location_id (+) = rti.po_line_location_id
271: AND rti.processing_status_code = 'RUNNING')
960: END IF;
961:
962: SELECT count(*)
963: INTO l_drop_ship_exists
964: FROM po_line_locations_all plla,
965: rcv_transactions_interface rti
966: WHERE rti.header_interface_id = x_header_record.header_record.header_interface_id
967: and rti.po_line_location_id = plla.line_location_id
968: and plla.drop_ship_flag = 'Y';