APPS.INV_LOGICAL_TRANSACTIONS_PUB dependencies on RCV_TRANSACTIONS

Line 1901: FROM oe_drop_ship_sources odss, rcv_transactions rt

1897: BEGIN
1898: l_progress := 220;
1899: SELECT MAX(odss.line_id), odss.header_id
1900: INTO l_mtl_trx_tbl(1).trx_source_line_id, l_oe_header_id
1901: FROM oe_drop_ship_sources odss, rcv_transactions rt
1902: WHERE rt.transaction_id = l_mtl_trx_tbl(1).rcv_transaction_id
1903: AND rt.po_line_location_id = odss.line_location_id
1904: GROUP BY odss.header_id;
1905:

Line 1944: rcv_transactions rt,

1940: mso.sales_order_id
1941: INTO l_mtl_trx_tbl(1).trx_source_line_id,
1942: l_mtl_trx_tbl(1).transaction_source_id
1943: FROM oe_drop_ship_sources odss,
1944: rcv_transactions rt,
1945: mtl_sales_orders mso,
1946: oe_order_headers_all ooha
1947: WHERE rt.transaction_id = l_mtl_trx_tbl(1).rcv_transaction_id
1948: AND odss.line_location_id = rt.po_line_location_id