[Home] [Help]
1566: FETCH get_location INTO l_locator;
1567: CLOSE get_location;
1568: SELECT transaction_type_name
1569: INTO l_type
1570: FROM mtl_transaction_types
1571: WHERE transaction_type_id = l_mmti_rec.transaction_type_id;
1572: IF l_locator IS NOT NULL THEN
1573: gme_common_pvt.log_message ('GME_MATERIAL_STS_INV_SUB_LOC'
1574: ,'TRANSTYPE',l_type,'ITEM',l_item
1755: WHERE organization_id = gme_common_pvt.g_organization_id
1756: AND inventory_item_id = l_inventory_item_id;
1757: SELECT transaction_type_name
1758: INTO l_type
1759: FROM mtl_transaction_types
1760: WHERE transaction_type_id = p_transaction_type_id;
1761: gme_common_pvt.log_message ('GME_MATERIAL_STS_INV_LOT'
1762: ,'TRANSTYPE',l_type,'ITEM',l_item
1763: ,'LOT',l_mmli_rec.lot_number);