APPS.GME_TRANSACTIONS_PVT dependencies on MTL_LOT_NUMBERS

Line 4608: FROM mtl_lot_numbers mln

4604: AND process_flag = 'Y') LOOP
4605: UPDATE mtl_transaction_lots_temp mtlt
4606: SET (grade_code, supplier_lot_number) =
4607: (SELECT grade_code, supplier_lot_number
4608: FROM mtl_lot_numbers mln
4609: WHERE mln.lot_number = mtlt.lot_number
4610: AND mln.organization_id = mmtt_rec_cur.organization_id
4611: AND inventory_item_id = mmtt_rec_cur.inventory_item_id)
4612: WHERE transaction_temp_id = mmtt_rec_cur.transaction_temp_id

Line 4624: FROM mtl_lot_numbers mln

4620: AND process_flag = 1) LOOP
4621: UPDATE mtl_transaction_lots_interface mti
4622: SET (grade_code, supplier_lot_number) =
4623: (SELECT grade_code, supplier_lot_number
4624: FROM mtl_lot_numbers mln
4625: WHERE mln.lot_number = mti.lot_number
4626: AND mln.organization_id = mti_rec_cur.organization_id
4627: AND inventory_item_id = mti_rec_cur.inventory_item_id)
4628: WHERE transaction_interface_id = mti_rec_cur.transaction_interface_id

Line 5434: FROM mtl_lot_numbers

5430: l_expire_date DATE;
5431: l_api_name CONSTANT VARCHAR2 (30) := 'is_lot_expired';
5432: CURSOR Cur_lot_expire IS
5433: SELECT expiration_date
5434: FROM mtl_lot_numbers
5435: WHERE organization_id = p_organization_id
5436: AND inventory_item_id = p_inventory_item_id
5437: AND lot_number = p_lot_number;
5438: BEGIN

Line 5741: FROM mtl_lot_numbers

5737: p_lot_number IN VARCHAR2,
5738: x_return_status OUT NOCOPY VARCHAR2) IS
5739: CURSOR Cur_get_lot IS
5740: SELECT expiration_date
5741: FROM mtl_lot_numbers
5742: WHERE organization_id = p_organization_id
5743: AND inventory_item_id = p_inventory_item_id
5744: AND lot_number = p_lot_number;
5745: l_api_name CONSTANT VARCHAR2(30) := 'validate_lot_for_ing';