APPS.OE_INVOICE_PUB dependencies on OE_DROP_SHIP_SOURCES

Line 6280: FROM rcv_transactions t , oe_drop_ship_sources s

6276: --following line added for bug 3712551
6277: IF(p_line_rec.actual_shipment_date is null) THEN
6278: SELECT nvl ( max ( transaction_date ) , sysdate )
6279: INTO p_x_interface_line_rec.ship_date_actual
6280: FROM rcv_transactions t , oe_drop_ship_sources s
6281: WHERE t.po_header_id = s.po_header_id
6282: AND t.po_line_location_id = s.line_location_id
6283: AND transaction_type = 'RECEIVE'
6284: AND s.line_id = p_line_rec.line_id;