DBA Data[Home] [Help]

APPS.GME_COMMON_PVT dependencies on MTL_RESERVATIONS

Line 2879: AND t.reservation_id not in (select reservation_id from mtl_reservations

2875: WHERE t.move_order_line_id = l.line_id
2876: AND t.move_order_header_id = h.header_id
2877: AND t.organization_id = l_mtl_dtl_rec.organization_id
2878: AND t.inventory_item_id = l_mtl_dtl_rec.inventory_item_id
2879: AND t.reservation_id not in (select reservation_id from mtl_reservations
2880: where demand_source_header_id = l_mtl_dtl_rec.batch_id and
2881: demand_source_line_id = l_mtl_dtl_rec.material_detail_id and
2882: demand_Source_type_id = gme_common_pvt.g_txn_source_type)
2883: AND TRANSACTION_SOURCE_ID NOT IN (l_mtl_dtl_rec.batch_id) --bug 7496141