APPS.OE_INVOICE_PUB dependencies on OE_DROP_SHIP_SOURCES

Line 6035: FROM rcv_transactions t , oe_drop_ship_sources s

6031: --following line added for bug 3712551
6032: IF(p_line_rec.actual_shipment_date is null) THEN
6033: SELECT nvl ( max ( transaction_date ) , sysdate )
6034: INTO p_x_interface_line_rec.ship_date_actual
6035: FROM rcv_transactions t , oe_drop_ship_sources s
6036: WHERE t.po_header_id = s.po_header_id
6037: AND t.po_line_location_id = s.line_location_id
6038: AND transaction_type = 'RECEIVE'
6039: AND s.line_id = p_line_rec.line_id;