APPS.INV_3PL_SEEDED_SOURCES dependencies on MTL_MATERIAL_TRANSACTIONS

Line 180: from mtl_material_transactions mmt

176: debug('recs.l_source_to_date => '|| To_Char(l_source_to_date, 'DD-MON-YYYY HH24:MI:SS'));
177: debug('recs.l_last_computation_date => '|| To_Char(l_last_computation_date, 'DD-MON-YYYY HH24:MI:SS'));
178:
179: Select count(*) INTO l_temp
180: from mtl_material_transactions mmt
181: where transaction_source_type_id = 2
182: AND transaction_type_id = 33
183: AND transaction_action_id= 1
184: AND inventory_item_id = recs.inventory_item_id

Line 265: from mtl_material_transactions mmt

261: debug('recs.l_source_to_date => '|| To_Char(l_source_to_date, 'DD-MON-YYYY HH24:MI:SS'));
262: debug('recs.l_last_computation_date => '|| To_Char(l_last_computation_date, 'DD-MON-YYYY HH24:MI:SS'));
263:
264: Select count(*) INTO l_temp
265: from mtl_material_transactions mmt
266: where transaction_source_type_id = 2
267: AND transaction_type_id = 52
268: AND transaction_action_id = 28
269: and inventory_item_id = recs.inventory_item_id