APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on OE_DROP_SHIP_SOURCES

Line 1918: FROM oe_drop_ship_sources odss, rcv_transactions rt

1914: BEGIN
1915: l_progress := 220;
1916: SELECT MAX(odss.line_id), odss.header_id
1917: INTO l_mtl_trx_tbl(1).trx_source_line_id, l_oe_header_id
1918: FROM oe_drop_ship_sources odss, rcv_transactions rt
1919: WHERE rt.transaction_id = l_mtl_trx_tbl(1).rcv_transaction_id
1920: AND rt.po_line_location_id = odss.line_location_id
1921: GROUP BY odss.header_id;
1922:

Line 1960: FROM oe_drop_ship_sources odss,

1956: SELECT MAX(odss.line_id),
1957: mso.sales_order_id
1958: INTO l_mtl_trx_tbl(1).trx_source_line_id,
1959: l_mtl_trx_tbl(1).transaction_source_id
1960: FROM oe_drop_ship_sources odss,
1961: rcv_transactions rt,
1962: mtl_sales_orders mso,
1963: oe_order_headers_all ooha
1964: WHERE rt.transaction_id = l_mtl_trx_tbl(1).rcv_transaction_id