DBA Data[Home] [Help]

APPS.INV_LOGICAL_TRANSACTIONS_PVT dependencies on OE_DROP_SHIP_SOURCES

Line 569: FROM oe_drop_ship_sources odss, rcv_transactions RT

565: -- get the start active and end active dates and make sure that
566: -- transaction date is between them.
567: BEGIN
568: SELECT odss.header_id INTO l_so_header_id
569: FROM oe_drop_ship_sources odss, rcv_transactions RT
570: WHERE odss.line_location_id = rt.po_line_location_id AND
571: rt.transaction_id = p_mtl_trx_tbl(i).rcv_transaction_id
572: GROUP BY odss.header_id;
573: EXCEPTION