APPS.GME_MATERIAL_DETAIL_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 1520: FROM mtl_material_transactions_temp

1516: -- Use the qty check to exclude returns based on multiple overtypes.
1517: IF (l_multiplier < 0) THEN
1518: SELECT count(*)
1519: INTO l_cnt
1520: FROM mtl_material_transactions_temp
1521: WHERE transaction_source_id = p_batch_header_rec.batch_id
1522: AND trx_source_line_id = p_material_detail_rec.material_detail_id
1523: AND transaction_quantity < 0;
1524: ELSE

Line 1527: FROM mtl_material_transactions_temp

1523: AND transaction_quantity < 0;
1524: ELSE
1525: SELECT count(*)
1526: INTO l_cnt
1527: FROM mtl_material_transactions_temp
1528: WHERE transaction_source_id = p_batch_header_rec.batch_id
1529: AND trx_source_line_id = p_material_detail_rec.material_detail_id
1530: AND transaction_quantity > 0;
1531: END IF;

Line 1557: UPDATE mtl_material_transactions_temp

1553: END IF;
1554:
1555: -- 13976194 handle primary qty also.
1556: IF (l_multiplier < 0) THEN
1557: UPDATE mtl_material_transactions_temp
1558: SET transaction_quantity = (l_multiplier * p_material_detail_rec.actual_qty),
1559: primary_quantity = (l_multiplier * l_primary_qty),
1560: secondary_transaction_quantity = l_secondary_qty
1561: WHERE transaction_source_type_id = 5

Line 1566: UPDATE mtl_material_transactions_temp

1562: AND transaction_source_id = p_batch_header_rec.batch_id
1563: AND trx_source_line_id = p_material_detail_rec.material_detail_id
1564: AND transaction_quantity < 0;
1565: ELSE
1566: UPDATE mtl_material_transactions_temp
1567: SET transaction_quantity = (l_multiplier * p_material_detail_rec.actual_qty),
1568: primary_quantity = (l_multiplier * l_primary_qty),
1569: secondary_transaction_quantity = l_secondary_qty
1570: WHERE transaction_source_type_id = 5