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 2263: l_mmt_rec mtl_material_transactions%ROWTYPE;

2259: ,x_msg_count OUT NOCOPY NUMBER
2260: ,x_msg_data OUT NOCOPY VARCHAR2
2261: ,x_return_status OUT NOCOPY VARCHAR2
2262: ) IS
2263: l_mmt_rec mtl_material_transactions%ROWTYPE;
2264: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
2265: l_ret boolean;
2266: l_api_name VARCHAR2 (50) := 'check_inv_negative';
2267: BEGIN

Line 2450: FROM mtl_material_transactions_temp

2446: AND mr.demand_source_type_id = gme_common_pvt.g_txn_source_type
2447: AND mr.demand_source_header_id = p_batch_id
2448: AND mr.demand_source_line_id = p_mat_det_id
2449: AND NOT EXISTS (SELECT 1
2450: FROM mtl_material_transactions_temp
2451: WHERE reservation_id = mr.reservation_id
2452: AND organization_id = p_organization_id)
2453: ORDER BY mr.requirement_date, mr.reservation_id;
2454: EXCEPTION

Line 2499: FROM mtl_material_transactions mmt

2495: END IF;
2496: x_return_status := FND_API.G_RET_STS_SUCCESS;
2497: OPEN x_txns_cur FOR
2498: SELECT *
2499: FROM mtl_material_transactions mmt
2500: WHERE trx_source_line_id = p_mat_det_id
2501: AND transaction_source_id = p_batch_id
2502: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type
2503: AND NOT EXISTS (SELECT /*+ no_unnest */

Line 2603: FROM mtl_material_transactions

2599: l_material_detail_id NUMBER;
2600: l_txn_type_id NUMBER;
2601: CURSOR Cur_get_trans(v_transaction_id IN NUMBER) IS
2602: SELECT organization_id, transaction_source_id, trx_source_line_id, transaction_type_id
2603: FROM mtl_material_transactions
2604: WHERE transaction_id = v_transaction_id;
2605: setup_failed EXCEPTION;
2606: update_txn_fail EXCEPTION;
2607: validate_txn_fail EXCEPTION;

Line 2670: l_mmt_rec mtl_material_transactions%ROWTYPE;

2666: p_transaction_id IN NUMBER,
2667: x_return_status OUT NOCOPY VARCHAR2) IS
2668: l_api_name CONSTANT VARCHAR2 (30) := 'delete_material_txn';
2669: l_return_status VARCHAR2(1);
2670: l_mmt_rec mtl_material_transactions%ROWTYPE;
2671: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
2672: l_mmti_rec mtl_transactions_interface%ROWTYPE;
2673: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
2674: setup_failed EXCEPTION;