APPS.GME_MATERIAL_DETAIL_PVT dependencies on MTL_MATERIAL_TRANSACTIONS

Line 997: FROM mtl_material_transactions

993: IS
994: CURSOR cur_get_trans (v_material_detail_id NUMBER, v_batch_id NUMBER)
995: IS
996: SELECT transaction_id
997: FROM mtl_material_transactions
998: WHERE transaction_source_id = v_batch_id
999: AND trx_source_line_id = v_material_detail_id
1000: AND transaction_id NOT IN (
1001: SELECT transaction_id1

Line 1199: || ': return -1: more than 1 trxn in mtl_material_transactions');

1195: || '.'
1196: || l_api_name
1197: || 'matl_dtl_id= '
1198: || TO_CHAR (l_mtl_dtl_rec.material_detail_id)
1199: || ': return -1: more than 1 trxn in mtl_material_transactions');
1200: END IF;
1201:
1202: RETURN -1;
1203: END IF;

Line 1226: || ': return -1: lot ctrl with 0 trxn in mtl_material_transactions');

1222: || '.'
1223: || l_api_name
1224: || 'matl_dtl_id= '
1225: || TO_CHAR (l_mtl_dtl_rec.material_detail_id)
1226: || ': return -1: lot ctrl with 0 trxn in mtl_material_transactions');
1227: END IF;
1228:
1229: RETURN -1;
1230: ELSE

Line 1249: || ': return -1: 1 trxn in mtl_material_transactions with more than 1 lot entry in mtl_transaction_lot_numbers'

1245: || '.'
1246: || l_api_name
1247: || 'matl_dtl_id= '
1248: || TO_CHAR (l_mtl_dtl_rec.material_detail_id)
1249: || ': return -1: 1 trxn in mtl_material_transactions with more than 1 lot entry in mtl_transaction_lot_numbers'
1250: || ' trans_id= '
1251: || TO_CHAR (l_trans_id) );
1252: END IF;
1253:

Line 1432: l_mmt_rec mtl_material_transactions%ROWTYPE;

1428: IS
1429:
1430: l_api_name CONSTANT VARCHAR2 (30) := 'PROCESS_ACTUAL_QTY';
1431:
1432: l_mmt_rec mtl_material_transactions%ROWTYPE;
1433: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
1434:
1435: l_mmti_rec mtl_transactions_interface%ROWTYPE;
1436: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;

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