APPS.GME_API_GRP dependencies on MTL_MATERIAL_TRANSACTIONS

Line 77: FROM mtl_material_transactions

73:
74: CURSOR get_txns (v_header_id IN NUMBER)
75: IS
76: SELECT *
77: FROM mtl_material_transactions
78: WHERE transaction_set_id = v_header_id;
79:
80: l_txn_rec get_txns%ROWTYPE;
81: BEGIN

Line 2178: l_mmt_rec mtl_material_transactions%ROWTYPE;

2174: ,x_msg_count OUT NOCOPY NUMBER
2175: ,x_msg_data OUT NOCOPY VARCHAR2
2176: ,x_return_status OUT NOCOPY VARCHAR2
2177: ) IS
2178: l_mmt_rec mtl_material_transactions%ROWTYPE;
2179: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
2180: l_ret boolean;
2181: l_api_name VARCHAR2 (50) := 'check_inv_negative';
2182: BEGIN

Line 2365: FROM mtl_material_transactions_temp

2361: AND mr.demand_source_type_id = gme_common_pvt.g_txn_source_type
2362: AND mr.demand_source_header_id = p_batch_id
2363: AND mr.demand_source_line_id = p_mat_det_id
2364: AND NOT EXISTS (SELECT 1
2365: FROM mtl_material_transactions_temp
2366: WHERE reservation_id = mr.reservation_id
2367: AND organization_id = p_organization_id)
2368: ORDER BY mr.requirement_date, mr.reservation_id;
2369: EXCEPTION

Line 2414: FROM mtl_material_transactions mmt

2410: END IF;
2411: x_return_status := FND_API.G_RET_STS_SUCCESS;
2412: OPEN x_txns_cur FOR
2413: SELECT *
2414: FROM mtl_material_transactions mmt
2415: WHERE trx_source_line_id = p_mat_det_id
2416: AND transaction_source_id = p_batch_id
2417: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type
2418: AND NOT EXISTS (SELECT /*+ no_unnest */

Line 2518: FROM mtl_material_transactions

2514: l_material_detail_id NUMBER;
2515: l_txn_type_id NUMBER;
2516: CURSOR Cur_get_trans(v_transaction_id IN NUMBER) IS
2517: SELECT organization_id, transaction_source_id, trx_source_line_id, transaction_type_id
2518: FROM mtl_material_transactions
2519: WHERE transaction_id = v_transaction_id;
2520: setup_failed EXCEPTION;
2521: update_txn_fail EXCEPTION;
2522: validate_txn_fail EXCEPTION;

Line 2585: l_mmt_rec mtl_material_transactions%ROWTYPE;

2581: p_transaction_id IN NUMBER,
2582: x_return_status OUT NOCOPY VARCHAR2) IS
2583: l_api_name CONSTANT VARCHAR2 (30) := 'delete_material_txn';
2584: l_return_status VARCHAR2(1);
2585: l_mmt_rec mtl_material_transactions%ROWTYPE;
2586: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
2587: l_mmti_rec mtl_transactions_interface%ROWTYPE;
2588: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
2589: setup_failed EXCEPTION;